The Beginner's Guide to Cash Flow Forecasting for Small Local Businesses

Most small businesses that get into trouble aren't unprofitable. They're just short of cash on the day a bill lands. A customer pays ninety days late, the VAT bill arrives on time, and a business that made money last quarter can't quite make payroll this Friday. A cash flow forecast is the simplest defence against that. It's a plain table showing what you expect to come in, what you expect to go out, and what's left in the bank at the end of each week or month. You don't need accounting software or a finance degree. You need an hour, your bank statements, and the willingness to look at numbers you'd rather avoid.

Why Profit Isn't the Same as Cash

Your profit and loss account records income when you earn it. Your bank records it when it arrives. Those two dates can be months apart.

Say you fit a kitchen in March and invoice £9,000 on 30-day terms. Your books show a strong March. Your bank sees nothing until May, or June if the customer stretches it. Meanwhile the supplier who sold you the units wants paying in April and the fitter wants wages on Friday. A forecast ignores the question "was that a good month?" and asks the one that matters day to day: will there be money in the account when this payment goes out?

Gather Six Things Before You Start

You already have everything you need.

• The last twelve months of bank statements — your reality, not your memory of it.
• Invoices you've issued but not been paid for, with the date you expect each to land.
• Regular outgoings: rent, wages, utilities, insurance, subscriptions, finance agreements.
• Irregular but predictable costs: VAT, PAYE, corporation tax, professional fees, stock orders.
• Committed one-offs: a replacement van, a shop refit, a deposit.
• Your own drawings — the money you take out to live on. That's a business cost like any other.

Twelve months of statements will also reveal your seasonal rhythm, which matters more than most owners expect.

Build Your Forecast in Five Steps

1. Choose your time unit. Weekly if margins are tight or your balance is small; monthly if you want the bigger picture. Many small firms run a rolling thirteen weeks — far enough to see trouble coming, near enough to stay accurate.
2. Start with today's bank balance. Include every account: current, savings, and any overdraft you're already using.
3. List money in by the date it will actually arrive. Not the invoice date. If a client always pays late, forecast them late. Pessimism here is just accuracy.
4. List money out by the date it leaves. Rent on the first, wages on the last Friday, VAT seven days after the quarter ends.
5. Work out the closing balance. Opening balance plus money in, minus money out. That becomes next week's opening balance. Repeat down the page.

A quick worked example

You start the week with £4,000. Two invoices are due, worth £6,000, but one customer is slow, so you bank £3,500. Outgoings that week: £1,800 wages, £900 rent, £600 materials, £400 van finance — £3,700 leaving. Closing balance: £3,800. Comfortable. Now run the same week with a £2,400 VAT bill and the answer is £1,400, and next week looks thin. That's the whole point: you saw it a fortnight early, while you could still do something about it.

Spotting Shortfalls Early

You're looking for trends, not single numbers.

Warning signs

• The closing balance falls for three periods in a row, even slightly.
• A large payment out lands in the same week as VAT or payroll.
• The lowest point on the page is already below zero, or below the buffer you'd want to keep.
• Debtors are taking longer to pay than they were three months ago.

What to do when you see a gap

• Chase overdue invoices tomorrow, starting with the largest.
• Offer a small discount for early payment if the cash is worth more to you than the margin.
• Delay discretionary spending. The new signage can wait; the broken fridge can't.
• Talk to suppliers before you miss a payment, not after. Most will agree a date; few forgive silence.
• If tax is the problem, contact HMRC early rather than waiting for a demand.

Borrowing should be arranged when you don't urgently need it, because that's when it's cheapest and easiest to secure. For anything involving tax, debt or credit agreements, a short conversation with an accountant or adviser is worth having before you commit.

Handling Seasonal Income Swings

Plenty of local businesses live with this. Garden centres do most of their trade between March and July. Wedding venues earn in summer and spend all year. A café near an office park goes quiet in August. Once you've mapped twelve months of statements, the shape of your year is obvious — so forecast the peaks and troughs honestly instead of pretending every month is average.

Build a cushion in the good months

Decide on a percentage of each strong month's takings — even 5% — and move it into a separate account the day it lands. Call it the slow-season fund and leave it alone. When February arrives, you're drawing on money you set aside rather than scrambling for it.

Move costs out of the lean months

• Renew insurance, buy equipment and book training during your strong months.
• Pay yourself a steady wage every month rather than taking whatever is left. It settles your household budget and your forecast at the same time.
• Set up monthly payment plans for suppliers or tax where possible, so one big bill becomes twelve small ones.
• Look for off-season cash: vouchers, gift cards, pre-booked packages, or a quiet-month offer that brings money in now for work later.

Keep It Alive

A forecast that isn't updated is just a nice-looking document. Set aside twenty minutes on the same day each month. Compare what you predicted with what actually happened, correct the next thirteen weeks, and write one line explaining the biggest difference. Those lines teach you more than any report: you'll learn that one client always pays a fortnight late, that January is worse than you remembered, that materials spending creeps up whenever you're rushed.

Your First Forecast This Week

Open a spreadsheet, or take a sheet of paper. Write today's bank balance at the top. Add the next eight weeks down the left-hand side. Fill in the payments you know are coming and the money you reasonably expect in, dated honestly.

Then look at the lowest number on the page. If it's comfortable, run it again next month with real figures and keep an eye on the seasonal months ahead. If it's tight or negative, you've just bought yourself weeks of warning. Start with the overdue invoices in the morning. That's the whole skill — see the gap early, close it calmly.

Photo: Jakub Zerdzicki / Pexels