In Black & White

City of San Luis

Rachel Raymond
Success Stories
minute(s)Game Changer: City of San Luis Cuts Weeks from ACFR Process Project: ACFR Automation Organization: City of San Luis Population: 35,770 (2022) Platform: Workiva The Need The small but mighty finance department at the City of San Luis, Arizona, was looking to automate its Annual Comprehensive Financial Report (ACFR) preparation process. Their primary goals were to save as much time as possible and reduce their risk of error. They wanted a streamlined, repeatable process producing a quality, reliable report. When FHB met the City’s team, they were relying heavily on hand-keyed data entry. “We were doing the process manually…the financial information was in Excel, and the financial statements, some of that was in Word,” said Monica Castro, CPA, Director of Finance for the City. “There seem to be more errors when you do a lot of manual work. So, that's one of the things that we wanted to improve,” she said. As an added challenge, the San Luis team was knee-deep in budget season as they set out to optimize their ACFR process. The Right Tool The FHB team, led by Principal Consultant Faith Olanipekun, CPA, met with the San Luis team to assess their needs. Based on their conversations, FHB recommended that the city implement Workiva. As a cloud-based tool, Workiva was great fit for San Luis, allowing multiple people to work on the ACFR simultaneously; the software is also intuitive for anyone who’s used Excel, and specifically designed to support financial reporting. Leaving Nothing to Chance The Partnership The notion of cost savings might entice some municipalities to implement software on their own. However, Monica saw the value in a formal, professional implementation. “FHB’s expertise was crucial to the success of the project. I would not have been able to implement Workiva without the help of the FHB team,” she said “They were always available when we needed them, quick to respond to our questions and provided answers that solved our issues. Their accounting expertise was excellent," she added. “The implementation was great,” said Carolina Corral, Accountant for San Luis. “Faith was available whenever I needed help. She was good at explaining how to do things.” “FHB is a great team to work with. They really helped us through the process, gave us a lot of alternatives, especially with us being a small municipality,” said Monica. The Results Monica estimates that the ACFR automation project will save her team, "Weeks. Because for instance, the management, discussion, and analysis (MD&A) has a lot of tables in it. Before, we would update the tables in an Excel spreadsheet, then copy and paste it into a Word document. With the new software, the table is already built in that document—as long as you upload the information, it is already linked to pull the information into the note or wherever it belongs.” Another benefit of the project is the simplification and automation of formatting, which will improve the standardization and professional appearance of the team’s reports. “Everything will have the same indentation, same margin, same font,” said Monica. “Rounding was another thing that caused a lot of headaches throughout the report. So, having a rule for that and making sure that everything gets rounded as to the specifications we want will save more time,” she said. Monica’s team now feels comfortable moving forward in Workiva. “The training provided by FHB throughout the process helped us better understand the software and be able to manage it ourselves,” she said.   Looking Ahead To ensure Monica’s staff is equipped for success, FHB’s Capstone Training will be invaluable, as it includes a video capturing instructions and demonstrations specific to the City's process. Combined with Aftercare Support, to be provided by the same FHB team members who led the implementation, the training will ensure that the City won’t waste any time with questions or worries about optimal use of the solution.  In the future, Monica and her team may reengage FHB to help revamp their budget book process. “I definitely see a lot of potential in Workiva,” she said. “Its capabilities are much greater than the other application we have.” In the past, she said, “There was always a rush. We were so focused on just getting the document completed, we would just finalize it at a bare minimum. Because of the limited time, we were always working against the clock and just meeting the deadline of having the report out for compliance purposes." "I definitely think that we will be able to make a better document, and that's the ultimate goal,” she said.

Learn how FHB helped the City of San Luis cut weeks from its ACFR process while improving accuracy.

State of West Virginia

