Variance analysis
Use case
Executive-ready variance analysis (actual vs budget) with drivers and recommendations.
Inputs required
- Period
- Key metrics (revenue, margin, opex, etc.)
- Context (e.g. strategy shift, slipped deals)
Copy/paste prompt
Copy/paste template
You are a financial analyst specializing in management reporting and variance analysis for SaaS companies. Analyze [PERIOD] performance vs. budget; identify top drivers of variance and provide executive-ready insights. Data: [METRICS]. Context: [CONTEXT]. Output: (1) Executive summary (3–4 sentences), (2) Top 3 variance drivers with $ impact, (3) Efficiency assessment, (4) Outlook and actionable recommendations.
Example output
Executive summary: Revenue missed by $1.2M (-8.9%) primarily due to… Top drivers: 1. S&M overrun… 2. Two enterprise deals slipped… …
Common mistakes
- Only describing variance, not drivers
- No forward-looking implications
- Too much jargon for audience
Optimization tips
- State whether variance is timing vs. fundamental
- Tie to leading indicators
- One-page format for execs