Cash Flow Forecasting for Small Businesses: A Practical UK Guide
Cash flow forecasting is one of those business tasks that sounds more complicated than it is. In practice, it’s simply working out how much money you expect to have in your account — and when. Done regularly, it’s probably the single most useful financial habit a small business owner can develop.
What is a cash flow forecast?
A cash flow forecast is a projection of the money you expect to come into and go out of your business over a set period — usually the next 3, 6 or 12 months, broken down month by month.
It’s different from a profit and loss statement, which tells you how your business has performed in the past. A forecast looks forward. It helps you answer questions like:
- Will I have enough to cover payroll next month?
- Can I afford to take on a new member of staff in April?
- When is my quietest month likely to be, and how much of a buffer do I need?
- What happens to my cash position if a big client pays 30 days late?
Why forecasting matters more than most owners realise
Many small business owners focus on revenue and profit but neglect cash flow forecasting until they’re already in trouble. By then, options are limited.
A forecast gives you lead time. If you can see three months ahead that your cash position is going to tighten — perhaps because a big payment is due and your quieter season is approaching — you have time to act. You can chase invoices more aggressively, delay a non-essential purchase, negotiate extended payment terms with a supplier, or arrange a short-term facility with your bank.
Your cash flow forecast should cover at least as long as your cash flow cycle — the time it takes for money leaving your business to come back in. For most service businesses that’s 30–60 days. For businesses carrying stock or running long projects, it can be considerably longer.
What to include in your cash flow forecast
A basic cash flow forecast has two sides: money in and money out.
Money coming in (inflows)
- Sales income — based on when invoices will actually be paid, not when you send them
- Any loans or finance drawdowns
- Tax refunds (VAT reclaims, for example)
- Grant income
- Any other cash receipts
Money going out (outflows)
- Staff wages and employer’s National Insurance contributions
- Rent, rates and utilities
- Supplier payments
- Loan repayments
- VAT payments (quarterly — make sure these land in the right month)
- Corporation Tax (annually — plan well ahead for this one)
- PAYE (monthly — due by the 22nd of the following month if paying electronically)
- Software subscriptions and recurring costs
- Marketing and advertising spend
- Any one-off planned expenditure (equipment, refurbishment, etc.)
The bottom line
For each month, subtract your total outflows from your total inflows. This gives you your net cash flow for the month. Add your opening cash balance (what’s in your account at the start of the month) and you get your closing balance — which becomes next month’s opening balance.
How far ahead should you forecast?
It depends on your business, but as a general guide:
The minimum for most businesses. Enough to spot immediate cash problems and avoid being caught short on a specific payment. Good starting point if you’ve never forecasted before.
A more useful horizon for planning hiring decisions, investments or seasonal preparation. Gives you enough runway to make meaningful decisions rather than just react.
Ideal, and expected by lenders and investors. The later months become less precise, but the exercise of mapping out the full year is valuable in itself — you’ll spot annual costs you might otherwise forget.
For businesses going through a difficult patch or a period of rapid growth, weekly forecasting can be more useful than monthly — it gives you much more granular visibility of your cash position when it matters most.
Building your forecast: spreadsheet or software?
Starting with a spreadsheet
For most small businesses, a simple spreadsheet is perfectly adequate — especially when you’re starting out. A basic structure with months across the top and income/expense categories down the side is all you need.
The British Business Bank and Sage both offer free downloadable cash flow forecast templates that are well designed and straightforward to use. Worth starting there rather than building from scratch.
Dedicated forecasting tools
Once your business reaches a certain size or complexity, dedicated tools become worthwhile. The main ones used by UK small businesses:
| Tool | Best for | Integrates with |
|---|---|---|
| Float | Visual forecasting, scenario planning, easy to use | Xero, QuickBooks, FreeAgent |
| Futrli (by Sage) | Daily projections, tight cash runway, confidence scoring | Xero, QuickBooks, Sage |
| Xero / QuickBooks / FreeAgent | Basic forecasting built in — good starting point | Native |
The most common forecasting mistakes
Your forecast should reflect when money actually hits your bank account, not when you raise an invoice or make a sale. This is the single most common error and it makes the whole forecast misleading.
If your payment terms are 30 days but your clients typically pay in 45, use 45 in your forecast. An optimistic forecast that assumes everyone pays on time isn’t a planning tool — it’s wishful thinking.
Insurance renewals, accountancy fees, annual software licences, business rates bills — these land in specific months and catch people off guard. Map out the whole year at the start and put them all in.
If you’re VAT registered, the VAT you collect isn’t your money — it goes to HMRC quarterly. Either work in net (ex-VAT) figures throughout, or make sure the VAT payment is clearly shown as an outflow in the correct month.
A forecast that isn’t regularly updated quickly becomes inaccurate and stops being useful. The value is in the habit of maintaining it, not in the document itself. Monthly updates take 30 minutes and are worth every one of them.
Is there a downside to cash flow forecasting?
The main limitations are worth acknowledging honestly:
It requires good underlying data. If your bookkeeping is behind, your forecast will be built on incomplete information. Forecasting and bookkeeping need to work hand in hand.
It can give false precision. A detailed 12-month forecast can look authoritative but be built on quite uncertain assumptions — particularly for newer businesses. Be clear about which figures are based on hard data and which are educated guesses.
It takes time to maintain. Not a huge commitment, but a regular one. If you know you won’t keep it updated, a simpler monthly review of your bank position and upcoming commitments might be more realistic than a detailed forecast you abandon after two months.
None of these are reasons not to forecast. They’re just reasons to do it honestly.
A note on using cash flow to value your business
Cash flow is one of the main methods used to value a business, particularly for buyers and investors. A method called Discounted Cash Flow (DCF) analysis estimates the present value of your future cash flows, adjusted for time and risk. In practice, most small business valuations use a simpler multiple of profit or EBITDA — but a strong, consistent cash flow history will support a higher valuation regardless of the method used. We’ll cover business valuation in more depth in a separate guide.
Download: Free UK Cash Flow Forecast Template
We’ve built a free 12-month cash flow forecast template specifically for UK small businesses. Fill in the blue cells and all the totals calculate automatically.
- Separate sections for income, staff costs, premises, operating costs and HMRC payments
- VAT and Corporation Tax rows built in so you don’t forget them
- Automatic totals and a running bank balance for every month
- Closing balances highlight red if a month is projected to go negative
- Full-year summary column — see your annual position at a glance
Download the free template →
Other useful resources
- British Business Bank — a clear four-step guide to building a cash flow forecast, at british-business-bank.co.uk
- HMRC Time to Pay — if a VAT or tax bill is going to cause a cash flow problem, call the Business Payment Support Service on 0300 200 3835 before the due date. They will often agree a payment plan if you contact them early.
- Your accountant — if you’re not sure where to start, ask your accountant to help you build your first forecast. Many will do this as part of their service, and the time is well spent.
More guides for UK small business owners
Right Hand Man covers everything from cash flow and pricing to hiring your first employee and growing your business. Browse our guides or get in touch if you have a question.