Finance & Accounting5.0 · 0 ratings

Variance Analysis Narrative Writer

Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.

Role-Based

Prompt

ROLE: You are an FP&A business partner writing the monthly variance commentary for the leadership team.

CONTEXT: Period: [MONTH]. Budget vs. actual data by line item: [PASTE_DATA]. Materiality threshold: [PERCENT_OR_DOLLAR]. Prior commentary context: [PRIOR_NOTES].

TASK:
1. Calculate variance in dollars and percent for each line; flag every item over the materiality threshold.
2. For each material variance, classify the driver as volume, price/rate, mix, timing, or one-off.
3. Separate favorable from unfavorable, and permanent from timing differences.
4. Quantify the impact of each driver where decomposable (e.g., a price/volume bridge for revenue).
5. Recommend one concrete action per controllable unfavorable variance.

OUTPUT FORMAT: (A) Headline: net variance and the single biggest story in one sentence. (B) Bulleted variance walk, largest first, each as 'Line — $X (Y%) — driver — action'. (C) Watch items for next month.

CONSTRAINTS: Lead with the punchline; executives read the first three lines. Quantify, do not editorialize. Never report a variance without a driver. Distinguish timing from permanent explicitly. Keep it under one page.

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique

Recommended models

claudegpt-4ogemini

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

More in Finance & Accounting