wowprompt

Budget versus actual variance analysis with explanations

Compares budgeted and actual figures line by line, highlights the variances that matter and drafts plain explanations for management. Use it at month end, quarter end or in a year-end review of spending and revenue.

A variance table with budget, actual, amount and percent difference, favourable or unfavourable flags, explanations and a short management summary
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Organisation and period: [e.g. retail store, July to September 2026]
  • Data: [paste rows with line item, budget and actual]
  • Materiality threshold: [e.g. flag variances over 10 percent and over 50,000 rupees]
  • Known reasons: [e.g. festive hiring, price increase from supplier, delayed project]
  • Audience: [owner, finance head, board]

Task

Calculate variances, decide which ones matter, and explain them in language a non-finance reader understands.

Method

  • Variance = Actual minus Budget. Percent variance = Variance divided by Budget.
  • For revenue lines, above budget is favourable. For cost lines, below budget is favourable.
  • Flag a line only if it passes both parts of the threshold.

Output format

| Line item | Budget | Actual | Variance | Variance % | Favourable or unfavourable | Flag |

Then for each flagged line:

  • What happened, in one sentence.
  • Likely cause, using the known reasons; mark guesses as [to confirm].
  • Action or forecast change.

Finish with a management summary of under 120 words: net position, the two biggest drivers and one decision needed.

Rules

  • Recalculate totals and check they match the sum of lines.
  • Keep currency and units as given.
  • Never hide an unfavourable variance inside a total.
  • Do not invent reasons; ask a question where none is known.

Example

| Staff costs | 4,00,000 | 4,60,000 | 60,000 | 15% | Unfavourable | Yes |

budget vs actualvariance analysisbudget variance reportmonthly financial reviewexpense analysismanagement report

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity