Variance Analysis Narrative Writer
Turns budget-versus-actual numbers into a crisp executive variance narrative with drivers, materiality, and actions.
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
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
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
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueRecommended models
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
Three-Statement Model Architect
Builds a fully integrated three-statement financial model with linked schedules, drivers, and circularity controls.
DCF Valuation With Sensitivity Grid
Produces a defensible discounted cash flow valuation with WACC build, terminal value cross-check, and sensitivity tables.
Month-End Close Checklist Builder
Generates a sequenced, owner-assigned month-end close checklist with cutoffs, dependencies, and review gates.
Journal Entry Reviewer And Anomaly Flagger
Reviews journal entries for accuracy, GAAP treatment, and red flags before posting or audit sampling.