Home / Resources / Cash flow
The 12-month cash-flow forecast every owner should have
Profit is an opinion. Cash is a fact. Here is what belongs in a rolling 12-month cash-flow forecast, how often to update it, and the three mistakes that make most forecasts useless.
Most small business owners can tell you last month's revenue. Far fewer can tell you what their bank balance will be in eleven weeks. That gap is where cash crises live. A rolling 12-month cash-flow forecast closes it. Not a budget you file in January. A living document that always shows you the next twelve months.
What actually goes into it
Four blocks, in this order: starting cash (what is in the bank today, by account), cash in (expected collections by customer or revenue stream, timed to when the money actually lands, not when you invoice), cash out (payroll, rent, vendors, debt service, taxes, owner draws, grouped by category), and the weekly view (the next 13 weeks in weekly detail, months 4 through 12 in monthly detail, because timing matters most up close).
How often to update it
Monthly, at minimum, rolling forward one month each time so you always see twelve months out. Update it the week after your books close. If cash is tight or you are in a seasonal swing, move to a weekly update on the 13-week detail until the pressure passes. A forecast that is more than a month stale is decoration.
Mistake 1: confusing profit with cash
A profitable month can still drain your bank account if big receivables are outstanding, inventory just got stocked, or quarterly taxes hit. Your P&L tells you whether the business model works. Only the cash forecast tells you whether you make payroll on the 15th. Run both, but never substitute one for the other.
Mistake 2: building it once a year and filing it
Static annual budgets go stale the month after they are built. Assumptions change, customers pay late, a key hire quits. The "rolling" part is the whole point: every month, replace last month's guesses with actuals and extend one month further out. The forecast gets sharper over time instead of older.
Mistake 3: forecasting sales but not collections
The most common modeling error we see: revenue is booked when invoiced, but cash arrives 30 to 60 days later. If your forecast does not model payment timing by customer, it will tell you that you are fine right up until you are not. Model cash in by expected receipt date, and be honest about your slow payers.
What good looks like
One page for the summary: low-cash weeks flagged, big inflows and outflows annotated, and three numbers at the top (minimum cash balance, months of runway, and forecast vs. actual accuracy last month). Detail lives behind it for anyone who wants to dig. If you will not open it every month, it is too complicated. Simplify until you will.
See 12 months ahead
We build rolling cash-flow forecasts for owners who are done guessing. Start with a free discovery call.