Variance Analysis Explainer

FP&A teams and controllers use this prompt at month-end and quarter-end to turn raw budget vs. actual spreadsheets into the written commentary required for board packs, investor reports, and internal management reviews — saving hours of manual narrative writing.

You are a senior FP&A analyst specializing in management reporting for [COMPANY NAME], a [INDUSTRY] business reporting in [CURRENCY] for the period ending [PERIOD]. I will provide you with actual versus budget figures across our key revenue and expense lines.

Actual vs. Budget Data:
[ACTUAL VS BUDGET TABLE]

Using this data, produce a comprehensive variance analysis covering the following:

1. **Executive Summary**
   Open with a two- to three-sentence narrative summarizing overall financial performance — whether the business is ahead or behind budget in total, the magnitude of the variance in [CURRENCY] and percentage terms, and the single most important driver.

2. **Revenue Variance Breakdown**
   For each revenue line, explain:
   - The favorable or unfavorable variance in absolute and percentage terms
   - The likely business driver (volume, price, mix, timing, or market condition)
   - Whether the variance is expected to reverse in coming periods or is structural

3. **Expense Variance Breakdown**
   For each expense category, explain:
   - Whether the variance is favorable (under budget) or unfavorable (over budget)
   - Root cause classification: volume-driven, rate-driven, timing, one-time item, or budget error
   - Annualized impact if the variance is recurring

4. **Waterfall Summary**
   List all variances sorted from largest favorable to largest unfavorable, showing a clear walk from budgeted to actual net income.

5. **Management Actions**
   For each significant unfavorable variance (greater than 5% of budget line), recommend a specific corrective action or monitoring step that management should take in the next 30 days.

6. **Forward Look**
   Based on the pattern of variances, project the likely full-year forecast adjustment and identify which budget lines warrant a formal reforecast.

Write all narrative sections in clear, professional language suitable for a board pack or monthly management report. Avoid jargon. Use definitive statements, not hedged language.

Prompt Variables

Replace each placeholder with your specific information:

What You'll Get

An executive summary paragraph, line-by-line revenue and expense variance explanations with root cause classifications, a waterfall summary showing the walk from budget to actual net income, specific management actions for unfavorable variances, and a forward-looking reforecast flag for key lines.

💡 Pro Tip

Add a column for prior-year actuals alongside budget vs. actual — the AI will enrich the analysis by distinguishing between variances that are new this year versus recurring patterns, making the commentary significantly more insightful.

Compatible AI Tools

Related Prompts

Related Resources