In the pack: ChatGPT, Claude & Gemini Prompts for Finance and Accounting Professionals
Variance Commentary From a Budget vs Actual Table
Prompt
Period: {{PERIOD}}
Currency and units: {{CURRENCY_UNITS}}
Budget vs actual table (line, actual, budget): {{VARIANCE_TABLE}}
Reasons supplied by budget holders: {{REASONS}}
Commentary threshold (explain lines above this amount): {{THRESHOLD}}
Steps:
1. Recalculate every variance in amount and as a percentage of budget, showing the arithmetic. Label each favourable or unfavourable, explaining your sign convention.
2. Write commentary only for lines above the threshold: what moved, the reason I supplied, and whether it looks timing or permanent. If I gave no reason, write "reason needed" and the question to ask the budget holder.
3. Add a two-sentence summary for the operating result.
4. List any rows where the numbers don't add up or the reasons don't explain the size of the variance.
Rules: never invent a cause or number, keep each comment under 40 words, and tell me what to verify before it goes into the pack.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Variance Commentary From a Budget vs Actual Table” is a free prompt for ChatGPT in the Business category, 163 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 5 placeholders to fill in first:
{{PERIOD}}, {{CURRENCY_UNITS}}, {{VARIANCE_TABLE}}, {{REASONS}}, {{THRESHOLD}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 9 times.
Browse all Business prompts, the AI prompt database or use the AI prompt finder to search every prompt.