In Black & White

What a difference a year made for the City of Fort Wayne

Rachel Raymond
Success Stories
minute(s)The City of Fort Wayne cut budget book prep 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 Population: 265,752 (2019) Solutions: Workiva Wdesk & Wdata Budget Book: Operating Budget Book Success Story: City of Fort Wayne The Challenge When we first met the finance team at the City of Fort Wayne, they were using multiple disjointed systems to prepare their budget book. The budget department would bring balances from Excel into Munis, their ERP system. Any required changes would be manually keyed in there. The team would then run "really clunky" Crystal Reports and open them in Excel. Next, they pivoted the data by inputting appropriate parameters by fund and department. If a department like "police" had sub-departments (police admin, radio shop, records, etc.) any changes to a sub-department would require running a report at the sub-department level before running a department-level report. They then needed to review the reports 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 The Solution 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 and 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; the book and all other applicable materials are automatically updated. Reports that would have taken hours to prepare now take moments, and data can be pivoted in an instant. "I just can't say enough about how much efficiency and accuracy improved." The Implementation 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 keeping costs low, as 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. FHB recreated the prior year budget book template in Workiva, then set up basic sections and ten pages of linking to train the city's team. Next, we assisted the city with the tasks assigned to their team, including loading, tagging, and grouping imported data by object and function; building and linking schedules, notes, and statements; then 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 Result 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." For more on this project, read the full story.

The city of Fort Wayne reduced their budget book preparation time by 300 hours, that's 75%! This is how they did it.

Frederick County, MD Unifies and Automates the Budget Book

Rachel Raymond
Success Stories
minute(s)Frederick County Unifies All The Pieces Of The Budget Book Under A Comprehensive Solution Project: Budget Book Automation Organization: Frederick County, MD Population: 271,717 (2020 Census) Total Budgeted Revenues: $905 million Solution: Questica Budget Book powered by CaseWare Budget Book: Adopted Operating & Capital Budgets Success Story: Frederick County The Challenge Frederick County's, Budget Department faced a challenge common to Public Sector organizations when preparing the Budget Book. They spent countless hours gathering and reconciling pieces of their Budget Book across multiple applications. They had pieces in Questica Budget, pieces in Excel, pieces in Word, and they presented it in Adobe. To ensure confidence in the data, every change or update would require a time-consuming review. "Budget Book pieces were coming from every direction, that's what we had to solve" Tanya Kauffman, Budget Analyst III at Frederick County Government The Solution Replace Microsoft & Adobe with CaseWare and integrate it with Questica Budget. CaseWare hosts the Budget Book template and pulls balances and narratives directly from Questica. Any changes applied to the budget are made in Questica and flow straight through to all applicable locations in the book, facilitating greater confidence in the data and reducing the requirement for constant review and reconciliation. In addition, CaseWare's document management functionality allowed contributions from all parties to be stored and managed in a single location. The Project F.H. Black & Company Inc. assisted the team at Frederick County to implement the solution with the FHB method. Discovery - What are the County's wants and needs. Scope - Defining the parameters of the project. Planning - Working backward from the project goal to define a timeline and assign tasks. Configuration - Configure the selected solution to meet the County's needs. Training - Provide training to the County's budget team in the use of their new tools. Management - Weekly meetings and communication to ensure the project stays on track. Completion - Mutual agreement that the scope of the project has been completed. Ongoing Support - FHB continues to support and work with the County to improve and refine their processes. The Result The County has unified its piecemeal budget book under a single comprehensive solution resulting in increased confidence in the data and an estimated 25% reduction in the time it takes to complete budget book preparation processes. We asked Tanya if she has anything to add about the project. Here's what she had to say... For more on this project, read the full story.

Frederick County unifies and automates the budget book with a comprehensive solution for outstanding results.

City of Garland Modernizes its Budget Processes

Rachel Raymond
Success Stories
minute(s)The Forward-Thinking City of Garland Overcomes 3 Budget Challenges With 1 Project Project: Budget & Budget Book Preparation Organization: City of Garland, Texas Population: 239,928 (2019 Census) Annual Budget: $1.1 billion (Operating + CIP) Solution: Caseware & Questica Budget Book: Annual Operating Budget CIP: Capital Improvement Program Success Story: City of Garland The Challenge The city of Garland's Budget Department faced a trio of challenges that shared the same root cause: antiquated software solutions, and the business processes required to make them work. The city relied on legacy budget software to prepare the budget and a combination of Word, Excel, and Adobe to prepare the Capital & Operating Budget Books. The processes were slow, disjointed, and error-prone. The Solution After extensive research, the city's Budget Director, Allyson Bell Steadman decided on Questica Budget to prepare the budget, CaseWare to prepare the budget book, and F.H. Black & Company Inc. to integrate the two and ensure the budget book solution was optimally implemented to maximize their benefits and guarantee project success. The Project The implementation process was managed and guided by consultants from FHB. It started with a planning meeting, introduction to FHB's online project management tool, allocation of deliverables, and scheduling of software training. Once trained in the use of their new tools, the FHB team built the Capital Improvement Program budget book template based on the City's specifications. Once complete, a similar process was carried out for the Operating Budget Book. The Result By the end of the sixteen week implementation, the City was able to produce and publish both the proposed and adopted 2020-21 CIP & Operating Budget Books. The City now has a robust, documented, repeatable, and largely automated process for preparing their budget book. "The Budget & Research Department is in a much better position to produce and distribute budget documents. Our most recent success was having our 2021 Adopted CIP document finalized for publication on the City’s website and distribution to City Council two weeks after adoption". For more on this project, read the full success story here.

