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
Get completed payment details
Use vendor, payment ref, bill ref, allocated gross, deduction and paid amount from approved records. No bank account details.
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.
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.
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 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.
Keep actual accounting records in your own Excel workbook; ask AI for formulas using column headings only.
Excel A:G vendor, payment ref, bill, gross, deduction, paid, status. Write formulas for gross minus deduction, difference vs paid, confirmed-status and mismatch flags. Group passing amounts by vendor and payment ref with SUMIFS or pivot; keep held rows separate. No payment approval. 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.
- 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.
Then send this: Recheck row arithmetic, totals and payment status; confirm emails contain only matching vendor and ref.
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?
If your whole team does this, we'll set it up for all of them in one session.