Compare your budgeted amounts against actuals to calculate variance in both absolute and percentage terms. Instantly see whether performance is favourable or adverse, understand the financial impact, and learn the right thresholds for investigation.
Inputs
The planned or budgeted amount for this line item.
The actual spend or revenue recorded.
Results
Variance
-$5,000
How to use
Enter the budgeted amount for the line item or category. This is the figure from your approved budget or forecast.
Enter the actual amount recorded from your accounting system or management accounts.
Review the variance in pounds and as a percentage.
Check whether the variance is flagged as favourable (under budget for costs, over budget for revenue) or adverse.
If the variance exceeds your investigation threshold (typically 5–10%), dig into the underlying drivers.
Worked Example
Your marketing department was budgeted £100,000 for the month, but the actual spend came in at £112,500. Let us calculate the variance and assess whether it warrants investigation.
Identify the figures
Budget = £100,000. Actual = £112,500.
Calculate absolute variance
£112,500 − £100,000 = £12,500 adverse (over budget).
Calculate percentage variance
(£12,500 / £100,000) × 100 = 12.5% adverse.
Assess materiality
At 12.5%, this exceeds the typical 5–10% investigation threshold. The variance is material and should be investigated.
Investigate root causes
Drill into the marketing sub-accounts: paid media was on budget, but an unplanned conference sponsorship (£8,000) and agency overspend (£4,500) drove the variance.
Take action
The conference sponsorship was a one-off and should be flagged as non-recurring. The agency overspend needs to be addressed by reviewing the scope of work for next month.
Key Takeaway
A 12.5% adverse variance on a £100,000 budget line is significant. By breaking the variance into its component parts, you can separate one-off items from recurring overspends and take targeted action. This is exactly the kind of analysis that budget variance reporting should surface each month.
Guidance
Budget variance analysis is a cornerstone of financial management. For cost items, spending below budget is favourable and above budget is adverse. For revenue items, the reverse applies — exceeding budget is favourable. Material variances (typically over 5–10%) should be investigated and explained. Regular variance analysis helps you course-correct early and maintain financial discipline. In Grove FP, variance analysis is automated with real-time colour coding.
Deep Dive
Budget variance is the difference between what you planned to spend (or earn) and what actually happened. It is the most fundamental management accounting technique and forms the basis of financial control in virtually every organisation. The formula is straightforward — Actual minus Budget — but the interpretation requires nuance.
For cost items (expenses), a negative variance means you spent less than budgeted, which is typically favourable. A positive variance means you overspent, which is adverse. For revenue items, the convention reverses: a positive variance (more revenue than planned) is favourable, while a negative variance (less revenue) is adverse. Some organisations use the alternative convention of Budget minus Actual, so always confirm which direction your finance team uses.
Variance can be expressed in absolute terms (pounds) or as a percentage. Absolute variance tells you the financial impact; percentage variance tells you the relative significance. A £10,000 variance on a £1 million budget (1%) is very different from a £10,000 variance on a £50,000 budget (20%). Both perspectives are needed for proper analysis.
Most finance teams set materiality thresholds for variance investigation. Common thresholds are 5% or 10% of the budget line, a fixed absolute amount (such as £5,000 or £10,000), or a combination of both. Variances below the threshold are noted but not actively investigated, allowing the team to focus their limited time on the items that matter.
Effective variance analysis goes beyond identifying the numbers — it explains why the variance occurred. Common categories of explanation include timing differences (the cost was incurred earlier or later than planned), volume effects (sales were higher or lower than forecast), price or rate effects (input costs changed), scope changes (new projects or activities not in the original budget), and one-off items (non-recurring events). A good variance commentary separates these factors so leadership can distinguish between systemic issues requiring action and temporary fluctuations that will self-correct.
In Grove FP, variance analysis is automated. Actuals flow in from your accounting integration, variances calculate in real time, and colour-coded flags highlight material deviations. Finance teams can add commentary directly against each variance, and the system tracks whether variances have been acknowledged and explained. This transforms variance analysis from a time-consuming monthly exercise into a continuous monitoring process.
Related
Find out exactly how many units you need to sell (or how much revenue you need) ...
Work out the fully loaded cost of employing staff in the UK for the 2025/26 tax ...
Evaluate any investment by calculating ROI percentage, payback period in months,...
Stop running one-off calculations. Build live financial models that update automatically and share results with your team in real time.
FAQ