13 Week Cash Flow Forecast: The Complete UK Guide for SME Owners

Ask any finance director how they keep a business out of trouble, and the answer is almost always the same: a rolling 13-week cash flow forecast. It is the single most useful financial tool a UK SME can run — and one of the least understood by the owners who need it most.

This guide explains what it is, why the number 13 matters, and how to build one that actually works.

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a week-by-week projection of the money coming into and going out of your business over the next quarter. Unlike an annual budget — which deals in months and averages — it deals in specific weeks and specific payments. It tells you, for each of the next 13 weeks: how much cash you'll start the week with, what's coming in, what's going out, and what you'll end the week with.

The output is a single, powerful number for each week: your projected closing bank balance. When that number dips towards zero — or below — you have advance warning of a cash squeeze, usually weeks before it happens, while you can still do something about it.

Why 13 weeks? Why not a month, or a year?

Thirteen weeks is one quarter — and it's the sweet spot the entire treasury profession has settled on, for three reasons:

• Long enough to be useful. A quarter ahead is far enough to see a problem coming and act — chase a debtor, delay a purchase, arrange finance — before it becomes a crisis.
• Short enough to be accurate. Beyond about 13 weeks, weekly forecasting becomes guesswork. You know roughly who owes you what and what bills are due over a quarter. Push to six months and the detail dissolves.
• Weekly, not monthly. Monthly cash forecasting hides the danger. A month can end healthy while you were technically out of cash in week two — the payroll run that lands before the big customer pays. Only weekly granularity catches that.

What goes into it

A proper 13-week forecast is built bottom-up from real commitments, not top-down from averages. The building blocks:

Cash inflows

• Outstanding invoices, placed in the week you realistically expect payment — not the week they're due. This is the crucial refinement: a customer who always pays 15 days late should be forecast 15 days late.
• Expected new sales likely to be invoiced and paid within the window.
• Other inflows — VAT refunds, grants, loan drawdowns, owner injections.

Cash outflows

• Supplier invoices due for payment, by week.
• Payroll — usually your largest and most rigid outflow.
• Tax — VAT, PAYE, Corporation Tax, placed on their exact HMRC due dates. These are large, predictable, and the most common cause of a forecast that looked fine suddenly turning red.
• Recurring payments — rent, loan repayments, direct debits, subscriptions.

The refinement that makes it predictive

The difference between a basic schedule and a genuinely predictive forecast is one thing: adjusting each invoice's expected receipt date based on that customer's actual payment history, not their stated terms. A customer on 30-day terms who reliably pays in 47 days should be forecast at 47 days. Do this across your debtor book and your forecast shifts from wishful thinking to something you can bank on. This is exactly the modelling logic a finance director brings that a spreadsheet template does not.

How to build one

1. Start with today's actual bank balance. The one fact everything else builds on.
2. List your 13 weeks as columns. Rows for opening balance, each inflow category, each outflow category, net movement, closing balance.
3. Populate inflows from your debtors, timed to realistic payment dates.
4. Populate outflows — suppliers, payroll, tax, recurring costs — on their real dates.
5. Let each week's closing balance carry into the next week's opening balance.
6. Refresh it weekly. A forecast is only as good as its last update. Roll it forward every week so you always have a full quarter of visibility.

You can build this in Xero to a point, but Xero's native forecasting has real limits — we cover exactly where it stops in our guide to the cash flow forecast in Xero. Many owners start in a spreadsheet and quickly find that keeping it accurate every week is the hard part — which is where a fractional finance function earns its fee.