What is Variance Analysis?
Variance analysis compares actual financial results with budgeted/forecasted numbers to identify differences. It helps you understand: Are we spending according to plan? Is revenue meeting targets? Which areas need immediate attention? What's driving over/under-performance?
Frequency: Monthly for most startups, weekly for fast-growing or cash-tight companies, quarterly for mature businesses. Consistent timing enables trend analysis.
Creating Your Budget
Annual budgeting process: Start 2-3 months before fiscal year-end. Bottom-up approach: Each department submits budget needs, then consolidate. Top-down approach: Leadership sets targets, departments allocate.
Budget components:
- Revenue budget: By product line, customer segment, geography. Based on sales pipeline + growth assumptions.
- Personnel budget: Headcount plan with salaries, benefits, ESOP costs. Typically 60-70% of total expenses.
- Operating expense budget: Marketing, technology, office, travel, professional fees. Categorized by department.
- Capital expenditure budget: Equipment, software licenses, property improvements. One-time or infrequent expenses.
- Cash flow budget: When will cash come in (collections) and go out (payments)? Accounts for payment terms.
Budget assumptions: Document all assumptions (pricing, churn rate, hiring dates, inflation). Makes it easier to explain variances later.
Calculating Variances
Variance = Actual - Budget. Positive variance for revenue is good (exceeded target). Positive variance for expenses is bad (overspent).
Variance % = (Variance / Budget) × 100. This normalizes variances for comparison. ₹10L variance on ₹1Cr budget (10%) is less concerning than ₹10L variance on ₹20L budget (50%).
Example table:
- Revenue: Budget ₹50L, Actual ₹45L, Variance -₹5L (-10%) → Unfavorable
- Salaries: Budget ₹20L, Actual ₹22L, Variance +₹2L (+10%) → Unfavorable
- Marketing: Budget ₹10L, Actual ₹8L, Variance -₹2L (-20%) → Favorable
- Net Burn: Budget ₹30L, Actual ₹35L, Variance +₹5L (+17%) → Unfavorable
Materiality threshold: Focus on variances >10% or >₹1L (whichever is lower). Don't waste time explaining ₹5,000 variances on ₹5L budget line items.
Analyzing Favorable vs Unfavorable Variances
Favorable variance: Actual is better than budget. Revenue higher than expected or expenses lower than budgeted. BUT investigate - could signal issues too.
Unfavorable variance: Actual is worse than budget. Revenue miss or cost overrun. Requires immediate investigation and corrective action.
Favorable variance scenarios:
- Revenue beat: New customer signed, pricing increase, lower churn → Good!
- Revenue beat: One-time deal, not repeatable → Neutral, don't revise forecast up
- Expense savings: Negotiated better rates, delayed hiring → Good!
- Expense savings: Budgeted activity not executed (e.g., marketing campaign delayed) → Bad! Missing growth opportunity.
Unfavorable variance scenarios:
- Revenue miss: Sales pipeline didn't convert, pricing pressure, higher churn → Bad! Need intervention.
- Revenue miss: Revenue timing shifted to next month, deals delayed not lost → Neutral, will recover next month.
- Expense overrun: Unplanned hires, cost inflation, project overruns → Bad! Budget revision needed.
- Expense overrun: Accelerated activity for good reason (hired star candidate early) → Good! As long as ROI justified.
Root Cause Analysis
For material variances, dig into the 'why' using these questions:
- Volume vs Price: Is variance due to selling fewer units or lower pricing? Different solutions needed.
- Timing: Is this a permanent miss or just timing shift (will normalize next month)?
- Internal vs External: Did we mess up execution or did market conditions change?
- One-time vs Recurring: Is this a one-off event or new run-rate we need to reflect in forecasts?
- Controllable vs Uncontrollable: Can we fix this or is it market-driven?
Example: Marketing expense 30% over budget. Root cause analysis: New paid ad channel tested (₹2L), agency fees increased (₹1L), event expenses brought forward from next month (₹1L). Conclusion: ₹2L test spend + ₹1L timing = acceptable. ₹1L agency increase = renegotiate contract.
Taking Corrective Action
Revenue miss actions:
- Accelerate sales pipeline: Increase demos, follow-ups, close pending deals
- Pricing adjustments: Limited-time promotions to pull forward revenue
- Revise forecast: If structural issue, reset expectations with investors/board
- Double down on what's working: Shift resources to high-performing channels/products
Expense overrun actions:
- Immediate spending freeze: Pause non-essential expenses until back on track
- Reforecast expenses: Update budget with new run-rate if costs permanently higher
- Process improvements: Better approval workflows to prevent future overruns
- Vendor renegotiation: Challenge every contract, look for savings opportunities
Monthly variance review meeting: Finance presents variance report, department heads explain their variances, team discusses corrective actions, update rolling forecast, document decisions in meeting notes.