Budget variances and questions to ask
Budget says ₹50,000. Actual says ₹75,000. The reason column says 'various'.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get comparable cost totals
Export department or expense head, approved budget, actual spend and any verified note. Use the same period and cost basis.
Confirm sign convention
For costs, actual minus budget positive means over budget. No reason is guessed.
Privacy Use category-level cost data and approved notes; remove personal details. Delete bank account numbers; replace customer UPI IDs and phone numbers.
I'm attaching budget and actual costs for [Period]. Flag absolute differences above ₹[Review variance above]. A. Table: head, budget, actual, variance (actual minus budget), percentage if budget nonzero; if zero, show not applicable. Sum totals. B. Flag differences above threshold, zero-budget spend and missing values. Use only supplied notes as known explanations; otherwise ask what changed. C. Short manager summary of facts and suggested questions, not a spending decision. Use only my data. GST rates, HSN and TDS rates only from my supplied figures; never guess tax treatment. This is a first pass; a person checks and posts any final entries in Tally/Busy.
Which model? Use your tool's strongest model with thinking turned on.
In your AI tool: attach the files with the + button, paste, send.
Keep the actual budget in Excel.
Columns A:D = head, budget, actual, note. Write formulas for E variance C−B, F percent if B nonzero, G flag if absolute variance above ₹[Review variance above] or zero-budget spend. Show totals. Tell me where to paste.
Fill down and verify totals, then add only confirmed explanations.
- Freight₹25,000 over. Budget ₹50,000; actual ₹75,000; ask why.
- Repair₹15,000 spend. Zero budget; percentage not applicable.
- Travel₹10,000 under. Exactly threshold; not above it.
Then send this: Re-add budget and actual, reconcile variance to totals, recheck zero-budget and threshold flags.
It calls all differences bad
Reply: "Show sign and facts; no judgement."
It divides by zero
Reply: "Percentage not applicable."
It guesses reasons
Reply: "Use notes only or ask a question."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. Pick your tool at the top to see how.
What is that?
A Project is a folder in ChatGPT that keeps your instructions and files for every chat inside it. It's on the free plan too. Checked 14 Nov 2026.
What is that?
A Project in Claude is a workspace with its own instructions and files that every chat inside it uses. Checked 14 Nov 2026.
What is that?
A Gem is a custom Gemini that loads your instructions before every chat. Free on every plan; you create it on a computer. Checked 14 Nov 2026.
What is that?
Signed in with a work account, Microsoft's Copilot Chat applies enterprise data protection: your prompts aren't used to train its models. Checked 14 Nov 2026.
If your whole team does this, we'll set it up for all of them in one session.