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.
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
- Copy the budget-versus-actual table from your report.
- Ask the sales and operations teams for the reasons behind big variances.
- Paste the prompt with your data and reasons.
- Check the calculations and the Favourable/Adverse direction.
- Follow up every [reason needed] before the report goes out.
The prompt
Copy it, then replace the example figures and [brackets] with your own.
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
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
- Recalculate two or three variances yourself, including operating profit.
- Check the F/A direction: higher revenue is favourable, higher cost is adverse.
- Every reason in the commentary must come from your list. Follow up each [reason needed]; do not delete it.
- Watch boundary cases: cost of sales at exactly Tk 100,000 is not “more than” Tk 100,000, so it is correctly not flagged.
Common mistakes
- Letting AI explain variances it knows nothing about, such as “due to inflation” or “seasonal demand”.
- Reporting percentages without amounts, or the reverse. Management needs both.
Learn more
More recipes
Bank reconciliation with AI
এআই দিয়ে ব্যাংক রিকনসিলিয়েশন
Match a cash book against a bank statement, list unmatched items with likely reasons, and draft a bank reconciliation statement you can check line by line.
ChatGPTClaude
IFRS 16 lease liability schedule
আইএফআরএস ১৬ লিজ দায়ের সূচি
Calculate the initial lease liability and right-of-use asset, build the amortisation table and journal entries, then prove the numbers with Excel’s PV function.
ClaudeChatGPTCopilot in Excel
Salary income tax computation (Bangladesh)
বেতনভোগীর আয়কর হিসাব
Lay out a salaried person’s Bangladesh income tax computation step by step, using the rates and limits you paste from the current Finance Act, never the AI’s memory.
ChatGPTClaudeGoogle Gemini
Sample figures are for learning only. Check every AI answer before you rely on it.