The 13-week cash flow forecast: a director's guide

Why 13 weeks, not 12 months

An annual budget tells you whether the year should work; it tells you nothing about whether you can pay this Friday's wages. The 13-week forecast fills that gap. It tracks the actual movement of cash — money hitting and leaving the bank — over a horizon short enough to estimate accurately but long enough to give you warning before a shortfall lands. It is the standard tool turnaround specialists reach for first, precisely because it exposes liquidity risk that a profit-focused view hides. See profit versus cash flow.

What goes into it

Start with your opening bank balance. Then, week by week, list expected receipts — customer payments timed to when you actually expect the cash, not the invoice date — and expected payments: wages, PAYE and VAT, rent, suppliers, loan repayments, and anything else that leaves the account. Each week's closing balance carries into the next. The output is a running bank balance thirteen weeks out, so you can see exactly which week, if any, dips into the red.

Timing is everything

The forecast lives or dies on timing. An invoice raised today on 30-day terms is not cash today — and if that customer runs to 45 debtor days in practice, forecast it at 45. Be honest about how late your payers really are. On the payment side, know your fixed dates: PAYE by the 22nd, VAT a month and seven days after quarter-end, wages on their usual day. Getting the dates right matters more than getting the pennies right.

Roll it forward every week

The forecast is a living document. Each week, replace the oldest week's estimates with what actually happened, add a new week 13 on the end, and revise the weeks in between against reality. This rolling discipline is what turns a spreadsheet into an early-warning system: variances between forecast and actual show you where your assumptions are wrong before they cost you. Learn the mechanics in how to build a 13-week forecast.

Using it to make decisions

Once you can see a dip coming three or four weeks out, you have options: chase a large receivable early, delay a discretionary payment, or arrange a short facility before you actually need it — always cheaper than arranging one in a panic.

Credicorp lends to your company, not to you personally, and takes no personal guarantee. See indicative terms on business loans, or apply online in minutes.

Model the numbers with the cash flow forecast calculator.