The City of Garland modernizes its Budget, Capital Improvement Program, and Annual Operating Budget Book preparation processes with a single project.

City of Greensboro Budget Book Automation Project

Jamie Black
Success Stories
minute(s)With a population of nearly 300,000 and growing, the City of Greensboro is the third-most populous in North Carolina. The City's 2020-21 adopted budget of $602 million spans 169 pages and was awarded the GFOA Distinguished Budget Presentation Award. Long-time Questica Budget users, the City is extremely happy with their processes for preparing the budget. The Budget Book however was another story. Like many finance departments, the City used Microsoft Excel, Word, and Publisher to prepare the book. The process was time-consuming, repetitive, resource-heavy, and disjointed; it was time to make a change. The team at Greensboro had heard about F.H. Black & Company Incorporated at a Questica conference and reached out for help to improve their budget book. Once the project was complete, we gave the City a little time to bask in their achievement before interviewing them about their journey. Here are the highlights of that interview with the City's Budget Database Specialist, Leah Price. The Old Way "We used a combination of Microsoft Excel, Word, and Publisher, and it was very time consuming for all staff members. The Budget Analysts had to manually enter all of their departments’ numbers line by line twice: once for the Manager Recommended version and again for the Final Adopted version. The Budget Database Specialist also had to make sure all of the formatting was correct in Publisher, and finally work with our internal print shop to make sure every page had the perfect amount of space between the text and the hole punches. When we heard there was a software that we could use to import the numbers from Questica directly into the budget document, we jumped on it." The Project "We sent our FHB consultants a copy of our former budget document and a copy of our budget data from Questica. The consultants built a template for us that was similar to the old format, and then worked closely with our staff to make sure that the budget data was going to the right places in the document. We have over 25 operating funds and many tricky aspects to our budget rules overall, so assigning the budget numbers and FTEs where they needed to go was the biggest struggle. However, it all came together in the end." The Benefits "The process is more streamlined and controlled. It probably saves the analysts a couple of weeks’ worth of time because they no longer have to do any manual data entry." "The budget analysts are an important resource to our departments, and their new found availability during the budget development process allows them to help out more with current year concerns." The Relationship "Our (FHB) consultants have always helped us meet our deadlines and make sure to work us into their schedule if we have last minute issues." "I have mainly worked with Joy, and I am so grateful to her for all of her help and expertise! I really appreciated that she wanted to make sure that I was learning how to do (almost) everything we needed her help with. It was my first year being responsible for the budget book and I had very little knowledge of CaseWare. I truly could not have done it without her." Considering a reporting automation project? Schedule a meeting with one of our experts to explore your options.

The City of Greensboro implemented an automated budget book solution that pulled data directly from their Questica Budget software resulting in a better book in less time.

City of Iqaluit keeps calm and carries on

Jamie Black
Success Stories
minute(s)The City of Iqaluit is the capital of the Canadian Territory of Nunavut and is an ecological wonderland. Famed for an abundance of natural landscapes and wildlife, it attracts visitors from around the globe. The Challenge Located on beautiful Baffin Island in the Canadian Arctic with a population of just 7,740 (2016 census), the City's finance department has experienced some difficulty attracting qualified staff due to a remote location, housing shortage, high cost of living, and limited infrastructure to facilitate travel. When the City required urgent Payroll support, CAO Amy Elgersma was certain that employing an experienced, qualified Payroll Administrator could not happen before the next payroll run. Elgersma needed a quick, temporary solution so the organization's 150 employees would continue to be paid on time. With time of the essence, the City turned to F.H. Black & Company Incorporated to fill the gap until a suitable replacement could be on-boarded. She knew of FHB from a presentation they provided at a recent conference, and the work they had done with the Government of Nunavut previously. The Response After a few brief conversations, FHB assigned several members of their team to support the City: Michael Switzer, CPA, CA, was formerly the Town of Collingwood’s Deputy Treasurer with responsibilities including preparation of both the year-end financial statements and the annual Town budget as well as managing the town's receivables, payables, and payroll. Joy Richardson, CPA, was formerly the Chief Financial Officer of Thomasville, Georgia where her primary responsibilities included managing both the budget and year-end financial reporting processes as well as overseeing receivables, payables, payroll and all the other day to day activities of the finance department. Tina Steliga rounded out the team. Utilizing 16 years of experience managing the receivables, payables, and payroll processes for numerous clients of all sizes. Michael, Joy & Tina's decades of experience working in government finance made them an ideal addition to immediately and completely meet the City's needs. Within a week of the request, consultants Michael & Joy were onsite working with the team to transfer responsibilities and document processes. They were followed shortly thereafter by Tina, who assisted in administering payroll onsite before commencing remote support. FHB’s response time was exceptional. Their CPA's had the knowledge, skills, and experience needed to learn, document, and process the payroll system efficiently. They also had excellent interpersonal skills and were able to understand processes quickly. Once FHB was on board and started working with us, we were confident that payroll would be completed by the deadline. Disaster Averted The first step in the project was developing complete process documentation. Extensive interviews with City staff allowed FHB to build extremely detailed process documentation. The decision was made to put the documentation into a project management software to allow for the ongoing assignment of tasks and monitoring of the process by both FHB management and the City. This ensured FHB would not miss any steps and resulted in the proper execution of payroll each and every time. As the City's search for a Payroll Administrator was underway, FHB continued to process the payroll remotely. From mid-October to the end of February. We were able to arrange to have the payroll done via distance, this saved us time and money. The entire process was documented using a project management software tool. Ultimately the City successfully recruited a Payroll Administrator to take on the role. FHB transitioned to provide assistance getting the new Payroll Administrator up to speed and support them through the first few payroll runs. I would absolutely recommend FHB to other finance departments. They were able to process payroll with very little notice and continued via distance. They had a strong knowledge of the payroll and finance systems and could adapt to our processes easily.

