Cash Flow Forecasting for Startups: A UK Founder's Guide
A startup cash flow forecast is a month-by-month estimate of the cash you expect to receive and pay out, ending in a closing bank balance for each month. Build it over 12 months, update it on a fixed timetable, and run it under more than one scenario. Then you will see a shortfall months before it reaches your bank account.
This guide shows you how to build the model, what to put in it, how to keep it rolling and where UK founders usually go wrong.
TL;DR
A cash flow forecast tracks cash in and cash out by month, not profit. A profitable startup can still run out of cash.
Cover 12 months, calculate net cash flow monthly and carry each closing balance into the next month.
Make it rolling: drop the month that has closed, add a new one, and review on a fixed date.
Model worst, most likely and best cases to find the earliest date you might need funding.
Include UK payments that land in lumps: PAYE/NI, VAT and loan repayments.
Table of Contents
What a cash flow forecast shows, and why it matters
A forecast shows how much cash a business expects to receive and pay each month. That tells you whether you can meet your bills when they fall due. Business Wales adds that it supports decisions on starting investment, extra finance and spending such as marketing or hiring.
Profit and cash are different things. You can invoice £30,000 in March and still be unable to pay wages in April if the customer pays in June. Late payment makes this worse: the Federation of Small Businesses figure quoted by Xero UK is that 60% of small firms say late payments hold back their growth. If that sounds familiar, our piece on late payment and cash flow covers the knock-on effects.
How to build a startup cash flow model
A workable model is a simple grid with months across the top and lines down the side. Here is the order we would build it in.
Set the opening balance. Use the actual bank balance on day one, including any funding already received.
List cash coming in. Include sales by the month you expect to be paid, not invoiced. Add grants, investor money, director loans and any VAT refunds.
List cash going out. Split fixed costs (salaries, rent, software, insurance) from variable costs (materials, contractors, ad spend, payment fees).
Add the lumpy items. Tax payments, annual subscriptions, equipment purchases and loan repayments.
Calculate net cash flow. Cash in minus cash out for each month.
Carry the balance forward. Each month’s closing balance becomes the next month’s opening balance. This step is described in the Business Wales guidance.
Keep inputs, workings and outputs apart
Put your assumptions (price, conversion rate, payment terms, headcount) on one tab, the calculations on another and the summary on a third. The ICAEW lists failing to separate inputs, workings and outputs as a common cause of unreliable forecasts. It also warns about error-prone spreadsheets with no independent review and no built-in checks or alerts.
A simple worked example
Imagine a software startup opening with £60,000. It expects £8,000 of receipts a month at first, rising by £1,000 a month, and £14,000 of monthly costs. The net outflow is £6,000 in month one, £5,000 in month two and so on. The closing balance falls from £54,000 to £49,000 and keeps shrinking until receipts catch up. These are illustrative numbers only, but laying them out this way shows the month your balance would hit zero if nothing changes. That is your runway.
Choosing your horizon: 12 months, 13 weeks or rolling
A forecast usually covers 12 months, according to Business Wales. The British Business Bank advises covering at least as long as your cash flow cycle, and updating it as things change or estimates firm up. If you buy stock or pay suppliers months before customers pay you, your horizon needs to be longer than the gap.
The ICAEW notes that 13-week weekly forecasts are often used in turnarounds or loan applications, and 12-month rolling monthly forecasts are also standard for those purposes. A sensible startup setup is a monthly 12-month view, plus a weekly 13-week view when cash gets tight.
What rolling means in practice
A rolling forecast always looks the same distance ahead. When a month closes, you drop it and add a new one at the far end. The CBA practice note gives common set-ups: four to six quarters updated quarterly, or twelve to eighteen months updated monthly. For most early-stage companies, 12 months updated monthly is the practical choice.
The same note makes a point worth pinning above your desk: a forecast that arrives late loses the decisions it was meant to inform. Fix the date. For example, put it in your diary for the fifth working day of each month, once bookkeeping is up to date. Our startup bookkeeping checklist helps keep the actuals clean enough to forecast from.
Use scenarios to find your runway
One forecast is one opinion. Build three: worst case, most likely and best case. The ICAEW says this helps generate ideas, improves response time and gives a prediction of the earliest date additional funding may be needed.
Change only a few drivers between scenarios:
Driver | Worst case | Most likely | Best case |
Customer payment time | 30 days slower | Current terms | Faster |
New sales | Half of plan | Plan | Ahead of plan |
Hiring date | As planned | As planned | Delayed to protect cash |
Major cost | Higher | Quoted | Negotiated |
The date your balance crosses zero in the worst case is your decision date. If that date is nine months away, raising money or cutting costs now is far easier than doing it with eight weeks left. Lenders and investors also tend to want longer-range projections, which we cover in three-way forecasting.
UK payments to put in your forecast
The ICAEW guidance on cash flow forecasts says to include forecast spending on PAYE/NI, VAT and loan repayments, and to note when rent is due. For a UK startup that means:
PAYE and National Insurance on salaries, which are paid over to HMRC separately from wages.
VAT, if you are registered. Model output VAT collected and input VAT paid, then the quarterly payment (or refund) as its own line.
Corporation tax, once you are making taxable profits.
Loan and director loan repayments, including interest.
Rent and annual bills, entered in the month they actually leave the account.
Check the due dates for your own company on GOV.UK, as they depend on your year end and VAT stagger. If you are pre-revenue, our guide to accounting for pre-revenue startups explains what to track before sales begin.
Mistakes that make forecasts unreliable
Treating the budget as the forecast. The CBA names over-reliance on the budget as a common error.
Hidden hardcoded numbers. A typed-over formula quietly breaks every later month.
Leaving out the people who run the drivers. Whoever manages sales, hiring or suppliers knows when the cash will really move.
Optimism. The ICAEW advises managing biases such as confirmation bias when building and reading forecasts.
Never comparing with actuals. Each month, compare forecast to actual and revise the remaining months, as Business Wales suggests.
Two habits improve accuracy quickly: tighten your invoicing and chasing routine (see our credit control guide) and review how your cash is tied up in stock, debtors and creditors in our working capital guide. For a deeper method comparison, read our cash flow forecasting methods article.
Our perspective
We see the same pattern with founders. The forecast gets built once for a funding conversation, then sits untouched while the business changes around it. Our view is that a forecast earns its keep only when it is tied to live bookkeeping. If the books are current, the monthly update takes hours rather than days, and you spot a gap while there is still time to act. That is why we pair modern digital tools with experienced accountants, many of whom have worked at leading firms in the UK and the Middle East. We would rather you had a simple, honest 12-month model that is refreshed every month than an elaborate one nobody trusts. Start with bookkeeping you can rely on, add VAT, payroll and tax lines, and then layer in scenarios as the business grows. Shoaib
Get help keeping your forecast current
If you would rather not rebuild the spreadsheet every month, we can run the bookkeeping, VAT, payroll and tax planning that feed it. Our flexible accounting packages are published at £99 to £199 per month, and they are designed to scale as your startup grows. See what is included on the Keystone Financial Advisory site.
[
](www.keystonefa.co.uk)
We can also help with company set-up, confirmation statements, accounts preparation and audit readiness checks, so your numbers are in order when an investor or lender asks. Our types of accounting services article explains which support suits which stage.
FAQ
How far ahead should a startup forecast cash?
Twelve months is the usual period, per Business Wales. It should be at least as long as your cash flow cycle, as the British Business Bank advises. If cash is tight, add a 13-week weekly view.
How often should I update a rolling forecast?
For a 12 to 18 month horizon, monthly is a common pattern, according to the CBA. Pick a fixed date each month so the update is never late. Update sooner if something material changes, such as a lost customer or a new hire.
What is the difference between burn rate and runway?
Burn rate is how much net cash you lose each month. Runway is how many months your cash balance lasts at that rate. Your forecast calculates both, and scenarios show how runway shifts if sales slip or costs rise.
Do I need accounting software to forecast cash flow?
A spreadsheet can work if inputs, workings and outputs are kept separate and someone reviews it. Software linked to your bookkeeping reduces manual entry and hardcoded errors. Either way, the forecast is only as good as the actuals feeding it.
Sources
Recommended