PROMPT BRO
Accounts desk

Match PO, receipt and vendor bill

PO says 10. GRN says 8. Bill says 10. Everyone says their sheet is correct.

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

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

Get the three files

Export approved PO lines, unique GRN lines with inspection-approved accepted/rejected/pending qty and bill lines with current and prior billed qty, all with linked PO line, item code and unit. Practice has three sheets.

First time? Try it on fake data first:

Check the references

Use unique PO line IDs; don't match by item name alone.

Privacy Use business references and values; remove personal data and unnecessary banking details. 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)
po.xlsxgrn.xlsxbill.xlsx

Whenever I send PO, GRN and bill exports for [Vendor], match by PO line ID. Basis: [Comparison basis]. A. Validate unique PO line IDs, GRN line refs and bill line refs, matching SKU/unit and complete numeric quantities/rates. Group unique receipts by PO line; show ordered, physically received, inspection-approved accepted, rejected/pending, previously billed and current billed quantities, PO rate, bill rate and taxable value. Received does not imply accepted. Hold missing inspection approval, invalid quantities, duplicate/conflicting refs or item/unit mismatch; do not double-count. B. Flag prior billed + current billed above inspection-approved accepted quantity or ordered qty, rate mismatch, missing bill/receipt/approval or negative values. A partial accepted receipt can pass only if current plus prior billing stays within accepted and ordered quantities. If billed quantity exceeds accepted quantity, hold the whole bill line (do not pass the accepted part) until a revised bill or approved debit note is supplied. Hold rejected/pending goods unless accounts supplies separate approved payable evidence; do not assume they are payable. C. Totals: known bill taxable value, value passing checks and held value, with complete/partial labels. Give copyable handoff: PO/GRN/bill line refs, accepted qty, prior billed qty, current billed qty, rate, passing/held and reason. List evidence needed for accounts; no payment approval. 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 line match rules once. Pick your tool at the top to see how.

After that, each time: attach the next three exports with unique references.

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)
5bill lines
3pass checks
₹1,700held value
  • P2Qty over receipt. 10 billed vs 8 received at ₹100.
  • P3Rate mismatch. ₹70 billed vs ₹60 PO, 10 units.
  • P4Partial receipt. 5 of 10 ordered received and billed; passes quantity check.
Before you trust it

Then send this: Recompute cumulative billed vs accepted and ordered, reconcile physical received to accepted/rejected/pending, unique refs, rate and taxable totals; held values remain separate. No payment approval.

If it goes wrong
It matches by name

Reply: "Match unique PO line ID only."

Partial receipt marked wrong

Reply: "Compare billed to received and ordered, not just ordered."

It assumes tax

Reply: "Tax not supplied; taxable values only."

Sir ne bola urgent. Ab bolo: ho gaya.

Did it work?