If your city manager calls at 3 pm to ask how much the city collected in permit fees last month, what do you do?
Most local government finance directors can’t answer that question on the spot. Instead, they have to open three different system exports, reformat a spreadsheet, chase down a discrepancy between what utilities reported and what actually posted, and send an email to two department heads. By the end of the week, they’ve managed to pull together an answer they’re 90% confident in, which they caveat anyway because they’ve learned to.
Meanwhile, leadership is wondering why the finance team isn’t more agile and strategic.
Building a strategic treasury office requires a single, real-time view of all municipal revenue and collections across every department.
While many municipalities lack a consolidated view, they already have access to the data. The problem is that the systems holding that information were often not designed for centralized finance department oversight.
Key Takeaways
- Most local government finance teams spend more time manually consolidating revenue data than analyzing it.
- The systems that hold financial data were built for departments, not for the treasury function.
- Without a consolidated view of revenue, finance directors can’t answer basic questions in real time or operate strategically.
- Visibility into revenue isn’t about better dashboards, but about having one place where reconciled numbers are available when someone asks for them.
- Centralizing revenue data is what gives finance teams the capacity to move from closing the books to advising leadership.
Why Disconnected Payment Systems Complicate Municipal Revenue Reconciliation
The reason most finance directors can’t answer revenue reconciliation questions on the spot has nothing to do with how good they are at their jobs. Municipal payments originate from disconnected sources, such as utilities, permits, parking, courts, licensing, and property taxes. Each channel runs on its own system and timeline, with custom reporting formats that don’t work across departments. Because each department adopts systems independently, the treasury ends up responsible for manually reconciling data across different formats after the transactions occur.
Each month, the finance department serves as the connective tissue, manually reconciling reports to figure out why totals don’t match those posted to the general ledger. The analysis part of the job—trend spotting, variance explanations, revenue forecasting that leadership keeps asking for—gets done if there’s time left, which there usually isn’t.
Euna’s 2025 State of Public Payments and Reconciliation Report found that half of the respondents cited manual reconciliation as their biggest frustration. Nearly two-thirds said they spend more than 10 hours per month reconciling across their systems, with some even reporting more than 80 hours per month, every month, pulling together data from different files and systems.
Defining Revenue Visibility for Local Government Treasury Offices
In most cities, having real revenue visibility means being able to track daily payments and outstanding collections without manually extracting data from multiple departmental systems.
Right now, most finance directors have data. What they don’t have is a consistent way to look at it all at once. Utilities payments are in one system, permit revenue in another, and parking and court collections in a completely different channel. Each one is accurate on its own terms, but none of the systems connect to provide a real-time view of the city’s financial standing.
Finance directors and their teams end up spending their time proving the numbers are right instead of using them to inform a strategic perspective. By the time the month-end books are reconciled, and the reports are clean enough to share with leadership, it’s too late to act on most of what they show.
If teams can access all departmental revenue data from a centralized system, they can catch issues early, when they’re still fixable. The reporting that once took them weeks of prep work is now accessed in minutes, so when leadership asks for data, the team can answer.
Comparing Transactional and Strategic Treasury Functions in the Public Sector
A transactional treasury function focuses on processing payments, reconciling accounts, and generating standard financial reports to close the books. It does this accurately and on time, and in most cities, it does it with a lean team.
A strategic treasury office uses centralized financial data to deliver predictive insights along with revenue forecasts that support the leadership decision-making process. When finance leaders can see revenue patterns before they become budget problems and confidently answer questions, the conversation changes from whether the books are closed to what the numbers mean for the organization.
Every finance director is capable of running a strategic treasury office. What gets in the way is not team talent or effort, but the lack of centralization to support analysis and the time eaten up by manual processes.
Every month the finance department spends manually reconciling across multiple systems is a month they’re not functioning as the strategic partner leadership expects them to be.
How Centralized Revenue Management Systems Bolster Strategic Treasury Operations
The instinct is usually to look for a new tool. But adding technology to an already disconnected process to solve one bottleneck can make that problem worse. You’re adding more data sources, another reconciliation point, and more complicated manual entry.
The starting point is easier: a single centralized view of revenue—such as Euna Payments Revenue Management—that reflects how the finance department works, not how individual departmental systems are organized. One place where payment data from across the organization is normalized, up to date, and accessible without a manual step in between.
Centralizing revenue data gives the finance department its time back. They can find discrepancies more easily and earlier in the reconciliation process and pull reports with custom fields the moment someone asks. During leadership meetings, the conversation can focus on what the numbers mean instead of where they came from.
For a closer look at what a strategic treasury office looks like, including how other cities are rethinking revenue operations and what it takes to get there, check out Euna’s on-demand webinar, Building a Strategic Treasury Office: Visibility, Control, and Impact.
Frequently Asked Questions
What is the main goal of learning how to build a strategic treasury office?
The goal is to get the finance department out of its transactional role of data assembly and into actual strategic analysis. That means using real-time, centralized data to advise leadership with predictive insights, forecast revenue shortfalls, and answer questions confidently.
Why is revenue reconciliation so difficult for local government finance teams?
Revenue reconciliation is difficult because municipal payments come in through multiple systems that were never designed to talk to each other. Utilities, permits, courts, and parking—each runs on its own platform with its own reporting format. Finance teams must manually extract, reformat, and consolidate this data, which consumes staff time and increases the risk of errors.
What is the difference between a transactional treasury and a strategic treasury function?
A transactional treasury function processes payments and confirms collected data to close the books accurately and on time. A strategic treasury office uses consolidated financial data to identify revenue patterns over time, explain any variances, and provide leadership with forecasting to support decision-making.
How does revenue visibility improve municipal finance departments?
Revenue visibility provides finance teams with a current, consolidated view of payments and collections across every department. A single, centralized system eliminates the manual data collection process, detects issues earlier, and gives teams the ability to generate accurate reports instantly.
How many hours per month do public sector finance departments spend on reconciliation?
Euna’s 2025 State of Public Payments and Reconciliation Report found that almost two-thirds of municipal finance professionals spend more than ten hours per month reconciling across all of their systems. Some further reported that their reconciliation work alone exceeded 80 hours per month.
