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
Get vendor advance working
Use vendor code, advance ref, date, open balance, approved bill link and bill outstanding. Confirm same vendor and currency.
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.
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.
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 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.
Keep actual accounting records in your own Excel workbook; ask AI for formulas using column headings only.
Excel A:H advance ref, vendor, date, open balance, bill, bill vendor, outstanding, approved link. As on [As on date], age threshold [Flag advance older than], rule [Adjustment rule]. Write formulas for age, duplicate refs, matching vendor and approval checks, MIN adjustment, remaining advance and bill. Sum opening, proposed and remaining; flag old open advances. 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 bill.
- A3Old and unlinked. ₹10,000 from 1 Aug; no approved bill link.
- A4Vendor mismatch. ₹5,000 held; do not move between vendors.
Then send this: Recheck each link, min calculation and age; reconcile opening advances to proposals plus remaining.
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?
If your whole team does this, we'll set it up for all of them in one session.