For many small businesses in the UK, cash flow rather than profit is the real measure of stability.
It is possible to be profitable on paper yet run out of cash. Late payments, unexpected tax bills, or poorly timed expenses can quickly create pressure, even for healthy businesses. Building a reliable cash flow forecast isn’t just a finance task; it’s central to running your business well.
In this guide, we’ll show you how to build a practical and accurate cash flow forecast, and importantly, how to use it to make better decisions as your business grows.
Quick Summary
- A cash flow forecast tracks money moving in and out of your business over time
- It helps you anticipate shortfalls, manage tax obligations, and plan growth
- Accuracy depends on timing, not just totals
- A rolling 12-month forecast is best practice for most UK SMEs
- Scenario planning helps you manage uncertainty more effectively
What Is a Cash Flow Forecast? (And Why It Matters)
A cash flow forecast estimates the actual movement of cash in and out of your business over a defined period, usually weekly or monthly.
At its core, it answers one critical question:
Will we have enough cash available to operate, invest, and meet our obligations?
This fundamentally differs from profit. Profit reflects when income is earned and expenses are incurred, whereas cash flow reflects when money actually enters or leaves your bank account.
For example, you may invoice a client in January but not receive payment until March. Similarly, a tax liability may accrue over several months before being paid in one lump sum.
For UK SMEs, these timing differences are especially important because of:
- Standard 30 to 60 day payment terms
- Quarterly VAT payments
- Monthly or quarterly PAYE commitments
- Seasonal fluctuations in revenue
Without a clear forecast, these factors can lead to avoidable cash shortages.
What a Good Cash Flow Forecast Should Do
Many guides purely focus on structure by listing inflows and outflows. In practice, a useful forecast goes further and supports decision-making.
A well-built cash flow forecast should:
- Highlight future cash gaps early, giving you time to respond
- Show when surplus cash is available so you can reinvest with confidence
- Help you plan for tax liabilities without last-minute pressure
- Provide clarity if you need to secure funding
- Act as a live financial tool that evolves alongside your business
In short, it should allow you to move from reacting to problems to proactively managing them.
Step-by-Step: How to Build Your Cash Flow Forecast
Step 1: Choose the Right Forecast Structure
The structure of your forecast should reflect both how your business operates and how closely you need to manage cash.
For most UK SMEs, a rolling 12-month forecast broken down monthly is the most effective approach. Businesses with tighter cash positions may prefer a weekly view, as this provides greater control.
A rolling forecast means that as each month passes, you extend the forecast forward so that you always maintain a 12-month view. This approach is more flexible than a fixed annual budget and allows you to adjust as circumstances change.
Step 2: Set Your Opening Cash Position
Your opening balance forms the foundation of the forecast. It should reflect your current bank balance along with any cash that is immediately available.
Accuracy at this stage is essential. If the starting point is incorrect, the rest of the forecast will be unreliable. For businesses with multiple accounts, it may be helpful to consolidate balances or track them separately, depending on complexity.
Step 3: Forecast Your Cash Inflows (Realistically)
You should then estimate the cash you expect to receive during the forecast period.
Typical inflows include:
- Customer payments from sales
- VAT refunds where applicable
- Grants or government support
- Loans or investment funding
The most important principle here is realism. Forecasting based on when sales are made often leads to overly optimistic projections. Instead, you should focus on when cash is actually received.
To improve accuracy, review historical payment patterns and factor in your average debtor days. If customers regularly pay later than agreed terms, your forecast should reflect this behaviour.
Step 4: Forecast Your Cash Outflows (Comprehensively)
Outflows are often easier to predict, but they must be captured in full to avoid unexpected gaps.
These typically include:
- Supplier payments
- Payroll, pensions, and bonuses
- Rent, utilities, and overheads
- Marketing costs and software subscriptions
- Loan repayments
It is also important to account for less frequent but significant costs.
Pay particular attention to UK-specific obligations:
- VAT, which is usually paid quarterly, can create large spikes in outflows
- PAYE, which is paid monthly and tied directly to payroll
- Corporation Tax, which is often overlooked until it becomes due
Accurately mapping these payments allows you to plan ahead and avoid sudden cash pressure.
Step 5: Map Timing and Payment Behaviour
This stage is where a basic forecast becomes genuinely useful.
Rather than focusing only on totals, you need to reflect the timing of cash movements. This includes understanding how quickly customers pay, how suppliers are managed, and how costs are distributed throughout the year.
For example, if certain clients consistently pay late, your forecast should reflect that pattern. Likewise, if you have a large annual expense such as insurance, it should be shown in the month it occurs rather than spread evenly across the year.
Seasonality is another key factor. Many businesses experience peaks and dips in revenue, and these should be built into the forecast to provide a more realistic picture.
Step 6: Calculate Net Cash Flow
Once inflows and outflows are mapped, you can calculate your net cash position for each period using the following formula:
Opening Balance + Inflows – Outflows = Closing Balance
| Month | Inflows | Outflows | Net Cash | Closing Balance |
| Jan | £20,000 | £15,000 | £5,000 | £15,000 |
| Feb | £18,000 | £22,000 | -£4,000 | £11,000 |
This rolling calculation shows how your cash position evolves over time. It allows you to identify periods where cash may fall below a safe level, as well as opportunities to reinvest surplus funds.
Scenario Planning: The Step Most Businesses Miss
Many forecasts assume a single outcome, but in reality, business conditions change. A more robust approach is to model different scenarios.
You should typically create scenarios for:
| Expected Case | Worst Case | Best Case |
| Based on realistic assumptions and typical performance. | This might include delayed payments, reduced revenue, or increased costs. | This reflects stronger sales or faster payment collection. |
Comparing these scenarios helps you understand potential risks and prepare accordingly. It also allows you to make decisions with greater confidence, knowing how different outcomes could affect your cash position.
How to Use Your Cash Flow Forecast
Building a forecast is only part of the process. Its value comes from how it informs your decisions.
A well-maintained forecast helps you assess whether you can afford to hire, when to invest in growth, and whether additional funding may be required. It also allows you to test how your business would perform during a downturn.
Rather than relying on your current bank balance, you gain a forward-looking view that supports more strategic decision-making.
Common Mistakes to Avoid
Even a well-structured forecast can become unreliable if certain issues are not addressed.
Common mistakes include:
- Overestimating revenue, which creates an overly optimistic outlook
- Ignoring payment delays, which reduces accuracy
- Forgetting tax liabilities, particularly VAT and Corporation Tax
- Failing to update the forecast regularly
- Confusing profit with cash, which leads to poor decision-making
Avoiding these pitfalls will significantly improve the reliability of your forecast.
Tools for Cash Flow Forecasting
Most UK SMEs use a combination of tools depending on their needs.
Common options include:
- Xero for core accounting data
- Futrli, Syft or Fathom for more advanced forecasting and scenario planning
- Excel or Google Sheets for flexible, custom models
While software can simplify the process, the effectiveness of your forecast ultimately depends on the quality of your data and how consistently it is maintained.
When to Consider Outsourced Finance Support
As your business grows, forecasting becomes more complex and more critical.
You may benefit from outsourced finance support if you lack clear visibility over your cash position, are scaling quickly, or need more strategic financial insight. It can also be valuable if you don’t have in-house expertise to manage forecasting effectively.
An outsourced finance team can build and maintain your forecast, provide scenario analysis, and support decision-making at a higher level.
ViFi provides outsourced finance teams to UK SMEs, helping you gain clarity, control, and confidence over your finances so you can focus on growing your business.
Get in touch today to learn more about how we can transform your finance function.
Frequently Asked Questions (FAQs)
What is the difference between a cash flow forecast and a budget?
A budget outlines planned income and expenses, while a cash flow forecast tracks when money actually moves in and out of your business. Both are useful, but they serve different purposes.
How often should a cash flow forecast be updated?
At a minimum, forecasts should be updated monthly. Businesses with tighter cash control requirements may benefit from weekly updates.
Can I create a cash flow forecast in Excel?
Yes. Many businesses begin with Excel or Google Sheets. As complexity increases, dedicated forecasting tools can provide additional functionality.
What is a good cash buffer for a small business?
A common guideline is to hold enough cash to cover at least two to three months of operating costs, although this will vary depending on your business model and risk profile.