Budget Variance Calculator

Calculate budget variances in absolute and percentage terms, classify them as favourable or unfavourable, and flag which exceed your materiality threshold.

📋 Financial Analysis📐 Variance = actual − budget; favourability depends on whether the line is revenue or cost💼 Business

Line type

Budgeted amount

Actual amount

Materiality threshold (%)

Prior period actual (optional)

Please enter valid values.

Formula & Reference

Variable	Symbol	Formula	Units
Budget Variance Calculator	—	Variance = actual − budget; favourability depends on whether the line is revenue or cost	currency and percent

Step-by-Step Examples

Example 1

Revenue Above Budget

Revenue line, budget 250,000, actual 268,000, 5% threshold, prior 240,000.

Variance = 268,000 − 250,000 = +18,000
Percentage = 7.20%
Revenue above budget is favourable
Exceeds the 5% threshold — worth understanding why
Up 11.67% on prior period

✓ +18,000 favourable, 7.20%

Example 2

Cost Above Budget

Cost line, budget 180,000, actual 197,000, 5% threshold.

Variance = +17,000, or 9.44%
For a cost line, above budget is unfavourable
Exceeds the materiality threshold

✓ +17,000 unfavourable, 9.44%

Example 3

Immaterial Variance

Cost line, budget 90,000, actual 92,500, 5% threshold.

Variance = +2,500, or 2.78%
Unfavourable but within the 5% threshold
Below the level warranting formal investigation

✓ +2,500 unfavourable but immaterial

Real-World Applications

📊

Management Reporting

Variance analysis is the core of monthly management accounts and board reporting.

🔍

Exception Focus

Materiality thresholds direct attention to variances that matter rather than every line that moved.

⚖️

Sign Convention

Whether a positive variance is good depends entirely on whether the line is revenue or cost — a frequent source of reporting confusion.

📈

Forecast Correction

Persistent variances in the same direction indicate the budget assumptions need revising, not just the actuals explaining.

Common Mistakes to Avoid

⚠️

Assuming positive variance is always good

On a cost line, spending more than budget is unfavourable. Reporting that mixes conventions across revenue and cost lines confuses everyone reading it.

⚠️

Investigating every variance

Without a materiality threshold, teams spend time explaining trivial movements while genuinely significant variances get equal weight.

⚠️

Explaining variances without adjusting forecasts

If a variance reflects a permanent change rather than timing, the remaining forecast should be updated rather than simply explained each month.

Frequently Asked Questions

How is budget variance calculated? ▾

Actual minus budget. The percentage is that difference divided by the absolute budget value.

What is a favourable variance? ▾

One that improves profit — revenue above budget or costs below budget. The same numeric sign means opposite things on the two line types.

What materiality threshold should I use? ▾

Commonly 5 to 10% combined with an absolute minimum, so small percentage swings on tiny lines do not trigger investigation.

What is the difference between timing and permanent variances? ▾

Timing variances reverse in later periods, such as a delayed invoice. Permanent variances persist and require the full-year forecast to be revised.

Should I flex the budget for volume? ▾

For variable costs, yes. Flexed budgeting adjusts the budget for actual volume, separating price and efficiency effects from volume effects.