Accueil
Gestion de trésorerie Communication bancaire Rapprochement bancaire Gestion des financements Lettrage comptable Anti-fraude (KBF)
Secteurs
Industrie manufacturière Immobilier Commerce & distribution Construction & BTP Éducation Agences de service Agricole & agroalimentaire
Métiers
Directeur financier Trésorier Comptable
Taille d'entreprise
TPE / PME ETI Grande entreprise
Success story
Noz centralise 1 100 comptes bancaires700 sociétés · 40 banques · Lire le cas client → Voir les 8 success stories
À propos de nous Partenaires Success stories Ressources Blog
Contactez
Demander une démonstration →
Home
Treasury Management Banking Communication Bank Reconciliation Financing Management Payment Matching Antifraud (KBF)
Industries
Manufacturing Real Estate Retail & Distribution Construction Education Service Agencies Agri-food Sector
Roles
CFO Treasurer Accountant
Company Type
Small Business Mid-size Company Large Enterprise
Success story
Noz centralises 1,100 bank accounts700 companies · 40 banks · Read the case study → See all 8 success stories
About us Partners Success stories Resources Blog
Contact
Request a demo →
Cash management

Cash variance analysis: a 5-step method with an example

Types of variance, causes, a 5-step method and a worked example: how to analyse variances between forecast and actual and update your cash flow forecast.

Thierry Lodomez, Director of Sales at E-Finances Updated on Nov 18, 2026 6 min read
Contents
In short

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.

SourceExampleEffect on cashResponse
Timing differenceA customer pays after 45 days instead of 30The total is unchanged, but the intermediate balance is lowerMove the due date in the forecast and check the payments that come before it
Amount differenceDiscount, credit note, deposit, price revision, VAT rateThe variance is permanentCorrect the amount and carry the variance into recurring flows
Data anomalyMissing flow, duplicate, formula error in ExcelThe variance is artificial or hides a real flowFix 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

  1. Update the actual position. Start from today’s bank balances, preferably from imported statements rather than re-keyed figures.
  2. 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.
  3. 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.
  4. Identify the source. For each significant variance, determine whether it is a timing difference, an amount difference or a data anomaly.
  5. 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.

ItemForecastActualVarianceSource
Customer receipts120,000105,000−15,000Timing difference: two customers paid the following month
Supplier payments−70,000−74,000−4,000Amount difference: price revision
Salaries and payroll costs−25,000−25,0000—
Annual insurance0−3,000−3,000Missing flow: data anomaly
Net change25,0003,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 solution

Frequently 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.

Sources
  1. Banque de France — statistics and publications on corporate financing and payment times
Thierry Lodomez
Thierry Lodomez

Director of Sales at E-Finances, a French financial software publisher for more than 25 years.

LinkedIn profile
From reading to action

Manage your cash with E-Trésorerie