Budget variance analysis: how to keep your finances on track

Published Saturday 8 August 2026

Table of contents

• What is budget variance analysis?
• Types of budget variances
• How to calculate budget variance
• How to perform budget variance analysis in 5 steps
• Budget variance analysis example
• Best practices for budget variance analysis
• Simplify your budget variance analysis with Xero
• FAQs on budget variance analysis

Key takeaways

• Budget variance analysis compares your planned spending and revenue against actual results so you can catch financial gaps early and adjust course.
• Favorable variances mean you earned more or spent less than planned; unfavorable variances signal overspending or revenue shortfalls that need attention.
• A regular review process, even monthly, gives you the confidence to make faster decisions and allocate resources where they have the most impact.
• You don't need an accounting background to run a variance analysis; a simple formula and a consistent routine are all it takes to stay in control.

What is budget variance analysis?

Budget variance analysis is the process of comparing what you planned to spend or earn against the actual result. The difference between those two numbers is called a variance.

You set a budget at the start of a quarter or year, then measure reality against that plan. When you track variances over time, you get a clear picture of where your business is hitting its targets and where it's falling short.

The goal isn't perfection, it's awareness. When you know where the gaps are, you can make smarter decisions about hiring, inventory, marketing spend, and every other area of your business.

Why it matters for your business

When you're running a business with 20 or more employees, money moves fast across departments. Payroll, supplies, software subscriptions, sales revenue: there are dozens of line items that can drift from your original plan without anyone noticing.

Budget variance analysis gives you an early warning system. Instead of discovering at year-end that you overspent on contractor fees or underperformed on product sales, you catch those trends monthly.

You can reallocate the budget before a small problem turns into a big one, and you build more accurate forecasts because each variance teaches you something about how your business actually operates.

Types of budget variances

Not all variances are equal. Some signal good news, others flag a potential issue. Here's how to categorize them.

Favorable variances

A favorable variance occurs when your actual results are better than budgeted. This could mean earning more revenue than expected or spending less than planned.

A few common examples of favorable variances include:

• Revenue that exceeds your forecast: Your sales team closes more deals than projected, increasing income beyond what you budgeted.
• Material costs below budget: A supplier offers an unexpected discount, reducing your production costs.
• Utility expenses below budget: Energy-saving upgrades reduce your monthly utility bills below your forecast.

Favorable variances are good news, but they still deserve attention. If revenue jumped because of a one-time event, you don't want to bake that spike into next quarter's forecast. Understanding the "why" helps you repeat successes intentionally.

Unfavorable variances

An unfavorable variance occurs when your actual results are worse than budgeted. This could mean earning less revenue than expected or spending more than planned.

Common examples of unfavorable variances include:

• Revenue falls short of your forecast: A key client delays a contract, pushing income into the next quarter.
• Payroll costs exceed budget: Overtime hours increase during a busy season.
• Unexpected repair expenses: Equipment breakdowns add unplanned costs.

Unfavorable variances aren't automatically a crisis. Some are seasonal, some are one-off events, and some point to a deeper trend. The key is investigating each one to decide whether it calls for immediate action or simply a better forecast next time.

Other variance categories

Beyond favorable and unfavorable, variances are sometimes described by what they measure:

• Revenue variance: The difference between projected and actual income.
• Expense variance: The difference between budgeted and actual costs.
• Volume variance: Tied to the quantity of goods sold or produced versus what you planned.
• Price variance: The difference between the expected price of inputs (materials, labor) and what you actually paid.
• Efficiency variance: Measures whether you used more or fewer resources than planned to produce a given output.

You don't need to track every category from day one. Start with revenue and expense variances, and add more detail as your analysis matures.

How to calculate budget variance

The math behind budget variance is straightforward. Two formulas cover most of what you'll need.

Dollar variance formula

The dollar variance tells you the absolute difference between your budget and actual figures.

Dollar variance = actual amount - budgeted amount

For revenue, a positive result means you earned more than planned (favorable). For expenses, a positive result means you spent more than planned (unfavorable).

Here's a quick example: you budgeted $50,000 in monthly revenue and actually brought in $54,000.

Dollar variance = $54,000 - $50,000 = $4,000 (favorable)

For an expense line, say you budgeted $12,000 for marketing but spent $13,500.

Dollar variance = $13,500 - $12,000 = $1,500 (unfavorable)

Percentage variance formula

The percentage variance puts the dollar figure in context, making it easier to compare across categories of different sizes.

Percentage variance = (dollar variance / budgeted amount) x 100

Using the revenue example above:

Percentage variance = ($4,000 / $50,000) x 100 = 8% (favorable)

And the marketing expense example:

Percentage variance = ($1,500 / $12,000) x 100 = 12.5% (unfavorable)

A $1,500 overspend on a $12,000 budget (12.5%) demands more attention than the same dollar amount on a $120,000 budget (1.25%). Percentage variance helps you prioritize which line items to investigate first.

How to perform budget variance analysis in 5 steps

Running a variance analysis doesn't require a finance degree. Follow these five steps on a regular schedule and you'll stay ahead of most budget surprises.

1. Gather your data

Pull together your budgeted figures and your actual financial results for the period you're reviewing. That typically means your income statement, expense reports, and any departmental budgets you've set.

Make sure you're comparing the same time period. If your budget is monthly, pull actual figures for that same month. Mixing timeframes leads to misleading variances. Confirm that all transactions have been recorded and reconciled before you start comparing.

2. Calculate variances

