Building a 13-Week Rolling Cash Flow Forecast

The 13-week cash flow forecast is the most important short-term cash tool a Financial Controller can build, and one of the most undervalued until the moment it is needed. When cash is tight — in a downturn, during growth that consumes working capital, in a turnaround, or whenever the gap between profit and cash becomes a live concern — it tells the business whether it can meet its obligations, and when. A company with a good one navigates a squeeze with foresight; a company without one finds out about a shortfall when a payment fails to clear.

This guide is the practical build: the template layout, the receipts and payments lines, the data source for each line, the weekly update, variance to actuals, the covenant and headroom rows, and how lenders use the forecast. For the broader method — why the forecast exists, scenarios, and who should own it — read our step-by-step guide to creating a 13-week rolling forecast. For the longer, monthly, driver-based view that sits above it, see building a rolling forecast.

Why Thirteen Weeks

Thirteen weeks is one quarter: long enough to see the cash consequences of decisions being made now, short enough to forecast individual receipts and payments with real accuracy. Beyond that, weekly timing becomes speculative and the monthly forecast and budget take over. Within it, the major flows are largely knowable — what customers owe and roughly when they pay, what you owe and when it falls due, payroll dates and HMRC dates.

It is also the horizon over which a business can still act on a looming shortfall: accelerate collections, defer discretionary spend, draw on a facility, or talk to the bank before the problem arrives rather than after. A forecast that only shows a shortfall in the week it happens gives no time to act.

Direct, Not Indirect

The 13-week forecast uses the direct method — actual cash receipts and payments, week by week — not the indirect method that starts from profit and adjusts for non-cash items. The indirect method, familiar from the statutory cash flow statement, explains the link between profit and cash over a period. It does not tell you what will hit the bank account in week six. The direct method does, which is exactly what short-term cash management needs.

Each line is forecast in the week the cash is expected to move. The closing balance of each week becomes the opening balance of the next, so the sequence shows the cash trajectory across the quarter.

Structuring the Forecast

A good template has thirteen weekly columns (week-ending dates, usually Fridays), with rows grouped into opening cash, receipts, payments, net movement, closing cash and, below that, the facility and headroom rows. The illustrative extract below shows the first six weeks for a business with a monthly payroll, quarterly VAT and a revolving overdraft. Figures are in £000 and are illustrative only.

Weeks 7 to 13 continue in the same format, and a final column totals the thirteen weeks. Week 4, when payroll and a loan repayment coincide, is the pinch point; week 6 brings VAT. A Financial Controller seeing this would look at pulling forward key-account collections into week 3 or 4, or moving the week 3 supplier run, well before the week arrives.

The receipts lines

Split customer receipts so the lines mean something. Major customers go individually where a single late payment would move the forecast; the rest sit in sensible groups, such as by region, channel or payment terms. Other receipts Other receipts — facility drawdowns, grants,mdash; grants, asset sales, VAT repayments, R&D tax credits — get their own lines so they never disguise the trading position. Facility drawdowns are best shown below the closing cash line rather than as receipts, so the forecast shows the underlying trading cash and the funding separately.

The payments lines

Payments should mirror how the business actually spends. The usual lines are:

• Suppliers, on the days the payment runs actually happen, with large or critical suppliers shown separately.
• Payroll, as net pay on pay day, with PAYE and National Insurance to HMRC as a separate line — electronic payments are due by the 22nd after the end of each tax month (see HMRC’s PAYE guidance for employers). Pension contributions follow their own date.
• VAT, in the week it is due — usually one month and seven days after the end of the VAT period, as set out in VAT Notice 700. Our guide to VAT for finance teams covers schemes that change the timing.
• Corporation tax, on its due date or instalment dates, which differ for larger companies (see gov.uk on Corporation Tax).
• Rent, often quarterly in advance, and other recurring overheads.
• Capital expenditure that is committed, not merely planned.
• Financing: loan repayments, interest, lease payments and any dividends.

Adapt the lines to the business: a contractor may need lines for retentions and applications for payment; a retailer for card settlement timing; a SaaS business for annual upfront billing.

Where the Numbers Come From

