PROMPT BRO
Accounts desk

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

By hand1–2 hrs
With AI15 min
Per week · estimate
Easier on your office computer.Send to my computer
I usePick yours. We'll show the right steps.

Get open advances and bills

Use customer code, advance ref and available balance, invoice ref and outstanding amount. Confirm approved matching instructions.

First time? Try it on fake data first:

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.

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

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.

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.

What you'll get back (example, from the practice files)
₹35,000advances
₹18,000proposed
₹17,000remaining
  • 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.
Before you trust it

Then send this: Recheck references and customer codes, recompute lesser amounts, reconcile advances = proposed + remaining.

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