Apply the dollar and percentage formulas from the previous section to each line item in your budget. Work through revenue lines first, then move to expense categories.

Lay out three columns in a spreadsheet or your accounting software: budgeted amount, actual amount, and variance. Add a fourth column for percentage variance so you can spot proportionally large gaps at a glance.

3. Identify which variances matter

Not every variance needs your attention. A $200 difference on office supplies probably isn't worth investigating when your total budget runs into the millions. Focus on variances that are large in dollar terms, large as a percentage, or both.

Many businesses set a threshold: anything over 5% or over $5,000 gets flagged for review. Pick a threshold that makes sense for your scale and stick with it.

4. Investigate root causes

For each flagged variance, dig into the "why." Talk to department heads, review purchase orders, and check sales records. The goal is to separate one-time events from recurring patterns.

Ask yourself these questions:

• Was this a timing issue (for example, an invoice paid early or a payment received late)?
• Did external factors change, such as supplier pricing or seasonal demand?
• Was the original budget estimate realistic?
• Is this variance part of a trend building over several months?

5. Take corrective action

Once you know the cause, decide what to do about it. Your options generally fall into three buckets:

• Adjust spending. If an expense category is trending over budget, find ways to reduce costs or reallocate funds from a category that's under budget.
• Revise the budget. If your original assumptions were off, update the forecast so future periods reflect what you've learned.
• Change operations. If a process or supplier is consistently causing unfavorable variances, address the root issue directly.

Document your findings and actions. That record becomes a valuable reference when you build your next annual budget.

Budget variance analysis example

Here's a realistic scenario to show how this works in practice.

Imagine you run a regional marketing agency with 25 employees and projected annual revenue of $7 million. At the start of Q2, you set the following monthly budget:

• Revenue: $580,000
• Payroll: $290,000
• Contractor fees: $45,000
• Software subscriptions: $12,000
• Office rent and utilities: $18,000
• Marketing spend: $25,000

At month-end, your actual results come in:

• Revenue: $548,000 (variance: -$32,000, or -5.5%, unfavorable)
• Payroll: $295,000 (variance: +$5,000, or +1.7%, unfavorable)
• Contractor fees: $38,000 (variance: -$7,000, or -15.6%, favorable)
• Software subscriptions: $12,400 (variance: +$400, or +3.3%, unfavorable)
• Office rent and utilities: $17,800 (variance: -$200, or -1.1%, favorable)
• Marketing spend: $28,500 (variance: +$3,500, or +14%, unfavorable)

Using a 5% threshold, three variances get flagged: revenue (-5.5%), contractor fees (-15.6%), and marketing spend (+14%).

You investigate and find the root causes:

• A major client pushed a $35,000 project into next month, explaining most of the revenue shortfall.
• Contractor fees dropped because you brought two freelance roles in-house.
• Marketing spend jumped because the team ran an unplanned paid social campaign.

Your corrective actions:

• Confirm the delayed project's new timeline and adjust next month's forecast upward.
• Log the contractor savings as a structural change for future budgets.
• Review the marketing approval process so unplanned campaigns get sign-off before spending starts.

That 30-minute review gave you a clear action plan and a more accurate forecast for next month.

Best practices for budget variance analysis

These six practices keep the process efficient and useful as your business grows:

• Set a regular cadence. Monthly reviews work well for most small businesses. Quarterly is too infrequent to catch trends early.
• Use consistent categories. Keep your budget line items and chart of accounts aligned so comparisons are apples to apples.
• Define your thresholds upfront. Decide what counts as a material variance before you start reviewing. A 5% or $5,000 threshold is a solid starting point.
• Involve department leads. The people closest to the spending know why variances happen. Include them in your monthly review for faster answers and stronger accountability.
• Track variances over time. A single month's variance is a data point. Three months of the same variance is a trend. Keep a running log to spot patterns.
• Keep it simple. A spreadsheet with four columns (budget, actual, dollar variance, percentage variance) is all you need to start.

Simplify your budget variance analysis with Xero

Pulling together budget and actual figures shouldn't eat up your entire afternoon. Xero's accounting software connects your bank accounts, invoices, bills, and payroll in one place, so the data you need for variance analysis is always up to date.

With customizable budget reports and real-time dashboards, you can compare budgeted figures against actuals in a few clicks. Set up tracking categories to break down spending by department, project, or location, and spot variances before they snowball.

Ready to spend less time in spreadsheets and more time growing your business? Get 90% off for 6 months and see how Xero makes budget management easier.

FAQs on budget variance analysis

Here are answers to common questions about budget variance analysis.

What is the acceptable range for budget variance?

Most small businesses use a 5% to 10% threshold, with anything beyond 10% typically warranting investigation. Your ideal threshold depends on your industry, cash position, and revenue volatility.

How often should you perform budget variance analysis?

Monthly reviews strike the best balance between timeliness and effort for most small businesses. If your revenue is highly variable, consider reviewing key revenue lines every two weeks while keeping the full analysis monthly.

What is the difference between budget variance and forecast variance?

Budget variance compares actual results to your original, fixed budget for the period. Forecast variance compares actuals to a rolling forecast that gets updated as conditions change, showing how well you're adapting your plan over time.

Can you do budget variance analysis without accounting software?

Yes, a basic spreadsheet with columns for budgeted amounts, actual amounts, dollar variance, and percentage variance covers the essentials. The tradeoff is manual data entry, which takes time and introduces error risk compared to accounting software that automates the process.