PROMPT BRO
Accounts desk

Payment advice emails with bill details

Payment done. Vendor asks which bills. The NEFT narration is not helping.

Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files

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

Get completed payment details

Use vendor, payment ref, bill ref, allocated gross, deduction and paid amount from approved records. No bank account details.

First time? Try it on fake data first:

Check payment status

Only confirmed payments get advice; hold discrepancies for accounts.

Privacy Use payment refs and amounts; remove bank account numbers and personal payment/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)
payment-advice.xlsx

Whenever I send payment allocation for [Payment date], prepare advice. Sign off: [Sign off]. A. Per bill check allocated gross minus supplied deduction equals paid. Flag mismatch or unconfirmed payment; sum totals for all and passing rows. B. Group passing rows by vendor and payment ref; draft one short (up to 6 lines) email with bill refs, paid amounts and supplied deductions. Do not say payment completed unless status confirmed. C. List held rows and questions for accounts. No invented tax rate or payment. 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 advice format and checks. Pick your tool at the top to see how.

After that, each time: send new confirmed payment allocations.

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)
3passing rows
2held
₹33,000passing paid
  • B2₹500 mismatch. ₹10,000 less ₹500 = ₹9,500, not ₹9,000.
  • B4Payment pending. Do not send advice yet.
  • V1/P1Two bills. One email for ₹20,000 across B1 and B3.
Before you trust it

Then send this: Recheck row arithmetic, totals and payment status; confirm emails contain only matching vendor and ref.

If it goes wrong
It says paid for pending

Reply: "Only confirmed passing rows get advice."

It invents TDS

Reply: "Use supplied deduction label and amount."

It mixes vendors

Reply: "Group by vendor and payment ref."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?