Budget variance explanation prompt: free ChatGPT template
Updated · By Robert Breen
Use this when you have a budget-versus-actual report and need to explain it to an owner, a partner or yourself. AI is good at turning a grid of numbers into sentences. The risk is that it fills gaps with plausible reasons ("likely due to seasonal demand") that nobody checked. This prompt only lets it use the reasons you provide, turns every unexplained move into a question, and keeps advice out.
Have a professional review it. This prompt helps you explain your own numbers, not give financial advice. Have your accountant or financial advisor review anything you will act on.
The prompt
Copy it into ChatGPT (or Claude, Gemini or Copilot) and replace every [BLANK] with your own details. It uses the four parts from Prompt Writing 101: Role, Context, Task and Format.
Role: You are a plain-spoken finance assistant helping the owner of [BUSINESS] read a budget-versus-actual report. You explain; you don't advise. Context: Period: [PERIOD]. What I already know about why some lines moved: [KNOWN REASONS]. Only explain a variance with a reason from that list. If a line moved and I gave no reason, write "Reason not given" and add it to the questions. Do not suggest cuts, investments or budget changes. Task: For each line, calculate the difference (actual minus budget) and the percent of budget. Then explain each line that moved by more than [THRESHOLD] in one or two sentences. Format: First a table: Line, Budget, Actual, Difference, Percent. Then "Biggest moves," a short paragraph per line over the threshold. Then "Questions to answer," a short list. Under 250 words outside the table. Budget vs. actual report: [REPORT]
Fill in the blanks
[BUSINESS]- Your business name and what it does.
[PERIOD]- The month, quarter or year the report covers.
[KNOWN REASONS]- What you know caused specific moves, one line each. Leave a line out if you don't know; the AI will ask.
[THRESHOLD]- What counts as a big move for you, such as "10% or $500, whichever is larger."
[REPORT]- Each line with its budget and actual, copied from your spreadsheet or accounting report.
Example, filled in
A made-up example from the free lesson Build a Custom GPT Ad Copy Writer for Search and Social Ads. Harbor & Pine Coffee Roasters is the made-up online coffee brand in the ad copy lesson. Its owner wants a plain read of Q3 before planning the holiday season.
Role: You are a plain-spoken finance assistant helping the owner of Harbor & Pine Coffee Roasters, a small online coffee brand, read a budget-versus-actual report. You explain; you don't advise. Context: Period: Q3 (July to September). What I already know about why some lines moved: green coffee, our importer raised the price per pound in July. Social ads, we ran extra test ads for the holiday blend in September. Only explain a variance with a reason from that list. If a line moved and I gave no reason, write "Reason not given" and add it to the questions. Do not suggest cuts, investments or budget changes. Task: For each line, calculate the difference (actual minus budget) and the percent of budget. Then explain each line that moved by more than 10% or $500, whichever is larger, in one or two sentences. Format: First a table: Line, Budget, Actual, Difference, Percent. Then "Biggest moves," a short paragraph per line over the threshold. Then "Questions to answer," a short list. Under 250 words outside the table. Budget vs. actual report: Green coffee: budget $18,000, actual $21,400 Packaging: budget $4,500, actual $4,350 Search ads: budget $3,000, actual $3,000 Social ads: budget $2,500, actual $4,100 Shipping: budget $6,000, actual $7,250 Software: budget $900, actual $880
What a good answer looks like
- Correct math: green coffee +$3,400 (18.9%), social ads +$1,600 (64.0%), shipping +$1,250 (20.8%).
- Explanations for green coffee and social ads that repeat your reasons, nothing more.
- Shipping marked "Reason not given" and listed as a question.
- No line like "consider renegotiating with your importer."
How to check it before you use it
An AI draft can sound right and still say something you never told it. Use the habit from the Reply Faster lesson: check every promise, name, date and number against what you gave it before anything goes out.
- Recompute two or three lines yourself. Language models can slip on arithmetic, especially percentages.
- Read each explanation and point to the reason you gave for it. Delete any reason you didn't supply.
- Make sure small moves under the threshold weren't dramatized.
- Answer the open questions before you share it, or share them as open questions.
Why this prompt works
The Context separates what you know from what you don't, which is how you stop a hallucination that sounds like analysis. Asking for the table first puts the math where you can check it. The "Reason not given" rule borrows the "Not stated" habit from the client meeting lesson.
Practice it in the free lesson
Prompt Writing 101: Role, Context, Task, Format: Ask ChatGPT for the same customer email twice, once vaguely and once with a four-part prompt, and see exactly why structure gets a better answer. You do every step yourself in a practice copy of ChatGPT, and nothing touches your real accounts.
Also useful: Turn a Client Meeting into Action Items and a Follow-Up Email (Accounting Firms)
Terms used here
Related prompts
- Cash flow summary for owners prompt: Get a plain-English summary of your own cash numbers: where money came from, where it went, and what known bills do to the…
- Month-end close checklist prompt: Turn your rough month-end close notes into an ordered, day-by-day checklist with an owner and a "done when" for every step. No…
- Client quarterly review recap prompt: Turn your notes or transcript from a client's quarterly review into a recap email: decisions, who does what by when, what you…