Cash flow forecasting for small businesses

"Cash is king" is one of the oldest clichés in business, but for a small business owner, it’s a daily reality. You can have a full order book and a profitable business on paper, but if your clients don't pay on time, you can still find yourself unable to pay suppliers, staff, or even yourself. This is where cash flow forecasting moves from a "nice-to-have" accounting exercise to an essential survival tool.

This practical guide will walk you through a framework for building a cash flow forecast that works for a real-world UK small business. We'll focus on the specific challenges of unpredictable invoice payments and seasonal trading, helping you move from reactive fire-fighting to proactive financial management. Forget complex financial modelling; this is about creating a simple, powerful tool to help you sleep better at night.

What is Cash Flow Forecasting (and Why Isn't It Just a P&L)?

First, let's be clear about what a cash flow forecast is not. It is not a profit and loss (P&L) statement. A P&L statement shows your revenues and expenses over a period to calculate your profit or loss. It's a measure of profitability, but it doesn't track the actual movement of money in and out of your bank account.

A profitable business can easily run out of cash. Imagine you land a huge £50,000 project. Your P&L looks fantastic for that month. But the client is on 90-day payment terms. In the meantime, you have to pay your own staff salaries, rent, and a hefty VAT bill for the previous quarter. The cash isn't there. This is a classic cash flow crunch.

A cash flow forecast, in contrast, is simply a plan of the actual money you expect to flow into and out of your business bank account over a set period. It's your financial early warning system.

The Core Components of a Cash Flow Forecast

Every cash flow forecast, whether it's on the back of a napkin or in a sophisticated spreadsheet, has three fundamental parts.

1. Opening Bank Balance: This is the total amount of cash you have in your bank accounts at the very start of the period (e.g., on the 1st of the month).
2. Cash Inflows (Money In): This is all the money you expect to receive during the period. It's crucial to forecast this based on when you realistically expect the cash to hit your account, not when you issue the invoice.
   • Payments from customers (cleared funds)
   • VAT refunds from HMRC
   • Director loans paid into the business
   • Grants or other funding received
3. Cash Outflows (Money Out): This is all the money you expect to pay out during the period.
   • Supplier payments
   • Salaries, PAYE, and National Insurance contributions
   • VAT payments to HMRC
   • Corporation Tax payments
   • Rent, business rates, and utilities
   • Software subscriptions, marketing costs, and other overheads
   • Loan repayments
   • Director's drawings or dividends

The calculation is simple: Closing Balance = Opening Balance + Cash Inflows - Cash Outflows. The closing balance for one month becomes the opening balance for the next.

A Step-by-Step Framework for Building Your First Forecast

You don't need fancy software to get started. A simple spreadsheet is the perfect tool for your first forecast.

Step 1: Choose Your Period and Tool

Decide on the timeframe. A 12-month rolling forecast, broken down by month, is the most common and useful for strategic planning. If your business has very tight cash flow or is in a turnaround phase, a 13-week forecast, broken down by week, is more practical for tactical, day-to-day cash management.

Open a new spreadsheet in Excel or Google Sheets. Set up your columns: one for categories (e.g., 'Sales Receipts', 'Salaries') and then one for each month or week of your forecast period.

Step 2: Fill in Your Opening Balance

In the first cell for your first month (e.g., 'January'), enter your current total cash at bank.

Step 3: Forecast Your Cash Inflows

This is the hardest part to get right, but the most important. Don't just copy and paste your sales targets. You need to be realistic.

• Look at your sales pipeline: What work is confirmed? What is likely to be confirmed?
• Be conservative: It is always better to underestimate income than to overestimate it. Create a 'best case' and 'worst case' version if it helps.
• Focus on the payment date: If you invoice a client for £5,000 on 15th January with 30-day terms, do not put £5,000 in your January 'cash in' column. Realistically, you will receive that money in mid-February at the earliest. If that client is a known slow payer, you might even pencil it in for March. We'll cover this in more detail later.

Step 4: Forecast Your Cash Outflows

This is usually easier as many of your costs are fixed or predictable.

• Fixed Costs: Go through your bank statements and list all the regular, recurring payments. This includes rent, salaries, software subscriptions, insurance, and loan repayments. Put them in the corresponding months.
• Variable Costs: Estimate your variable costs, which fluctuate with sales, such as raw materials, project-specific contractor fees, or shipping costs.
• Don't Forget Tax! This is the number one "gotcha" for small businesses.
  • VAT: If you are VAT registered, you will likely pay a large lump sum to HMRC every quarter. Mark these dates in your forecast. This is not an expense on your P&L, but it is a massive cash outflow.
  • Corporation Tax: This is due 9 months and 1 day after your company's year-end. It's a huge payment that can catch you by surprise if you haven't planned for it.
  • Self-Assessment: For sole traders, remember your Payments on Account are due by 31st January and 31st July.

Step 5: Do the Maths

Now, create rows at the bottom of your spreadsheet:

• Total Cash In
• Total Cash Out
• Net Cash Flow (Total In - Total Out)
• Closing Balance (Opening Balance + Net Cash Flow)

Make sure the closing balance of one month automatically populates the opening balance cell of the next month. You'll quickly see a picture of your future cash position emerge.

Forecasting for Invoice Payment Cycles: The Real-World Challenge

For most service-based businesses in the UK, the biggest variable in any cash flow forecast is customer payment behaviour. An invoice on 30-day terms is just a request; it isn't a guarantee of cash in 30 days. To make your forecast more accurate, you need to stop guessing and start using data.

Calculate Your Average Debtor Days

Your 'debtor days' (or Days Sales Outstanding - DSO) is the average number of days it takes for your customers to pay you. Most accounting software can calculate this for you. A simple way to estimate it is:

(Total Amount Owed by Customers / Total Credit Sales in the Period) x Number of Days in the Period

For example, if you have £20,000 in outstanding invoices and your sales for the last quarter (90 days) were £60,000, your average debtor days are (£20,000 / £60,000) x 90 = 30 days.

If your standard terms are 30 days and your average is 45 days, you now have a much more realistic basis for your forecast. Instead of forecasting payment in 30 days, you should forecast it in 45 days.

Segment Your Customers

Not all customers are equal. You probably have:

• The Good: Large, reliable clients who always pay on or before the due date.
• The Average: Most of your clients, who pay within a week or two of the due date.
• The Challenging: A handful of clients who consistently pay 60 or 90 days late, and only after multiple reminders.

Your forecast should reflect this reality. When you project income from a 'Challenging' client, add an extra 30 or 60 days to their payment terms in your forecast. This realism is what makes a forecast a useful tool rather than a pointless fantasy.

Systematically chasing these payments is critical to making your cash inflows more predictable. The manual effort of tracking who owes what and sending reminder emails can be draining. This is where automating the process with a tool like InvoiceReminder can make a significant difference. By connecting to your accounting software and sending scheduled reminders that escalate from friendly to firm, you can systematically reduce your debtor days and make your cash flow forecasts more reliable.

Dealing with Seasonal Dips and Bumps

Many businesses have a natural seasonal rhythm. A wedding photographer is busiest in the summer, an accountant is swamped around the tax year-end, and a retailer does most of its trade in the run-up to Christmas.

A cash flow forecast is your best friend for managing this.

1. Analyse Historical Data: Look at your sales and bank statements from the last 2-3 years. Identify the peaks and troughs. This historical pattern is your best guide for the future.
2. Build a Buffer: The golden rule of seasonal business is to use the profitable peak season to build a cash reserve that will see you through the quiet months. Your forecast will show you exactly how much of a buffer you need to survive the dip.
3. Time Your Expenses: If you need to buy a new piece of equipment or invest in a website redesign, use your forecast to plan it. The best time to spend that cash is during or just after your peak season when your bank balance is healthiest, not during a trough when every penny counts.
4. Smooth the Flow: Can you introduce new services for the off-season? Could a landscaper offer winter gritting services? Could you offer a discount for customers who book and pay for work during your quiet period? Use the insights from your forecast to develop strategies that smooth out your income throughout the year.

Using Your Forecast to Make Better Business Decisions

A cash flow forecast isn't just a passive report; it's an active decision-making tool. Once you have it, you can start asking powerful "what if" questions.

Spotting Trouble in Advance

The most immediate benefit is seeing a potential cash crunch months before it happens. If your forecast shows a negative closing balance in three months' time, you have a 90-day head start to fix it. You can:

• Start chasing overdue invoices more aggressively.
• Negotiate longer payment terms with a key supplier.
• Delay a non-essential purchase.
• Arrange a business overdraft with your bank (which is much easier to do when you're not desperate).

Making Strategic Investment Decisions

Let's say you want to hire a new employee. You can model this in your forecast. Create a copy of your forecast and add a new monthly outflow for the salary, National Insurance, and pension contributions. Does your cash flow remain positive? How much does it reduce your buffer? The table below shows a simplified example.

Metric	Oct	Nov	Dec	Jan	Feb	Mar
Scenario A: No Hire
Net Cash Flow	£5,000	£4,000	£8,000	-£2,000	£3,000	£5,000
Closing Balance	£15,000	£19,000	£27,000	£25,000	£28,000	£33,000
Scenario B: New Hire
Net Cash Flow	£1,500	£500	£4,500	-£5,500	-£500	£1,500
Closing Balance	£11,500	£12,000	£16,500	£11,000	£10,500	£12,000

In this example, while the business remains cash-positive with the new hire, the buffer is significantly reduced, especially in January. The forecast doesn't give you the answer, but it gives you the data to make an informed decision. Perhaps you decide to wait until March to hire, after the seasonal dip.

Securing Finance

If you ever need to apply for a business loan, grant, or investment, a well-thought-out cash flow forecast is non-negotiable. It demonstrates to lenders and investors that you have a deep understanding of your business's financial health and that you are a credible, organised operator.

Frequently asked questions

What's the difference between a cash flow forecast and a budget?

A budget is a plan for what you want to happen – a set of financial goals (e.g., "we will spend no more than £500 on marketing per month"). A cash flow forecast is a prediction of what you think will actually happen based on your sales pipeline, payment history, and known expenses. A good forecast informs whether your budget is realistic.

How often should I update my cash flow forecast?

As a minimum, you should review and update your forecast at the end of each month with the actual closing figures. This allows you to re-forecast the upcoming months with more accuracy. If your business has very tight cash flow, updating it weekly is a sensible discipline.

My sales are too unpredictable to forecast. What should I do?

This is a common concern, especially for new businesses. The solution is to create three scenarios: a 'worst case' (you only land confirmed deals), a 'most likely' case (confirmed deals plus the ones you're 75% sure of), and a 'best case' (everything in the pipeline comes off). This range gives you a much better feel for the potential outcomes. Even a rough forecast is infinitely better than no forecast at all.

Does a cash flow forecast need to include VAT?

Yes, absolutely. VAT is a real cash movement. You collect it from customers (cash in) and pay it to HMRC (cash out). Because VAT payments are often large, quarterly lump sums, failing to account for them is one of the most common reasons businesses get into unexpected cash flow trouble.

What's the best tool for cash flow forecasting?

For most small businesses, a spreadsheet (like Microsoft Excel or Google Sheets) is the best place to start. It's flexible and forces you to understand the numbers. As you grow, your accounting software (Xero, QuickBooks, etc.) may have built-in forecasting tools or dedicated add-on apps that can automate much of the process.

What happens if my forecast shows a future negative balance?

Don't panic! This is the entire point of forecasting – it gives you an early warning. A projected negative balance is a signal to take action now while you still have time. You can focus on collecting debts, delaying non-critical spending, reducing overheads, or exploring short-term financing options like an overdraft.

Take Control of Your Cash Inflow

A reliable cash flow forecast depends on reliable payment cycles. If you're tired of manually chasing invoices and want to make your 'cash in' column more predictable, InvoiceReminder can help. It connects to Xero, Sage, QuickBooks, and FreeAgent to automate your invoice chasing with customisable email schedules. The core service for unlimited email reminders is currently available at no cost. InvoiceReminder is built by the team behind WeCovr, a UK company authorised and regulated by the Financial Conduct Authority for its insurance activities, bringing a commitment to security and reliability.