Budget vs actual variance
Compare budget and actual figures line by line, with variances in %.
How it works
Variance = actual − budget, and % variance = variance / budget. The last number on each line is the actual, the one before it the budget.
Results are for guidance only and do not replace professional advice.
Worked example
With the default values:
- Lines (name, budget, actual, one per line)Sales 120000 112500 · Purchases 48000 46100 · Salaries 38000 39200 · Marketing 6000 810…
you get:
- Largest relative varianceMarketing (35 %)
- Total budget221,600
- Total actual215,500
Frequently asked questions
How does the “Budget vs actual variance” tool work?
Variance = actual − budget, and % variance = variance / budget. The last number on each line is the actual, the one before it the budget.
What do I need to enter?
Just fill in: lines. The result updates as you type.
Can you give an example?
Lines (name, budget, actual, one per line): Sales 120000 112500 · Purchases 48000 46100 · Salaries 38000 39200 · Marketing 6000 810… → Largest relative variance: Marketing (35 %); Total budget: 221,600.
Is this calculator free, and is my data private?
Yes. HOD Calc is completely free with no sign-up. The calculation runs in your browser: nothing you type is sent or stored.