PROMPT BRO
Accounts desk

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

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

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.

First time? Try it on fake data first:
How to export from TallyPrime
  1. Press Alt+G (Go To), type Ledger, pick the customer, set the dates.
  2. Press Alt+E (Export), then Current.
  3. 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.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
Our ledger.xlsxCustomer's statement

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.

What you'll get back (example, from the practice files)
6transaction matches
3differences
₹20,200gap explained
  • ₹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.
Before you trust it

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.

If it goes wrong
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?