Most business owners check sales, bank balance, and net profit every month. But those numbers only show what happened, not why it happened.
You might notice things like:
- Profit dropped even though sales were strong
- Expenses are higher than expected
- Cash feels tighter this month
- Marketing costs are rising faster than revenue
- Payroll suddenly increased
These situations are common. The real answers usually come from one of the most practical tools in financial management:
Variance Analysis
Variance analysis compares what you planned with what actually happened. It helps you spot problems early, understand the cause, and take action before things get worse.
Whether you run an eCommerce store, real estate portfolio, construction company, agency, clinic, or SaaS business, this approach can quickly improve your decision-making.
What Is Variance Analysis?
Variance analysis is simply the comparison between:
- Budget or forecast (what you expected)
- Actual results (what really happened)
The difference between the two is called a variance.
Here’s the basic formula:
Variance = Actual Revenue – Budgeted Revenue
- If results are better than expected, it’s considered favorable
- If results are worse, it’s unfavorable
The goal is not just to find differences, but to understand the reason behind them.
Why It Matters
Without variance analysis, you only see totals.
With it, you understand the story behind the numbers.
It helps you answer questions like:
- Why did profit change?
- Which expenses are out of control?
- Are your prices still working?
- Is your team cost-efficient?
- Which areas of the business need attention?
- Is growth actually profitable?
This is what turns financial reports into useful insights.
Key Types of Variances
Not all variances are the same. Here are the most important ones:
Revenue Variance
Difference between expected and actual sales.
Price Variance
Changes in how much you charge.
Volume Variance
Changes in number of clients, orders, or units.
Expense Variance
Costs higher or lower than planned.
Labor Variance
Changes in hours worked or wage rates.
Margin Variance
Changes in profitability per sale.
Understanding these categories makes it easier to find the root cause.
How to Calculate Variances
There are two common ways to measure variance:
1. Dollar Variance
Actual minus budget.
2. Percentage Variance
Variance Percentage = ((Actual – Budget) ÷ Budget) × 100
Example:
- Budget marketing = $12,000
- Actual = $18,000
Result = 50% higher than planned
This shows the scale of the issue, not just the number.
ECommerce Case Study
Situation
An eCommerce business saw strong growth but lower profit.
| Item | Budget | Actual | Variance |
| Revenue | $120,000 | $138,000 | +$18,000 |
| Ad Spend | $18,000 | $31,000 | ($13,000) |
| Shipping | $9,000 | $14,200 | ($5,200) |
| Net Profit | $24,000 | $15,600 | ($8,400) |
What Happened
- Ads became less efficient
- Shipping costs increased
- Lower-margin products sold more
Action Taken
- Improved ad targeting
- Adjusted shipping strategy
- Promoted higher-margin products
Key Insight
More sales don’t always mean more profit.
Real Estate Case Study
Situation
Rental income looked stable, but cash flow dropped.
| Item | Budget | Actual | Variance |
| Rental Income | $42,000 | $39,500 | ($2,500) |
| Repairs | $4,000 | $11,800 | ($7,800) |
| Vacancy | $2,000 | $6,000 | ($4,000) |
| NOI | $26,000 | $13,700 | ($12,300) |
Root Causes
- Vacant units
- Unexpected repairs
- Slow tenant turnover
Action Taken
- Preventive maintenance
- Faster leasing process
- Vendor cost review
Construction Case Study
Situation
Projects were active, but margins kept shrinking.
| Item | Budget | Actual | Variance |
| Revenue | $250,000 | $246,000 | ($4,000) |
| Labor | $78,000 | $104,000 | ($26,000) |
| Materials | $71,000 | $89,500 | ($18,500) |
| Gross Profit | $101,000 | $52,500 | ($48,500) |
Causes
- Overtime
- Material price increases
- Poor estimates
Action Taken
- Better job costing
- Stronger approval process
- Weekly tracking
SaaS Business Case Study
Situation
Revenue increased, but cash pressure grew.
| Item | Budget | Actual | Variance |
| MRR | $60,000 | $64,000 | +$4,000 |
| Churn | 4% | 8% | Unfavorable |
| Support Payroll | $14,000 | $21,000 | ($7,000) |
| Cash Change | $8,000 | $1,500 | ($6,500) |
Causes
- High support workload
- Weak onboarding
- Customer churn
Action Taken
- Better onboarding
- Self-service tools
- Improved retention strategy
How to Use It Monthly
A simple monthly process works best:
- Set a realistic budget
- Close accurate books (tools like QuickBooks Online or Xero help here)
- Compare actual vs budget
- Focus on large or unusual differences
- Identify root causes
- Take action
The key is consistency. One review is useful. Monthly reviews create real improvement.
Common Mistakes
- Using unrealistic budgets
- Ignoring seasonal trends
- Focusing only on revenue
- Not assigning responsibility
- Reviewing too late
These mistakes make the analysis less useful.
KPI Dashboard Example
| KPI | Budget | Actual | Variance |
| Revenue | $200,000 | $193,000 | ($7,000) |
| Gross Margin | 55% | 49% | -6% |
| Payroll | $58,000 | $64,500 | ($6,500) |
| Marketing ROAS | 4.0x | 2.8x | Unfavorable |
| Net Profit | $34,000 | $18,900 | ($15,100) |
A dashboard like this gives a quick, clear view of performance.
Final Thoughts
Variance analysis turns numbers into decisions.
Instead of saying:
“This month felt off”
You can clearly see:
- Revenue dropped slightly
- Payroll increased
- Margins declined
- Marketing efficiency fell
- Profit decreased
That level of clarity helps you act faster and with confidence.
Many businesses don’t need to work harder first.
They need better visibility.