The City of Iqaluit required urgent support to keep its payroll on track. They turned to FHB's team of experienced CPAs for assistance.

An Interview with Queens University

Jamie Black
Success Stories
minute(s)For more than 175 years Queens University in Kingston, Ontario has gained and maintained a reputation for excellence. Educating thousands of scholars and researchers including 2015 Nobel Prize winner Arthur B. McDonald. The University services more than 25,000 students and as of April 30th, 2019 its endowment was valued at more than $1 billion. The Challenge Queen's University wanted to reduce the time it took to prepare their annual financial statements while increasing their confidence in the data. We interviewed Peter Viveiros, the Associate Director of Financial Analysis and Reporting in Financial Services, to discuss their experiences in overcoming these challenges. The Interview 1 What was your business process to tackle the Annual Financial Statements previously, and how much time did it take? What product were you using before and why did you want to switch? Our previous business process was done through the use of Microsoft Excel and Word after pulling a trial balance from our accounting system. We had a set of multiple spreadsheets to allow us to map our accounting system trial balance into various financial reports like the statement of financial position, statement of operations, statement of operations by fund, statement of operations by consolidated entities and various tables to feed the notes to the financial statements. We also had spreadsheets to produce tax related financial reports. This mapping adventure took us approximately a week, and was usually delayed until we had confirmation that the numbers were close to final to avoid the risk of having to update the spreadsheets several times over. In addition to the time spent updating these spreadsheets, numerous hours were also spent in the review process to ensure that the numbers tied in and that subtotal and totals added correctly; not to mention rounding! A few members of our Financial Reporting team had previously used CaseWare, so that switch was a no brainer to eliminate the amount of time spent on updating spreadsheets and reviewing the numbers over and over again. 2What other solutions did you consider? How did you hear about FHB, and what was the key factor(s) in choosing our solution? As mentioned, a few members of our Financial Reporting team had previously used CaseWare, so we did not bother seeking other solutions. In addition, our auditors confirmed with us that CaseWare would definitely compliment their audit process. We first heard of FHB at a Canada-wide conference that our Controller attended. The key factors in selecting FHB was the ability to contract out the implementation process as opposed to self-implementation; and FHB’s experience in implementing CaseWare for other higher education institutions. 3 Were you concerned about working with someone other than the software vendor for implementation? Or working remotely? We were not concerned about working with a consultant. We had expectations of what we were looking for with implementing CaseWare, and FHB was able to demonstrate from the very beginning that they were more than able to meet our expectations and did so throughout the entire process. We had no concerns with working remotely. In fact, working remotely was key in us gaining approval to proceed with implementing CaseWare as it kept the implementation costs down. 4 What process did you follow to implement CaseWare? We chose to outsource the implementation to FHB as oppose to self-implement. They reconciled our numbers, which allowed us to continue with our day to day responsibilities while FHB was in the background setting up our account structure in Caseware, including the financial statements. With the exception of touch base meetings to discuss the progress and questions from the FHB team during the implementation, the process was very hands-free for our team. I would recommend to anyone considering implementing CaseWare to really consider the delegated implementation route. Our decision was based on the fact that we had limited internal resources to commit to a successful self-implementation and felt that we would be better served by having FHB perform the implementation given the size and complexity of our financial reporting requirements. The implementation process consisted of regular meetings with our FHB consultants to ensure that we were on the same page, which included hands-on illustrations of our file as the implementation progressed. There was also review steps throughout the process to ensure that the end product met our expectations. Our staff attended formal training provided by FHB to ensure that we were well equipped to take on the software once it was ready to be moved into production. 5 From your perspective, how is the University in a better position now as compared to with your old solution? Is the process faster? Could you estimate the time savings, or provide any examples? CaseWare has tremendously enhanced the University’s ability to produce its set of financial statements for both annual and interim requirements as well as tax filing requirements. We are now rolling into our third year of using CaseWare and have definitely gained efficiencies in our financial and tax reporting processes. We have also gained comfort on the accuracy of mapping our figures from one financial report to another; not to mention a decrease in the number of hours committed to reviewing the figures. Our week long process in moving from our accounting system’s trial balance to our financial statements now takes a few hours to complete, and we can also begin this process the minute we import the numbers into Caseware (we used to wait until the numbers were close to final!). If we had to put a number to it, I would say we saved a week or so (down from six weeks to five) in regards to the direct switch from the manual process of mapping the numbers to the automation provided by CaseWare. 6 What are the biggest benefits of the CaseWare Tool vs. your old system? For all the reasons that have been stated in the answers above, but one of the biggest benefits is the automation that takes place once the trial balance is imported…we have a set of financial statements shortly after that! 7 What was your experience with FHB like? In our opinion, FHB is an expert on the use and capabilities of CaseWare. We were impressed with their ability to setup the software to meet our reporting needs with minimal intervention required from our team. 8What is our client service like? Did you feel that we carefully managed your project? Did you feel like you were well taken care of by your consultants, that your concerns were heard, and your questions answered? The client service received by FHB was super. The implementation deadline was met; allowing us to use it for our fiscal 2018 year-end process as planned. Our consultants, Tricia Fraser and Noreen Vavrek, were extremely helpful throughout the process and did a great job in keeping us on schedule while ensuring that all our questions and concerns were adequately addressed. 9 Is there anything you wish you knew at the beginning of this process that you know now? Advice for others considering a similar automation project? Have a clear understanding of what other types of reports you might want to prepare using the automation capabilities that CaseWare offers; so that the initial implementation incorporates these needs upfront as opposed to revisiting it afterwards. Although not a deal breaker, but something that would have saved us time during the implementation. 10 Would you recommend FHB and specifically the CaseWare solution to other finance departments and why? Yes, we would definitely recommend FHB and the CaseWare solution to others. The time savings that are gained from the automation capabilities more than outweigh the annual costs associated with maintaining the software. Not to mention the inherent comfort that it provides knowing that it reduces the risk of errors and increases the consistency of the financial reports.

