The City of Fort Wayne cuts budget book preparation time by 75%. That's 300 hours!
|Project:||Budget Book Automation|
|Project Scope:||Automate balances and narrative
GFOA Budget Book Award compliance
Replicate appearance of existing book
|Organization:||City of Fort Wayne, IN|
|Solutions:||Workiva Wdesk & Wdata|
|Budget Book:||Operating Budget Book|
The City of Fort Wayne was using multiple disjointed systems to prepare the budget book. The budget department would bring balances from Excel into Munis, their ERP system. Any required changes would be manually keyed into the ERP system. The team would then run "really clunky" Crystal Reports and open them in Excel. They then pivoted the data by inputting appropriate parameters by fund and department. If a department like Police, had sub-departments (police admin, radio shop, and records) any changes to a sub-department would require a report to be run at the sub-department level before being rolled up for a department level report. They then needed to review for accuracy before going back to Excel for any updates.
"Every time we made one little number change, it caused at least another 30-45 minutes worth of work"
Kathleen Smith Finance Manager at the City of Fort Wayne
Having had great success with the reporting automation solution used to prepare the city's ACFR, the team opted for more of the same: Workiva's Wdata & Wdesk, customized and implemented with F.H. Black & Company Incorporated. What does the process look like now? Data is pulled from the City's ERP system and imported into Workiva. The budget book is then automatically populated with balances. All participants have the ability to access the system and provide their contributions. Any required changes are updated in a single location in Workiva, and the book and all other applicable materials are automatically updated. Reports that would have taken hours to prepare before now take moments, and data can be pivoted in an instant.
"I just can't say enough about how much efficiency and accuracy improved"
After carefully considering the implementation service levels offered, the city contracted FHB to automate the budget book on a "guided-self" basis with onboarding support. This meant that while costs were kept low, Kathleen and her team would do the majority of the work under the guidance of FHB's experts once they had completed the initial setup and customization.
FHB assigned a team to work on the city's project and the work began. As with all FHB led implementations, the initial kick-off meeting defined scope, assigned tasks/deadlines, and trained the city's team on using their project management tool. Next, FHB implemented a pre-built data model designed for public sector organizations, and built a connection from the city's ERP system, Munis. FHB recreated the prior year budget book template in Workiva, set up basic sections and ten pages of linking to train the city's team. We then assisted the city with the tasks assigned to their team, which included loading, tagging, and grouping imported data by object and function, building and linking schedules, notes, and statements, before reconciling, reviewing, and testing.
"We had the budget book done probably a week earlier than we normally do and that was while learning and implementing a whole new system"
The city achieved a 75% time savings while improving its budget book preparation process. Kathleen and her team now have robust, documented, and repeatable processes making onboarding new team members a breeze. Having automated the ACFR and the expenditure budgets, the city is planning another project to automate the revenue side.
"I was here a lot of evenings making sure everything looked right and tied together correctly. We didn't have that this year, I didn't find myself working any evenings or weekends."