Rachel Raymond
Success Stories
minute(s)West Virginia Team Automates More Than 90% of Budget Book Project: Budget Book Automation Organization: State of West Virginia Population 1.78 million (2021) Solution: Workiva Wdesk & Wdata The Challenge When we first spoke with the State of West Virginia (WV) budget office team, they were looking to automate their process for producing Volume II of their annual budget book. Heather Greenfield, Budget Analyst, explained that the team’s existing process was “all manual…you’re talking about the…domino effect…so, if you [made] one change, it [would] hit 12 different places across several different books—thousands of pages—and you’d have to remember where all of those [were].” How It Went With their 2024 budget book recently completed, WV sat down with us to discuss the project’s implementation and outcomes. “Personally, I've never gone through an implementation where I was so heavily involved. Most [of the ones] I've gone through...had a tech team heading up [the project], so this was pretty ‘hands-on' for us, but it was good... I think it helped us learn what to do and troubleshoot a lot more so than if we hadn't been so hands-on,” said Misty Reese, the office’s Deputy Director. FHB Principal Consultant Jill Moats, CPA and her team set up custom queries, tables, and scripting to automate WV's narratives, eliminating the need to update each one manually and the associated risk. FHB also provided WV with the full documentation of their configuration, with step-by-step instructions for updating scripts, creating new groups, and more. This documentation will be particularly helpful when bringing new employees on board. "There was very little that we had to do manually besides setting it up as a one-time thing...and we have a colossal amount of data...it was pretty impressive," said Heather. At one point during the implementation, the WV team ran into some technical difficulties. FHB’s tech support team did some troubleshooting and discovered that the issue was software-related—which is not unheard of, even among best-in-breed solutions like Workiva. FHB and Workiva worked together to facilitate a quick resolution. “It was helpful to have somebody to go to bat for us...it's nice that F. H. Black has had all this experience with [Workiva] and could get it sorted,” said Heather. An Expert Team Throughout the project, the WV team was in Jill's capable hands. Her public-sector accounting expertise was immediately evident, said Heather. “Every state or project is going to be different, but I felt like—even for our most complicated tasks or procedures, different accounting techniques, or details [specific to us]—she was able to pick up on [those] pretty quickly.” “Jill was awesome. Anytime we had a problem or question, she just dove into it and was relentless in figuring it out…I felt like she had our back.” –Heather Greenfield, Budget Analyst, WV State Budget Office Misty agreed. “[Jill] was wonderful. Very smart. She was really good to work with,” she said. The entire WV team was highly impressed with Jill’s responsiveness. “She would send us messages, even late at night,” Heather said. “Yeah, at 1 a.m., we [were thinking], ‘why are you awake?’,” Misty added. “We even had a meeting on her day off, so she always made time for us…I never felt like she left us hanging,” said Heather. Having an expert guide the project was crucial to ensuring an optimal outcome for the WV team. Jill adapted project steps to meet the team’s needs in real time, harnessing functionality that they otherwise wouldn’t have known existed. Staying on Track WV was also pleased with FHB’s project management approach. “[Their tool] worked really well. It was helpful to go in and see exactly what I had to do, and if I was behind deadline,” said Heather. “And then also having the links to…a Microsoft Teams meeting, or [file] or [video] links, all in one place. It kept the whole thing organized,” she said. A Measurable Outcome With the help of FHB, the WV team successfully automated more than 90 percent of their budget book document. For the first time, Heather and her team were able to beat the book's deadline by several hours. "You don't finish Volume II early. And it was done two hours early. It was crazy," she said. What's Next “[In the past], sometimes we [didn’t] have time to even proof our books. There were so many changes and... we were doing all this manual work...we just sent them off because we're required...to do so. Now, [we] don't have to worry about those little embarrassing errors. [We] can go through and read the books, [we] can do analysis if [we] want to,” said Heather. The WV team plans to make the most of its new setup. “The goal is to add other volumes...and that will save even more time…there are so many possibilities,” she said.

With the help of FHB, the State of West Virginia dramatically reduced the time it took to produce their Budget Book.

City of Houston and Houston Airport System

