Most treasury teams at governments and nonprofits use a cash flow forecast to manage future cash balances. Far fewer have checked that forecast against what actually moves in and out of the bank.
When a reimbursement lands late or a capital project slips, it affects the organization's cash flow. But if those changes aren’t caught and reflected in the forecast, cash flow projections will continue as if nothing happened. The number stops reflecting reality before anyone notices.
Those oversights can have material consequences for any organization. When you make financial decisions based on a forecast that nobody reconciles, the result is yield you didn’t actually earn, borrowing you didn’t need, and cash shortfalls you didn’t see coming.
That’s why a stale forecast can be worse than having no forecast at all: It carries the authority of a hard number without the accuracy.
Stacy Lassiter leads finance and treasury for Mobile County, Alabama, after 40 years in the private sector closing books by the fifth business day of every month with full variance analysis. The report he gives county commissioners today is a single backward-looking snapshot of last quarter's cash by fund, with no forward-looking forecast attached.
If that gap exists for someone with his discipline, it exists for a lot of teams.
This article covers what separates a cash forecast from a budget, how forecasts grow stale without regular review, and the simple fix treasury teams can make to keep their forecasts honest.
Cash flow forecasting is the process of predicting an organization’s future cash inflows and outflows to better plan for its upcoming cash liquidity needs.
We cover the full definition in our cash flow forecasting guide. The short version is laid out in the table below.
| Annual budget | Cash flow forecast | |
| Answers | Can we afford the year? | Will cash be there when bills fall due? |
| Layer | Governance | Operational |
| Horizon | Fixed fiscal year | Rolling, near-term |
| Updated | Approved once, then locked | Continuously, against actuals |
Most governments lean on a budget or capital plan as their forward-looking document. But as Luke Otto, Senior Product Specialist at DebtBook, puts it, that’s "not truly a rolling cash forecast." If you're the treasurer or treasury manager who owns the cash forecast, the first move is to stop asking a budget to do a job it was never built for.
Rolling forecasts are considered best practice, but only 43% of corporate finance teams use them, per the 2026 AFP FP&A Benchmarking Survey. Public-sector conditions make the discipline harder to sustain. Fund accounting, appropriations, and grant timing all introduce variability that a corporate rolling forecast wasn't designed to absorb.
That same survey found that only 14% of finance teams formally track forecast accuracy. That leaves the rest with no structured way to know whether last quarter's numbers held.
"Something that we hear about is assumption drift," says Otto. "A reimbursement lands late, a project slips, a revenue mix changes, and the model keeps projecting as if nothing moved."
For most cash managers, the forecast is a spreadsheet built from several manually polled data sources. Refreshing every assumption on schedule rarely happens, so the gaps compound quietly.
A DebtBook survey of public finance professionals surfaced a pattern Otto calls a catch-22. "Forecasting doesn't get listed as the top concern by a lot of finance leaders, yet it consistently shows up as one of the main barriers to doing the job well."
A forecast nobody reconciles doesn't stop being used. It misleads, because everyone treats its numbers as current.
Otto calls this calcification. A forecast that has calcified is "almost worse than not having a forecast at all," he says, because it produces false confidence in decisions that depend on:
"Forecasting feels optional right until the point that you need it and you don't have it," Otto says.
A forecast is supposed to be provisional. The discipline is keeping it honest as reality changes. Bryan Lapidus, Director of the FP&A Practice at the Association for Financial Professionals, puts it plainly: "Finance's response to an unpredictable future must be to maintain multiple points of view of what can happen. Inflexible budgets break."
The goal is a cash flow forecast whose gaps you can see and explain.
The solution to stale forecasting is to set up a rolling forecast that offers a standing comparison of projected versus actual cash flow.
"If you don't measure it, you can't manage it," says Lassiter.
Here are four steps to make that happen:
1. Make the forecast roll
A rolling forecast always looks a fixed distance ahead and slides forward as each period closes. The assumptions inside it don’t refresh themselves, which is how a forecast can keep rolling and still drift stale.
The mechanism is called actualizing. At each period-end, swap the closed period's projection for real results, then add a fresh period at the far end. "What we want to get to is a rolling thirteen week cash flow," Lassiter says.
2. Reconcile against actuals, at least every quarter
Once a quarter, put the forecast next to actual bank activity and measure the gap. Align that review to the cycle your board already sees. The forecast rolls forward more often as you position cash, but the quarterly reconciliation is the nonnegotiable check. "What we predicted versus what the actuals were," in Lassiter's words, is the comparison that shows where the model held and where it drifted.
3. Adjust the assumptions the variance exposes
A variance report only helps if it changes the next forecast. Where a reimbursement landed late or a project ran long, update your cash-in assumptions and cash-out modeling so the same miss doesn't repeat. Run what-if modeling on the inflows you trust least.
4. Keep it simple enough to sustain
Rolling forecasts collapse when every update means rebuilding dozens of line items. In government, you usually can't collapse the fund detail. That level of detail is a floor set by your auditors.
Simplify what you can: the number of assumptions, the update steps, and the manual data pulls. These are the cash flow management strategies worth prioritizing, because a rough forecast kept current is more useful than a precise one nobody maintains.
After spending the bulk of his career closing books in the private sector, Lassiter is facing the new challenge of rebuilding that discipline inside a government’s cash reality. Mobile County's commissioners still receive a backward-looking end-of-quarter snapshot.
"We don't have any kind of predictive report that we give them or a predictive forecast that we provide,” Lassiter says. “It is really just a snapshot.”
In many governments, the work still runs on manually gathering and keying data from several sources into a spreadsheet. The cadence lives or dies on one person's diligence.
Two variables make Mobile County's forecast harder to maintain than most. The first is the opening number. A forecast is only as good as the cash position it starts from, which means confirming the opening cash balance against pending deposits and uncleared checks before projecting anything forward.
The second is grants. "With the feds, you never know what you're going to get,” Lassiter says. “It's like Forrest Gump and the box of chocolates.” Building those inflows from actual expected dates keeps unpredictable grant timing from skewing the numbers for months before anyone notices.
Both feed the same downstream decision. "You got three buckets, really: your operating cash, your short term investment cash, and your long term investment cash," Lassiter says.
Getting that split right requires a current forecast. You can move operating cash into higher-yielding investments if you know when you'll need it back. A stale forecast pushes every liquidity call toward the conservative default, leaving money in low-yield accounts when it could be working harder.
DebtBook Cash Flow Forecasting is built to enable the forecasting discipline Lassiter is trying to implement.
It gives you a 13-month view of how your cash position is expected to change. Projections are entered on a one-off or recurring basis, with historical averages pre-populating the recurring amounts. When a capital project shifts or new information lands, you update the projection in place. Debt service payments from your debt team flow into the same system, so the obligations most likely to move a fund's balance are already reflected in the forecast.
Meanwhile, DebtBook Variance Analysis compares forecasted amounts against actual transactions coming in from your bank feeds. The predicted-versus-actual comparison runs as a standing view, updated automatically, so the quarterly check doesn't depend on a manual reconciliation.
With those solutions in place, treasury teams must then have someone accountable for keeping up with quarterly reviews and deciding which assumptions need to change.
Book a demo to see how DebtBook’s rolling forecast and variance analysis can benefit your organization.
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.