PROMPT BRO
Accounts desk

Match your vendor ledger with theirs

Vendor balance confirmation: two accountants, two totals, one long email thread.

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

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

Export both statements

Use the same period and opening payable. Convert both to a common sign: bill increases payable, payment or credit note decreases it.

First time? Try it on fake data first:

Keep unique references

Include invoice, payment or note reference and amount. Use the sample to practise.

Privacy Remove bank and personal contact details; keep business references. 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)
our-ledger.xlsxvendor-ledger.xlsx

I'm attaching our vendor ledger and the vendor's statement for [Vendor], [Period]. Both use bill positive, payment or credit note negative. Opening payable ₹[Opening payable in both books] in both. A. Match unique references and signed amounts one to one; list exact matches. B. List our-only, vendor-only and same reference different amount. Do not assume a reason; suggest source document to check. C. Show each closing payable and bridge from our closing to theirs. Write a short (up to 6 lines) email asking vendor to confirm differences. 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.

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)
4matched
2unmatched
₹7,000closing gap
  • P02Our payment only. ₹5,000 reduces our payable; ask vendor to confirm receipt.
  • B05Vendor bill only. ₹2,000 increases their payable; ask for bill copy.
  • ₹7,000Closing bridge. Our ₹22,000 plus ₹5,000 plus ₹2,000 = vendor ₹29,000.
Before you trust it

Then send this: Sum each ledger from opening; show every signed difference and bridge exactly. Recheck references not double-matched.

If it goes wrong
Opening differs

Resolve opening first; don't force match.

Signs reversed

Reply: "Use payable increases positive, decreases negative."

Duplicate ref

Reply: "Flag duplicates; do not pair by amount alone."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?