Cash Flow Forecasting for Small Businesses

If you make business decisions by checking your bank balance first, you're doing what most business owners do. It feels logical. The money is there, so you can afford it.

The problem is that your bank balance only shows you one moment in time. It doesn't show you what's committed, what's due, or what's about to land. A cash flow forecast does.

What a cash flow forecast actually is

A cash flow forecast maps out the money coming in and going out of your business over a period of time, usually the next three to six months. It takes your expected income, your known expenses, your tax obligations, and your planned spending, and lays them out week by week or month by month.

The result is a picture of your future cash position. Not a guess. A picture built on real data about what you're owed, what you owe, and what's coming up.

Why your bank balance lies to you

A business owner I work with recently made a significant equipment purchase because his bank balance looked healthy. Within three weeks, his VAT quarter was due, payroll was coming up, and two large customers were late paying. The comfortable bank balance became a crisis.

What went wrong? He'd looked at one number in isolation. That number didn't account for the VAT liability sitting in the account that was about to leave. It didn't reflect the seasonality of his business. It didn't show the delayed customer payments. And it didn't flag the regular quarterly expenses that were about to land.

This is common. A healthy bank balance can mask VAT liabilities, upcoming payroll, overdue supplier payments, and seasonal dips. Checking the balance without understanding what's behind it is like judging a business by its revenue without looking at its costs.

How to build a basic forecast

Start with what you know. List your regular monthly outgoings: rent, salaries, software subscriptions, insurance, loan repayments. These are predictable and don't change much month to month.

Then add the variable costs you can estimate: materials, subcontractor costs, stock purchases, and anything that fluctuates with the volume of work you're doing.

Next, map your expected income. Look at your outstanding invoices and when they're due. Look at your pipeline and make realistic estimates about when work will be completed and invoiced. If you have recurring revenue, that's the easiest part.

Finally, add your tax obligations. VAT, corporation tax, PAYE, and any other payments that fall due at specific points in the year. These are the ones that catch people off guard because they're not monthly costs but they can be large.

When you put all of that together on a timeline, you can see your projected cash position at any point in the future. You can see when the tight months are coming. You can see whether you'll have enough to cover a planned purchase. And you can take action before a problem arrives rather than after.

The difference between a spreadsheet and a useful forecast

Most accounting software can produce a basic cash flow report. The issue is usually interpretation. A report full of numbers is only useful if someone explains what it means and what to do about it.

When I produce cash flow forecasts for my clients, the forecast itself is one part. The other part is the conversation about what it shows. When the tight months are coming and what we can do about them. Whether a planned hire or purchase is affordable and when the best time to do it would be. Which customers need chasing before the cash position gets uncomfortable.

That's the difference between having a forecast and actually using one to run the business.

When you need more than a spreadsheet

If your business has multiple revenue streams, seasonal fluctuations, long payment terms, or you're growing quickly, a basic spreadsheet forecast will only take you so far. The interactions between different income streams, the timing of large payments, and the impact of growth on working capital all add complexity that's hard to model in a simple spreadsheet.

At that point, having someone produce and maintain the forecast as part of a wider financial management service makes more sense than trying to do it yourself.