The University of Queens automated their annual financial statements to reduce the time it took to prepare and increase their confidence in the data.

An Interview with The City of Rock Springs

Jamie Black
Success Stories
minute(s)Home of the infamous outlaw Butch Cassidy, The City of Rock Springs a.k.a the City of "56 Nationalities" attracted emigrants from far and wide to the Union Pacific Coal Mines in the late 1800s and early 1900s. With a population of 23,350, it's the 5th largest City in Wyoming. The Challenge The City was using multiple, inefficient solutions to prepare their annual financial statements, which was very time consuming and labor-intensive. When their solution, CAFR Unlimited discontinued support for the software they knew it was time to find a new solution. The Interview 1 What was your business process to tackle the Annual Financial Statements previously, and how much time did it take? What product were you using before and why did you want to switch? Prior to using CaseWare, we were using a software called CAFR Unlimited as well as Microsoft Office/Microsoft Excel to prepare and draft our report. To start, we would extract the financial information from our accounting software and import into CAFR Unlimited. Once the information was in CAFR Unlimited, we would make any necessary journal entries, after which we would extract the information from CAFR Unlimited into Excel tables. Once the information was in Excel we would write our financial and compliance report using Microsoft Word and linking with Excel to “pull” the tables into the report. This was quite time consuming, and if there were any major changes Microsoft Word can be difficult to work with regarding formatting. While this whole process is very manual and a pain, it was all we had, and we really were unaware of anything better until we were forced to switch from CAFR Unlimited as the software was no longer supported by the vendor. 2 Did you look at other solutions and if so, what was the key factor(s) in choosing our solution? Besides CaseWare we briefly looked for other options (Opengov, CAFR Online, and a software option through Harris as we currently use some of their software) but really were unable to find anything that suited our needs as many weren't tailored to governmental financial statements and others lacked data. In addition, our auditors use CaseWare as their primary auditing software, so in theory we could provide the auditors our CaseWare file and they could audit from that point. We also really like that CaseWare has a document library (content) that is specifically tailored to governmental entities. Another big plus is that the City’s senior accountant came from a public accounting background and was fairly familiar with the CaseWare software which allowed for an easier transition for the City. Furthermore, CaseWare is a big software company so we didn’t have to worry as much about support ending for it. 3 Were you concerned about working with someone other than the software vendor for implementation? Working remotely? Working with a Canadian company? We were not concerned about working with a consultant. We’ve done similar types of implementations many times previously. In addition we had no concerns about working with a Canadian company. 4 What process did you follow to implement CaseWare? Perhaps provide a summary of the process? We elected to do a self-implementation to help keep costs down. We initially took two 16 hours classes with F.H. Black to learn how to work with the software. Once the classes were complete we started our implementation. We met with F.H. Black weekly to discuss progress, address questions/concerns and to receive direction on what to do next. We elected to implement using the FY2017 report (as it was audited and complete) so we had something to work towards. Once we had rebuilt the FY2017 report in CaseWare, we were able to start work on the FY2018 report. 5 From your perspective, how is the City in a better position now as compared to with your old solution? Is the process faster? Could you estimate the time savings or provide any examples? For the implementation we elected to start using the FY2017 report, we chose this as it gave us an audited statement to work towards rebuilding in CaseWare. For the current year report (FY2018) it was hard to see exactly how much time we will be saving, as we were still working on the implementation of FY2017 while working on the FY2018 report. Going forward we feel that the overall process will be faster for report preparation. We can say for sure that preparing the current year report was much quicker than the process has been in the past. 6 What are the biggest benefits of the CaseWare tool vs. your old system? The biggest pro is that now we are able to prepare the adjusted trial balance and prepare the compliance and finance report all in the same program. The CaseWare tool allows for us to draft the financial statements in a much more automated fashion. Previously we were using Microsoft Word and Excel to prepare the statements which was a very time-intensive process, especially when the auditors had changes/adjustments. 7 What was your experience with FHB like? Specifically, can you speak to our knowledge of: Technology generally and CaseWare specifically Year end processes & GASB requirements We feel that FHB had an excellent understanding of the CaseWare product and its capabilities. FHB was very easy to work with and was able to help us navigate questions/issues we had with CaseWare. We also feel that FHB had a comprehensive understanding of GASB requirements and the process needed to build a compliant report. FHB was able to provide great suggestions as to format as well as ensure we were able to keep the spirit of the report we provided previously. 8 How did the self-implementation go? Did you feel like you were adequately equipped to do it with our training and project management? Were you able to meet your deadlines timely without excess effort? Would you do it again? We feel that the self-implementation process went really well. We were able to meet our current year audit deadlines which was very important to us. We also feel that we were well equipped due to 1) the required FHB CaseWare classes, and 2) the weekly status meetings with FHB. We both feel that we would do it all again if given the option. 9 Is there anything you wish you knew at the beginning of this process that you know now? Advice for others considering a similar automation project? We think it is important to try and keep the end goal in mind when setting up statements and other report content. FHB had mentioned it to us; however, it really hit home with us and set in when we were in the latter stages of the report and were glad that we had taken the time to set things up correctly. Additionally, we would suggest that other clients not underestimate the time commitment to implement, this is something that needs to be properly planned out; however, it is well worth the time and effort. 10 Would you recommend self-implementation of CaseWare to other state or local government finance departments and why? We would wholeheartedly recommend the self-implementation process to another government. We feel that it really helped us to gain a better understanding of how CaseWare really works as well as the overall process. When working on the FY2018 year report it was much easier to make changes to the templates since we were the ones who created them in the first place (with FHB’s help). We just cannot imagine gaining the same depth of understanding with having FHB perform the implementation for us. In addition since the initial implementation of CaseWare, the City implemented a budgeting software that is compatible with CaseWare (Questica Budget) and we are currently working with FHB to automate the process of our budget book and it is going great. Watch this space With a successful implementation under their belt, the City is now working with FHB and CaseWare to automate their budget book. Once implemented, we will interview them again for more valuable insights. To be notified when this and other finance-related articles are released Subscribe to our Blog.