Rachel Raymond
Success Stories
minute(s)Houston, we have a solution. Project: ACFR Automation Organizations: City of Houston Controller's Office & Houston Airport System City's Population: 6.8 million Solution: Workiva Wdesk & Wdata Occasionally, two connected organizations hire FHB to guide them through implementations concurrently. Such was the case for the Office of the Controller at the City of Houston, Texas, and Houston Airport System. While FHB Principal Consultant Joy Richardson, CPA, was leading the Controller’s office through automation of their ACFR process, her colleague, FHB Principal Consultant Jill Moats, CPA, began working with Houston Airport System to automate theirs. The Airport project was expected to trail behind the City’s project by about two months. However, in the end, the two implementations were wrapped up within one week of each other. The Challenges When we met the two teams, each of their ACFR preparation processes was manual and cumbersome, requiring a great deal of data entry. Former Deputy City Controller–Financial Reporting at the City of Houston, Beverly Riggans, CPA, knew the process needed to be modernized, and spearheaded the effort. “We used spreadsheets, linking, PDFs,” said Conrad Lin, Deputy Director–Financial Reporting, Office of the City Controller, City of Houston. “If we changed one page number, we’d have to [manually] change 25 other page numbers,” he said. Collaboration within each separate team was tenuous at best. “[We saved] the spreadsheet into network folders, and you could only have one person in there [at a time]. So, [you’d] see emails coming through saying, ‘can you get out of the file?’,” said Conrad. Collaboration between the two teams was also challenging. “The airport would prepare their own financial statements, and then send a spreadsheet to the City Controller, who would then…enter it into the controller’s spreadsheet. And sometimes…the captions were different, they may have entered it in the wrong line…once it [was] published, the lines [wouldn’t] line up…it just caused a lot of a lot of issues between the departments,” said Conrad. “Government’s having a hard time hiring people—qualified, experienced reporting personnel. So, we have to figure out some way to utilize technology to do some of the job,” said Conrad. Leaving Nothing to Chance Both the Airport and City teams chose to implement Workiva for ACFR automation. Out of the box, the software is a blank slate to be built upon. With the right skills and knowledge, it becomes a powerful tool for process optimization. Why Not Self-implement? While some finance teams might opt to self-implement automation software, Conrad advises against it. “I wouldn't think that would be a good idea…because the system is definitely more sophisticated and more complicated… you need some experience with it in order to set it up correctly…doing it yourself…it would take a lot of trial and error to get it to work. And typically, a regular user wouldn't know how to write a script…even if you [get assistance with] those very technical parts of the system…to do the initial setup, it will help a lot. [If there are] issues later on, you're going to be spending more time and money to try to fix it [rather than] just doing it correctly from the start,” he said. Conrad recalled that the City’s Combined Utilities team elected to self-implement a similar solution. It took them three years, and there are still a lot of updates to be made to the setup in Workiva, he added. For any city like Houston—large and complicated, with multiple entities they're trying to connect—self-implementation would be exceptionally difficult. “I’d say it would be impossible for the controllers to just set up the whole thing…you could have a whole team of two or three employees just working on [it] year-round for five years, trying to get it all integrated and connected,” Conrad said. A Powerful Partnership Both the City and the Airport System were very pleased with FHB’s performance and partnership. “Joy was very knowledgeable. She’s been an auditor. So, [our] implementation was great,” said Conrad. Nicki at the Airport System provided similar feedback. “Jill was awesome…Jill, [FHB Technical Consultant Michael Spurlin], [Principal Consultant Faith Olanepikun, CPA], all of them, were really quick to respond. Communication was seamless. We were able to get everything done right away, with no issues at all,” she said. Nicki appreciated that the FHB team was transparent about what they could accomplish, rather than trying to placate her team. “[FHB] was very good at letting us know what we could and could not actually do. They didn't...commit to something that they knew wasn't possible, which I really appreciate.” –Nicki Thibodeaux Public Sector Expertise In addition to their software expertise, all of FHB’s Principal Consultants are CPAs who bring decades of public sector experience to every implementation. “They have seen many governments’ financials and they have worked in government,” Conrad said. When asked, on a scale of one to 10, how important government experience was for a successful implementation, he replied, “A 10. I saw another implementation, without the experience, and there were multiple issues, missing pieces, costly to fix… they didn't have the knowledge of the accounting or the Government Accounting Standards Board (GASB) requirements. You have to have governmental experience to…know how to fix the issues,” he said. The Results Accuracy Nicki is relieved that many opportunities for manual error have been eliminated from the Airport System’s ACFR process. “...everything is crossfooted with the data validation table…[with] the linking, we put our number in one spot and it goes to the five places that it needs to go to... so, a lot of that tedious crossfooting [is taken care of].” Time and Cost Savings The Airport System is grateful for the time savings their new process will bring. “I think typically, [our] ACFR [isn’t] released till the end of December. And we were literally done on our deadline, which was Nov. 15—a month and a half early. Everybody sees how much [this implementation] has improved our process, immediately,” she said. Conrad’s team saw similar results. Last year marked their first time meeting the ACFR deadline. “I don't think it had ever happened ‘til last year…we actually finished it,” he said. For Conrad and his team, the implementation resulted in a time savings of 75 percent, reducing four months of work (for 10 people) down to one month, he said. This dramatic reduction in workload means “more efficiency and less stress for the staff, and reduced turnover,” Conrad said. It also means savings of approximately $150,000 for the City, which can be dedicated to other projects. Benefits of Concurrent Projects When connected teams within a larger organization implement the same solution concurrently, they are bound to see additional benefits beyond what is typically expected. This was true for the Airport System and the Controller’s Office. “The fact that [FHB] did the City and [Airport System] at the same time, we saw right away how that benefited both sides. We have a lot of work papers that were fed from the Airport to the City, and [vice-versa]. And your team was able to implement that,” said Nicki. “I loved how Jill and Joy were able to collaborate…to use the work Joy did in the first month [with the City] to speed up [Jill’s] work on the Airport,” she said. Having FHB work with both the Airport and the City, “eliminated a lot of unnecessary conflict,” said Conrad. “It’s good that the same firm [got] everything set up at once and applied the same standards, procedures, that really helps,” he said. Because the two systems were interconnected and using the same software, communication and collaboration were simpler and timelier. Nicki appreciated, “the synergy of being able to use the software with the two reporting entities and [the way] Conrad was able to add comments to [the Airport’s documents] ...it was real time [collaboration]...there was no delay,” she said. It's much easier now that we have all the workspaces connected to the airport…[the Airport] pushes [data] to [the City], the Airport [has] access to [the City data], and we [can] look at it together at the same time, so there's no difference between [the two]. And it's a much quicker process,” said Conrad. Having the two systems integrated saved the City “days of time,” he said. What's Next? As a testament to the effectiveness of FHB’s training, Conrad and Beverly successfully added their “trends” report (a shorter, simpler report than the ACFR) into their new system without any guidance. In the future, “we want to learn how to write script and…how to get different reports…so if we need to create another monthly or quarterly report, it doesn’t affect the ACFR file,” he said. Conrad’s team is also open to discussion with FHB about future Treasury and GASB work. Did you know? FHB offers a live, CPA-led course on Structured Query Language (SQL) and the basics of chains. Register for Workiva 201 today. With the Controller’s and Airport System’s projects successfully completed, the City’s Finance Department is now looking to optimize their monthly financial reporting process, Conrad said. Nicki and the Airport System team have their eyes on a couple of additional projects as well, around financial close reconciliations and interim reporting/variance analysis. “So, we'll probably be reaching out [to FHB] as we get to those,” she said. We’re always curious as to whether our clients would recommend partnering with FHB, knowing what they know once implementation is complete. When we asked Nicki, she did not hesitate to reply. “Absolutely. Absolutely,” she said.

