The 13-Week Cash Flow Forecast for Small Businesses: The Weekly Hour That Ends the Overdraft Surprise

The four rows that matter, the Monday-morning hour that rolls the window forward, the three rules that keep the forecast honest, and the five traps that turn a spreadsheet into a decoration.

Most small businesses discover their cash position the way you discover a low tyre: at the worst possible moment, and only once it has already cost something. The profit-and-loss statement says the business is fine; the bank account says Tuesday is a problem; and the gap between the two is timing — invoices that age while payroll and the BAS sit on fixed dates. The cash runway checklist is the survival instrument for when money is genuinely short. The 13-week forecast is what you run the rest of the time, so the short spell never arrives as a surprise. Thirteen weeks — one quarter — is the horizon where cash problems are still fixable: a month is too short to change anything, a year is too vague to believe. It takes an hour on Monday to run, one spreadsheet tab, four rows, and it feeds directly from the debtor days review that tells you what your receivables are actually doing.

1. Why thirteen weeks — not a month, not a year

• A month is too short. A month-end view hides the week inside the month where payroll, rent and the tax instalment land together. Businesses do not run out of money "in March"; they run out on the Thursday of week 5.
• A year is too vague. An annual budget is a set of opinions. Nobody banks on opinions. At thirteen weeks the inputs are named invoices, dated runs and known due dates — commitments, not hopes.
• Thirteen weeks is one full quarter. It catches every recurring beast at least once: rent cycle, payroll cycle, BAS quarter, superannuation quarter, the supplier's end-of-month terms, and the seasonal dip you always forget.
• It is the length of the future you can still change. A hole thirteen weeks out has eleven solutions. A hole on Friday has two, and both are phone calls you didn't want to make.

2. The four rows — the whole instrument

One tab. Columns: week 1 to week 13, Monday dated. Rows:

1. Cash in. Only money that clears. Collections from the debtor list (by customer, by week — this is where the overdue invoice ladder plugs in), standing customer payments, and other recurring receipts. Not booked invoices. Not "usually pays around the 20th" unless it has cleared the last three months running.
2. Cash out. The five fat lines, each its own row if you can: payroll, rent, suppliers (by terms — see the supplier payment terms), tax and super (dated, immovable, never swept into "other"), and everything else. The thin long tail goes in one line; the fat dates deserve their own.
3. Opening balance. Last week's actual closing balance. Actual, not forecast — the forecast version is only ever a rehearsal; this row always starts from the bank's word.
4. Closing balance. Opening plus in minus out. And one derived number that does the real work: weeks of cover — closing balance divided by average weekly outgoings.

Colour the closing row: green above the floor, amber within two weeks of it, red under it. The floor is a number you agree once — commonly four weeks of payroll — written on the sheet, not remembered by mood.

3. The weekly hour — Monday, nine o'clock, same chair

1. Pull actuals. Last week's bank statement line by line into the in/out rows. Five minutes. The forecast is only as honest as this step.
2. Roll the window. The finished week drops off the left; a new week 13 appears on the right, seeded with the recurring lines. Two minutes.
3. Update the promises. Every customer invoice now dated inside the window: which week will it actually clear? Move it to the week you believe, based on the customer's real behaviour, not the due date printed on it. Ten minutes — and it is the highest-value ten minutes of the hour.
4. Read one number. Scan the closing row for the next thirteen Mondays. Any red, any amber: that week is today's problem. Decide on it today — pull a claim forward, move a discretionary spend right, call the supplier about terms, or arrange the buffer before you need it.
5. Write one line. The week's note: what moved, what you decided, what you're watching. In three weeks that line is the reason you'll trust the sheet.

One hour, one owner, same chair every week. The forecast that lives in the bookkeeper's head and updates "when there's time" is a spreadsheet of the dead — the ritual is the instrument.

4. The three rules that keep the forecast honest

• Book the cheque, not the promise. "He always pays around the 15th" goes in on the 15th only if it has cleared on the 15th three times running. Collection optimism is the single biggest corruption of small-business forecasts — every promised week is a week you quietly borrowed from your own future.
• Payroll and tax are first-order; everything else negotiates. The forecast exists so the immovable lines are never surprised. Suppliers negotiate; discretionary spend moves; the ATO's date and the payroll run do not.
• The floor is agreed once, in writing. Four weeks of cover, or whatever your nerves require — but it is a number on the sheet, decided on a calm Monday, not re-litigated on a frightened Friday.

5. The five traps

• Forecasting profit instead of cash. The P&L recognises the invoice the day it's issued; the bank recognises it the day it clears. A forecast built from sales rather than collections is a wish with formatting.
• The tax calendar treated as weather. BAS, super, payroll tax and instalments are the most predictable cash-out you have — every quarter, same shape. When they arrive as a surprise, it is because they were never rows.
• Collection optimism. See rule one. It is also the trap that makes the debtor days number worse every month you believe it.
• Building it once and never rolling it. A forecast is a window, not a wall chart. The Monday hour IS the system; the spreadsheet is just where it lives.
• One owner in theory, three in practice. When the bookkeeper, the owner and the accountant each hold a different version of "the numbers", the forecast is a fourth spreadsheet nobody updates. One owner of the window; the accountant reconciles it monthly at the close.

6. Worked example — the joinery contractor's week 5

A nine-person joinery and fit-out contractor, $1.9M revenue, profitably busy for years — and yet every quarter there was a fortnight where the owner personally checked the account before payroll ran. One wet June Monday he built the sheet: four rows, thirteen weeks, two hours with the bank statements. Week 5 closed red: three progress claims due to clear that week, payroll, and the BAS instalment, all on the same days — a hole of $68,400, eleven weeks out. Because it was week 5 and not Friday, there were eleven solutions: two claims invoiced the same day instead of "when the site wrap finishes" (pulled a week early), the timber order moved onto 30-day terms agreed in one phone call (the terms checklist from this site), and the hire invoice — $9,800, discretionary that fortnight — moved right three weeks. Week 5 closed at +$11,200. Payroll never checked the weather again; the overdraft was cancelled at renewal because it hadn't been touched. His line, verbatim: "The hole was always there. The only thing that changed is that I met it eleven weeks early, with options, instead of on the day, with none."

Kits

Every page ships with a kit block — the paid tools behind the free advice:

• The First 30 Minutes — free incident quick-start checklist
• Ops Starter Kit — incident response for small teams — $14
• Ops Starter Kit Vol. 2 — advanced incident response & communications — $27
• Ops Mega Bundle — all 5 kits in one download — $49

Related: the cash runway checklist is the survival instrument for when money is genuinely short — this forecast is what keeps it from ever getting there; the debtor days review is the monthly truth about how fast receivables really turn into cash — it calibrates the collection weeks in this sheet; the supplier payment terms checklist is the lever on the outflow side — the same negotiation that moved the timber order in the worked example; the overdue invoice letters are what you send when a promised week quietly doesn't clear; and the month-end close is where the forecast's actuals get reconciled against the books.

Related: the purchase order process is why the forecast's outflow row can be believed — every commitment enters the books the week it is made, not the week the invoice ambushes you.

Related: the budget vs actuals review is the P&L sibling of the 13-week forecast — one asks is the business the one you planned, the other asks will the bank account survive the quarter; findings feed forecast rows the same day.

Related: the gross margin pricing review is where the cash this forecast counts actually comes from — a quarterly read of margin by job catches the free work early enough for the repricing to land inside the quarter’s window.

The close surfaces the year’s lumpiest payments (tax, bonus, CPA) — the year-end close checklist decides when they land in the forecast.