The City of Rock Springs automated their financial statements. We interviewed them about the process and their experience. Here's what they had to say.

An Interview with Washington County: Budget Book Automation

Jamie Black
Success Stories
minute(s)Washington County is the second largest of 36 counties in the State of Oregon. As of the 2010 census, its population was 529,710 and its largest city Hillsboro had a population of 91,611. With a $1.2 billion total budget proposed for 2018-19 to include investments in infrastructure, transportation and affordable housing to name a few, the county's budget department has 'its work cut out for it.' The Challenge The county's budget book spans more than 300 pages. It took four of the team's six staff members approximately 75% of their time from March through the end of June to prepare. Links to Excel in Word documents would routinely break or malfunction randomly; these errors plagued their processes as they would change numbers in multiple locations unexpectedly. The Interview We interviewed Washington County to learn their thoughts on the budget book automation project we completed with them in 2018 (see the book that resulted here). Here are the highlights: 1 What was your business process to tackle the Budget Book previously, how much time did it take and why did you want to switch? Our process was to download information into an Excel Spreadsheet after the information was entered in Questica, open a series of Word Documents by our Functional Area’s then link the spreadsheet that pertained to a specific Org Unit to the correct page in the Word Document, write the budget analysis and present to the Deputy County Administrators for their review and input. As the Deputy County Administrators recommended changes, the changes would be entered in Questica, downloaded into Excel, update the links, reprint the page for further review. At the end of all the changes then the summary sheets would need to be redone with new downloads, the prior links were updated, the budget analysis sections would need to be proofed to verify the words and numbers matched the linked tables. Then after the Budget Summary Book was completed for the public hearing it would need to be re-done after the year-end changes and impacts changed by the budget committees before it was produced as an Adopted Budget Summary in July. This took four staff members approximately 75% of their time from March through the end of June. The desire to switch to a different process was generated as a result of the Excel links in the Word Documents continued to break or malfunction randomly, the mistakes that would plague the process due to changing numbers in multiple locations and a desire to automate some of the processes, standardize language and writing style and have increased confidence in the final numbers in all reports. 2 What other solutions did you consider? How did you hear about FHB, and what were the key factors in choosing our solution over the others? We looked at a few other solutions that were more of a publication software style and did not link to Questica or provide number checking abilities. Two staff members were able to attend the Questica conference two years ago and watched a demonstration from FHBlack on the ability to link Questica to preparation of the Budget Summary Book. In addition, Questica sales representatives assisted us with finding other agencies who had implemented CaseWare as a Comprehensive Annual Financial Report solution. The key factors for our selection were the interface ability to link CaseWare to Questica and the standardization of programmed sentences and fonts. 3 Were you initially concerned about working remotely or working with a Canadian company? We had very limited experience working 100% remotely on software implementations so yes, we did have some reservations at the start. We had no concerns about working with a Canadian company. 4 What process did you follow to implement CaseWare and how did you feel the implementation went? Perhaps provide a summary of the process? We used the consultant for all implementation of the software and preparation of the past year Budget Summary Book. We met weekly during the development and provided results of queries from Questica that the consultant built. The consultant was given access to our systems or was able to direct us on what was needed during our webinar sessions. All sessions were attended by the County team so that we were all learning about the software, provided the consultant information on how our budget process worked, accounting structure, how the software used the data to provide the summary pages, spreadsheet view, pictures, and how other outside the system documents were added. We were then able to work more independently when putting together the new year budget summary with the assistance of the consultant. The consultant was very knowledgeable about CaseWare and was an invaluable partner in the successful implementation of the software. He was very adept at learning our account structures, setting up what was needed and provided a best practices approach to how the book went together. He was great at problem-solving and thinking outside the box to find solutions that benefited our project. The implementation was successful and the experience was one of the best we have encountered. 5 How many team members at the County worked with the CaseWare Budget Book Solution? We had six staff members on the County team, a Project Manager, Chief Financial Officer, Controller and three other budget analysts. 6 From your perspective, how is the County in a better position now as compared to with your old solution? Is the process faster? What are the biggest benefits? Could you estimate the time savings or provide any examples. We are just now about ready to begin our second actual year of preparation of the Budget Summary book. Our process starts with getting the budget into Questica before we can begin using CaseWare. We envision that the process to interface the needed information from Questica to CaseWare will go smoothly. The interface is required in order to prepare the first draft of the summary pages with the financial information linking smoothly. We do plan to use the consultant to assist us with the initial conversion to the new fiscal year so that we have clear written directions to complete the process. We believe that the time staff use to put into downloading information into spreadsheets, unhiding rows, adding new organizational units etc. will be better spent providing additional analysis, and free up time to work on other projects that often get delayed during this budget preparation time. One budget analyst is also having time re-directed to assist in the implementation of CaseWare for our Comprehensive Annual Financial Reporting implementation project. I would estimate that we are saving about two of the FTE who were working on this part of the budget development. 7 What is your perception of our expertise? Specifically, can you speak to our knowledge of: Technology generally and CaseWare/Questica specifically Budget Book process & requirements Our consultant was very knowledgeable on both CaseWare software and Questica information and queries. The consultant we used was great and his knowledge of the Budget Book process and requirements was outstanding. He was able to build our document to meet our needs, troubleshoot issues that arose and make many great suggestions to assist us in this process. The software is complicated enough that I am not sure we would have been successful without his direct work and interventions when we had difficulties. 8 What was our client service like? Did you feel like we carefully managed the project, knew and met your deadlines? Did you feel like you were well taken care of by your consultant and that your concerns were heard, and your questions answered etc. Client service was great. Some interim project deadlines were allowed to slip by the Chief Financial Officer. However, the overall project deadline was met. The consultant was dedicated to making sure the project was completed and we were happy with the final product. All our concerns and questions were answered by the consultant and his level of patience and willingness to provide additional training were excellent. From a project perspective, F.H. Black exceeded our expectations. From day 1, their project manager (Darryl Parker) made us believe we were his one and only client. With his deep knowledge in governmental accounting, he had a clear understanding of our practices and challenges. Also, project timelines were clearly communicated. When challenges arose, Darryl seemed to do magic getting us back on track! A true pleasure to work with! 9 Would you recommend FHB and specifically the CaseWare Budget Book solution to other state or local government finance departments and why? Yes, we would recommend both FHB and CaseWare Budget Book to other jurisdictions. We believe the time savings going forward will more than offset the annual cost for access/licenses. The ability to customize the look and feel of the book to match our prior books, add our own other documents that did not make sense to build into CaseWare including charts and graphs are key to the successful build of our Budget Summary Book. 10 Do you have plans to tackle any other automation projects (Comprehensive Annual Financial Report, monthly, quarterly, state-mandated reports etc.) with CaseWare and FHB? If so, please discuss them and why you feel the county will benefit from these automation projects. We have just begun the implementation project to automate our Comprehensive Annual Financial Report. In addition, we have two other departments within the County who are interested in automating some of their quarterly or annual financial reports. The automation of the Annual Report is anticipated to save a great deal of staff time chasing down numbers that change during the development of the Comprehensive Annual Financial Report. Every time a number changes in the current process causes additional time to find and make the changes in all places impacted. CaseWare will carry through the changes to all needed tables/pages so that this additional review time will be saved. The other departments see the value of this software and are excited to develop projects to assist them with meeting their reporting needs.