The forecast is only as good as its inputs, and the Financial Controller’s job is to source each line from the most reliable basis available, then apply judgement.

The early weeks are built mostly from the ledgers; the later weeks increasingly from the forecast and order book. That handover is where many forecasts go wrong, because the later weeks are built from sales at face value rather than converted into cash at realistic collection rates. The art is in the judgement: forecasting when the customer who always pays late will actually pay, not when the invoice says they should, and picking up the one-off items the ledgers do not yet show. A forecast built mechanically from due dates is systematically optimistic. That judgement is why cash forecasting remains a controlling responsibility even as tools improve; our guide to AI for cash flow forecasting covers where automation genuinely helps, such as collection-pattern analysis and bank-feed matching.

The inputs also depend on a clean ledger. If debtors are not reconciled or supplier invoices sit unposted, the forecast inherits the mess. A disciplined close, covered in our guide to optimising the month-end close, is the foundation.

Keeping It Rolling

“Rolling” is the difference between a forecast that works and one that gathers dust. Every week, at the same time, the forecast is updated:

1. Replace the forecast opening cash with the actual bank balances, reconciled.
2. Record the week just gone as actuals and compare line by line with what was forecast.
3. Drop the completed week and add a new week 13 at the far end.
4. Refresh weeks 1 to 6 from the latest aged debtors, aged creditors and payment-run plan.
5. Revisit the assumptions in weeks 7 to 13 and update for anything new — orders, hires, capex approvals, tax.
6. Recalculate headroom and covenant rows, then write a short commentary on what changed and why.

Many teams run this early in the week so it can inform that week’s payment run. Keep each week’s version; the history makes variance analysis possible.

Variance to Actuals

Comparing forecast with actual is where the forecast improves and earns trust. Each week, the Financial Controller should be able to see where the previous forecast was right and where it was wrong, and why: the receipt that arrived later than expected, the payment that was larger than forecast, the item nobody knew about.

Two distinctions make variance analysis useful. First, separate timing variances (a receipt that slipped a week) from permanent ones (a receipt that will never come, or a cost that was missed). Timing variances reverse; permanent ones change the outlook. Second, track accuracy over time, not just week to week. A simple measure — forecast closing cash four weeks out against the actual when that week arrives — exposes any consistent bias, most often over-forecast receipts. The wider discipline of explaining variances is covered in variance analysis that drives decisions.

The Covenant and Headroom View

Below the closing cash line sit the rows that turn a projection into a management tool: the facility limit, the undrawn facility, available liquidity, and headroom against any minimum cash or liquidity covenant. These rows answer the question the business and its lenders actually care about — not “what is the balance?” but “how close are we to the limit, and in which week?”

Where facility agreements include financial covenants — minimum liquidity, leverage, interest cover — the forecast should show the test dates and a projected position for each. Liquidity covenants can be read straight from the weekly forecast; earnings-based covenants need the monthly forecast too, which is one reason the two must reconcile. Set an internal trigger well above the covenant level, so that a forecast breach of the trigger prompts action long before a breach of the covenant itself. Our guide to AI for covenant and KPI tracking covers tools that monitor these automatically.

Using the Forecast to Manage Cash

A 13-week forecast is only worth building if it changes decisions. When it shows a tight week or a headroom breach ahead, it should trigger action: chasing specific customers, re-timing payment runs, deferring discretionary spend, arranging additional facility headroom, or opening an early conversation with the bank. If tax payments are the problem, HMRC may agree a Time to Pay arrangement, but only if approached before the payment is missed.

The forecast also informs larger decisions: whether the business can afford a planned investment or hire, and whether and when it needs to raise finance. In a turnaround, it becomes the central management document, reviewed constantly; our guide to cash flow management in a downturn covers that context.

The Relationship Between Profit and Cash

Profit and cash are not the same, and a profitable business can run out of cash. Working capital movements, capital expenditure, financing flows and the timing gap between recognising revenue and collecting it all drive a wedge between the two. Fast growth is the classic case, funding receivables and stock ahead of the cash coming back. Part of the Financial Controller’s job is to make this visible to a leadership team that may equate a healthy profit with a healthy bank balance, and the 13-week forecast is the tool that makes it concrete.

