Match open customer advances to invoices
Advance received six months ago. Invoice raised yesterday. Adjustment still pending.
Tested Claude Opus 5.5, medium effort · 15 Nov 2026 · on the practice files
Get open advances and bills
Use customer code, advance ref and available balance, invoice ref and outstanding amount. Confirm approved matching instructions.
Check approval and tax basis
Do not decide GST on advances. Ask accountant / consultant if treatment unclear.
Privacy Use customer codes and invoice/advance refs; remove payment identifiers. Delete bank account numbers; replace customer UPI IDs and phone numbers.
Whenever I send advance adjustment working for [Period], use this rule: [Adjustment rule]. A. For each row with approved invoice link, same customer and valid amounts, propose min(advance, outstanding); show remaining advance and invoice. Flag missing link or customer mismatch; no adjustment. B. Sum original advances, proposed adjustments and remaining advances; count held rows. Don't use an invoice or advance twice; flag duplicate refs. C. Draft adjustment list for accounts review and questions for accountant / consultant about tax treatment. 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 approved adjustment rules. 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 current open advances and named invoice links.
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 actual accounting records in your own Excel workbook; ask AI for formulas using column headings only.
Excel A:G advance ref, customer, available advance, invoice ref, invoice customer, outstanding, approved link. Give formulas for unique refs, same customer, approved link, numeric positive balances, adjustment MIN(advance,outstanding), remaining advance and invoice. Hold duplicate refs or missing link. Sum original, proposed and remaining; no automatic entry. Tell me exactly where to paste formulas and how to verify totals. Use made-up examples only; do not ask for actual company data.
Run locally, reconcile totals to your source records and have accounts approve any correction or payment before acting.
- A2₹3,000 remains. ₹8,000 advance, ₹5,000 invoice.
- A3No invoice link. ₹6,000 held.
- A4Customer mismatch. ₹4,000 held; never move between customers.
Then send this: Recheck references and customer codes, recompute lesser amounts, reconcile advances = proposed + remaining.
It allocates across customers
Reply: "Same customer only; hold mismatch."
It uses full advance
Reply: "Limit to outstanding amount."
It assumes GST
Reply: "Amounts only; ask accountant."
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.