AI prompt to explain budget vs actual variances
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
- Open ChatGPT or Gemini and start a new chat.
- Tap Copy prompt, paste it, and replace every part in [square brackets] with your details. Placeholders are fine for names and personal data.
- Send it, then improve the draft in the same chat: "shorter", "more formal", "in Hindi".
- 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
- ChatGPT prompt for a polite payment reminderA copy-paste ChatGPT prompt for payment reminders that get paid: a polite email and a short WhatsApp message, with firmer versions for 30 and 60 days overdue.
- AI prompt to categorise expenses from a bank statementPaste exported bank or card transactions and get every line sorted into expense categories with a monthly total, using ChatGPT or Gemini. Remove account details first.
- AI prompt to write a monthly MIS summaryPaste your monthly numbers and get a one-page MIS summary for management: what changed, why, and what needs a decision, with ChatGPT or Gemini.
- AI prompt to get the right Excel formulaDescribe what you need in plain words and get the right Excel or Google Sheets formula, explained part by part, with a test row to check it. Works in ChatGPT and Gemini.