Why Profit Is Not Cash — and Why That Catches Out Good Businesses
A business can be profitable on paper and still run out of money. Invoice a client £10,000 on 60-day terms and your accounts show £10,000 of revenue today — but your bank account shows nothing for two months, while wages, rent and HMRC all fall due. The Chartered Institute of Credit Management found 82% of UK SMEs have faced cash flow difficulties, and Q1 2026 saw 17.48 million overdue invoices on UK books.
A cash flow forecast closes that gap: it predicts money in and out, shown in the week or month it actually moves, and answers the one question your accounts cannot — will we have money in the bank on the day we need to pay?
The Two Forecasts Every Small Business Needs
Run two forecasts. The 12-month rolling forecast is your strategic view: cash mapped month by month for a full year, updated monthly. It is the forecast your bank will want to see, and tax liabilities are plotted here so they never arrive as surprises.
The 13-week rolling forecast is your early warning system: receipts and payments mapped week by week for three months, updated weekly as projections become actuals. It tells you whether you will have a cash gap in the third week of January, with time to act — if you run only one forecast, run this one. Our guide to cash flow management explains the habits that keep it honest.
How to Build Your Forecast in Six Steps
A spreadsheet is enough; software such as Xero, QuickBooks or FreeAgent can generate much of it automatically. Columns are weeks or months; rows fall into three sections.
Step 1: Start with your real opening balance. The actual bank balance on day one, across all accounts — not an average or a hoped-for figure.
Step 2: Project cash in by the date it actually arrives. Shift credit sales by your payment lag: on 30-day terms, January’s invoices appear in February’s cash. Add card and cash sales, grants and refunds. The most common error is projecting sales at invoice date.
Step 3: List every cash out by the date it leaves the bank. Wages, employer NI and pension, suppliers, rent, utilities, insurance, loan repayments, stock timed to when you actually pay, and capital spending in the month of payment. Then add the tax dates below — large and fixed, which is why they cause cash gaps when forgotten.
Step 4: Calculate the closing balance. Closing balance equals opening balance plus cash in, minus cash out — and becomes next period’s opening balance. Any negative period is a forecast shortfall.
Step 5: Build in the 2026/27 costs that catch people out. Employer NI is 15% above the £5,000 secondary threshold — on a £30,000 salary that adds roughly £866 a year per employee versus the old 13.8% rate above £9,100. The National Living Wage is £12.71 per hour (21 and over) from 6 April 2026, and Bank Rate is 4% from 5 November 2026. If rolling turnover approaches the £90,000 VAT threshold, model registration.
Step 6: Review and update. Compare actuals against forecast weekly (13-week view) and monthly (12-month view), updating the same week a 30-day payer slips to 60 days. A forecast never updated is worse than no forecast — it gives false confidence.
Worked Example: Three Months for a Small Design Agency
Take Northbridge Design Ltd, a fictional two-employee agency opening at £9,000 on 1 December 2026. Clients pay on 30-day terms; its Corporation Tax bill for the year to 31 March 2026 falls due on 1 January 2027:
| December 2026 | January 2027 | February 2027 | |
|---|---|---|---|
| Opening balance | £9,000 | £15,050 | £11,500 |
| Client receipts | £14,000 | £11,800 | £18,200 |
| Project deposit | £2,400 | £0 | £0 |
| Total cash in | £16,400 | £11,800 | £18,200 |
| Salaries | £6,500 | £6,500 | £6,500 |
| NI and pension | £1,300 | £1,300 | £1,300 |
| Rent | £1,200 | £1,200 | £1,200 |
| Suppliers | £900 | £1,100 | £950 |
| Corporation Tax | £0 | £4,800 | £0 |
| VAT payment | £0 | £0 | £2,600 |
| Loan repayment | £450 | £450 | £450 |
| Total cash out | £10,350 | £15,350 | £13,000 |
| Net cash flow | +£6,050 | −£3,550 | +£5,200 |
| Closing balance | £15,050 | £11,500 | £16,700 |
January is the danger month: receipts dip to £11,800 while Corporation Tax of £4,800 lands, a £3,550 outflow month — survivable only because December built the balance to £15,050. The February VAT payment of £2,600 is money collected for HMRC — keep it in a separate VAT reserve account. The forecast tells the owner in early December that January will be tight: chase the December invoices early.
The UK Tax Calendar Your Forecast Must Include
Tax payments are large and fixed — plot these dates first:
| Payment | When it is due | Notes for 2026/27 |
|---|---|---|
| PAYE and employer NI | 19th of the following month (22nd if paid electronically) | Employer NI at 15% above the £5,000 secondary threshold |
| VAT | One month and seven days after each quarter end | Quarter ending 31 Dec due 7 Feb; 31 Mar due 7 May; 30 Jun due 7 Aug; 30 Sep due 7 Nov |
| Corporation Tax | Nine months and one day after the company year end | 19% on profits up to £50,000; 25% above £250,000; marginal relief between |
| Self Assessment | 31 January (balancing payment plus first payment on account) and 31 July (second payment on account) | Personal tax for directors and sole traders — plan the cash extraction in advance |
| National Living Wage | From 6 April 2026 | £12.71 per hour for workers aged 21 and over; £10.85 for 18 to 20-year-olds |
Scenario Planning: Best, Base and Worst Case
A single forecast is a guess dressed up as a number. Build three versions — base, best and worst — and pay most attention to the worst: your largest customer pays 30 days late and a key contract slips a month. For Northbridge Design that would mean January receipts of £8,000 instead of £11,800 and a closing balance of £7,700 instead of £11,500: still positive, but only a £3,800 buffer stands between the business and a shortfall. Run the worst case before hiring or signing a lease: if the business survives it, the decision is safe.
What to Do When the Forecast Shows a Shortfall
A shortfall spotted in the forecast is good news — you found it weeks early. Work through these in order, cheapest first.
Chase what you are already owed. An invoice 30 days overdue is cash in someone else’s bank account. Our guide to how to chase late payments covers the escalation from reminder to formal letter. Under the Late Payment of Commercial Debts (Interest) Act 1998 you can charge interest at 8% above Bank Rate — 11.75% for debts falling due in late 2026, 12% from January 2027 — plus £40, £70 or £100 per invoice.
Tighten your own payment terms. Ask new customers for a deposit, shorten terms from 60 days to 30, or offer a small discount for payment within seven days.
Delay spending and renegotiate terms. Push non-essential purchases into a comfortable month, and tell suppliers early if you need 45 days instead of 30 — agree it in writing first.
Use invoice finance for a specific gap. If one or two large invoices are causing the shortfall, invoice finance releases most of their value within days.
Arrange borrowing before you need it. An overdraft agreed while your balance is healthy is far cheaper than one arranged in a crisis. Our business loans guide explains the options — your 12-month forecast is what lenders will ask to see.
Cut the cost base, last. If the shortfall is structural — outgoings permanently above receipts — no chasing or borrowing fixes it. That is a pricing or cost problem, and the forecast has done its job by showing it early.
Common Mistakes to Avoid
Forecasting sales at invoice date instead of payment date — it understates your cash gap by months.
Forgetting tax dates — Corporation Tax, VAT and Self Assessment are large and fixed.
Treating VAT receipts as income — VAT collected on sales belongs to HMRC.
Forecasting profit, not cash — depreciation belongs in your accounts, not your cash forecast.
Frequently Asked Questions
How far ahead should a small business forecast its cash flow?
Run both: a 13-week forecast updated weekly, and a 12-month forecast updated monthly. Twelve months is the standard a bank expects.
What is the difference between a cash flow forecast and a budget?
A budget plans income and expenses when earned or incurred; a forecast tracks when money actually enters or leaves the bank. A business can hit its budget and still run out of cash.
Final Thoughts
Forecasting needs no expensive software — a spreadsheet, your real bank balance and honest payment dates. The value is the warning: a shortfall you can see in December is a problem you can solve; the same shortfall discovered in January is a crisis. Build the 13-week forecast this week, add the 12-month view next, update both weekly.
Related reading
Cash flow management for small business
How to chase late payments in the UK