Q: What specific issues were uncovered during the initial assessment?
Schmal: One of the most significant findings was that the County’s new system wasn’t taking full advantage of Oracle’s capabilities. There was also a lack of formal closing processes for transactions and journals, causing discrepancies in financial reporting. Data accuracy was another major issue, particularly with reports that either didn’t exist or contained incorrect information. The most alarming discovery was that there was a $350 million variance between the ledger and the treasury.
Q: What was Baker Tilly’s approach to optimization for Lake County?
Penick: A big part of our approach was the collaboration between the Municipal Advisors and Oracle groups to ensure that we were mitigating gaps across process, technology, and compliance reporting. With Lake County being flagged by the State Board, data corrections and reporting were our top priorities, but Baker Tilly also identified significant challenges and pain points within Benefits and HR that needed to be addressed. Baker Tilly also emphasized continuous knowledge transfer and education throughout, keeping the County system admins very close to the redesign efforts. This emphasis ensured that the employees who oversee the system understood what changes were being made, why they were being made, and how they were being made, so that they could maintain the system following the conclusion of the project.
Q: What are some of the key outcomes of the optimization process so far?
Schmal: The biggest win has been bringing the County back to an auditable status. This required a lot of work on the part of the Baker Tilly team, especially in straightening out our 2022 financials. The lift-and-shift approach during the initial implementation left us with data integrity issues and a lack of proper controls, which made it challenging to carry over accurate balances between systems. Baker Tilly did an excellent job addressing these issues and having them partner with our auditors really helped restore the County’s credibility. The state is nearly done with the 2022 audit, and it looks like there won’t be any material adjustments, which is a huge relief after the challenges we faced in 2023.
Hedden: The resubmission of the County’s financial statements for 2022 has been a huge win so far. The team was able to largely identify and correct all of the material variances and get the County back on track for a Regulatory Audit for CY2022. However, returning to Generally Accepted Accounting Principles (GAAP) reporting has always been the goal. In the next phase, we’ll be working closely with both the County and our Oracle team to ensure their system can generate accurate GAAP-compliant financial statements by the end of the year.
Penick: Additionally, the County has hired a new controller of finance to assist with cloud governance, which is helping to drive change internally. While there’s still work to be done in bringing additional resources on board, we’re moving in the right direction. Another big win was the successful relaunch of several Oracle modules, including EPM Workforce Planning. This has allowed the County to shift their budgeting and planning processes from manual spreadsheets in Excel to Oracle, integrating data from both HCM and ERP systems.
Q: What’s next for Lake County and its Oracle Cloud system?
Schmal: We're looking forward to continuing our optimization efforts, particularly with dashboards for real-time financial reporting and planning. This will allow County officials to make more informed decisions with better data visibility. Another key focus will be improving payroll processes and expanding our use of Oracle Cloud’s financial and HR capabilities.
Baker Tilly’s knowledgeable enterprise solutions professionals bring forward leading practices from our years as Oracle implementers to collaborate with federal agencies, state and local governments, municipal utilities and other public sector organizations to help them achieve the modernization and optimization of back-office strategies, processes and technologies. With a focus on enhancing their software investment and improving their business practice, our approach is designed to drive adoption and sustainability. We help public sector entities achieve their digital transformation initiatives.
