38°C
November 19, 2026
Business

Cash Flow Forecast: How to Build One That Actually Works

  • November 19, 2026
  • 5 min read
Cash Flow Forecast: How to Build One That Actually Works

Quick answer: A cash flow forecast is a plan of the money you expect to receive and pay out over the coming weeks or months. It shows what your bank balance will be at the end of each period, so you can spot a shortage before it happens.

Many profitable businesses still run out of cash. This guide shows you how to avoid that.

What Is a Cash Flow Forecast?

It’s a simple table. It lists the cash coming in, the cash going out, and what’s left.

The key word is cash. You record money when it lands in your account, not when you send the invoice. This one rule makes a forecast useful.

Cash Flow Forecast vs Profit

Profit is what you earned on paper. Cash is what you can actually spend today.

Say you finish a £10,000 job in March. The customer pays in May. You made a profit in March, but your bank account didn’t. Your rent and wages are still due.

A forecast looks ahead. A cash flow statement looks back at what already happened.

How to Build a Cash Flow Forecast in 6 Steps

  1. Pick your time frame. Most small businesses should start with 13 weeks. That covers one full quarter, including a VAT date.
  2. Write your opening balance. Check your bank, not your accounting software.
  3. List your cash in. Use the date customers usually pay, not the invoice date. If a client always pays 45 days late, plan for 45 days.
  4. List your cash out. Include wages, rent, suppliers, loan payments, software and tax.
  5. Work out the net cash flow. Cash in minus cash out.
  6. Find your closing balance. Opening balance plus net cash flow. This becomes next period’s opening balance.

Update it weekly. A forecast you never update is just a guess.

UK Dates Your Forecast Must Include

Many guides skip these. Add them first, because they are the biggest hits.

Payment Usual due date
VAT 1 month and 7 days after the VAT quarter ends
PAYE and National Insurance 22nd of the next month (electronic payment)
Corporation Tax 9 months and 1 day after your year end
Self-Assessment payments on account 31 January and 31 July

Always check the latest dates on GOV.UK. Late filing penalties for Corporation Tax went up for returns due on or after 1 April 2026, with the one-day-late penalty doubling from £100 to £200, according to 365 finance. 

A Simple Example

Here is a small business over three months.

Month 1 Month 2 Month 3
Opening balance £6,000 £8,000 £2,000
Cash in £10,000 £7,000 £9,000
Normal costs £8,000 £8,000 £8,000
VAT payment £0 £5,000 £0
Closing balance £8,000 £2,000 £3,000

Look at Month 2. The business is still earning. But a late payer and a VAT bill leave only £2,000 in the bank.

Without a forecast, that shock arrives without warning. With one, you’d see it two months early and could act.

What to Do If Your Forecast Shows a Shortage

Don’t panic. You have options:

  • Chase overdue invoices now
  • Ask customers for deposits or shorter payment terms
  • Delay non-urgent spending
  • Talk to suppliers about longer terms
  • Ask HMRC about a Time to Pay arrangement before you miss a deadline
  • Arrange a small overdraft or short-term funding early, not in a crisis

3 Common Mistakes

  1. Using invoice dates. This is the most common error. Always use the expected payment date.
  2. Forgetting tax. VAT, PAYE and Corporation Tax are predictable. Treat them like rent.
  3. Being too optimistic. Forecast sales a little lower and costs a little higher. A pleasant surprise is better than a nasty one.

Late payment makes this worse. Coface reported that 90% of UK companies experienced late payments in 2025, with small firms most exposed. Build that delay into your numbers.

How Often Should You Update It?

Weekly is best for a 13-week forecast. Monthly works for a 12-month view. Compare your forecast with your actual bank figures each time. The gaps show you where your guesses are wrong.

You can use a spreadsheet to start. As you grow, accounting software can pull in invoices and bank data automatically.

FAQs

What is a cash flow forecast in simple words? 

It’s a prediction of the money coming into and leaving your business, with the bank balance you’ll have at the end of each period.

How far ahead should a cash flow forecast go? 

Start with 13 weeks. Add a 12-month view for longer planning.

What is the difference between a cash flow forecast and a budget? 

A budget is what you plan to earn and spend. A forecast tracks when the cash actually moves, which can be very different.

What is the formula for a cash flow forecast? 

Opening balance + cash in – cash out = closing balance.

Who needs a cash flow forecast? 

Every business, from sole traders to limited companies. Lenders and investors often ask for one too.

Final Thoughts

A cash flow forecast won’t make you richer overnight. It will make you calmer. You’ll see problems early and fix them while you still have options.

Start small. Open a spreadsheet, add your bank balance and your next three VAT and payroll dates, and build from there.

About Author

Admin