Skip to content

Finance templates

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