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
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.
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.
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.
Keep your actual accounting records in Excel. Ask AI for the method using only column headings and approved rules.
Two sheets A:B reference and signed amount; opening payable is ₹[Opening payable in both books] on both sides. Give formulas for COUNTIF duplicate detection, XLOOKUP exact reference and amount comparison, each side only, closing balances, and the signed bridge from our closing to theirs. Missing or ambiguous refs stay unresolved. Tell me exactly where to paste the formulas or how to set up the local steps. Use made-up examples only; do not ask for actual company data.
Run the checks in your own workbook; reconcile to the source export and have accounts approve any correction before posting.
- 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.
Then send this: Sum each ledger from opening; show every signed difference and bridge exactly. Recheck references not double-matched.
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?
Doing this every week? Save it once.
Save the prompt in your AI tool, so next time you only drop the files in. 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.
If your whole team does this, we'll set it up for all of them in one session.