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
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.
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.
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.
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: 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.
Keep your actual accounting records in Excel. Ask AI for the method using only column headings and approved rules.
Local PO A:E line ID, item, ordered qty, rate, unit; GRN A:F PO line, received, accepted, rejected, pending, unique GRN ref (plus item/unit if needed); Bill A:E PO line, current billed, rate, prior billed, unique bill ref (plus item/unit). Give formulas or Power Query for duplicate checks, accepted+rejected+pending = received, sum unique valid GRN accepted per PO line, compare cumulative prior+current billed with accepted and ordered, rate and unit match, pass/hold and known taxable totals. Hold missing inspection evidence and conflicting refs. Use fictional examples only; no payment or posting. Tell me where to paste.
Run the checks in your own workbook; reconcile to the source export and have accounts approve any correction before posting.
- 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.
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.
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?
If your whole team does this, we'll set it up for all of them in one session.