Customer story
Industrial Commission of Arizona Streamlines Advanced Budgeting with CloudBudget
A centralized budgeting model, payroll-related calculations and thirteen custom reports replaced fragmented spreadsheets and weeks of manual report preparation.
The Industrial Commission of Arizona (ICA) is a State of Arizona government agency serving Arizona’s workforce and employers. It plans, allocates and reports public funding across multiple programs and projects.
Staffing and payroll-related costs form a significant part of that planning, with reporting requirements spanning state and federal stakeholders.
Challenge
ICA’s budgeting and reporting relied on a manual process spread across multiple Excel files.
- Teams allocated funding across projects and salary categories, then assembled reports in the required formats.
- Different state and federal fiscal-year calendars complicated reconciliation.
- Salary calculations also needed to account for employee taxes, deductions, insurance, pension contributions and other related costs.
The result was a time-consuming reporting cycle with repeated manual preparation and checks.
Solution
CloudBudget implemented a budgeting and reporting framework around ICA’s allocation rules, payroll calculations and established reporting formats.
- Funding allocations: distribute funds across projects and salary categories within one planning model.
- Payroll-related calculations: automate salary calculations and the related taxes and charges used in the model.
- Thirteen custom reports: produce ICA’s established report formats, including federal funding reports and state-calendar program reports.
- Fiscal-year alignment: account for the differences between state and federal reporting calendars.
Results
ICA moved from fragmented spreadsheets to a centralized workflow for budgeting, allocations, employee-related calculations and reporting.
- One centralized planning environment: budget inputs, allocations and calculations were brought together.
- Less spreadsheet maintenance: teams reduced multi-file consolidation and reconciliation work.
- Repeatable reporting: allocations, employee-related calculations and thirteen report formats became part of an automated workflow.
- Report preparation reduced from weeks to minutes: the implementation retained ICA’s established report formats while accounting for different state and federal fiscal-year calendars.
These results describe ICA’s implementation and reporting workflow.
Discuss your allocation and reporting requirements with CloudBudget.