Dustread

AI prompt to explain budget vs actual variances

Works in ChatGPT, Gemini · Free plan is enough · Updated 18 November 2026

The prompt

You are a management accountant.
Here is budget vs actual for [period] (₹):
[paste: line item | budget | actual]

1. Calculate the variance in ₹ and % for each line, and mark it Favourable or Adverse (for costs, spending more than budget is Adverse).
2. Flag every line where the variance is more than [10]% and more than ₹[amount].
3. For each flagged line, draft a one-line explanation using only these notes: [your notes on what happened]. If my notes do not explain it, write "Ask [department]".
4. Show your variance calculations so I can check them.
Return a table: Line | Budget | Actual | Variance ₹ | Variance % | F/A | Flag | Explanation.

Replace the parts in [square brackets] before you send it.

How to use it

  1. Open ChatGPT or Gemini and start a new chat.
  2. Tap Copy prompt, paste it, and replace every part in [square brackets] with your details. Placeholders are fine for names and personal data.
  3. Send it, then improve the draft in the same chat: "shorter", "more formal", "in Hindi".
  4. Read the final version yourself before you use it. Check every number, date and name.
  • Paste numbers without thousand separators if the AI misreads them.

Do not paste Aadhaar, PAN, bank details, salaries or anyone's personal data into a public AI tool. Use placeholders and add the real details in your own document.

Example result

A table of every budget line with the variance in rupees and per cent, marked favourable or adverse, and the material ones flagged. Each flagged line has a one-line explanation drawn only from your notes, or "Ask Sales" where your notes do not cover it. The calculations are shown below the table so you can check them against your own sheet.

Described in words: what you get depends on your photo or details, and on the tool.

Variations

Send one of these as your next message in the same chat, or use it to replace the matching line in the prompt.

Excel formulas

Give me the Excel formulas for the Variance ₹, Variance % and F/A columns, assuming Budget is column B and Actual is column C.

Forecast

Using the actuals so far, suggest a revised full-year forecast for the flagged lines and state the assumption behind each.

More finance and accounts prompts

All finance and accounts prompts · The whole prompt library