Budget vs Actual Variance Calculator

What is Budget vs Actual Variance? (Variance Analysis) Budget vs actual variance is the difference between what you planned (budget) and what happened (actual) for a line item,...

Budget vs Actual Variance Calculator

Compare budgeted vs actual amounts, compute variance ($ and %), and get a quick interpretation of whether performance is on track.

Controls how the calculator labels favorable vs unfavorable variance

$

The planned amount for the period (budget, forecast, or target).

$

The realized amount for the same period as the budgeted amount.

Scenarios
Load a realistic example, then edit the numbers for your own budget line item.
Expense: on budgetExpense: over budgetExpense: under budgetRevenue: below plan

Results

  • Variance (Actual − Budget)$
  • Variance (% of budget)— %
  • Actual as % of budget— %
  • Status—

Enter your inputs above to calculate the results.

What is Budget vs Actual Variance? (Variance Analysis)

Budget vs actual variance is the difference between what you planned (budget) and what happened (actual) for a line item, cost center, or revenue stream.

It matters because it turns financial performance into a decision input: cost discipline (OPEX), margin management (gross margin, contribution margin), and forecasting quality for better capital allocation.

Formula

Variance = Actual-Budget
Variance% = Actual-Budget / Budget × 100
Actual as% of Budget = Actual / Budget × 100

Example

Scenario: Expense / cost (where spending less than budget is favorable)

  • Budgeted amount: $100,000
  • Actual amount: $95,000

Results:

  • Variance = $95,000 − $100,000 = -$5,000
  • Variance% = (-$5,000 / $100,000) × 100 = -5.0%
  • Actual as% of budget = ($95,000 / $100,000) × 100 = 95.0%
  • Status: Under budget (favorable)

Note on interpretation: for Revenue, the sign flips—positive variance is favorable (above plan) and negative variance is unfavorable (below plan).

Frequently Asked Questions

Why does the calculator show a negative variance when we’re under budget on expenses?

Because it uses Variance = Actual - Budget. For expenses, being under budget means Actual < Budget, so variance is negative—but the status is still “favorable” in the Expense/Cost context.

Which context should I choose: Expense/Cost or Revenue?

Choose Expense/Cost for spend lines (OPEX, payroll, tools, travel) where lower-than-budget is favorable. Choose Revenue for sales/income where higher-than-budget is favorable.

What does “Variance (% of budget)” actually tell me?

It normalizes the gap so you can compare across departments or months. Example: -5% on a $100k line is more meaningful than just “-$5k” when you’re scanning many accounts.

What should I do if the budgeted amount is zero (or tiny)?

Don’t rely on percent variance— (Actual - Budget) % Budget will blow up or be misleading. Use the $ variance and add a note like “new/unbudgeted spend” or “new revenue stream.”

Sources & Methodology