Running out of cash while your profit and loss looks healthy is one of the most common — and most avoidable — crises facing small business owners. The culprit, more often than not, is the absence of a simple cash flow forecast. Unlike a profit and loss statement that tells you what you earned, a cash flow forecast tells you what you have — and when. For SME owners managing tight margins and unpredictable payment cycles, it may be the single most valuable financial tool you can build.
What Is Cash Flow Forecasting?
A cash flow forecast is a forward-looking estimate of when money will enter and leave your business over a defined period — typically the next 12 weeks, three months, or 12 months. It is not a P&L. It is not a budget. It is a living, rolling projection of your actual bank position at any given point in time.
The forecast accounts for the timing of cash movements: when a customer actually pays an invoice, not just when it was raised; when a supplier is actually paid, not just when the cost was incurred. That distinction — timing — is what makes cash flow forecasting so powerful and so different from any other financial report.
For a small business with, say, £20,000 in monthly costs, knowing you have £50,000 of invoices outstanding is reassuring — until you discover that none of them are due for 60 days, and your payroll runs in 12. A cash flow forecast surfaces that gap before it becomes a crisis.
“Revenue is vanity, profit is sanity, cash is reality.” — This old finance adage endures because it is precisely true. A business can be profitable and still become insolvent. Cash flow forecasting is the tool that keeps reality in view.
Cash Flow vs Profit: Why the Difference Matters
Many business owners conflate profit with cash. They are related — but they are not the same thing, and treating them as interchangeable is a common and costly mistake.
Profit is an accounting concept. It represents revenue minus expenses for a given period, calculated on an accruals basis. That means income is recognised when it is earned and costs when they are incurred, regardless of when actual money changes hands.
Cash flow, by contrast, is entirely about movement. It records money in and money out — the actual bank debits and credits as they happen. Consider a business that invoices a client £10,000 in January but is not paid until March. The profit and loss shows the revenue in January. The cash flow statement shows the receipt in March. For two months, that £10,000 exists on paper only.
Other factors that drive a wedge between profit and cash include capital expenditure (buying an asset reduces cash but is not immediately a P&L expense), loan repayments (repaying principal reduces cash but is not a P&L cost), and VAT collected on behalf of HMRC (it sits in your bank account but was never your money to spend).
Understanding this distinction is covered in more depth in Accounting Basics: The Balance Sheet — Structure and Key Elements, which explains how assets, liabilities, and equity interact across your financial statements.
How to Build a Simple Cash Flow Forecast
You do not need sophisticated software to start forecasting. A spreadsheet — or even a piece of paper — will do. The structure is straightforward: opening balance, add expected cash inflows, subtract expected cash outflows, arrive at a closing balance. That closing balance becomes next month’s opening balance.
The table below shows a simple three-month forecast for a fictional SME with predictable revenues and a known equipment purchase in Month 2:
| Item | Month 1 (£) | Month 2 (£) | Month 3 (£) |
|---|---|---|---|
| Opening Cash Balance | 12,000 | 10,500 | -1,000 |
| Customer receipts | 22,000 | 18,000 | 25,000 |
| Other income (grants, interest) | 500 | 0 | 0 |
| Total Inflows | 22,500 | 18,000 | 25,000 |
| Payroll & employer costs | 11,000 | 11,000 | 11,000 |
| Rent & utilities | 3,500 | 3,500 | 3,500 |
| Supplier payments | 6,500 | 4,000 | 5,000 |
| Equipment purchase | 0 | 11,000 | 0 |
| VAT payment to HMRC | 3,000 | 0 | 3,000 |
| Total Outflows | 24,000 | 29,500 | 22,500 |
| Closing Cash Balance | 10,500 | -1,000 | 1,500 |
Month 2’s closing balance of -£1,000 is a red flag — a projected overdraft. Without this forecast, the business owner might not realise the shortfall until payroll day arrives and the account is empty. With the forecast in hand, they have weeks to act: delay the equipment purchase, chase outstanding invoices, or arrange a short-term credit facility before the crisis hits.
When building your own forecast, use your bank statements and sales pipeline as source data, not your P&L. Apply your actual payment terms — if customers typically pay 45 days after invoice, model the receipts accordingly. Be conservative with inflows and realistic with outflows.
Common Cash Flow Traps — and How to Avoid Them
Even businesses with a forecast can fall into predictable traps. Knowing them in advance is half the battle.
Late-paying customers. The most common cash flow disruptor. If your payment terms are 30 days but your average debtor days run at 55, your forecast needs to reflect the reality, not the policy. Track your debtor days regularly and follow up on overdue invoices systematically. Consider early payment discounts or invoice financing if late payment is structural.
Seasonal revenue gaps. Many businesses have predictable slow periods — retail slumps in January, construction pauses in winter, professional services quiet in August. Map your seasonal pattern and ensure your forecast extends far enough to capture the troughs. Build a cash buffer during strong months to carry you through weak ones.
Overtrading. Growing faster than your working capital supports is a genuine risk. If you win a large new contract, you may need to pay suppliers and staff weeks before your client pays you. Forecast the cash impact of growth, not just the revenue. If you are curious about the different ways businesses raise working capital, Understanding Funding in Accounting: Shares, Debts, and Financing Options explains the landscape clearly.
Forgetting non-monthly outflows. Annual insurance premiums, quarterly VAT payments, Corporation Tax, professional membership renewals — these are easy to forget when building a forecast. List every annual and irregular obligation at the start of the year and spread them into the relevant months.
Treating the forecast as static. A forecast that is never updated is worse than no forecast at all — it gives false confidence. Review and update your forecast at least monthly, comparing actuals against projections and rolling it forward.
Turning Your Forecast Into Action
A cash flow forecast is only useful if it drives decisions. Here is how to make yours actionable:
Set a minimum cash threshold — the floor below which your closing balance should never fall. For most SMEs, this is at least one month of fixed costs. If the forecast shows you approaching that floor, it triggers an immediate action review.
Use your forecast to time major purchases. Capital expenditure, hiring decisions, or marketing campaigns should be modelled into the forecast before they are committed. If a purchase creates a dangerous cash trough, you can either defer it, phase it, or arrange financing in advance.
Share a simplified version with your bank or accountant. Lenders are far more receptive to a facility request when it is supported by a well-constructed forecast showing the timing and recovery of a shortfall. It demonstrates management competence and reduces lending risk.
Finally, as your business grows and you begin operating across multiple entities or locations, the complexity of cash forecasting increases. At that stage, having a clear consolidated picture of group finances becomes essential — not just individual entity forecasts, but a coherent group view.
Key Takeaways
- A cash flow forecast projects your actual bank balance over time — it is not a P&L or a budget.
- Profit and cash are different. You can be profitable and still run out of money if the timing of receipts and payments does not align.
- The basic structure is: Opening Balance + Cash Inflows − Cash Outflows = Closing Balance, rolled forward month by month.
- Model inflows conservatively based on actual debtor payment behaviour, not your stated payment terms.
- Include all irregular outflows — VAT, Corporation Tax, annual premiums — in the months they actually fall.
- Review and update your forecast at least monthly, comparing actuals to projections.
- Use the forecast to drive decisions: timing purchases, chasing debtors, and arranging finance before — not after — a crisis arrives.
Related reading: If you are building your financial literacy alongside your forecasting skills, these posts are a useful next step. The Balance Sheet: Structure and Key Elements explains the financial statement that provides the context for your cash position. Why Every SME Owner Needs Basic Accounting Knowledge makes the case for financial literacy at every level of business ownership. Understanding Funding in Accounting walks through the options when your forecast reveals a shortfall that requires external finance. And for a grounding in the core terminology you will encounter across all these areas, Top 10 Accounting Terms Every Business Owner Should Know is the right place to start.