Explain short payments and draft queries
They cut ₹8,400. No email. No reason. Good luck.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Make a payment comparison list
Use invoice, customer, amount due, received, documented deduction and reason. Compare the same payment allocation basis.
Check the source
Use actual remittance and approved deductions. Leave unknown reason blank.
Privacy Use customer code/name and invoice refs; remove payment and contact identifiers. Delete bank account numbers; replace customer UPI IDs and phone numbers.
Whenever I send payment comparison for [Period], prepare deduction queries. Sign off: [Sign off]. A. Per invoice show due, received, gap (due minus received), documented deduction and unexplained gap. Flag overpayment separately; no assumed tax or reason. B. Sum due and receipts; reconcile net gap to documented and unexplained amounts; list invoices needing review. C. Draft short (up to 6 lines) email per customer with unexplained gap asking for remittance/deduction details. No threats or write-off. 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. Line limits count body lines only, not subject, greeting or sign-off. Keep every required fact; if they do not fit, say so instead of dropping one.
Set it up once. Save the gap checks and email format. 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.
After that, each time: send new payment advice and open invoice amounts.
First time? Try it in a normal chat: paste and send.
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 actual accounting records in your own Excel workbook; ask AI for formulas using column headings only.
Excel A:F customer, invoice, due, received, documented deduction, reason. Write formulas for gap = due minus received, unexplained = gap minus supplied deduction, overpayment and invalid/missing flags; sum amounts by customer with SUMIFS or pivot. Keep disputed or unexplained items for human verification. Tell me exactly where to paste formulas and how to verify totals. Use made-up examples only; do not ask for actual company data.
Run locally, reconcile totals to your source records and have accounts approve any correction or payment before acting.
- I2₹3,000 unexplained. ₹20,000 due, ₹17,000 received; ask for reason.
- I3₹2,000 documented. Approved debit note reference DN3; verify locally.
- I4₹2,500 unexplained. Partial payment with no reason supplied.
Then send this: Recheck each gap and documented amount; reconcile totals; check each email against its customer.
It calls gap TDS
Reply: "No rate or reason assumed."
It writes off difference
Reply: "Show unexplained and ask customer."
It combines wrong customers
Reply: "Group only matching customer refs."
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
If your whole team does this, we'll set it up for all of them in one session.