Find likely matches for unknown receipts
Bank narration: 'TRANSFER'. Thank you for the detailed explanation.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get receipt and invoice lists
Use receipt ref, amount, narration hint and open invoice ref, customer code, due amount. Replace bank and UPI identifiers first.
Check the amount basis
Use actual credited and outstanding amounts; no assumed TDS or fees.
Privacy Keep receipt reference and amount; remove account numbers, customer UPI IDs and phone numbers. Delete bank account numbers; replace customer UPI IDs and phone numbers.
Whenever I send masked receipts and open invoices for [Period], find possible matches. Rule: [Match rule]. A. For each receipt list exact amount candidates; if hint names a matching invoice, show it. If multiple candidates without hint, mark ambiguous; if none, no match. Treat likely matches as proposals only. If two receipts have the same invoice as their explicit matching hint, hold both as a conflict; do not let row order decide. If an unhinted receipt has several exact candidates in the original invoice list, keep it ambiguous even if another receipt has a likely hint. Never propose one invoice for two receipts. Hold invalid, missing or non-positive amounts, duplicate receipt or invoice references and hints that conflict with the amount; ask for verified allocation details. B. Table of likely, ambiguous and no match with receipt and invoice refs, amount and reason. C. Total received and amounts by status; draft questions for accounts/customer to verify. No automatic allocation or TDS guess. 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.
Set it up once. Save the matching rules; keep actual data out until needed. 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.
After that, each time: send new masked receipts and current open invoices.
First time? Try it in a normal chat: paste and send.
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.
Receipts A:C receipt ref, amount, masked hint; invoices A:C invoice ref, customer code, outstanding. Give a COUNTIF and FILTER method to list every exact-amount candidate and compare invoice hint. Mark ties ambiguous even when another receipt has a hint; mark duplicate allocations for review. Sum receipt amounts by status. Do not assign or clear automatically. 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.
- R2₹5,000 ambiguous. I2 and I3 have the same amount; no hint.
- R4₹3,000 no match. No invoice has this outstanding amount.
- R5I3 hinted. ₹5,000 matches I3; keep R2 unresolved until verified.
Then send this: Recheck every amount and hint, count original candidates, identify competing proposals and duplicate refs, and reconcile status amounts to total known receipts. List invalid/missing amounts separately.
It picks one equal amount
Reply: "List all candidates; don't choose without evidence."
It guesses TDS
Reply: "Exact amounts only; no deductions assumed."
Narration has personal data
Replace it with the useful invoice hint only.
Sir ne bola urgent. Ab bolo: ho gaya.
Did it work?
If your whole team does this, we'll set it up for all of them in one session.