Most cash flow guides tell you how to build a forecast. Almost none tell you how to check whether the one you already have is lying to you. A forecast that was accurate in January and has not been touched since May is not a forecast anymore. It is a guess wearing a spreadsheet.
Why Forecasts Quietly Go Bad
A cash flow forecast does not fail all at once. It drifts. A customer who used to pay in 30 days starts paying in 45. A vendor renegotiates terms. A hire that was supposed to start generating revenue in month two is still ramping in month four. None of these show up as a dramatic miss. Each one just nudges the model slightly off, and by the time the gap is big enough to notice on its own, you have usually been making decisions off bad numbers for weeks.
This is the audit nobody runs, largely because “check the forecast” is not a task most owners or bookkeepers have on a recurring calendar. It should be. A forecast that has not been reconciled against actuals in the last 30 days should be treated the same way you would treat a bank reconciliation that has not been done. Not disqualifying, but a flag.
The Four-Point Forecast Audit
You do not need a finance degree to audit your own forecast. You need four comparisons, run monthly.
- Compare last month’s projected ending cash to actual ending cash. If the variance is under 5%, your model is healthy. Between 5% and 15%, something specific has shifted and needs identifying. Over 15%, stop trusting the forecast until you rebuild the assumptions.
- Check your accounts receivable assumption against your actual AR aging. If you modeled 30-day collections and your aging report shows customers sliding into the 45 and 60-day buckets, your entire forecast is built on a payment speed that no longer exists.
- Test your largest single revenue assumption in isolation. Pull out whatever one customer, contract, or product line contributes the most to projected revenue and ask: is this still accurate, or is it the number I plugged in three months ago out of habit?
- Re-run your fixed cost base. Rent, insurance, subscriptions, and loan payments should almost never surprise a forecast. If they do, the model was not updated when a cost changed, which is the easiest drift to catch and the easiest to fix.
What Good Looks Like vs. What Drift Looks Like
| Signal | Healthy Forecast | Forecast in Drift |
|---|---|---|
| Monthly variance to actual | Under 5% | Over 15%, unexplained |
| AR collection assumption | Matches current aging report | Based on payment terms customers no longer follow |
| Update frequency | Reconciled monthly against actuals | Last touched more than 60 days ago |
| Assumption documentation | Each major line item has a stated reason | Numbers carried forward with no record of why |
| Downside scenario | Modeled and reviewed quarterly | Does not exist, or was built once and never revisited |
A forecast is not a document you finish. It is a model you maintain. The moment you stop reconciling it against reality, it stops being a forecast and becomes a story you are telling yourself.
Who Should Own This, and How Often
In most small businesses, nobody owns forecast maintenance because it falls between roles. The bookkeeper owns historical accuracy. The owner owns the big decisions. Nobody owns the bridge between the two. If you work with an accountant or fractional CFO, this audit is a natural monthly deliverable, not an annual one. If you do not, put a 20-minute recurring block on the calendar the same week you close the books each month. That is enough time to run all four checks against a live dashboard.
The businesses that get burned by bad forecasts are rarely the ones without a forecast. They are the ones with a forecast they stopped questioning. A model built in January and trusted unchanged through Q3 has usually drifted further from reality than most owners realize, because nothing forced them to look.
What Is a Cash Flow Forecast Audit?
A cash flow forecast audit is a recurring comparison between what your model projected and what actually happened in your bank and accounting data, run to catch drift before it compounds into a bad decision. It is not a rebuild. It is a monthly checkup that tells you whether the assumptions underneath the model still hold, and it takes a fraction of the time it took to build the forecast in the first place.
How often should a small business audit its cash flow forecast?
Monthly, tied to your close process. A quarterly cadence is too slow for a business with tight margins or seasonal swings, because three months of undetected drift is usually enough to make a hiring or spending decision on numbers that no longer reflect reality. Weekly is more than most small businesses need unless cash is genuinely tight, in which case a rolling 13-week cash flow forecast reviewed weekly is the better tool.
What is the biggest sign a forecast has gone stale?
The assumptions have not changed even though the business has. If your team grew from six people to eleven, your rent increased, or your biggest customer renegotiated payment terms, and none of those changes show up as edits in your forecast, the model is running on outdated inputs regardless of how sophisticated it looked when it was built.
Try It With Your Own Numbers
An AI-connected forecast updates itself against your actual bank and accounting data, so the gap between projection and reality gets caught in days, not months. Connect your QuickBooks or Xero account and get your first cash flow forecast in under 60 seconds.
Create your free Finoya account and see what your cash flow looks like for the next 90 days, checked against your real numbers automatically.