Most cash crises announce themselves weeks in advance. The evidence sits in the debtors list, the creditors list and the compliance calendar; it just never gets assembled on one page. The 13-week cash flow forecast is that page. It's the first document a turnaround specialist builds on day one in a struggling business, and the useful lesson is that you don't need to be struggling to want one.
Why thirteen weeks
Thirteen weeks is a quarter, and it sits in a useful middle ground. It's far enough ahead that you can still act on what you see: chase a debtor, bring an invoice forward, delay a discretionary purchase, arrange finance while you're negotiating from strength rather than need. And it's near enough that the entries are grounded in things that already exist, actual invoices, actual pay runs, actual due dates, rather than hopes. Push the horizon out much further and you're budgeting; pull it in to a fortnight and most of your options have already closed.
One page, weekly columns
Columns are the next thirteen weeks, dated by week ending. Rows come in four blocks.
- Opening bank balance. Actual cleared funds across every account that matters, net of any overdraft drawn.
- Cash in. Debtor receipts from your aged debtors list, placed in the week each invoice will realistically land based on that customer's actual payment habits, not the due date printed on the invoice. Then conservative sales estimates for point-of-sale income, drawn from seasonal history. Then the known one-offs: a tax refund, an asset sale, a grant instalment.
- Cash out. Wages and super by pay date, which under payday super now travel together. Rent and the fixed direct debits in their actual weeks. Supplier payments from aged creditors, placed when you intend to pay them. The lumpy items that sink unforecasted businesses: BAS, income tax instalments, insurance renewals, loan and lease repayments, each in its real week. Finally, a modest weekly allowance for the small unplanned spend your bank feed history says always happens.
- Closing balance. Opening plus in, minus out, carried forward as next week's opening.
Add one conditional-formatting rule: any closing balance below your comfort floor turns red. The red cells are the entire point of the document.
The first build
Block out an afternoon with your accounting file open. The debtors and creditors lists populate the near weeks almost mechanically; recurring patterns and last year's history fill the far weeks; the compliance calendar supplies the lumps. Two disciplines make the result trustworthy: be pessimistic about when money arrives and punctual about when it leaves. That skew is deliberate. A forecast that errs on the gloomy side produces pleasant surprises and early warnings; one that errs the other way produces neither.
The weekly refresh
Once built, the model runs on a short weekly ritual. Replace last week's estimates with what actually happened, note where reality diverged, roll a fresh week onto the end, and adjust anything you now know more about. The variance is where the education lives: within a couple of months you'll know which customers routinely pay late, which weeks always run heavier than planned, and how honest your own invoicing rhythm really is. That knowledge feeds straight back into better placement of next quarter's entries.
Acting on the red cells
A red week seen early is a task list, not a crisis. You can ring the two customers whose payments would clear it, shift a discretionary purchase back a fortnight, invoice a milestone this week instead of next, or talk to your bank or a key supplier while the conversation is still relaxed and hypothetical. Every one of those moves is cheap and dignified with several weeks' notice, and expensive and fraught with a few days'. The forecast doesn't create the options; it creates the notice.
Where forecasts go to die
Three failure modes account for most abandoned spreadsheets. The model gets built once, impressively, and never refreshed, so it decays into fiction. Receipts get entered optimistically, so the red cells that should be showing never appear. Or the whole thing is delegated so far from the owner that nobody with authority to act actually reads it. Keep the refresh small, keep the assumptions honest, and keep the document in front of whoever can move money and make calls. And if your bookkeeping is current, the whole ritual leans on numbers that already exist — one more argument for the weekly coding habits we come back to throughout our finance hub.
About the author
Nick Lucock
Chief Executive Officer, Valont
Nick leads Valont's day-to-day operations across Finance, People, Operations and Growth. He writes about how the work actually gets done, the processes, systems, and tools that keep Australian SMEs compliant and growing.
LinkedIn →