Complete AI Training

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

  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 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

  1. Ask for any missing inputs, then wait for my reply before drafting.
  2. Calculate variance in currency and percent for each line, and mark each as favourable or unfavourable.
  3. Rank the three largest variances and explain each in two or three sentences using only the causes I supplied.
  4. Separate one-off items from recurring trends, and say which is which.
  5. List corrective actions with an owner and target date where I gave one.
  6. 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.