Align budget and actual data to the same periods, departments, and categories.
Budget variance guide
How to Compare Budget vs Actual in Excel
Budget versus actual analysis helps explain where performance differed from plan. The most useful version separates favorable and unfavorable variance and connects each difference to a business reason.
Step by step
A reliable workflow you can repeat.
Calculate absolute variance and percentage variance for every line.
Mark whether each variance is favorable or unfavorable based on the metric.
Focus commentary on the largest and most controllable differences.
Create actions, owners, and expected correction dates for material gaps.
Keep the result accurate.
- Higher expense than budget is unfavorable, while higher revenue is usually favorable.
- Avoid percentage variance when the budget value is zero.
- Separate timing differences from permanent overspending.
Move from the guide into the working tool.
Use the relevant workflow, review the preview carefully, and export only after the result matches your source data and business rules.
Open Budget vs ActualFAQ
Common questions about this workflow.
What is the basic variance formula?
Actual minus budget is common, but the favorable or unfavorable meaning depends on whether the line is revenue or expense.
Which variances need explanation?
Set a materiality threshold using both dollars and percentage so small lines do not dominate attention.
How often should variance be reviewed?
Monthly is standard, with weekly review for fast-moving cash, sales, or inventory metrics.