T’13-week forecast: thi early-warning system.The 13-week cashflow forecast, explained.What a 13-week cashflow forecast is and how to use it

If I could give every business owner one financial tool, it would be a 13-week cashflow forecast. It’s simple, practical, and it answers the question that matters most day to day: will we have enough cash to pay everything that’s due?

Why 13 weeks?

Thirteen weeks is one quarter. It’s long enough to include a full VAT cycle, at least three payrolls and most of your customers’ payment patterns. It’s also short enough to forecast with real confidence, because most of what happens in the next three months is already in motion: invoices you’ve sent, orders you’ve taken, bills you know about.

Monthly forecasts are useful for planning, but they can hide problems. A month that ends with a healthy balance might still dip below zero in week two, when payroll goes out before a big customer pays. Weekly detail shows you that dip.

What goes into it

• Opening cash: your actual bank balance today, across all accounts.
• Customer receipts: by customer or group, based on how they actually pay.
• Supplier payments: when you actually plan to pay them.
• Payroll and PAYE: on their real dates.
• VAT, Corporation Tax and other HMRC payments.
• Loan repayments, leases and finance agreements.
• Rent, insurance, subscriptions and one-off costs.

Each week works the same way: opening balance, plus receipts, minus payments, gives the closing balance. That closing balance becomes next week’s opening balance.

The three numbers I look at first

1. The low point. The lowest closing balance across the 13 weeks, and which week it falls in.
2. The buffer. How far that low point sits above the minimum cash you want to hold at all times.
3. The drivers. What causes the dip: a tax payment, a slow-paying customer, a seasonal quiet spell.

A forecast isn’t about predicting the future perfectly. It’s about seeing problems early enough to do something about them.

Keep it rolling

A 13-week forecast is most useful when it rolls. Each week or month, drop the period that’s passed, add a new one at the end and update for what’s changed. Then compare what actually happened against what you forecast. The differences show you where your assumptions need adjusting, and over time the forecast gets sharper.

Doing it yourself, or getting help

You can build a 13-week forecast in a spreadsheet, and if you’re comfortable in Excel, my free 13-week template is a good starting point. Where business owners tend to find value in help is turning the numbers into decisions: what to chase, what to delay and when to talk to the bank. That’s where my services come in.