By partnering with FHB for ACFR process improvement, the City of Houston and Houston Airport System reaped the benefits of concurrent implementations.

[Workiva + Adra]: An Integration Powered by FHB

Jamie Black
Workiva
minute(s)Adra is a leading software for the automation of the financial close process, while Workiva offers a cloud-based, collaborative platform connecting reports and data. Both solutions are known to save users time and money while improving accuracy and repeatability. And together, they equal more than the sum of their parts. FHB recognized that the combination of Workiva and Adra would offer a uniquely transparent, accurate, and controlled solution for financial close and statutory and regulatory reporting, while streamlining workflow across the entire record-to-report (R2R) process. So, we developed an integration tool to bring you the best of both worlds. Introducing: [Workiva + Adra] At FHB, we have one focus—streamlining and automating processes to lighten the workload of public sector finance and budget teams across North America. To that end, we partner with industry-leading software companies, providing custom implementation of the best available solutions to meet our clients’ needs. Workiva and the Adra Suite of Solutions by Trintech are two such valued partners. Learn more about [Workiva + Adra]. To find out how [Workiva + Adra] can work for you, schedule a call with our expert team.

Reap the combined benefits of Workiva and Adra with FHB's integration tool.

City of Albuquerque

Rachel Raymond
Success Stories
minute(s)Collaborative ACFR Process Takes City of Albuquerque to New Heights Project: ACFR Automation Organization: City of Albuquerque Population: 562,599 (2021) Solution: Workiva Wdesk & Wdata The Need When we met the finance team at the City of Albuquerque, New Mexico, preparation of their Annual Comprehensive Financial Report (ACFR) was highly manual and time-consuming. “We [entered] our adjusting journal entries in PeopleSoft, [our] ERP system...[and uploaded] them…daily, sometimes twice a day,” said Mari Hughes, the city’s Deputy Controller. “When I first started, we combined hundreds of Word and Excel files, manually paginated all of them,” said Jason Shaw, CPA, Associate Controller for the city. Mari and Jason wanted “...something more user friendly and integrated, [that was] non-relational, column based," he said. Another pain point was “not knowing how to fix certain items when they [came] up, having to rely on technical calls and help just to resize a chart, things like that,” said Jason. “If there was an issue...with a formula or something, really, it was only me who knew how to troubleshoot it,” Mari added. While the Albuquerque team appreciated the power and capability of their legacy software, its limitations for their purposes made them realize that it might not be the ideal fit for their organization. “We used to create mirrored duplicate statements in Excel to check ourselves against [our software]” said Jason. The team struggled with the unfamiliarity of their existing user interface and some of its grouping concepts. Additionally, their software limited collaboration. Because it wasn’t cloud-based, and the finance team was assigned a limited number of user licenses, only one single person could work within a document at any given time, while their colleagues had limited, read-only access. When Albuquerque connected with FHB, they were seeking a more efficient, collaborative, and intuitive solution and overall process for producing their ACFR. The Solution The FHB team worked closely with Mari and her staff to assess their current process, then recommended implementing Workiva’s cloud-based tools. Wdata would serve as a central database and single source for all data, while Wdesk would be used for reporting and formatting. Unlike the custom syntax of their existing software, which was unique to their organization, the syntax in Workiva is mostly familiar to anyone who has used Excel, making the transition to Workiva much easier and more intuitive. In terms of groupings, the FHB team would be able to leverage Albuquerque’s existing groupings (already set up in their ERP) with minimal modifications. And as a cloud-based solution, Workiva would allow several of the city's team members to work within a document simultaneously. The Implementation A Uniquely Qualified Team The implementation took 16 weeks from start to finish. FHB Principal Consultant Christine Gilbert, CPA, CA, led the project. “She did a fine job of doing as much as she could with our data,” said Jason. Steering the team away from creating new, massive, complicated codes, “she was the one who just kept coming back to, ‘use what you already have.’” “I think you guys were really easy to work with, very clear and concise in expectations, from the client and yourselves.” –Mari Hughes The Albuquerque team also appreciated Christine’s unique combination of expertise in both their legacy software and Workiva. “She holds a very interesting seat, helping people implement both of them,” said Jason. Christine also demonstrated methods used effectively by other clients so that the city could pick the right approach for their needs. “The level of knowledge and detail and thoughtfulness about our data and how to make it work best was great.” –Jason Shaw, CPA All the Automation The FHB team was dedicated to making Mari and her team’s lives easier by automating as much of the ACFR preparation process as they could. While figuring out how to set up sheets in Workiva efficiently, Christine helped develop solutions for cash flows, based on how the Albuquerque team’s data works and how they had done them in the past. FHB also worked with Mari to balance her government-wide statements. Keeping Things on Track Mari’s staff was also pleased with how seamlessly the project was managed through FHB’s project management tool, Asana. “We would start every…meeting by ticking off tasks…the communication process and tagging people, that worked [smoothly],” said Jason. The Outcomes Time Savings One clear benefit of the city’s Workiva implementation is time savings. Their team will no longer need to create duplicate statements and publish multiple versions simultaneously. “The way that Christine worked through...the implementation should virtually eliminate a lot of the mirrored work that we were doing.” Jason said. Workiva’s grouping functionality will save the city even more time. “We were able to leverage the attributes that we have in our ERP system, which we implemented…with the intent that we were going to use those for our grouping codes…the implementer for [our former software] told us we couldn't use them. But for Workiva, we're able to use them…now [we won’t] have to spend a bunch of time each year…grouping new things,” said Jason. “It's going to save some time, particularly on the more detailed schedules...it could save one to eight hours per the big funds, particularly if you've got a lot of new data,” he said. Freedom to Do More Mari is excited about using the time they’ll save to focus on higher-level tasks. “The way that we've got the citywide statement set up in Workiva, with the linking and things like that…if there [are] any issues with the reconciliation…those will be easier to identify,” she said. “And I don’t have to worry about any inconsistency there...that's going to save some time. And then I think that will hopefully free us up to do a little bit more thorough...final review.” “A repeatable process is what we're looking forward to the most—being able to teach... more than just Mari and I...how to do the critical functions,” added Jason. Ad Hoc Reporting The team is excited to be able to capture and share a true snapshot of accurate data upon request. Enhanced Collaboration Mari's team can't wait to take advantage of Workiva's cloud-based environment, where multiple people can view the data and make updates at the same time. They will no longer need to rely on screen sharing to demonstrate how to fix something, for example. “We're extremely grateful for the collaborative workspace that this will be.” –Jason Shaw, CPA Ease of Use Because working in the Wdesk report writer is like working in a beefed-up combination of Word and Excel (with which her team is familiar), Mari will no longer be the sole troubleshooter on staff. “I think it’s just more straightforward,” she said. Mari added that her team looks forward to using Workiva for report formatting, as “there’s not going to be that kind of fighting with it,” that they experienced previously. “Things like that, I think are going to make our lives a lot easier, because you don’t need to be dealing with that stuff when you're in the eleventh hour, and you're already freaking out about deadlines. And then you have a software program that's just not that easy for you to use,” she said. As icing on the cake, Mari has found the Workiva support and training site to be thorough and easy to use, she said. Looking Ahead More Hands On-deck In the past, Mari and Jason were the only team members capable of data review. “We haven’t felt comfortable [sharing the review] because…[neither of us had] time to explain more,” to staff members who expressed interest in helping. “It was, ‘thank-you, but no’,” said Jason. “At this point, I think we're going to be able to start opening some of that up as well…keeping the two of us on…the overall picture instead of the minutia of…rounding from front to back. We can let some of the other more advanced staff do things like that, [which] we weren't comfortable with before,” he said. Spreading the Word Since the implementation, Mari has become an FHB advocate. “I've already told a couple people…like my former boss…she's got a different agency now…I told her…we're going to Workiva and she [said], ‘Oh, how are you liking it so far?’ I said, ‘so far, I like it much better’…I was telling her…about being able to leverage our groupings that already exist and [such]…she [is] hoping to look into that within the next couple of years [for herself].

