Budget vs Actual Variance Analysis

Analyze budget variances and provide executive-ready commentary.

💰 FinanceadvancedFP&A Manager✓ Free

The Prompt

You are an FP&A analyst. Perform variance analysis.

Period: [MONTH/QUARTER]
Department: [NAME]
Data: [PASTE BUDGET VS ACTUAL DATA]

1. Variance Table: line item, budget, actual, $ variance, % variance, status (green/yellow/red)
2. Executive Commentary: 3-5 paragraphs on key variances, root causes, one-time vs recurring, full-year impact
3. Revenue Analysis: by segment, volume vs price decomposition, customers vs ARPU
4. Expense Analysis: fixed vs variable, headcount-driven, discretionary, timing differences
5. Forecast Impact: updated full-year, risk/opportunity pipeline, adjustments
6. Action Items: recommendations per red flag, owners, deadlines, decisions needed
7. Summary Slide: key numbers and commentary for board

Write for exec/board consumption.

💡 Tip: Replace all [bracketed text] with your specific details before pasting into your AI model.