KYBOS RESOURCES

What is variance analysis? Budget vs actual explained

Discover, learn, grow

Subscribe


Every month, finance teams compare what happened with what was planned. The differences are called variances, and explaining them is one of the most important jobs in FP&A. Done well, variance analysis turns numbers into insight the business can act on. Done badly, it becomes a long list of differences that nobody reads. This guide explains what variance analysis is, the main types of variance, how to calculate them and how to make your analysis more useful.

What is variance analysis?

Variance analysis is the process of comparing actual results with a budget, forecast or prior period, and explaining the reasons for the differences. A variance is favourable when it improves profit (for example, higher revenue or lower costs than planned) and adverse when it reduces profit.

Budget vs actual: a simple example

BudgetActualVariance
Revenue£500,000£470,000-£30,000Adverse
Cost of sales£300,000£276,000£24,000Favourable
Gross profit£200,000£194,000-£6,000Adverse

The headline is a £6,000 shortfall in gross profit. But on its own that tells you little. Was revenue down because fewer units were sold, or because prices were lower? Were costs lower because of efficiency, or simply because volumes fell? Breaking the variance down answers those questions.

The main types of variance

Volume variance

The effect of selling or producing more or fewer units than planned. Calculated as (actual volume – budget volume) x budget price or margin.

Price variance

The effect of selling at a different price than planned. Calculated as (actual price – budget price) x actual volume.

Mix variance

The effect of selling a different mix of products or services, for example more lower-margin products than planned.

Cost and efficiency variances

The effect of paying different rates for materials or labour, or using more or less of them per unit than planned.

Timing variances

Differences that will reverse later, such as a cost planned for March that is paid in April. Flagging these stops the business worrying about variances that are not real.

Making variance analysis useful

  • Focus on what is material. Set thresholds so commentary covers the variances that matter.
  • Explain causes, not just numbers. “Revenue down £30k” is a fact; “three new contracts slipped to next quarter” is insight.
  • Separate timing from permanent variances. Be clear which will reverse and which will not.
  • Compare against the latest forecast as well as the budget. The forecast shows whether performance is changing against current expectations.
  • Link to drivers. If your plan is driver-based, you can see exactly which driver moved and who owns it.
  • Agree actions. Every significant variance should lead to a decision or an update to the forecast.

How to speed up monthly variance reporting

Most of the time spent on variance reporting goes on preparing data, not explaining it. These steps shift the balance:

  1. Automate the actuals. Load actuals straight from the ledger or ERP instead of exporting and pasting them into spreadsheets.
  2. Keep budget, forecast and actuals in one model. Variances then calculate themselves, with no reconciling of versions.
  3. Set materiality thresholds. Highlight only the variances above an agreed amount or percentage, so the team knows where to look first.
  4. Flag unusual variances automatically. Rules or AI-based checks can spot movements that break the normal pattern before anyone opens a report.
  5. Collect commentary in the system. Budget holders add their explanations next to the numbers, instead of in separate emails.
  6. Use a standard report pack. The same layout every month means the report refreshes rather than being rebuilt.

Why variance analysis is hard in spreadsheets

In many teams, variance analysis starts only after days of exporting actuals, pasting them into spreadsheets and reconciling versions. By the time the analysis is ready, there is little time left to investigate causes. Automating data loads and using variance analysis software means budget, forecast and actuals sit in one model, with drill-down to the detail behind each number.

This is a core part of financial reporting automation. If you are also looking to speed up the close, see our guide on how to speed up month-end reporting.

Frequently asked questions

What is variance analysis?

Variance analysis compares actual results with a budget, forecast or prior period and explains the reasons for the differences, so the business can understand performance and act.

What is the difference between a favourable and an adverse variance?

A favourable variance improves profit compared with plan, such as higher revenue or lower costs. An adverse variance reduces profit.

What are the main types of variance?

The main types are volume, price, mix, cost or efficiency, and timing variances.

How do you calculate a price variance?

Price variance = (actual price – budget price) x actual volume.

How do you calculate a volume variance?

Volume variance = (actual volume – budget volume) x budget price or budget margin.

How can I speed up monthly variance reporting?

Automate the loading of actuals, keep budget, forecast and actuals in one model, set materiality thresholds, flag unusual variances automatically and collect commentary in the system rather than by email.

About Kybos
Kybos is a dedicated UK & Ireland Jedox Platinum partner. We build planning and analysis solutions that deliver value fast using accountancy qualified consultants. Whether you want a fully customised application or to build upon an existing solution, Kybos consultants are here to help.