Budget Variance & Expense Deviation Calculator
Budget variance is the percentage difference between what you budgeted and what you actually spent. Enter budgeted and actual amounts to see the variance and whether you are over or under budget.
Budget Variance
Forecasting & Planning
Fill all inputs
Your result appears here automatically as you type.
How the Budget Variance Works
Budget variance measures how far actual results drift from plan. The formula is (actual - budget) divided by budget, expressed as a percentage. A positive result means you spent or earned more than planned, which is unfavorable for costs and favorable for revenue, so context matters. A negative result is the reverse. This calculator returns the percentage variance and a plain over/under label. Small variances are normal noise; tracking them over time reveals whether a gap is a one-off or a trend. For a full picture, split variance into price and volume components: paying more per unit is a price variance, while buying more units is a volume variance. That breakdown points to the real cause, whether it is a supplier increase or higher demand. Investigate variances beyond a threshold you set, usually around 5%, and document the reason. Present variances with a short cause for each material gap, because finance teams act on explanations, not just percentages.
Formula Used
Variance % = (Actual - Budget) / Budget x 100
Budgeted $5,000, actual $5,500. Variance = ($5,500 - $5,000) / $5,000 = +10%, meaning 10% over budget and unfavorable for a cost line.
When to Use This Calculator
- Reviewing monthly departmental spending.
- Explaining overruns to leadership.
- Deciding whether a forecast needs revision.
Common Mistakes
- Treating every variance as a problem: A favorable revenue variance is good; interpret the sign in context of the line item.
- Ignoring small variances that repeat: Consistent 3% overruns compound across categories and quarters into a real problem.
- Not separating price from volume: Knowing whether you paid more or bought more points to the actual fix.
Frequently Asked Questions
How is budget variance calculated in financial reporting?
Subtract the budgeted amount from the actual amount, then divide by the budgeted amount and convert to a percentage. Positive means over budget for costs; negative means under. The same formula works for revenue, where positive means over target.
What is a favorable versus unfavorable variance?
For costs, spending less than budget is favorable and spending more is unfavorable. For revenue, earning more than plan is favorable and less is unfavorable. The math is identical, so always interpret the result against the type of line item.
How do teams identify the root causes of budget deviations?
Break variance into price and volume, then compare against the same period last year and against forecast. Small recurring variances often point to a bad assumption; large one-off gaps usually have a specific event. Document the cause for each material variance.
What is the formula for favorable versus unfavorable variance?
Variance equals actual minus budget, divided by budget. For costs, actual below budget is favorable and above is unfavorable. For revenue, actual above budget is favorable. The sign alone does not tell you good or bad, context does.
How do you calculate price variance and volume variance?
Price variance isolates the effect of paying a different rate per unit. Volume variance isolates buying or selling a different quantity. Split total variance into these two parts to see whether cost control or demand drove the gap.
How This Page Is Reviewed
Written by the Recapflow Editorial Team and last reviewed . Every formula and worked example is cross-checked against the live calculator engine and a hand-worked example. This page is educational and does not replace professional financial, tax, or legal advice.