Washington County automated their budget book with the help of F.H. Black & Company Incorporated by implementing the Questica Budget Book powered by CaseWare solution, drastically streamlining the processes while producing a more reliable report.

Comprehensive Annual Financial Report Automation Success - State of ...

Jamie Black
Success Stories
minute(s)The State of Maine is thrilled with its new automated approach to preparing the Comprehensive Annual Financial Report (see the resulting document here). We interviewed them to learn more, and share their insights with others considering a Comprehensive Annual Financial Report automation project. Read the full interview: The Interview 1 What was your business process to tackle the Comprehensive Annual Financial Report previously and how much time did it take? We import a trial balance from our accounting system that is formatted for use by our reporting application using Excel. We request information from numerous state agencies and other sources for the purpose of posting adjustments (over 300 manually entered adjustments and over 100 "auto-reversals") to account balances and compile other information for note disclosures, required supplementary information and statistical information. Our previous Comprehensive Annual Financial Report reporting software generated only numerical financial statements in Excel format. Narrative information was generated with Word. Desktop publishing was a completely manual process that involved converting multiple documents into PDF format and compiling numerous PDF documents into one published document. The entire process began with some "prep" work in August, with the full commitment of all five members of the financial reporting team beginning in September. Draft financial statements typically were issued by approximately the second week in December and often the Auditor's Opinion letter would not be received until the last week of December, with the deadline to qualify for a Government Finance Officers Association Certificate of Excellence being December 31. A significant amount of time involved in generating the Comprehensive Annual Financial Report requires the compilation of information, making calculations, documenting, reviewing and filing workpapers for review by our Auditors. Additionally, we are the reporting entity for several component units, who must complete their financial statements before we can include their information in our statements. Thus, it would be difficult to push the timeline back further than approximately December 1st. 2What product were you using before and why did you want to switch? We used "CAFR Unlimited." The product was a Microsoft Access based application that was originally developed by a lone developer and sold to a software development company. The company discontinued support for the original application and planned to convert the application to a networked, SQL server platform, but discontinued support for that product as well. The product was simple to use and worked well for us. But, it had no desktop publishing capabilities. The reports that CAFR Unlimited produced were all Excel based reports. Thus, we switched, number one, for the lack of product support; and two, we wanted a more robust product that provided publishing and workflow capabilities. 3Did you look at other solutions and if so, what was the key factor(s) in choosing our solution? We were provided with demonstrations of other products, but none of them had all the capabilities that CaseWare offered. We also liked the staff at FHB and felt comfortable that they would provide excellent customer service. After a demonstration of CaseWare, we were instantly intrigued by the product. When we asked the presenter "will CaseWare do this?", the answer was in most cases "Yes, this is how that is done." The decision to go with CaseWare was easy. 4Were you concerned about dealing with someone other than the software vendor for implementation? No, not at all. In fact, after the implementation, we had a couple of minor "glitches" to resolve and in a least one case, F.H. Black resolved the problem quicker than CaseWare International's support staff. So, we're very happy we have the support of FHB. 5What process did you follow to implement CaseWare? We installed CaseWare on our computers and received four days of training from an F.H. Black consultant in two separate 2-day sessions. We provided the consultant with the prior year Comprehensive Annual Financial Report and our previous trial balance "crosswalk" or "rollup" codes. The consultant recreated the prior year's statements, notes, and various schedules based on Governmental Accounting Standards Board (GASB) templates. Through online "Goto Meetings" we met with the consultant at least once per week to discuss questions we had and offered our comments about changes that needed to be made. During this process, the consultant maintained the "master copy" of the CaseWare Working Papers file. Once the prior financial statements had been substantially recreated, the consultant performed a "roll-forward" to create the current year (new working papers file) financial statements; and control of the master copy was handed off to us. We entered adjustments to account balances as usual during the report compilation period. During this period, we continued to make editorial improvements to the Comprehensive Annual Financial Report with the help and support of FHB. The final step of publishing the Comprehensive Annual Financial Report merely involved "hitting the print" button. 6How did the implementation go? It was a lot of work and required the effort of five of our staff as well as three of F.H. Black's staff. Considering that our Comprehensive Annual Financial Report is an extremely complex and detailed 250-page document, the process went quite well. 7From your perspective, how is the State in a better position now as compared to with your old solution? Is the process faster? Could you estimate the time savings or provide any examples? We believe we are using a much better tool than before. We are comforted in the fact that we have support of a company with knowledge and expertise in financial reporting and supports mature industry-leading software with an international presence. It's difficult to measure "fast" in our circumstance. CaseWare's strength is with its desktop publishing capabilities. But, in terms our timeline, since we are a relatively large governmental entity, we post numerous adjustments (approximately 300 plus), that must be processed through our rigorous documentation and review process. This takes a tremendous amount of time regardless of the tool(s) used. CaseWare does save us the time and tedium of having to manually enter every adjusting journal. At the end of the reporting process, we used to compile numerous Excel workbooks and Word documents, send files to a "PDF printer" and import many PDF files into the final published version. Since individual documents came from so many different sources there was no consistency in page margins, page numbering, fonts and font sizes, etc. CaseWare is "heads and shoulders above" our previous software in terms of the quality of the published report. We also believe the overall integrity of the report to be much better and the risk of errors and omissions is less than before. 8What are the biggest benefits of the CaseWare tool vs. your old system? The biggest advantage is the desktop publishing and the ability to reference values between statements to ensure that all values agree. Our prior reporting application had no desktop publishing capabilities. The exceptional feature of CaseWare is that anyone can see a real-time view of the draft report at any time during the report compilation period. You don't have to wait until the end of the process to view a compiled "camera ready" draft product. CaseWare provides the ability for the user to formulate unlimited diagnostics and analytics to ensure the completeness, accuracy and integrity of the final product. CaseWare allows the user to easily generate customizable reports using its "automatic document" functionality. These reports were invaluable in establishing and verifying account rollup balances during the implementation phase and the reports were extremely useful for auditors as well during the first year of our Comprehensive Annual Financial Report reporting. Our old system did not allow the user to save customized worksheet reports; whereas CaseWare allows users to create as many "worksheet" reports as desired and organize them anyway they want. Our prior tool allowed for the import of the trial balance only. CaseWare allows user to import trial balances, budgets, revenue forecasts, performance measures, and even adjustment data from properly formatted Excel workbooks. The import functionality is extremely convenient as it eliminates the time and tedium of entering data that we've already "crunched" in our complex Excel spreadsheets. The import functionality also limits or eliminates data entry errors. 9What was your experience with FHB like? The consultant assigned to our project has over ten years of experience, his combined background in accounting and computer programming and technical acumen makes him an invaluable resource for us and FHB. 10Did you feel like we carefully managed the project, knew and met your deadlines etc? Yes. We were very clear in communicating our timeline to FHB. We had established a reasonable timetable at the beginning of the implementation project. We believe that effective planning and communications by all parties was key to the success of the project. 11What was our client service like? Did you feel like you were well taken care of and that your concerns were heard, and your questions answered etc? We believe FHB's customer service is "top notch." The team made a concerted effort to understand our requirements and concerns. We participated in periodic "how's everything going" meetings. We got the sense that FHB strives for continuous improvement in servicing its clients; and is genuinely concerned about its clients' opinions and satisfaction with FHB's products and services. 12How well did we communicate? Were we clear and concise, were we readily available to discuss your concerns? Did we do a good job of setting expectations and keeping you updated each step of the way? The consultant assigned to our project was extremely knowledgeable, helpful, easy to work with, and explained every detail of the technical, "under the hood" aspects of CaseWare whenever we had specific questions about how the application works. 13Is there anything you wish you knew at the beginning of this process that you know now? Advice for others considering a similar Comprehensive Annual Financial Report automation project? We can't think of anything that we wish we knew at the beginning of the process. However, as one would expect, the more complex the set of financial statements, the more lead time an entity should provide itself to implement CaseWare. Our Comprehensive Annual Financial Report is 250 pages that includes introductory information, management discussion and analysis, basic financial statements, notes to the financial statements, required supplementary information, notes to the required supplementary information, combining and individual financial statements, and statistical schedules, all prescribed by GASB standards. We started our implementation project in April of 2017 with training. The recreation of the prior year's financial statements, to be used as a template, took place from May through August. The generation of the current year's financial statements occurred during the usual time frame from September through December. We completed the published report approximately two weeks ahead of the usual timeframe. As with any project, proper planning, delegation of tasks, and adherence to deadlines is important to achieving a successful outcome. 14Would you recommend CaseWare to other state or local government finance departments and why? Absolutely...Yes. Based on our research and experience, CaseWare appears to be the most comprehensive reporting application on the market - the one tool that "does it all."

