Task recipe · Beginner · 15 min

Budget vs actual variance commentary

বাজেট বনাম প্রকৃত: ভ্যারিয়েন্স মন্তব্য

Turn a budget-versus-actual table into clear management commentary that flags material variances and uses only the reasons you supply, never invented ones.

Works well with ChatGPTClaudeMicrosoft Copilot in Excel

The problem

Every month you report actual results against budget. Calculating the variances is easy; writing clear commentary for management takes time.

What you need

  • Budget and actual figures by line item
  • Your materiality rule, for example more than 10% or more than Tk 100,000
  • The real reasons for big variances, from the people who know

Steps

  1. Copy the budget-versus-actual table from your report.
  2. Ask the sales and operations teams for the reasons behind big variances.
  3. Paste the prompt with your data and reasons.
  4. Check the calculations and the Favourable/Adverse direction.
  5. Follow up every [reason needed] before the report goes out.

The prompt

Copy it, then replace the example figures and [brackets] with your own.

Prompt
You are a management accountant writing monthly commentary for the CFO.

Tasks:
1. For each line, calculate the variance amount and the variance as a % of budget, and mark it Favourable (F) or Adverse (A). For income, higher actual is favourable; for costs, lower actual is favourable.
2. Flag lines where the variance is more than 10% OR more than Tk 100,000.
3. Write commentary of no more than 150 words covering only the flagged lines, using ONLY the reasons I give. Where I have given no reason, write [reason needed] instead of guessing.

Data for March 2026 (Tk):
Line             | Budget    | Actual
Revenue          | 5,000,000 | 4,600,000
Cost of sales    | 3,000,000 | 2,900,000
Gross profit     | 2,000,000 | 1,700,000
Salaries         |   600,000 |   640,000
Marketing        |   200,000 |   310,000
Utilities        |    80,000 |    95,000
Operating profit | 1,120,000 |   655,000

Reasons from the team:
- Revenue: two export orders shipped on 2 April instead of March.
- Marketing: the Pohela Boishakh campaign was brought forward from April.

What the AI should give you

Sample AI reply
Line             | Budget    | Actual    | Variance | % of budget | F/A | Flag
Revenue          | 5,000,000 | 4,600,000 |  400,000 |  8.0%       | A   | Yes
Cost of sales    | 3,000,000 | 2,900,000 |  100,000 |  3.3%       | F   |
Gross profit     | 2,000,000 | 1,700,000 |  300,000 | 15.0%       | A   | Yes
Salaries         |   600,000 |   640,000 |   40,000 |  6.7%       | A   |
Marketing        |   200,000 |   310,000 |  110,000 | 55.0%       | A   | Yes
Utilities        |    80,000 |    95,000 |   15,000 | 18.8%       | A   | Yes
Operating profit | 1,120,000 |   655,000 |  465,000 | 41.5%       | A   | Yes

Commentary
Operating profit was Tk 465,000 (41.5%) below budget. Revenue fell short by Tk 400,000 because two export orders shipped on 2 April instead of March, which also explains most of the Tk 300,000 gross profit shortfall. Marketing was Tk 110,000 over budget because the Pohela Boishakh campaign was brought forward from April. Utilities were Tk 15,000 (18.8%) over budget: [reason needed].

How to check it

Common mistakes

Learn more

More recipes

All recipes

Sample figures are for learning only. Check every AI answer before you rely on it.