How to Prepare a Cash Flow Forecast for Small Business Success

Three years ago I watched a client with a healthy order book nearly miss payroll. Not because sales had dropped — they hadn't. The problem was timing: two invoices worth £47,000 sat unpaid at day 62 while the VAT bill and three supplier payments cleared on the same Friday. The business was profitable on paper and broke in the bank.

That week taught me more about how to prepare a cash flow forecast for a small business than any accounting course I'd sat through. Profit tells you whether your model works. Cash tells you whether you'll still be trading next month. They are not the same number, and confusing them is the most expensive mistake a small business owner can make.

What a cash flow forecast actually does (and what it doesn't)

Spoiler alert: it will not tell you if your business is viable. That's a profit-and-loss job. A cash flow forecast answers one narrow, brutal question — on any given week, will there be money in the account to cover what's leaving it?

I've seen founders build elaborate 24-month projections with growth curves and then get caught by a two-week gap in January. The long view is fine. It's just not what keeps the lights on.

The direct method vs the indirect method

There are two ways to build one, and most small businesses should ignore the second.

• Direct method — you list actual receipts and payments by category and date. Client A pays £8,000 on the 15th, rent leaves on the 1st, wages on the 28th. This is what you want.
• Indirect method — you start from net profit and adjust for non-cash items like depreciation. Useful for accountants and larger companies reporting to investors. Overkill for a five-person operation, and harder to keep current.

Unless an investor or lender specifically asks for the indirect version, build direct. It maps to your bank statement, which means you can reconcile it in minutes instead of an afternoon.

Step-by-step: how to prepare a cash flow forecast

Here's the process I now run with every small business I work with. It takes about two hours the first time. After that, weekly updates are a ten-minute job.

Step 1: Lock down your opening balance

Open your banking app. Find the cleared balance — not the available balance, which includes pending transactions and authorised overdraft headroom. The cleared figure is your starting line.

I made this mistake on my own company's first forecast. I used available balance, which was £3,200 higher thanks to a cheque that hadn't cleared. The forecast looked comfortable for six weeks longer than reality allowed. Nothing catastrophic happened, but I made decisions that week I wouldn't have made with the correct number.

Step 2: List every receipt by expected date, not by invoice date

This is where most forecasts fall apart. An invoice dated the 3rd with 30-day terms is not cash on the 3rd. It's cash on or around the 2nd of next month — and realistically, later.

Pull your aged receivables report. For each outstanding invoice, note:

1. The amount
2. When it's contractually due
3. When that client actually pays, based on their history

If a client has averaged 47 days over the last year despite 30-day terms, forecast 47 days. This single adjustment has saved me more forecast accuracy than anything else. New customers get a 30-day assumption plus a week of padding. Existing ones get their real behaviour.

Step 3: Categorise every payment — fixed, variable, and lumpy

Split your outgoings into three buckets and treat them differently:

• Fixed — rent, insurance, software subscriptions, loan repayments. These land on the same date every month. Easy.
• Variable — supplier payments tied to sales, contractor invoices, card fees. Forecast these as a percentage of your expected revenue.
• Lumpy — quarterly VAT, corporation tax, annual licence renewals, equipment purchases. The ones that ambush people. Put them in on the exact date they'll clear.

And the worst part? Tax payments don't care about your cash flow. A £14,000 VAT bill lands when it lands. If you haven't set the money aside, the forecast will show you the hole — which is precisely the point.

Step 4: Calculate the net movement and running balance

For each week (or month), the arithmetic is simple:

Opening balance + money in − money out = closing balance.

That closing balance becomes next period's opening balance. If any closing figure drops below a threshold you're comfortable with — for many small businesses that's one month of fixed costs — you've found your problem early enough to do something about it.

A worked cash flow forecast example

Here's a simplified 5-week extract from a design studio with £12,000 starting cash. Notice how the crunch arrives in week 4 despite two invoices going out in week 1.

Item	Week 1	Week 2	Week 3	Week 4	Week 5
Opening balance	£12,000	£14,500	£11,200	£7,900	£2,400
Client receipts	£6,000	£1,500	£0	£0	£8,000
Wages	−£2,800	−£2,800	−£2,800	−£2,800	−£2,800
Rent & utilities	−£700	£0	−£700	£0	£0
Suppliers	£0	−£2,000	£0	−£2,700	−£900
VAT payment	£0	£0	£0	£0	−£6,200
Closing balance	£14,500	£11,200	£7,900	£2,400	£500

Week 5 is dangerously thin. Without this view, the studio owner would have felt fine in week 2 and panicked in week 5. With it, they have three weeks' notice to chase the £8,000 invoice, delay a supplier payment, or draw on a credit facility before they need it — which is when it's cheap and available.

How far ahead should you forecast?

Run two horizons side by side:

• 13 weeks — weekly granularity. This is your operational tool. Cash problems show up here first.
• 12 months — monthly granularity. This is for planning, seasonal patterns, and conversations with lenders or investors.

The 13-week horizon works because most small business cash crunches are short and sharp. A 12-month view smooths over a two-week gap that can genuinely sink you.

Building your cash flow forecast template in Excel

You don't need expensive software. A spreadsheet handles this fine for most businesses under a few million in turnover.

Setting up the sheet

1. Weeks as columns across the top, 13 of them, date-stamped.
2. Rows grouped in three sections: opening balance, receipts (broken out by customer or category), payments (broken out by type).
3. A closing balance row at the bottom that feeds the opening balance of the next column.
4. Conditional formatting on the closing balance row — red below your safety threshold, amber within 20% of it. This one trick has caught more problems for me than any dashboard.

Keep your assumptions on a separate tab: average payment days per client, expected revenue, tax due dates. When reality shifts, you update the assumptions tab, not forty individual cells.

What to do when the forecast shows a shortfall

Options, roughly in order of preference:

• Chase the invoices that are already late. Fastest, cheapest, most under-used.
• Negotiate supplier terms — ask for 45 days instead of 30. Most will say yes to a reliable payer.
• Delay discretionary spending. New equipment, that conference, the rebrand.
• Draw on an overdraft or credit line before you need it. Banks lend to businesses that don't look desperate.
• Offer an early-payment discount to your biggest client. Costs you margin, buys you certainty.

What you don't do is wait and hope. By the time the shortfall is visible in your bank balance, your negotiating position has evaporated.

The habit that matters more than the template

I've built forecasts in everything from a scrappy spreadsheet to proper forecasting platforms. The tool was never the differentiator. The businesses that survive cash crunches are the ones that sit down every Monday morning, update the actual figures against last week's forecast, and look three months ahead.

Ten minutes. That's the whole ritual. And after a few months you start noticing something unexpected: you get better at predicting your own business. You learn which clients pay late, which months are always tight, how much buffer you actually need. The forecast stops being a document and becomes a kind of instrument you're reading.

Which raises a question worth sitting with. If you knew today exactly when your cash would run thin over the next 90 days, what would you do differently this week?