A cash flow forecast projects money in and money out for a future period, usually a rolling 12 weeks or 12 months. It tells you whether you can pay bills on time, take dividends safely, or need to raise finance. For UK small businesses, a working forecast is the difference between profit on paper and survival in practice — profit and cash are not the same thing, and most insolvency starts with cash, not P&L.

This guide explains why forecasts matter more than profit, what inputs you need, how to build a 12-week and 12-month forecast, the most common mistakes, and when software beats spreadsheets.

Why cash flow forecasts matter more than your P&L

A profit and loss account records revenue when you invoice, not when you get paid. It records cost when invoiced to you, not when you pay. The result is a profit number that can look healthy while your bank balance is in trouble. A business can be profitable and insolvent at the same time.

UK insolvency law makes this concrete. Under Insolvency Act 1986 section 123, a company is treated as unable to pay its debts (the “cash flow test”) when it cannot pay debts as they fall due. That is a cash test, not a profit test. Once you fail it, directors’ duties shift to creditors and trading on can constitute wrongful trading.

So the question every Monday morning is not “are we profitable?” but “can we pay the wages, the VAT, the supplier?” The forecast answers that.

The five inputs you need

Building a forecast needs five inputs:

  1. Opening cash balance. Today’s combined balance across all business bank accounts and short-term cash holdings.
  2. Receipts with timings. Customer invoices outstanding, expected receipt dates (not invoice dates), and forecast new sales by week or month.
  3. Payments with timings. Supplier invoices, recurring costs (rent, payroll, software), one-off costs, and the dates each is actually paid.
  4. Financing. Loan drawdowns, loan repayments, equity injections, dividends, director loan account movements.
  5. Tax. VAT quarterly liabilities, PAYE/NI monthly, Corporation Tax annual, Self Assessment payments on account.

The most common error is using invoice dates rather than expected payment dates. A 30-day customer invoiced today is cash you forecast in 30 days, not today.

Building a 12-week forecast

A 12-week (rolling weekly) forecast is the standard tool for tactical cash management. Build it in this order:

  1. List 12 columns, one per week, starting with the current week.
  2. Enter opening cash balance in week 1.
  3. List receipts row by row (existing customer invoices, expected new sales) with the week each is forecast to land.
  4. List payments row by row, in week buckets — payroll always lands the same week each month, VAT lands monthly the week the quarter is due plus filing window.
  5. Sum receipts and payments per week.
  6. Calculate weekly net cash movement and rolling cash balance.
  7. Identify weeks where the rolling balance dips below your minimum buffer.

Update it weekly, sliding the window forward by one week each Monday. After three or four weekly cycles you will know how accurate your forecast is and where your blind spots sit.

Building a 12-month forecast

A 12-month forecast covers the strategic horizon: budget alignment, financing decisions, and dividend planning. Use monthly columns rather than weekly. Tie the forecast to your budgeted P&L so revenue and cost lines reconcile, and add timing adjustments for invoice settlement, VAT, and Corporation Tax.

The 12-month version is what banks and investors typically want to see. Pair it with assumptions notes — what payment terms you have assumed, what growth rate, what cost timings — so the reader can challenge the inputs.

Common forecasting mistakes

Five mistakes account for most forecast failure:

  • Treating invoices as cash on issue. Invoice and cash receipt are different events. Forecast the date you actually expect to be paid, not the invoice date.
  • Forgetting the quarterly tax shocks. VAT lands every three months, Corporation Tax lands annually, and Self Assessment lands twice a year. Each is a one-week cash shock that catches new business owners out.
  • Ignoring seasonality. A retail business in January looks nothing like the same business in November. Use last year’s actuals to seed seasonality if you have them.
  • No buffer for slow payers. UK B2B payment terms slip routinely. Add a slippage assumption — if your terms are 30 days, model 45 days for a portion of customers.
  • Not updating the forecast. A forecast that is six weeks old is fiction. Update weekly for tactical, monthly for strategic.

Software vs spreadsheets

For a sole trader or single-director limited company under £250,000 turnover, a well-built spreadsheet is fine and gives you full control. For larger or faster-growing businesses, accounting software with built-in forecasting (or a dedicated forecasting tool) connects directly to actuals and updates in near real time, which beats manual reconciliation.

To see which platforms include forecasting natively, compare accounting software that builds your forecast automatically.

When to forecast: triggers

Forecast at these moments at minimum:

  • Monthly as part of management accounts review
  • Before raising or refinancing debt
  • Before declaring a dividend
  • Before signing a major customer or supplier contract
  • Whenever a customer goes 30 days past payment terms
  • Whenever you change pricing materially

Key takeaways

  • A cash flow forecast projects bank balance over time, not profit
  • Use a rolling 12-week forecast for tactical control and a 12-month forecast for strategy
  • The five inputs are opening cash, receipts, payments, financing, and tax
  • Treat invoice dates and payment dates as different events
  • Update weekly for the tactical version
  • The cash flow test under IA 1986 s.123 is what UK insolvency law actually measures

Frequently asked questions

What is the difference between cash flow and profit? Profit measures revenue minus cost on an accruals basis (when invoiced). Cash flow measures money actually moving in and out of the bank. A business can be profitable and run out of cash at the same time, which is why both metrics matter.

How often should I update my cash flow forecast? Weekly for a 12-week tactical forecast, monthly for a 12-month strategic forecast. A forecast that is more than four weeks out of date stops being useful.

Do I need software to build a cash flow forecast? No. A well-built spreadsheet works for many small businesses. Software helps when actuals need to feed automatically into the forecast or when you want scenario modelling.

What is the most common cash flow mistake? Treating invoice dates as cash dates. UK B2B customers commonly pay on 30 or 60 day terms, and many slip. Forecast the date you actually expect to receive money, not the date you raise the invoice.

What happens if I cannot pay my bills as they fall due? Under Insolvency Act 1986 section 123, a company unable to pay its debts as they fall due is at risk of being treated as insolvent. Directors’ duties shift to creditors at that point and continuing to trade can amount to wrongful trading.

Useful resources

GOV.UK — Prompt Payment Code https://www.gov.uk/government/publications/prompt-payment-code

Insolvency Service — Guidance for company directors https://www.gov.uk/government/organisations/insolvency-service

Federation of Small Businesses — Late payment campaign https://www.fsb.org.uk/