Government accounting tracks cash by fund. Banks track it by account. The moment several funds share a pooled account, the two sides stop lining up on their own. That means neither system alone can prove to you what a single fund holds today.
Getting that answer requires a spreadsheet, a bank statement, and at least one email to your accounting team. By the time the number comes back, it’s already a day old.
But everything treasury is asked to do next rests on that number: the cash position you hand to leadership, the forecast you build from it, the decision about how much idle cash is safe to invest, and the balance you defend in front of a commission. Each one inherits whatever gap is left between book and bank. Leave it open and every figure downstream is an estimate presented as a fact.
Fund-level book-to-bank reconciliation is the credibility layer under every treasury decision that follows. When book and bank agree fund by fund, the order reverses: every cash position, rolling forecast, investment decision, and commission-facing number starts from a balance you’ve already proven. Here’s what it takes to close that gap, and why reconciliation belongs at the starting line of strategic treasury.
Book-to-bank reconciliation is the work of proving that the cash your accounting records say you hold matches what the bank reports you actually hold. The book side is the cash balance in your general ledger, which serves as accounting’s source of truth for GAAP financial reporting.
The bank side is the bank statement balance at the close of a given period. Reconciliation runs down every difference between the two. A proof of cash goes further, tying the bank's balances and activity back to the government's own records.
If you still build that tie-out by hand, the definition is the easy part. The reconciliation is where the day goes.
In government, the two sides usually live in different places. Stacy Lassiter, who leads finance and treasury for Mobile County, Alabama, says treasury has traditionally owned the bank side while accounting and finance own the book side. Getting them to agree takes more than a single month-end tie-out.
“We want book and bank to balance at a transactional level. We want book and bank to balance at an operational level as well,” Lassiter says.
Transactional agreement means each deposit and disbursement lines up. Operational agreement means the totals your team uses to run the government line up as well.
Some drift is normal. Deposits in transit, outstanding checks, bank fees not yet booked, and other timing differences pull book and bank apart on any given day, and reconciliation is how you account for all of it to reach the true amount of cash available. What makes it hard in the public sector is the layer underneath, where a government tracks its money by fund and the bank never does.
Enterprise resource planning systems such as PeopleSoft treat book-to-bank reconciliation as a month-end close process, run as part of the general ledger close. For accounting, that cadence works. For treasury, waiting until month-end means the strategic work never starts.
Any cash position you hand to a commission is only as trustworthy as the reconciled balance underneath it. In a government, that balance only holds when book and bank agree at the fund level. A balance confirmed once a month can't support a decision you make on a Tuesday.
Leadership asks for forecasting and better yield, and the team can't build either on numbers it hasn't confirmed. "The integrity of the data, knowing what the data is, knowing what your cash flows are, that's just the biggest thing," Lassiter says. Money managers can only put cash to work once you tell them how much to invest.
"I think that what we want to get to is a rolling thirteen-week cash flow," Lassiter says. GFOA recommends ongoing cash forecasting and liquidity management over at least a 12-month rolling period. Both horizons rest on the same foundation: cash data that actually reconciles at the fund level. The diagram below shows how each layer depends on the one before it:
Capacity is where this becomes visible. When DebtBook's Luke Otto ran an audience poll on the biggest barrier to advancing the treasury function, one option was "data integrity, no single source of truth across the different systems." Team capacity drew the most votes, at about 40%.
Those two answers describe the same problem. Producing a daily cash position by hand is what consumes a lean team’s capacity. An earlier poll in the same session showed the mechanism: the largest group of respondents, over 40%, said they do produce a daily cash position, but only with manual effort to compile it. It’s also the same work that would give treasury teams the trustworthy data and real cash visibility they need.
Accounting records track cash by fund and classification, which rarely produces a one-for-one relationship between bank accounts and general ledger accounts. A single pooled bank account can hold money from a dozen funds, and a single fund's cash can sit across several accounts.
Proving the bank balance is right doesn't prove any individual fund's balance is right, and the fund is the unit governments actually budget, restrict, and report on.
To close that gap, treasury teams need global reconciliation that aggregates balances and activity across every account and every fund, then runs down the reconciling items between them. Those include deposits in transit, outstanding checks, NSF checks, and bank activity not yet recorded in the books.
State accounting standards require governments to document that global reconciliation of both ending balance and cash activity at least monthly, and recommend daily reconciliation for high-volume or high-risk accounts. Here’s why the book and bank sides never map one-to-one:
Even the federal government treats a single fund-level source of truth as the goal. Its central accounting system was built to eliminate the multiple layers of reconciliation once needed to validate fund balances. It replaces fragile crosswalks between systems with one source of truth that reconciles cash to each agency's Fund Balance with Treasury. The aim at the local level is the same: reconciled funds that every downstream number can inherit.
A forecast built on account-level cash can still be wrong on the fund-level cash leadership actually asks about, such as a restricted grant balance or a capital project's balance.
In the city of Ithaca, New York, four of the city's 22 bank accounts, which were holding nearly $51 million between them, had gone unreconciled for five months to more than three years, according to a 2026 state comptroller's audit. The two largest, carrying $49 million of that total, had not been reconciled since December 2021.
Those two accounts were already more than two years behind in March 2024, when Moody's withdrew the city's credit rating for lack of sufficient information. The most recent completed audit of the city's finances at that point covered fiscal 2020. Ithaca went to market unrated and raised more than $38 million in notes at a higher interest rate than a rated issuer would have paid. Cash records that don't reconcile are how financial reporting falls behind in the first place.
With the city's audits backlogged, Moody's withdrew its credit rating, a move that likely raises the interest Ithaca pays the next time it borrows.
That's the floor giving way beneath the fund-level work: reconciliation failing at the account level, before fund-level accuracy is even in question. Most teams are nowhere near that. But the distance is shorter than it looks, because both versions start with a difference nobody had time to run down. Teams that reconcile at the fund level, and do it close to daily for high-volume or high-risk accounts, clear those differences while they're still reconciling items, not findings someone else hands them.
"I really want to be in a position where I can push a button in the ERP system," Lassiter said in a recent webinar. He wants to see a given fund's balance in the book system next to that same fund's balance in the bank system. Getting there, in his words, would be "a touchdown."
The webinar chat filled with hearts and thumbs-up reactions. Push-a-button fund reconciliation isn't the ambition anyone lists on a strategic plan, but it's the one a room full of finance officers recognized instantly.
Three things have to be true for that to work:
DebtBook Cash Management pulls real-time bank data into the platform through a secure API, so your cash position reflects the day's activity as it posts. Transactions are auto-categorized using rules a team defines once, sorting bank activity into the categories a government tracks across capital projects, tax revenues, and other fund types. Account reconciliation and ERP integration line up the bank side and the book side in the same system.
What's left after that are the genuine exception items that still need a human eye: an NSF check, an unexplained fee, or a check posted to the wrong fund.
For Lassiter, the payoff is confidence earned across the finance team, the county administration, and the elected commissioners of the county who answer to voters. Book and bank agreeing at the fund level is what lets a treasurer stand in front of elected officials and defend the number.
A treasury that can prove book equals bank at the fund level can forecast, invest, and report with confidence. One that can’t is guessing, however sophisticated its models.
Here’s a test you can run this week. Pick one fund and try to answer, today, whether its balance in the books matches its balance at the bank, and notice how long it takes you to find out. The friction and the lag are the size of your book-to-bank gap, and they’re the first thing worth closing.
Schedule a demo to see how DebtBook Cash Management lines up bank-side and book-side data at the fund level, so that answer is always a button away.
Disclaimer: DebtBook does not provide professional services or advice. DebtBook has prepared these materials for general informational and educational purposes, which means we have not tailored the information to your specific circumstances. Please consult your professional advisors before taking action based on any information in these materials. Any use of this information is solely at your own risk.