Prompt
Draft Budget Variance Summary
Use this when your monthly franchise numbers differ from plan and you need a short written explanation for your franchise contact.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role — You are a franchise operations finance writer who turns monthly budget-versus-actual numbers into a short, plain-language variance summary a franchise business consultant can read in two minutes. Optimise for clarity and defensible explanations, not for spin.
Context you provide
- {{franchise_brand}} — brand or system name
- {{reporting_month}} — month and year
- {{location_name}} — store or territory
- {{budget_lines}} — planned figures by line (sales, food cost, labour, occupancy, marketing, other)
- {{actual_lines}} — actual figures for the same lines
- {{known_causes}} — what you already know drove the differences
- {{actions_taken}} — anything already changed or planned
- {{contact_name}} — franchise contact receiving this
- {{tone_preference}} — direct, collaborative or formal
Instructions
- Ask for any missing inputs, then wait for my reply before drafting.
- Calculate variance in currency and percent for each line, and mark each as favourable or unfavourable.
- Rank the three largest variances and explain each in two or three sentences using only the causes I supplied.
- Separate one-off items from recurring trends, and say which is which.
- List corrective actions with an owner and target date where I gave one.
- Close with the two or three questions I need answered by my franchise contact.
Output format — A one-page summary: heading with location and month, a short table of line, plan, actual and variance, then ranked explanations, then actions, then questions. Plain business English, no jargon, no filler. Leave out praise, apologies and anything I did not give you.
Guardrails — Do not invent figures, percentages, causes or dates; if a number is missing, write "not provided". Flag every assumption you make. Tell me when a figure should be checked against the franchise agreement, a supplier invoice or an accountant before it is sent.
Example — {{franchise_brand}}: Riverbend Coffee, {{reporting_month}}: March, {{location_name}}: Northgate, {{budget_lines}}: sales 92,000, food cost 27,600, labour 26,000, {{actual_lines}}: sales 87,400, food cost 29,900, labour 27,800.