The State of Maine automated their Comprehensive Annual Financial Report with the CaseWare solution and are thrilled with the results. We interviewed them to find out more about what they did before, the implementation process, and where they are now.

Palmetto proves automating the Comprehensive Annual Financial Report ...

Jamie Black
Success Stories
minute(s)Palmetto is a waterfront community located on the Gulf Coast of Florida, midway between Tampa to the north and Sarasota to the south. With a population of just over 14,000 residents, the City has seen dramatic growth in recent years while maintaining the “Old Florida” charm that residents and visitors have come to love. The Challenge The primary challenges for the City's Finance Department were three-fold, they needed to: Reduce Time Reduce the Risk of Errors Formalize Processes Everyone wants to reduce the time it takes to produce the Comprehensive Annual Financial Report & mitigate the risk of errors. Of particular concern for Palmetto was the impending retirement of the City's Finance Director. The finance department, made up of just four members, was very concerned about how this loss & associated "brain drain" would affect the department going forward. The Wrong Turns Not one to wait for a small problem to become large, the Finance Director anticipated the problems that would arise from her departure and took steps to mitigate them immediately. After extensive research, the finance department eliminated all spreadsheet-based applications and decided to proceed with a Comprehensive Annual Financial Report focused solution. Unfortunately, two-thirds of the way through implementing the solution, the City was abandoned by the provider. Sometimes even the best-laid plans go awry due to circumstances beyond your control. The Solution Convinced a better solution was still 'out there', the evaluation of vendors resumed. This time CaseWare International was the victor, a combination of the Working Papers & GASB Financial solution were just what the department needed. Perceived Road Blocks When asked why CaseWare was eliminated for consideration initially, the answer was simply “it was way too big for what we needed.” The perception was that the program was too large & complex, it would take too long to implement. In steps CaseWare authorized implementers F.H.Black & Company Incorporated. The Results Reduced time required to produce the Comprehensive Annual Financial Report including over 50% reduction in the time it takes to prepare Fund Statements, Reduced risk of errors, Documented, simplified & formalized processes that will ease the transition to a new Finance Director, Centralized-database for single location modification, Positioned to reclaim Government-Wide statement creation from auditors. A word of wisdom from the expert Karen Simpson, Finance Director, shared that no matter the size, “the same amount of work still has to be done.” As the number and complexity of regulations and requirements for financial reporting continue to increase, municipalities of all sizes are quickly realizing that spreadsheets and word processing software that have been used in the past to prepare financial reports are no longer sufficient. Read the full success story here.

The City of Palmetto proves that automating the Comprehensive Annual Financial Report provides time, cost & operational savings for local governments too.

Freeing Finance & Budget Departments from Drudgery One Article at a Time