Cash
A 13 week cash flow forecast shows, week by week, how much cash a business will have over the next quarter. Here is how to build one, a worked example in pounds, the mistakes that make forecasts useless, and when lenders will ask to see it.
By Christopher Fagan, Managing Partner, PEF Consulting Partners
Delivered for and alongside
















A 13 week cash flow is a rolling weekly forecast of cash in and cash out, starting from the actual bank balance today. It is built using the direct method: real receipts from customers, real payments to suppliers, staff, HMRC and lenders, in the week the money is expected to move. It is not the same as the cash flow statement in the annual accounts, which is built backwards from profit, and it is not a monthly budget.
Thirteen weeks is one quarter. That length works for three reasons:
Every week the oldest week drops off, actuals replace the forecast, and a new week thirteen is added at the end. That rolling habit is what makes it useful. A forecast built once and left alone is out of date within a fortnight.
The forecast answers a few plain questions. Can we pay the next three payrolls? When is our lowest cash point, and how close is it to the overdraft limit or a covenant? Which customers matter most to that low point? What happens if the biggest of them pays two weeks late?
You can build a perfectly good forecast in a spreadsheet. The discipline matters more than the tool.
One person should own the forecast, with named people supplying the receipts and payments inputs. If it lives in one person’s head, it stops the week they are on holiday.
Illustrative example only. The business and figures below are invented to show how the forecast reads. They are not from any client.
A distributor opens week one with £420,000 in the bank. It collects around £270,000 to £310,000 a week from customers, pays suppliers £150,000 a week, and has £35,000 a week of other running costs. Its monthly payroll of £260,000 falls in week four.
On a monthly view this business looks fine: it ends the month with more than half its opening cash. The weekly view shows something different. Receipts are falling week on week, and if that trend continues into weeks five to eight, the next payroll pushes the balance close to the £100,000 minimum the lender requires.
That is the point of the exercise. With several weeks of warning, management can chase the three largest overdue debtors, agree a later date for a large supplier payment, or talk to the bank about headroom before the lender has to ask.
The value of a 13 week cash flow comes from the weekly cycle around it. A simple routine that we see work:
Accuracy should be judged honestly. Weeks one and two should be very close to actual. Weeks three to six depend heavily on collections. Weeks seven to thirteen show direction rather than precision. If the near weeks are regularly wrong by a wide margin, the method needs fixing before anyone relies on the later weeks.
Many businesses find the forecast also exposes wider process problems, such as invoices raised late or purchase orders raised after the goods arrive. Those are worth fixing at source, and our guides to order to cash and procure to pay explain where to start.
Most forecasts that fail do so for the same handful of reasons.
If several of these sound familiar, the forecast is not the only problem. It usually means management information more widely needs attention, and that is often where a root cause analysis is a better starting point than another spreadsheet.
A 13 week forecast is one of the first things lenders, their advisers and investors ask to see when they become concerned about a business. The common triggers are:
When a forecast is going to a lender, it needs to reconcile to the bank and management accounts, state its key assumptions plainly, and come with a record of how accurate previous versions were. A forecast with a track record carries far more weight than a polished one produced for the first time.
Directors have a further reason to keep one. When a company is in financial difficulty, directors need to show they understood the cash position and acted on it. A forecast updated weekly, with minutes of the decisions taken, is good evidence of that. Directors who are worried about solvency should take advice from a licensed insolvency practitioner or lawyer. PEF does not give that advice, but we help businesses build and run the forecast as part of our business turnaround consulting and restructuring advisory work.
Related reading: Business turnaround consulting, Restructuring advisory, Business turnaround strategy: the stages that work, Finance transformation, Order to cash explained.
It is a rolling weekly forecast of cash receipts and payments over the next 13 weeks, starting from the actual bank balance. It uses the direct method, so it shows real money moving in the week it is expected, rather than profit. Each week, actuals replace the oldest forecast week and a new week is added at the end, so it always looks a full quarter ahead.
Thirteen weeks is a quarter, which captures a full cycle of payroll, PAYE, a VAT quarter and quarterly rent. It is long enough to give management time to act on a problem and short enough that the figures are based on actual invoices, orders and payment terms. Longer term planning still needs a monthly forecast, but the 13 week view is the one that protects liquidity.
Yes, and most businesses start that way. A well structured spreadsheet with twenty to thirty lines, a reconciled opening balance and a variance column is enough for a single company with one bank account. Software becomes worthwhile when there are several entities or currencies, a large number of customer invoices, or several people updating the forecast each week.
The first two weeks should be very close to actual, because the receipts and payments are already known. Weeks three to six depend mostly on how reliably customers pay. Weeks seven to thirteen show the direction of travel rather than an exact figure. Track forecast against actual every week, and if the near weeks are often wrong, fix the method before relying on the later weeks.
One named person in finance, usually the financial controller or finance director, should own it and be accountable for its accuracy. Others supply inputs, such as credit control for receipts and purchasing for committed spend. The owner needs the authority to challenge optimistic inputs, and there should be a second person who can run it if the owner is away.
Do you know your lowest cash point in the next quarter? If the answer is not a confident yes, talk to us about building a forecast your board and lenders can rely on.
Book a confidential conversation
Independent, client side support when the business is off plan or changing shape: business turnaround, restructuring advisory, chief transformation officer, centres of excellence, shared services and gbs, asset management, hedge funds, oil and gas, portfolio company turnaround. For our fees see pricing.
Written by Christopher Fagan
Managing Partner, PEF Consulting Partners
Christopher has led systems and transformation delivery for 19 years, including the National Grid separation, the £9bn Energy Bills Support Scheme and the BP Pulse EV charging rollout.
Where next