PROMPT BRO
Accounts desk

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

By hand2–3 hrs
With AI20 min
Per week · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Make a payment comparison list

Use invoice, customer, amount due, received, documented deduction and reason. Compare the same payment allocation basis.

First time? Try it on fake data first:

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.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
short-payments.xlsx

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.

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.

What you'll get back (example, from the practice files)
₹80,000due
₹72,500received
₹5,500unexplained
  • 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.
Before you trust it

Then send this: Recheck each gap and documented amount; reconcile totals; check each email against its customer.

If it goes wrong
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?