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 |






