Sep 30
A 13-week cash flow forecast is a rolling, week-by-week projection of the cash actually coming in and going out of your business over the next quarter, updated regularly so it always looks 13 weeks ahead. It is built on cash movements, not accounting profit, which is exactly why it catches problems your monthly management accounts can miss. Originally associated with turnaround and restructuring work, it has become a practical discipline for any growing business that wants to see a cash shortage coming with enough notice to actually do something about it.
Most people encounter the 13-week forecast for the first time when a lender, adviser or insolvency practitioner asks for one, and it is easy to assume it is only relevant once things have gone wrong. That misses the more common use case. A profitable, growing business can run out of cash faster than a stagnant one because growth consumes working capital: more stock to fund, more staff to pay before the new revenue lands, and more debtors waiting on 60 or 90-day terms while your own costs are due weekly or monthly.
This is the classic overtrading trap, and it catches businesses that are, on paper, doing everything right. A 13-week forecast is how you see it coming rather than finding out from your bank balance.
Your monthly management accounts, and any annual budget built from them, are normally prepared on an accruals basis. They tell you whether the business is profitable and whether the year is heading in the right direction, but they say very little about which specific week your bank account gets tight.
A month can show a healthy net cash position overall while hiding the one week inside it where payroll, a VAT payment and a large supplier settlement all land within a few days of each other. That week is where businesses actually run into trouble, and a monthly view is simply too coarse to show it. The Association of Corporate Treasurers describes operational cash forecasting, generally covering the next 13 weeks on a rolling basis, as the short-term layer beneath longer-range monthly and annual forecasting for exactly this reason: it answers when money actually clears the bank, not just whether the quarter looks fine on average.
The structure is simple even though keeping it accurate takes discipline. You start with your actual opening cash balance, add every cash receipt expected that week, subtract every cash payment due that week, and the result becomes next week’s opening balance. The whole thing rolls forward: once week one closes, you replace the forecast with what actually happened, add a new week 13 onto the far end, and the window always shows 13 weeks ahead.
| Category | Typical items |
|---|---|
| Opening balance | Actual bank balance at the start of the week |
| Cash receipts | Customer payments, loan drawdowns, asset sales, grant income |
| Cash payments | Supplier payments, payroll, rent, VAT and PAYE, loan repayments, capital expenditure |
| Net movement | Receipts minus payments for the week |
| Closing balance | Opening balance plus net movement, becomes next week’s opening figure |
The most important discipline is forecasting when cash actually lands, not when you raise the invoice or when the cost is incurred. If a customer typically pays 45 days after invoice regardless of the terms on the paperwork, forecast 45 days, not 30. Reviewing your key financial KPIs alongside actual customer payment behaviour, rather than contractual terms, is usually where the first real accuracy improvement comes from.
A 13-week forecast built once and left untouched is close to useless within a month. The value comes from the weekly cycle: refresh it every week, compare last week’s forecast against what actually happened, and understand why the two differ.
Best practice is to expect high accuracy in the first few weeks, since most of those receipts and payments are already known, with accuracy naturally loosening in weeks nine to thirteen where more of the figures are estimates. That is fine. The point of the later weeks is to flag a developing problem early, not to predict the exact number to the pound.
Businesses that keep proper management accounts already have most of the underlying data this needs, so building the forecast is usually a matter of reorganising information you already hold rather than creating something from scratch.
A handful of mistakes account for most of the forecasts that quietly stop being useful. Using invoice or due dates instead of realistic expected receipt dates is the most common, and it consistently makes the forecast too optimistic exactly when accuracy matters most.
Missing lumpy, periodic payments is the second: VAT quarters, PAYE, corporation tax payments on account, annual insurance renewals and quarterly commercial rent can all land as large single-week outflows rather than smooth monthly costs, and a forecast built from averaged monthly figures misses them entirely.
The third is simply letting the forecast go stale. A 13-week forecast that was accurate the week it was built and has not been touched since is not a forecast; it is a historical document, and it will not tell you about the tight week that is now only three weeks away.
If your business operates across the UK and Ireland, this is where a generic 13-week template usually falls short. UK VAT is commonly quarterly, with returns and payments usually due one calendar month and seven days after the VAT period ends, while PAYE, direct debit and corporation tax payments follow different timing rules. Irish VAT generally runs on a bi-monthly cycle, with standard filing and payment due by the 19th of the following month, extended to the 23rd for many ROS online filers who file and pay electronically.
That is a genuinely different rhythm to build into the same forecast. Payroll tax timing, corporation tax payment dates and even bank holiday calendars differ between the two jurisdictions too, and a single UK-only tax calendar layered onto a cross-border business will misplace real cash outflows by weeks. Businesses that have set up to operate in both the UK and Ireland, or that manage VAT compliance across the UK and Ireland border already, need two tax calendars built into one forecast, not one calendar applied twice.
If you ever need to renew a facility, extend a loan, or have a difficult conversation with a bank about headroom, a well-maintained 13-week forecast is one of the strongest pieces of evidence you can bring to that conversation. It shows a business that understands its own liquidity in detail rather than one hoping for the best.
The same applies in reverse. When a business is already showing warning signs of financial distress, a 13-week forecast is usually one of the first things an insolvency practitioner asks for, because it is the fastest way to establish whether the business has a viable path forward or whether a CVA or other restructuring route needs to be considered. Businesses that already run this discipline before they need it tend to have far more options available when a difficult period arrives, simply because the warning came weeks earlier than it otherwise would have.
You do not need specialist software to begin. A spreadsheet with 13 columns, one per week, and rows for opening balance, receipts by category, payments by category and closing balance is enough to start. What matters more than the tool is the habit: update it every week without fail, be honest about when cash actually arrives rather than when it is contractually due, and treat the variance between last week’s forecast and this week’s actuals as the most useful line on the page rather than something to skip past.
Purpose-built cash flow software that pulls data directly from your accounting system becomes worth considering once the manual weekly update starts taking meaningful time, but the discipline matters far more than the tool in the early stages.
A 13-week forecast is only as useful as the assumptions behind it, and getting those assumptions right, particularly across two tax jurisdictions, two payment cultures and however many sales channels your business runs, is usually where a first attempt goes wrong. Our team works with growing and distressed businesses across Northern Ireland, Ireland and the UK to build forecasts that reflect how cash actually moves through a cross-border business, not a generic template adapted after the fact. Get in touch with SCC Chartered Accountants if you want a 13-week forecast built properly the first time, whether you are managing rapid growth or getting ahead of a tighter period.
Contact us to find out more about SCC services
NI:
UK
ROI:
Email Address:
Friday
Our award-winning team across our offices in the UK and Ireland collaborates to deliver the highest standards in a fast moving and evolving manner.