Ask an insolvency practitioner what small companies lack when they fail and the answer is rarely “customers” — it is visibility. Businesses run out of cash with profitable order books because nobody saw the gap coming. The 13-week cash flow forecast is the standard fix: a week-by-week projection of money in and money out, long enough to see problems early, short enough to stay accurate.
Build it in four passes
- Opening position: actual cash in the bank today. Not accounting balance — cleared money.
- Receipts: for each week, when cash actually lands. Invoice date plus your real payment terms — if customers pay at 45 days, the cash lands in the week 45 days out, not when you bill.
- Payments: wages and PAYE on their real dates, VAT quarters, rent, software, the loan, corporation tax instalments. Weekly, on the date money leaves.
- Net movement and closing balance per week. The closing column is the forecast — any week it goes negative is a crisis you have now seen thirteen weeks early.
What it reveals that the P&L hides
A business can be profitable and still die on a Tuesday. The forecast exposes the structural traps: the VAT quarter that lands between two late-paying customers; the annual insurance premium that always surprises; the new hire whose payroll cost starts in March while their revenue starts in June. These are timing problems, not viability problems — but only if you see them early enough to fix with a call, a deposit request or an overdraft conversation held calmly, not desperately.
“Nobody went bust because their thirteen-week spreadsheet was too accurate.”
Running it as a habit
Update weekly — same day, same time, fifteen minutes. Replace the oldest week with a new week at the end. When actuals diverge from the forecast, note why: a customer paying late twice is a pattern to act on, not noise. And keep the file boring — the value is in the discipline, not the formatting.
When the forecast says trouble
The forecast’s value is the lead time it buys. A closing balance heading negative in week nine gives you nine weeks of options: chase the two biggest overdue invoices, negotiate supplier terms, draw the overdraft you arranged when you did not need it, pull forward billable work, or trim the discretionary spend. The same gap discovered in week nine is a crisis; discovered now it is a decision.
And it works the other way too — a forecast showing sustained surplus is the case for the hire, the equipment purchase, or the dividend you have been deferring. The spreadsheet does not just prevent failure; it licenses confidence.
Keep a separate buffer too. The forecast shows when cash runs out; a buffer — an overdraft arranged in advance, a director loan facility agreed on paper, a retained tax reserve account — is what you spend when it does. The businesses that survive cash squeezes are rarely the ones with better forecasts alone; they are the ones who arranged the lifeline before the forecast said they needed it.
Do I need special software?
No. A spreadsheet with weeks across the top and cash flows down the side is the industry standard — even large companies in distress run 13-week forecasts in Excel. Your accounting software can help fill it, but the model itself is simple.
Build the habit while things are calm. The worst time to learn the 13-week discipline is the week the bank calls; the business that already has the spreadsheet updates it in minutes and answers the question the bank is actually asking. Start this Friday, while there is nothing urgent to see.
How accurate does it need to be?
Directionally right beats precisely wrong. The point is to see the shape — which weeks dip, how deep, whether the trough recovers — not to predict to the pound. Review the variance weekly and the accuracy improves fast.
