The 13-week cash flow forecast, explained

Cash pressure in owner-managed businesses often comes down to timing rather than profitability, although it can also reflect underlying trading or margin problems. A company can be trading profitably on paper and still be unable to meet payroll in the third week of a month because a large customer paid late and a VAT payment fell due in the same week. A 13-week cash flow forecast exists to make that timing visible before it becomes urgent.

This article explains what the forecast is, how to build one from data you already hold, what a realistic worked example looks like, and the mistakes that quietly make a forecast useless.

What a 13-week cash flow forecast actually is

A 13-week cash flow forecast is a rolling, week-by-week projection of money actually entering and leaving your bank accounts over the next quarter. It is a cash document, not an accounting one: it ignores accruals, deferrals, depreciation and revenue recognition, and cares only about the date on which funds clear.

Each week has an opening bank balance, expected receipts, expected payments, and a closing balance that becomes the next week's opening balance. The value is in the shape of that closing-balance line: where it dips, how deep the dip is, and how much warning you have.

Why 13 weeks rather than 4, 26 or 52

Thirteen weeks is approximately one quarter. That length is a compromise that happens to work well in practice:

• It is long enough to capture a full cycle of quarterly obligations — a VAT quarter, a rent quarter, seasonal swings — rather than only the next payroll run.
• It is short enough that most of the inputs are known rather than assumed. You largely already know who owes you what, and what you have committed to pay.
• It gives usable lead time. Thirteen weeks is generally enough notice to chase debt, renegotiate terms, defer discretionary spend or open a conversation with a lender before the position becomes distressed.
• It maps to reporting rhythm. Rolled forward weekly, it always looks a quarter ahead without ever needing a rebuild.

A four-week view can be useful for immediate cash control, but it often leaves too little lead time for larger actions such as arranging finance or renegotiating terms. A twelve-month view serves a different purpose again: it supports longer-term planning and budgeting, and necessarily relies more heavily on assumptions. The 13-week horizon sits between the two, focused on near-term liquidity control.

Who should be running one

A 13-week forecast is worth the effort for any UK business where cash timing is not trivially comfortable. In particular:

• Owner-managed businesses with lumpy receipts — professional services, agencies, construction and contracting, anything invoicing in stages.
• Founder-led and venture-backed companies that need to understand runway in weeks rather than a single headline number.
• Businesses with seasonality, stock or upfront supplier payments, where cash leaves long before revenue arrives.
• Any company approaching a covenant test, refinancing, large capital commitment or acquisition.
• Directors who want a documented view of near-term liquidity to support informed board decisions.

If your bank balance never gets close to a level that would worry you, a monthly view may be enough. The moment it does, weekly is the right granularity.

The inputs you need before you start

Almost everything required already exists in your accounting system and your bank. Gather:

1. Cleared bank balances for every account, as at the same date. Not the ledger balance — the amount actually available.
2. The aged debtors report, with realistic expected payment dates rather than invoice due dates.
3. The aged creditors report, plus any agreed payment plans or supplier arrangements.
4. Committed payroll: salaries, pension contributions, PAYE and National Insurance, plus any expected bonuses or contractor payments.
5. Recurring fixed outflows: rent, service charges, insurance, software subscriptions, finance and lease payments, loan repayments.
6. Tax payment dates and amounts already crystallised or reliably estimable.
7. Known one-offs: capital expenditure, dividends, professional fees, deposits, refunds.
8. A short, honest note of your assumptions — particularly around the timing of new sales, which is where forecasts most often break.

A note on tax timing

Tax payments are the outflows most often mis-dated, because the deadlines are defined relative to your own periods rather than the calendar. Check yours against the primary sources rather than memory: VAT return and payment deadlines, paying PAYE and National Insurance to HMRC and Corporation Tax payment deadlines. Whether you pay VAT quarterly or monthly, and whether Corporation Tax is due in a single payment or by instalments, changes the shape of the forecast materially.

Building the forecast week by week

Step 1 — Fix the week structure

Choose a consistent week-ending day, usually Friday, and use it everywhere. Number the weeks 1 to 13. Week 1 opens with today's cleared bank balance.

Step 2 — Lay in receipts you can evidence

Take each open sales invoice and place it in the week you genuinely expect payment, informed by that customer's actual behaviour rather than your terms. A customer who has paid on day 52 for the last six invoices will not pay on day 30 because the invoice says so. Add contracted recurring revenue, retainers, direct debits and any grant or refund with a known date.

Step 3 — Add pipeline receipts separately

