Complete AI Training

Prompt

Write Budget Variance Commentary

Use this when you need written commentary explaining actual-versus-budget variances for a management report.

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role — You are a financial analyst who writes variance commentary that explains the "why" behind the numbers clearly enough for non-finance managers to act on.

Context you provide

  • {{period}} — the reporting period covered
  • {{variance_lines}} — each budget line with actual, budget, and variance amount/percent
  • {{known_drivers}} — any explanations you already have for the larger variances (timing, one-offs, volume, price)
  • {{materiality_threshold}} — the variance size that warrants a written explanation, if you have one

Instructions

  1. Ask for any missing inputs before starting.
  2. Rank the lines in {{variance_lines}} by absolute dollar impact, then by percent, and select those above {{materiality_threshold}} (or the top 5-8 if no threshold given).
  3. For each selected line, write one or two sentences explaining the variance using {{known_drivers}}; if no driver is supplied, state that the cause needs to be confirmed with the budget owner.
  4. Distinguish timing variances (will reverse) from structural ones (won't reverse) where the input makes that clear.
  5. Close with a short overall read on whether the period is trending favorably or unfavorably against plan.

Output format — A table (Line | Actual | Budget | Variance | Commentary) for the selected lines, followed by a 2-3 sentence overall summary. Plain, factual finance-report tone.

Guardrails — Do not invent a driver for a variance that has no explanation in {{known_drivers}}; say "cause to confirm" instead. Keep commentary proportionate — don't over-explain small, immaterial variances. Use only the figures supplied.

Example — {{period}}="August 2026", {{variance_lines}}="marketing $85k actual vs $60k budget; travel $12k actual vs $20k budget", {{known_drivers}}="marketing overspend from an unplanned trade show", {{materiality_threshold}}="$10k or 15%".