Most small UK businesses only discover a cash flow problem once it has already arrived. This guide explains what a cash flow forecast actually involves, where most business owners go wrong, and how to get one working for your business without spending weeks on spreadsheets.

Why cash flow forecasting matters for your business

The numbers behind UK business failure paint a consistent picture. A recent report published in April 2026 found that more than a quarter of UK SMEs hold cash reserves that would sustain them for two months or less. Around 60 percent of UK SMEs report that outflows exceed inflows for at least half the year. That is not a fringe problem. That is the normal operating condition for the majority of small businesses in this country.

A cash flow forecast does not prevent these pressures from existing. What it does is give you enough notice to act before a shortfall becomes a crisis. Whether you are a sole trader with irregular income, a limited company managing payroll, or a contractor with delayed invoice payments, knowing what is coming in and going out over the next three to six months changes the decisions you can make right now.

Where most business owners go wrong with cash flow forecasting

Research into forecasting limitations consistently shows that many UK businesses only forecast cash flow annually, or skip the process entirely. That means they are already reacting to a problem by the time they see it. A forecast produced once a year is almost useless for day-to-day decisions.

Confusing profit with cash

A business can be profitable on paper while running dangerously short of cash. This happens when money is owed to you but has not yet been received. On average, each UK SME is owed around £22,000 in outstanding invoices. That figure sits in your accounts receivable column and looks like income, but it cannot pay your VAT bill or your staff this Friday.

Building the forecast in isolation

A forecast only works if it reflects reality. If your sales figures, payroll costs, VAT schedule, and loan repayments are all sitting in different places, the forecast becomes inaccurate within weeks. The forecast must draw from your actual bookkeeping records, not from rough estimates written into a separate spreadsheet.

How to set up a cash flow forecast step by step

A working cash flow forecast does not need to be complicated. It needs to be accurate and updated regularly. The process below applies whether you are a sole trader doing this for the first time or a limited company that has outgrown basic spreadsheets.

1. Step 1: List every confirmed cash inflow for the next three months. This means actual payments expected from invoices already issued, scheduled income from contracts, and any confirmed grants or loan drawdowns. Do not include money you hope to earn. Only include what has a realistic basis.
2. Step 2: List every confirmed outgoing payment with its due date. Include PAYE, VAT, rent, loan repayments, supplier invoices, and payroll. The timing of each payment matters more than the total. A VAT bill due on the 7th of the month is a different problem from one due on the 28th.
3. Step 3: Calculate your opening bank balance for each month, add inflows, subtract outflows, and carry the closing balance forward. Do this month by month for at least three months. If any closing balance goes negative, that is your warning signal. That is the month you need to act before it arrives.

Regular monthly forecasting is the minimum standard recommended by financial planning specialists. The further ahead you forecast, the less precise the numbers become, but even a rough six-month view gives you time to arrange finance, delay a purchase, or chase overdue invoices before the pressure arrives.

What to expect when you use a cash flow forecasting service

There are broadly three ways to approach cash flow forecasting: do it yourself using spreadsheets, use accounting software with forecasting modules, or have a qualified accountant produce and maintain the forecast as part of a management accounts service. Each option has a different cost profile and a different level of reliability. At STZ Accounting, quarterly cash flow forecasts are included in the Gold package (for businesses with turnover over £750,000) and management reports are included across all limited company packages from £215 per month. If your situation falls outside a package, David will give you a fixed price before any work begins.

How to get started today

The most common reason business owners put off cash flow forecasting is that they feel their records are not tidy enough to start. In practice, the current state of your bookkeeping is exactly the right starting point. You need to know where you stand before you can project where you are going.

• Pull together your last three months of bank statements and any outstanding invoices you are owed. This is the raw material for an opening balance and a picture of your typical inflows.
• List every fixed payment due in the next ninety days with its exact due date. Include VAT, PAYE, loan repayments, and rent. This is the foundation of your outgoings column.