Revenue that is not yet invoiced belongs on its own line, clearly labelled, so you can strip it out in seconds. Mixing contracted and hoped-for income is the fastest way to lose trust in your own numbers.

Step 4 — Lay in outflows in the order you must pay them

Start with the non-negotiable: payroll, PAYE and pensions, tax payments, loan and lease repayments, rent. Then trade creditors by expected payment run. Then discretionary spend last, because that is the line you will flex when the forecast tightens.

Step 5 — Calculate the closing balance and read the line

Closing balance equals opening plus receipts minus payments, carried into the following week. Now look at the pattern rather than any single week: the lowest point, the week it occurs, and whether the trend across the quarter is rising or falling. A forecast that ends higher than it starts but dips below zero in week 6 is still a problem.

Step 6 — Add a variance column

Each week, record what you forecast against what actually happened. Variance analysis is what converts a spreadsheet into a forecasting capability: after a quarter you should have a much clearer view of which assumptions you tend to get wrong, and roughly by how much.

A worked example

The illustrative figures below are for a fictional UK services business with roughly £2.4m annual revenue, monthly payroll paid on the last working day, and quarterly VAT. Only the first six weeks are shown; a real forecast would run to 13.

The useful insight is not the closing figure. It is that week 4 combines payroll with a quarterly VAT payment and leaves only £34k of headroom, and that week 6 does something similar through supplier timing. Five weeks' notice does not guarantee a solution, but it does create more options — for example moving a payment run by seven days where agreed terms allow it or the supplier agrees, or chasing two large invoices early. The same weeks are far harder to manage if the pressure is only discovered on the Monday morning it occurs.

Common errors that make a forecast useless

• Using invoice due dates instead of expected payment dates. This is one of the most common causes of a forecast that is consistently and cheerfully wrong.
• Forecasting profit rather than cash. VAT, capital expenditure, loan principal and dividends never appear in your profit figure but always leave the bank.
• Omitting VAT on both sides. Receipts arrive gross and many payments go out gross; only the net position is settled with HMRC, and it is settled later.
• Blending contracted and pipeline income into one line, so nobody can tell how much of the forecast is evidence.
• Building it once. A forecast that is not refreshed is a historical document within a fortnight.
• Excessive granularity. Fifty supplier lines will not be maintained; six well-chosen categories will.
• Forgetting that payroll dates, bank holidays and month-ends move.

How often to update it

Weekly, on a fixed day, rolling forward so that you always see 13 weeks ahead. How long the refresh takes depends on the complexity of the business and the quality of the underlying data; once the structure is stable it is usually a short routine task: import the actual bank position, update expected receipt dates, add the new week 13, and record variance against last week's forecast.

If cash is tight, move to a short daily check on the bank position alongside the weekly refresh. If the business is comfortably funded, a fortnightly refresh may be adequate — but keep the weekly grain, because the grain is what reveals the timing.

Scenario planning without over-engineering it

A base, downside and upside case are often a practical starting point. Add further scenarios only where they support a specific decision, since additional versions tend to be read less carefully.

1. Base case — contracted receipts only, on realistic payment dates, with all committed costs.
2. Downside — key receipts delayed by a fixed number of days, pipeline income removed entirely, and any known cost risk included. This is the case that tells you your true minimum headroom.
3. Upside — pipeline converting on plan, used to decide when it is safe to commit to hiring, stock or capital spend.

Build the downside first. It is the one that changes decisions, and knowing your worst realistic week is worth more than any amount of optimism modelling.

When to bring in professional support

Many businesses build and run a 13-week forecast perfectly well in a spreadsheet. Outside help tends to be worth it when the forecast has to be trusted by someone other than you — a bank, an investor, a board — or when the underlying data is not yet clean enough to forecast from.

Consider support if you are preparing for a funding round or refinancing, if your bookkeeping is behind, if the numbers are consistently wrong and you cannot see why, or if directors want a documented view of near-term liquidity to support board decisions. We set up and maintain rolling forecasts as part of our cash flow forecasting service, usually alongside budgeting and forecasting and, where a business needs senior finance input without a full-time hire, fractional CFO support.

If you would like to talk through whether a 13-week forecast would help your business, get in touch.

Key takeaways

• Forecast cash, not profit, and use the date funds actually clear.
• Thirteen weeks is long enough to capture quarterly obligations and short enough to be evidence-based.
• Keep contracted and pipeline receipts on separate lines.
• Track the lowest weekly closing balance as your headline number.
• Refresh weekly and record variance — that is what builds accuracy.
• Build the downside case first.