Scenarios and Sensitivities

A single-point forecast says what is expected; cash management is about risk. Adding a downside case — the largest receipts slip by two or three weeks, a key customer pays late, a discretionary cost cannot be deferred — shows how much headroom the business really has. No elaborate model is needed: flex the timing of the biggest receipts and see what happens to the headroom row. The broader approach is set out in our guide to budgeting and reforecasting.

Common Pitfalls

• Optimism on collections — forecasting when customers should pay rather than when they do.
• Smoothing lumpy outflows — quarterly VAT, corporation tax, rent and insurance renewals spread evenly rather than shown in the week they hit.
• Building and abandoning — a forecast that is not updated weekly drifts and loses credibility.
• Unreconciled opening cash — starting from a ledger balance rather than the bank.
• Spreadsheet fragility — hard-coded numbers, broken links and no checks. Build in a check that closing cash equals opening cash plus net flow, and lock formula cells.
• Treating it as a finance document — producing it in isolation rather than using it to drive collections, payment timing and decisions.

The Forecast in a Banking or Investor Relationship

For businesses with bank facilities or external investors, the 13-week forecast is often something the lender or investor expects to see, particularly under financial pressure or close covenant monitoring. A bank supporting a business through a tight period will commonly ask for a weekly or fortnightly forecast, and the quality of that forecast shapes the relationship.

Lenders typically look for:

• A consistent template submitted on the same day each week or fortnight.
• A variance report comparing the previous forecast with actuals, with brief explanations.
• Clear assumptions, especially for the largest receipts and any asset sales or new funding.
• Headroom against facility limits and covenants, with any projected breach flagged early.
• Sign-off by a director or the finance lead.

A clear, accurate forecast with a track record of small variances signals a finance function in control; a vague or repeatedly missed one erodes the confidence that decides how supportive a lender will be. Private equity investors expect the same discipline, as our guide to the Financial Controller in PE-backed companies explains.

Integrating the Forecast With the Wider Finance Function

The 13-week forecast connects to the monthly management accounts, the rolling monthly forecast and the budget, and these should tell one story. The weekly forecast covers the immediate horizon in detail; the monthly forecast extends it across the year; the budget sets the annual frame. When the cash assumptions in the 13-week forecast reconcile to the working capital assumptions in the monthly forecast, the business has one coherent picture. When they conflict, confidence in all of them suffers. The practical answer is to source all three from the same reconciled ledgers. Our guide on management reporting that gets read covers how to present cash in the monthly pack.

From Spreadsheet to Trusted Tool

A 13-week forecast delivers its value only when the business trusts it and acts on it, and that trust is earned through weekly accuracy. The difference between a forecast the board relies on and one nobody believes is rarely the sophistication of the spreadsheet; it is the discipline of the person maintaining it. Most businesses run the forecast in Excel, and that is fine if it is well built — our guide to using AI inside Excel for finance covers ways to speed up the weekly refresh. Where a business has no forecast and needs one quickly, an interim Financial Controller brought in for cash flow visibility can typically build and embed one within the first weeks of an assignment.

13-Week Cash Flow Forecast: FAQs

What is the difference between a 13-week cash flow forecast and a cash flow statement?

A cash flow statement looks back over a period, usually using the indirect method. A 13-week forecast looks forward, week by week, using the direct method of receipts and payments.

How often should the forecast be updated?

Weekly, on a fixed day, with the opening position reconciled to the bank and the previous week compared with actuals.

How accurate should a 13-week forecast be?

The first few weeks should be close, because they are built from known invoices and payment runs. Accuracy naturally falls in the later weeks. What matters is that variances are small, explained and not consistently in one direction.

Who should own the forecast?

The Financial Controller usually owns and builds it, with input from credit control, purchasing and operations. In smaller businesses a finance manager may run it, reviewed by the finance director or a fractional FD.

Do I need software, or is a spreadsheet enough?

A well-built spreadsheet is enough for most businesses. Dedicated cash forecasting tools help where there are many bank accounts, entities or currencies, or where bank-feed automation would save significant time.