What a Cash Flow Forecast Actually Does

Profit and cash are two different things, and confusing them is one of the most common reasons small businesses get into trouble. You can have a perfectly healthy profit and loss account and still be unable to pay next month's wages, because profit is measured when you invoice and cash is measured when the money lands in your bank. A cash flow forecast is simply a week-by-week (or month-by-month) table showing what you expect to come in, what you expect to go out, and what your bank balance will look like as a result.

It is not a prediction of the future. It is a rehearsal. Run it often enough and you start spotting the pinch points before they arrive — the month when a large supplier bill coincides with a slow sales period, or the quarter when your VAT bill lands just as two big customers take their full sixty days to pay.

Gather Your Data Before You Build Anything

The good news is that if you already use cloud bookkeeping software, most of the raw material is sitting there waiting. You do not need a spreadsheet full of guesswork; you need the reports your software already produces. Before you start, pull together:

• Your bank feed — several months of actual transactions give you a realistic picture of your true outgoings, including the subscriptions and direct debits you have forgotten about.
• An aged debtors report — this shows who owes you money and how overdue they are. Every unpaid invoice over thirty days is a cash flow risk, not an asset.
• An aged creditors report — what you owe, and when it is due.
• Fixed commitments — rent, payroll, PAYE, pension contributions, insurance, loan repayments, software subscriptions.
• Tax dates — VAT returns, Corporation Tax, and self-assessment payments on account in January and July. These are the ones that catch people out because they are large, irregular and non-negotiable.

Aim for three to six months of history. You are looking for patterns, not perfection.

Build Your First Forecast Week by Week

Set up a simple table with one column per week for the next thirteen weeks, and a row for each category of income and expenditure. Weekly is better than monthly for small businesses, because a bill due on the 28th and a customer payment due on the 30th can look fine across a month but leave you short for two days.

Start with the money you are certain about. Invoices already issued with agreed payment dates, standing orders, direct debits, payroll runs. Then add the money you are fairly confident about — repeat customers, regular contract income, known seasonal trade. Leave genuine maybes out entirely for now; you can add them back into a best-case version later.

Work out your opening balance, add the inflows, subtract the outflows, and carry the closing balance forward to the next week. That running balance is the single most useful number in the whole document. It tells you not whether you are profitable, but whether you will be able to pay the bills.

Test It Against Reality — and Build in Scenarios

Once your first version is built, run two alternatives alongside it. A worst case, where your two largest customers pay a month late and sales drop by a fifth. And a best case, where everything lands on time. The gap between them is your margin for error, and it tells you how much of a buffer you should be holding.

Then compare each week's forecast against what actually happened. Most cloud bookkeeping systems let you export the real figures easily, so this takes minutes rather than hours. You will quickly learn which of your assumptions are reliable and which are wishful thinking — the latter is usually how long customers really take to pay.

Turn Forecasting into a Habit

A forecast built once and filed away is worthless. The value comes from doing it on a rhythm: fifteen minutes every Monday morning, updating the bank balance, chasing anything overdue, and rolling a new week onto the end. Tie it into your existing routines — check the forecast when you reconcile the bank, when you run payroll, and before you commit to any significant purchase.

A few practical habits make the numbers far more reliable:

• Keep a separate tax pot and move money into it as invoices are paid, rather than scrambling when the VAT return is due.
• Shorten payment terms where you can, and invoice promptly — a delay of a week in invoicing is a delay of a week in getting paid.
• Hold a buffer of at least one month's core costs once you are able to.
• Review your direct debits every quarter. Forgotten subscriptions are quiet cash leaks.

When to Ask for Help

If your forecast shows a persistent shortfall, the earlier you act the more options you have. That might mean negotiating staggered payments with a supplier, speaking to your bank before you need to, tightening credit terms, or reviewing pricing. All of these are far easier conversations twelve weeks out than twelve days out.

Your accountant or bookkeeper can help you sense-check the assumptions, particularly around tax timing and seasonality, and they will often spot patterns in your cloud bookkeeping data that are easy to miss when you are inside the business every day. A forecast does not remove uncertainty, but it turns a nasty surprise into a manageable decision — and that is worth far more than the fifteen minutes a week it takes to keep it current.