With help from FHB, the City of Albuquerque traded hundreds of manually manipulated Excel and Word documents with erroneous links for an efficient cloud-based, purpose-built solution for preparing its ACFR, resulting in saved time and effort.

Fairfax County ERFC

Rachel Raymond
Success Stories
minute(s)Riding in Style: How ACFR Automation Changed the Game for Fairfax County ERFC Project: ACFR Automation Organization: Fairfax County ERFC Established: 1973 Solution: Workiva Wdata and Wdesk The Challenge For the staff at Educational Employees' Supplementary Retirement System of Fairfax County, Virginia (ERFC), preparing and publishing an Annual Comprehensive Financial Report (ACFR) was a tedious process. Multiple people were tasked with entering data and repeatedly checking each other’s work. If they changed a figure in one place, they had to manually update it in a number of other places. Allison Kelly, CPA, Senior Retirement Financial Analyst at ERFC, explained, “We have had three people working on the table of contents, reviewing it. Because we've changed things, now we have to re-review [it] … we have spent hours with … communications folks … double checking the table of contents … just that is … a day's worth of work.” Fatigued by the process, Allison broached the subject of automation with her executive director. “We were talking about the painful process we had for doing the ACFR and I said … we could get software to do this … and he said, 'Find out! Go—go do it.'” –Allison Kelly Allison began researching available solutions and polling fellow finance teams for recommendations. “I had heard from a few systems that, you know, it's painful, the conversion is painful … so I was geared up for this, this pain...” The Solution Ultimately, Allison connected with the team at FHB, who carefully reviewed ERFC’s needs, then weighed workable solutions. FHB recommended adopting Workiva’s Wdesk and Wdata. As cloud-based software, Workiva would allow multiple users to work on the ACFR simultaneously. As a single-source database-driven system, it would eliminate the need for a variety of disconnected spreadsheets. And its formatting automation would make report finalization and publishing a breeze. A Painless and Effective Implementation Once Workiva was selected, a dedicated FHB project team guided the Fairfax staff through the software’s implementation, customizing the solution to fit their unique needs. Allison was pleasantly surprised by the smoothness of the conversion. “… I mentioned to [FHB Principal Consultant Christine Gilbert, CPA] and [FHB Principal Consultant Amy Manthey, CPA] a few times, am I missing something? Because I'm still waiting for this other shoe to drop, and I'm not feeling that pain. I don't know if it was them. I don't know if it was me … but … that … was not my experience at all.” “And for us, you know, our ACFR process kind of went from riding a bicycle to … driving a luxury vehicle … it was already great. But that just made the road so smooth.” With the help of FHB, Allison and her team grew “very comfortable” working in Workiva. “Everything works just the way it’s supposed to,” she said. Her staff found Asana, FHB’s project management tool, to be user-friendly as well. “I loved how all I had to do was drop a comment in the sheet or whatever I was working in. And then Christine or Amy would just reply to the comment.” This convenient functionality eliminated the need for additional emails, phone calls, and meetings. “I really, I have no complaints. I thought the way the project was run was just … so well done, that it made my job a lot easier.” The Results For Allison’s team, one of the greatest benefits of the implementation so far has been time savings. “I think it is 110 percent a timesaver. 110 percent we’re already benefiting. I mean … we're already working on our ACFR for next year. And … that's not something we would have done in the past … we got through phase one, we did our ACFR, and then we got through phase two. And now, there's so many more improvements we can do and efficiencies that we can put into it … I have time now to work on those…” “I'm really grateful we have it. I'm glad that … the project was able to happen and that it's done for the most part, because it really is a game changer.” “If I'm going to quantify what our actual process used to be, compared to what it's going to be now, [the time savings] is absolutely in the weeks—could even be a month.” To be clear, that’s a month’s time for many staff members, not just Allison. “We get our final numbers at fiscal year-end, and there's going to be maybe 20 percent of the work to do because 80 percent of it is done up front.” Looking Ahead In light of their ACFR project’s success, there has been some discussion about whether the county of Fairfax (as a whole) might benefit from an FHB-led Workiva implementation for their budget book process. FHB Client Services Manager Rachel Raymond and Wendy Zhi, CPA, Acting Deputy Executive Director for ERFC, have plans to follow up. When asked if she had any complaints about the FHB project team, Allison joked, “Yeah. That I don’t get to see them every week anymore … I feel like we have [a] good thing going, you know, new friends, … and now it's like, I don't get to see them anymore…”

