Match your ledger with your customer's
Your books say ₹74,400. Their books say ₹54,200. Both accountants are 'very sure'.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get both ledgers
Your ledger for this customer from Tally, and their statement of your account (ask them for it, Excel if possible). Same dates on both.
How to export from TallyPrime
- Press Alt+G (Go To), type Ledger, pick the customer, set the dates.
- Press Alt+E (Export), then Current.
- Set the format to Excel and export.
Menus can differ in Tally ERP 9 and Busy.
Check the opening balances
If the two opening balances don't agree, sort out the earlier period first. Otherwise everything after looks wrong.
Privacy Use customer code and masked ledger extracts. Remove bank account details, personal contacts, UPI IDs and other identifiers.
I'm attaching two customer ledgers for [Customer], period [Period]. Our books: debit increases receivable, credit decreases. Customer's books: credit increases amount owed to us, debit decreases. Align opening balances as at the same date; opening rows are balances, not transactions. Validate complete signed amounts and unique references or row IDs. A. Match transactions one-to-one. Exact invoice/cheque/UTR evidence requires same amount and mirrored direction. Otherwise propose equal signed amounts within [Dates can differ by] days using supplied evidence; hold ties or conflicting references. Never force a match or reuse a line. B. List our-only, their-only and ambiguous transactions, source refs, signed value and questions. Possible explanations labelled unverified. No inferred TDS, credit-note approval or posting. C. Show each opening and closing balance on same receivable basis; signed bridge from our closing to theirs using unmatched items and opening difference. Any unexplained residual stays explicit. Draft short (up to 6 lines) accounts email requesting confirmation of differences, not accepting a balance or authorising entries. Use only supplied records, customer codes and non-sensitive data. A person confirms and posts any correction. 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? This task is about numbers, so use your tool's strongest model with thinking (or extended reasoning) turned on.
In your AI tool: attach the files with the + button, paste, send.
Office doesn't allow uploading files? Ask AI for a formula instead. It never sees your data.
My Excel file has two sheets. Sheet "Ours": A = Date, B = Particulars, C = Debit, D = Credit. Sheet "Theirs": A = Date, B = Particulars, C = Debit, D = Credit. Their sheet is the mirror of ours: our Debit should appear as their Credit, and our Credit as their Debit. Write one formula for column E of the Ours sheet that shows "Matched" if the Theirs sheet has the mirror amount within [Dates can differ by] days, otherwise "Check". Then the same for column E of the Theirs sheet. Tell me where to paste them. Separate opening rows from transaction matches, align dates, require mirrored signed amounts, hold ties and duplicate proposals, reconcile signed bridge with residual.
Paste both formulas, fill them down, filter each sheet by "Check". Those lines are your differences. Two lines with the same amount can both show "Matched", so check those by hand.
- ₹25,000Their NEFT of 30 Sep. Not in your books for this period. Check if it reached your bank in October.
- ₹5,900Your credit note CN-15. They haven't booked it. Send them a copy with the email.
- ₹1,100Their TDS entry. Not in our books; ask accounts to verify actual deduction evidence before any entry.
Then send this: Recalculate openings, signed closings and bridge; count matched transaction pairs, not opening rows. Verify direction, amount and unique reference evidence; no forced match or assumed deduction.
It mixed up debit and credit
Their ledger is the mirror of yours. Add to the message: "In their file, Credit means our invoice and Debit means their payment."
Their statement is a PDF
Most AI tools read PDFs. If it's a scan and the numbers come out wrong, ask the customer for Excel, or send clear photos page by page.
Too many lines don't match
Check both files cover exactly the same dates, and that the opening balances agree. If they don't, sort out the opening balance first.
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.