Two branch ledgers reconciled line by line
Branch A says posted. Branch B says not received. Head office says reconcile.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get both inter-branch ledgers
Use unique transfer/entry ref and signed amount. Put both in one common sign basis, e.g. amount owed by Branch B to A increases positive.
Confirm opening balances
Resolve opening difference first; sample starts with equal opening.
Privacy Use branch codes and business refs; remove bank and personal details. Delete bank account numbers; replace customer UPI IDs and phone numbers.
I'm attaching Branch A and Branch B ledger exports for [Period]. Opening ₹[Opening balance in both] in both. Common sign: [Common sign basis]. A. Match one-to-one by unique ref and signed amount; flag same ref different amount, duplicates and each side only. B. Sum each side's movement and closing; bridge A closing to B using signed differences. C. List documents to check and a short (up to 6 lines) internal email asking branch to confirm differences. No automatic balancing entry. 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 the actual records in your own Excel workbook; share only headings and rules.
Two branch sheets A:B ref and common signed amount. Opening ₹[Opening balance in both]; sign basis [Common sign basis]. Give formulas for duplicate references, exact reference lookup, side-only and amount difference, both closing balances and signed bridge. No plug entry. Tell me where to paste formulas or how to set up the local steps; use fictional examples only, no actual records.
Run locally, verify flagged rows against your source and have the responsible person approve any action.
- T2₹1,000 difference. A ₹5,000 vs B ₹4,000.
- T4A only. ₹2,000 increase in A; ask B.
- T6B only. ₹1,000 reduction in B; check missing entry in A.
Then send this: Re-add both movements and closing; show each signed bridge adjustment and verify they reach B exactly.
It reverses signs
Reply: "Use common sign basis already supplied."
It creates plug entry
Reply: "No balancing entry; list evidence."
It merges duplicates
Reply: "Flag unique-ref issue; don't double-match."
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.