Read how Fairfax County ERFC saved weeks of work by partnering with FHB to optimize their ACFR process.

Workiva 101: Beyond the Basics

Michelle Richardson
Training
minute(s)The Need Although Workiva offers excellent, basic training for beginning users as well as additional specialized courses, many of our clients have expressed a need for more. We created Workiva 101: Beyond the Basics to provide a space for more than simple skill-building. This training serves the broader goal of enhancing our clients’ understanding of the domain they work in. It will improve attendees' ability to participate meaningfully in conversations about data and report automation. Like the reporting standards (GASB, PSAB, FASB, etc.) themselves, Workiva’s functionality is changing all the time—so we aim to help our clients become nimbler, lifelong problem-solvers. The Difference Workiva 101 differs from other course offerings in a few ways. First, the course was designed with adult education best practices in mind. Pre-course and post-course surveys and a course assessment are included as part of the overall learning experience to maximize engagement and enhance learning outcomes. Rather than being solely lecture-based, the course includes interactive components at every step, promoting the retention of skills and the reasoning behind them. In addition to its instructional piece, the training features live demonstration of the skills discussed. And finally, Workiva 101 allows participants to practice the skills they’ve just learned in a hands-on, safe workspace, with real-time guidance and oversight from our expert instructors. After all, watching an instructional video doesn’t give learners confidence. Practice does. A New Mindset Many of our new clients are refugees from a land of spreadsheets, with a deeply ingrained reliance on manual data entry and manipulation. They’ve learned to treat report preparation like a document-editing task, instead of setting up reports to be data driven. They’re used to gathering and typing information into a report by hand. If they discover errors, they must contact others to investigate and find a solution. This method relies heavily on human comprehension and attention. Finance and budget professionals typically take this approach because they don’t know how to use available tools and don’t have time to weed through instructional videos or “help” documentation. To them, manual manipulation seems simpler, safer, and even faster. It’s what they know. But in the long run, they will reap far greater benefits from doing the proper thing, rather than the seemingly simple thing. Instead of adding more steps to already complex processes, we challenge finance and budget teams to do away with unnecessary tasks. As their duties continue to expand, we invite them to think differently. A department that clings to manual data entry and manipulation is delaying the inevitable. Looking Ahead FHB intends to develop additional course offerings in the near future, following principles of adult learning to incorporate gamification and other interactive elements. For example, Workiva 201 will focus on advanced queries—how to write your own SQL (Structured Query Language) to extract every bit of available automation from the platform. Typically, writing SQL is left to members of an organization’s Information Technology (IT) staff because most accountants don’t understand the syntax. Unfortunately, in most cases, IT experts don’t understand accounting. This often leads to painful, time-consuming, back-and-forth communication in an effort to understand each other. We see massive benefits for those accountants who can bridge this gap effectively by fulfilling the more historic role of an accountant. A strong grasp of Workiva’s implementation of SQL will enable finance, budget, and audit teams to become less dependent on IT. We’re developing Workiva 101, 201, and additional courses because we know that a little incremental knowledge can unlock a world of understanding. And understanding brings competence, confidence, and calm. WORKIVA 101: BEYOND THE BASICS Course Description Have you taken Workiva’s basic training, but still feel ill-equipped to make use of its total functionality? Do you struggle to stay abreast of its newly updated features? Or are you strictly a Workiva beginner?  Taught over two half-days, this live virtual learning opportunity is: Led by Workiva-certified experts Designed and delivered by CPAs, for CPAs Hands-on and interactive Our experienced course leaders will provide instruction, demos, and practice exercises designed to optimize your Workiva experience, covering: Understanding platform components Creating tables to hold any of the data you need Loading data into the database Creating queries using Workiva’s quick and easy builder functionality Connecting your data to spreadsheets Building spreadsheets and writing formulas based on the connected queries Creating document content and linking it back to the query-connected spreadsheets Built for Public Sector – Applicable for Corporate Users Too While the scenario we use as the context for the Workiva 101 training is a new GASB pronouncement, the training is just as applicable for corporate Workiva users. So users from any industry will come away with a more advanced understanding and practical mastery of this valuable software. Prerequisites: Be a currently licensed user of Workiva Have a workspace suitable for training Have the “Workspace Owner” role in the workspace to be used Complete Workiva Learning Hub course "Using Workiva" At the time of this article’s publishing, establishment of CPD/CPE eligibility for Workiva 101: Beyond the Basics is in process. Please check back in 1-2 weeks for updates.

Learn to do Workiva the FHB way. This hands-on course is designed by CPAs for CPAs and led by a Workiva-certified expert.