About the Budget Variance Calculator
This budget variance calculator turns a budget-versus-actual list into a variance report. Paste one line per item with its budgeted amount, actual amount and whether it is revenue or an expense. For every line it calculates the dollar variance and percentage variance, labels it favorable (F) or unfavorable (U), and flags the unfavorable lines that exceed a materiality threshold you choose.
Finance managers, department heads, small business owners and nonprofit treasurers use this kind of report every month to explain why profit differed from plan. The totals show the revenue variance, the expense variance and the net effect on profit, so you can see at a glance whether higher sales were eaten up by overspending.
Favorable and unfavorable follow the usual management-accounting convention: earning more revenue than budgeted or spending less than budgeted is favorable; the reverse is unfavorable. This is a static budget comparison — it does not flex the budget for volume changes, so large swings in sales activity can make expense variances look worse or better than they really are.
With the default inputs, the net variance (effect on profit) is $400.00. Change any value above to recalculate instantly.
How to use the budget variance calculator
- 1List each budget line as: name, budgeted amount, actual amount, revenue or expense.
- 2Paste from a spreadsheet using tabs if your numbers contain commas.
- 3Set the percentage threshold above which unfavorable variances must be explained.
- 4Review the net variance and the revenue and expense totals.
- 5Investigate the flagged lines in the variance report first.
Formula and method
Each line’s variance is signed so that a positive number always helps profit. For revenue lines that means actual minus budget; for expense lines it means budget minus actual, so underspending shows as positive (favorable) and overspending as negative (unfavorable). The percentage variance divides the dollar variance by the budgeted amount for that line.
A line is flagged for investigation when it is unfavorable and its percentage variance is at least your threshold (or when nothing was budgeted). The net variance is the sum of all signed variances and equals actual net income minus budgeted net income, which ties the report back to the bottom line.
- F
- Favorable — more revenue or less cost than budgeted
- U
- Unfavorable — less revenue or more cost than budgeted
- Threshold
- Materiality cut-off for flagging lines, as % of budget
Worked examples
Monthly small business budget
Revenue came in $2,500 over plan ($162,500 vs $160,000) while expenses ran $2,100 over ($90,100 vs $88,000), so profit beat budget by $400. Service revenue (−10%), supplies (−18%) and utilities (−6.7%) are flagged; salaries were over by only 4.2%, below the 5% threshold.
Expense-only department budget, 10% threshold
Wages were $2,000 (8%) over budget but purchases were $2,000 under, so total spending matched the $71,000 budget exactly. With a 10% threshold no line needs formal explanation.
Zero threshold flags every overspend
Setting the threshold to 0% flags all four unfavorable lines, including the 4.2% salary overspend, while the net variance stays a favorable $400.
Frequently asked questions
How do you calculate budget variance?+
Subtract the budgeted amount from the actual amount for each line. For revenue, a positive result is favorable; for expenses, a positive result (actual above budget) is unfavorable. Divide by the budget and multiply by 100 to express it as a percentage.
What is a favorable vs unfavorable variance?+
A favorable variance improves profit compared with the plan — higher revenue or lower costs. An unfavorable variance reduces profit — lower revenue or higher costs. Favorable does not always mean good: underspending on maintenance or marketing can hurt later.
What variance percentage is significant?+
Many organisations investigate variances above 5% to 10% of the budget line, or above a fixed dollar amount, whichever is larger. Pick a threshold that matches your materiality and the time you have to review.
What is the difference between a static and a flexible budget variance?+
A static budget variance compares actual results with the original budget, as this calculator does. A flexible budget variance first restates the budget at the actual level of activity, so it separates volume effects from price and efficiency effects.
Why do variances on my budget report not add up to the profit difference?+
They should if every revenue and expense line is included and signed consistently. Missing lines, or mixing up the sign convention for expenses, are the usual causes. The net variance here always equals actual net minus budgeted net.
Results are estimates for educational purposes and are not financial advice. Rates, fees and terms vary — confirm with your lender or a licensed advisor before making decisions.