Budget Variance Analysis: How to Spot Problems Before They Cost You
A budget without variance analysis is just a wish list. Budget variance analysis is how you turn your financial plan into an accountability tool — catching problems early and amplifying what's working.
What Is Budget Variance Analysis?
Budget variance analysis compares your budgeted (planned) numbers to your actual (real) numbers, and investigates why they differ.
Variance = Actual − Budget
- Favorable variance: Revenue higher or expenses lower than budgeted
- Unfavorable variance: Revenue lower or expenses higher than budgeted
How to Perform Variance Analysis
Step 1: Build Your Comparison Table
| Line Item | Budget | Actual | Variance ($) | Variance (%) |
|---|---|---|---|---|
| Revenue | $50,000 | $47,000 | ($3,000) | -6% ⚠️ |
| COGS | $15,000 | $14,500 | $500 | -3% ✅ |
| Payroll | $20,000 | $22,000 | ($2,000) | +10% ⚠️ |
| Marketing | $5,000 | $4,200 | $800 | -16% ✅ |
| Rent | $3,000 | $3,000 | $0 | 0% |
| Net Income | $7,000 | $3,300 | ($3,700) | -53% 🔴 |
Step 2: Set Materiality Thresholds
Don't investigate every $50 variance. Set rules:
- Investigate anything >$1,000 or >10% off budget
- Always investigate revenue shortfalls
- Focus on the 3-5 largest variances each month
Step 3: Root Cause Analysis
For each material variance, ask:
- Is it a volume issue? (fewer sales than expected)
- Is it a price issue? (lower price per sale than planned)
- Is it a timing issue? (revenue recognized in a different month)
- Is it a one-time event? (unexpected expense, refund)
- Is it a systemic issue? (the budget assumption was wrong)
Step 4: Take Action
- Revenue shortfall: Increase marketing, adjust pricing, accelerate sales pipeline
- Expense overrun: Cut discretionary spending, renegotiate contracts, defer non-essential purchases
- Budget wrong: Revise the budget for remaining months with better assumptions
For Advisory Professionals
Budget variance analysis is a high-value monthly deliverable. Here's how to integrate it into your monthly review meetings:
- Prepare variance report 2-3 days before the meeting
- Highlight the top 3-5 variances with root cause analysis
- Come with recommendations, not just observations
- Track action items from month to month — did the fixes work?
Get Budget Templates and Analysis Frameworks
Our Advisory Starter Kit includes budgeting templates, variance analysis frameworks, and client presentation tools.
Download the Free Starter Kit →