PROMPT BRO
Accounts desk

Vendor advances matched to open bills

Advance paid. Goods received. The advance ledger is still waiting for its closure.

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

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

Get vendor advance working

Use vendor code, advance ref, date, open balance, approved bill link and bill outstanding. Confirm same vendor and currency.

First time? Try it on fake data first:

Confirm ageing rule

Get your manager's review threshold and approved adjustment instructions.

Privacy Use vendor codes and transaction refs; remove bank details and personal contacts. 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)
vendor-advances.xlsx

Whenever I send vendor advance working as on [As on date], apply [Adjustment rule]. Flag age greater than [Flag advance older than] days. A. Per row calculate proposed adjustment, remaining advance, remaining bill and age. Hold missing/unapproved links or vendor mismatch; flag duplicates. B. Sum original advances, proposals and remaining; list old advances still open after proposal. C. Draft adjustment working and questions for purchase/accounts. No payment or GST decision. 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 and ageing rules. Pick your tool at the top to see how.

After that, each time: send current advance and approved bill 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)
₹40,000open advances
₹18,000proposed
₹22,000remaining
  • A2₹3,000 remains. ₹8,000 advance, ₹5,000 bill.
  • A3Old and unlinked. ₹10,000 from 1 Aug; no approved bill link.
  • A4Vendor mismatch. ₹5,000 held; do not move between vendors.
Before you trust it

Then send this: Recheck each link, min calculation and age; reconcile opening advances to proposals plus remaining.

If it goes wrong
It adjusts other vendor

Reply: "Same vendor only."

It skips old advances

Reply: "Show age and remaining amounts."

It assumes tax

Reply: "Ask accountant; no tax decision."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?