Cash Flow Variance Analysis: Why Your Forecast Was Wrong Matters
You forecast that your business would have €50,000 in the bank at the end of the month.
Instead, it has €31,000.
You have a €19,000 variance.
The important question isn't simply whether your forecast was wrong. It is why.
Cash flow variance analysis compares what your business expected to happen with what actually happened, then asks what caused the difference. A forecast being wrong isn't necessarily the problem. Not understanding why it was wrong is.
What is cash flow variance analysis?
It is a side-by-side comparison of forecast and actual cash, category by category. Here is a simple month:
| Category | Forecast | Actual | Variance |
|---|---|---|---|
| Customer receipts | €100,000 | €82,000 | −€18,000 |
| Supplier payments | €60,000 | €67,000 | −€7,000 |
| Payroll | €25,000 | €25,000 | €0 |
Customers paid €18,000 less than expected — money you were counting on that did not arrive. Suppliers took €7,000 more than expected — money that left when you had planned to keep it. Payroll behaved exactly as forecast, so there is nothing to investigate there. Between them, those two lines left the business €25,000 worse off than the plan, and each one has a different cause and a different fix.
Note how the signs work: for money coming in, the variance is actual minus forecast. For money going out, spending more than forecast is shown as an adverse (negative) variance, because it is worse for your cash. Read a negative number as "worse than expected" in every row.
Why cash flow variance analysis matters
A month of variances is a month of information about how your business really behaves. Done consistently, it reveals:
- Customers paying later than expected
- Sales assumptions being too optimistic
- Supplier costs increasing
- Unexpected expenses
- Payments occurring earlier than expected
- Forecasting assumptions that repeatedly prove incorrect
- Missing information
- Seasonality
None of this requires accounting knowledge. It requires a forecast, a bank statement and the willingness to ask why the two disagree.
Timing matters as much as amount
€20,000 Friday
€20,000 following Wednesday
Monthly variance: €0. On paper, a perfect forecast. But if payroll was due on the Monday in between, the business spent three days without the money it was relying on — and that is a real cash problem, not a rounding difference.
This is why the template has a timing column as well as an amount column. Record when the money actually moved, not just how much of it moved.
How to perform cash flow variance analysis
A seven-step process for comparing your cash flow forecast with what actually happened, understanding the differences and improving your next forecast.
- Step 1
Take your original forecast
Start with the forecast exactly as you wrote it before the period began. Do not tidy it up or adjust it with hindsight — the point is to compare against what you genuinely expected at the time.
- Step 2
Enter the actual cash movements
Using your bank statement, record what actually came in and went out in the same categories you forecast. Work from money that moved, not invoices raised or bills received.
- Step 3
Calculate the variance
For money coming in, the variance is actual minus forecast. For money going out, it is forecast minus actual. In both cases a positive number means better for your cash than expected and a negative number means worse.
- Step 4
Identify the largest differences
Sort by size and look at the handful of variances that actually moved your closing balance. Small differences on small lines are noise; ignore them and protect your time.
- Step 5
Determine why each variance happened
For each large variance, write one plain sentence explaining the cause: a customer paid late, a price rose, a payment was pulled forward, a cost was forgotten entirely.
- Step 6
Decide whether it was temporary, recurring or structural
A one-off van repair is temporary. A customer who is always two weeks late is recurring. Assuming everyone pays on 30 days when your sector pays on 60 is structural — and structural causes are the ones worth fixing.
- Step 7
Adjust your next forecast
Feed what you learned back in: change the payment timing you assume, update the prices, add the cost you missed. That single adjustment is the entire point of the exercise.
The four questions to ask about every major variance
- 01What was different?
- 02Why was it different?
- 03Is it likely to happen again?
- 04What should I change in my next forecast?
If you answer only these four questions for your three largest variances each month, you are doing variance analysis properly.
Don't chase perfect forecasts
The objective is not 100 per cent accuracy. A forecast is an estimate of an uncertain future, and no amount of spreadsheet detail will change that. Owners who chase perfect numbers usually give up, because the target is unreachable.
The objective is better visibility and better decisions: seeing the tight week early enough to do something about it, knowing which customers to chase first, and understanding your own business well enough that next month's estimate is closer than last month's.
Your forecast should learn
Variance analysis turns forecasting from a one-off guess into a loop that improves itself:
- Forecast
- Actual
- Variance
- Understand
- Adjust
- New forecast
The value isn't simply discovering that last month's forecast was wrong. The value is understanding why it was wrong so that next month's forecast can be better.
Free Cash Flow Variance Analysis Template
Don't just read about variance analysis. Do it.
Use our free template to compare your forecast against actual cash movements, identify your largest variances and improve your next forecast.
What the workbook contains
- Instructions tab in plain English
- Variance Analysis tab you fill in
- Worked example tab
Every row records
- Forecast, actual, variance and variance %
- Timing difference and reason
- Recurring? Action required. Owner. Notes.
Variances calculate automatically, percentages handle zero forecasts safely, closing cash reconciles for you, and favourable and adverse variances are colour-coded so you can see at a glance which way each one went. Input cells are shaded; calculated cells are not.
The download form is just below ↓
Frequently asked questions
- What is a cash flow variance?
- A cash flow variance is the difference between the cash you forecast would move in or out of your business and the cash that actually moved. It can be a difference in amount, in timing, or both.
- How do you calculate cash flow variance?
- For money coming in, subtract the forecast from the actual: actual receipts minus forecast receipts. For money going out, subtract the actual from the forecast: forecast payments minus actual payments. Presenting it this way means a positive figure always means better for your cash than expected, and a negative figure always means worse. Variance percentage is the variance divided by the forecast amount.
- What is a good cash flow forecast variance?
- There is no universal target. Many small businesses find that closing cash within roughly 10 to 15 per cent of forecast over a month is workable, and that accuracy improves as they repeat the exercise. A small variance you cannot explain is worse than a larger one you can.
- Why is my cash flow forecast inaccurate?
- The most common causes are customers paying later than assumed, optimistic sales assumptions, supplier costs rising, payments falling in a different week than expected, and costs such as tax, VAT or insurance renewals being left out altogether. Variance analysis is how you find out which of these applies to you.
- How often should I perform variance analysis?
- Most small business owners do a short review each week alongside updating the forecast, and a fuller review once a month. Twenty minutes a week is usually enough once the habit is established.
- Should cash flow variance analysis be weekly or monthly?
- Do both if you can. Weekly analysis catches timing problems while you can still act on them; monthly analysis shows the patterns and assumptions that need to change. If you only have time for one, choose weekly — timing is what causes shortfalls.
Read next
Educational disclaimer. This material is general educational information about cash management. It is not investment, tax, legal, accounting or regulated financial advice, and it does not take account of your circumstances. Consider speaking to a suitably qualified professional before making financial decisions.