Contents
Cash variance analysis means comparing forecast and actual cash flows period by period, then identifying the source of each variance: a timing difference, an amount difference or a data anomaly. It measures the impact of variances on upcoming payments so you can update your forecast before they put pressure on your cash position.
Key takeaways
- A cash variance is the difference between a forecast cash flow or balance and what was actually received or paid.
- Three sources need to be told apart: timing differences, amount differences and data anomalies (missing flow, duplicate, formula error).
- The analysis only has value if it leads to an updated projected balance and updated upcoming payments.
What is a cash variance?
A cash variance is the difference between what the forecast predicted and what the bank accounts show. It can be measured on a single flow (a customer receipt, a supplier payment), on a category (salaries, VAT, taxes) or on the closing balance of a period.
The calculation is simple: variance = actual − forecast. Expressed as a percentage of the forecast, it lets you compare items of different sizes. How you read it depends on the direction of the flow:
- Receipts: a negative variance means you collected less than forecast.
- Payments: if payments are entered as negatives, a negative variance means you paid more than forecast.
- Balance: a negative variance on the closing balance means cash is lower than expected.
These variances are normal: no forecast is perfect. The goal is not to eliminate them but to understand them quickly. That is what forecast vs actual tracking is for, alongside the cash flow forecast.
The three sources of variance between forecast and actual
Not all variances should be handled the same way. Telling them apart avoids correcting a forecast that was right, or missing a genuine drift.
| Source | Example | Effect on cash | Response |
|---|---|---|---|
| Timing difference | A customer pays after 45 days instead of 30 | The total is unchanged, but the intermediate balance is lower | Move the due date in the forecast and check the payments that come before it |
| Amount difference | Discount, credit note, deposit, price revision, VAT rate | The variance is permanent | Correct the amount and carry the variance into recurring flows |
| Data anomaly | Missing flow, duplicate, formula error in Excel | The variance is artificial or hides a real flow | Fix the source and add a control |
Data anomalies are the hardest to spot in forecasts built by hand: when collecting and updating data relies on manual entry in Excel, one omission or a broken formula is enough to distort the projection. Cash flow problems often start with a variance that was spotted too late.
How to analyse cash variances in 5 steps
- Update the actual position. Start from today’s bank balances, preferably from imported statements rather than re-keyed figures.
- Match actuals to the forecast. Compare line by line or by category: customer receipts, supplier payments, salaries, VAT, taxes. An up-to-date bank reconciliation makes this step easier.
- Calculate the variances. Measure them in value and in percentage, by period and cumulatively, and set a threshold below which a variance is not analysed.
- Identify the source. For each significant variance, determine whether it is a timing difference, an amount difference or a data anomaly.
- Measure the impact and update. Identify the upcoming payments affected, update the flows concerned and recalculate the projected balance.
Good to know. A timing variance is not an amount variance. A receipt delayed by ten days does not change the month’s total, but it can deepen the balance just before a large payment (salaries, VAT). Look at variances against the payments coming up, not only cumulatively.
Cash variance analysis example
Here is a simplified one-month example, with illustrative amounts in euros.
| Item | Forecast | Actual | Variance | Source |
|---|---|---|---|---|
| Customer receipts | 120,000 | 105,000 | −15,000 | Timing difference: two customers paid the following month |
| Supplier payments | −70,000 | −74,000 | −4,000 | Amount difference: price revision |
| Salaries and payroll costs | −25,000 | −25,000 | 0 | — |
| Annual insurance | 0 | −3,000 | −3,000 | Missing flow: data anomaly |
| Net change | 25,000 | 3,000 | −22,000 | — |
Reading it: of the €22,000 net variance, €15,000 is a simple delay, recoverable next month if the customers pay. Only €7,000 is permanent: €4,000 of extra supplier cost to carry into upcoming payments, and €3,000 of forgotten spending to add to the forecast. The analysis changes the decision: rather than reacting to an overall variance of €22,000, you chase two customers and correct two lines of the forecast.
How can you make forecast vs actual tracking more reliable?
Tracking is only useful if it is regular and cheap to maintain. Four practices make the difference:
- Set a frequency. Weekly or monthly depending on the volume of flows: the more there are, the closer together the analyses should be.
- Define a materiality threshold. Only analyse the variances that matter, in value or in percentage.
- Keep a history of causes. A customer who always pays late or a supplier who keeps revising prices reveals a bias to correct in the forecast.
- Cut manual entry. Importing bank statements automatically limits omissions, duplicates and formula errors. Our guide to cash flow forecasting tools covers the options.
To see the method in action, join our webinar on cash variances: 10 minutes followed by Q&A, held in French.
Track cash variances without re-keyingE-Trésorerie automatically imports your bank statements and compares your forecasts with actuals every day, in the short, medium and long term.
Discover the solutionFrequently asked questions about cash variance analysis
How do you calculate a cash variance?
Variance = actual − forecast. To compare items of different sizes, divide it by the forecast: a variance of −€15,000 on €120,000 forecast is −12.5%.
How often should you analyse cash variances?
There is no single rule. A monthly analysis is enough for a moderate volume of flows; with many flows, several banks or during a tight period, a weekly analysis lets you react before the payment date.
What is the difference between a timing variance and an amount variance?
A timing variance moves a flow in time without changing its total: it weighs on the intermediate balance. An amount variance is permanent and must be carried into future flows.
Should you analyse every variance?
No. Set a materiality threshold, in value or in percentage, and focus the analysis on variances above it or that affect an upcoming payment.
- Banque de France — statistics and publications on corporate financing and payment times