PROMPT BRO
Accounts desk

Find duplicate and incomplete ledger masters

'Sharma Traders', 'Sharma Trader', 'Sharma Trdrs' – three ledgers, one man

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

By handRarely done
With AI1 hr
Each time · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Export a safe master list

Use ledger code, business name, group, masked registration token and local verification status. Same real registration gets same token. Never include PAN or bank details.

First time? Try it on fake data first:

Confirm groups and review rules

Use approved group names and local tax verification results; AI must not validate real registrations or merge masters.

Privacy Upload only a masked master list with codes and token IDs. Keep actual GSTIN, PAN, addresses and bank details in Tally/Busy; verify there. Never upload bank account numbers, customer UPI IDs or phone numbers.

Fill the orange boxes
You send (the "prompt": the message you paste into your AI tool)
masked-masters.xlsx

I'm attaching masked ledger masters. Approved groups: [Approved groups]. Rule: [Review rule]. A. List possible duplicate groups by exact same token or similar business name; show code and group; never merge. Flag missing token, pending verification and group outside approved list. B. Count rows and distinct flagged records, list reason(s) for each. Separate duplicate candidates from actual confirmed duplicates. C. Checklist for accountant to verify original master records and approve any correction. No GSTIN/PAN validation or deletion in AI. 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. Never repeat names, phone numbers, account or bank numbers, tax or registration numbers, or addresses found in the data, even when flagging them: refer to the row or code and say 'personal/identifier value present, remove before sharing'.

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)
5masters
4flagged codes
1duplicate group
  • L1 / L2Same token. Sharma Traders and Sharma Trader; possible duplicate.
  • L3Token missing. Registration status pending; verify locally.
  • L4Group unknown. Group 'Other' outside approved list.
Before you trust it

Then send this: Recount distinct flagged codes, compare tokens and names, and confirm all group and verification flags. Do not claim duplicates confirmed.

If it goes wrong
It merges automatically

Reply: "List candidates only."

It asks for PAN or GSTIN

Reply: "Use masked token and verification status."

It guesses group

Reply: "Flag unknown; accountant confirms."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?