How to build procure-to-pay with three-way matching
Paying a supplier bill should be a decision, not a reflex. This guide shows how to connect the purchase order, the goods receipt and the vendor bill so that you pay only for what you ordered and actually received, in the quantity and at the price agreed.
Why this matters
Money leaks in buying through small gaps: a rate that quietly changed, a truck that delivered 480 pieces against a bill for 500, a rejected lot that was still paid for. Together such gaps can run to lakhs a year. Three-way matching closes them by asking one question before any payment: do the order, the receipt and the bill agree?
Picture a pump-manufacturing unit in Coimbatore buying castings from a foundry. The purchase order says 500 castings at ₹420 each. The store counts 480 accepted and 20 rejected for porosity. The bill arrives for 500. Without a match, the accounts clerk pays ₹2.1 lakh. With one, the payment is ₹2.016 lakh and the 20 rejected pieces become a conversation with the foundry.
Before you start
- A requisition format that says what is needed, how much, by when and for which job or stock.
- A purchase order with number, supplier, item, quantity, rate, delivery date and terms.
- A goods receipt note (GRN) kept by the store for every delivery, with accepted and rejected quantities shown separately.
- A list of approved suppliers and a rule on when quotes are needed.
- A tolerance you will accept, such as a small percentage on quantity or price, and who may approve beyond it.
Step by step
- The buyer raises a requisition from real demand: a job that needs material, or stock that has fallen below the level you set. The requisition states the quantity, the date needed and the person who asked. Check stock first, so you do not buy what is already on the shelf.
- The buyer collects quotes for the item and compares price, delivery time and terms. The stores supervisor reviews the comparison and approves the purchase order, which then goes to the supplier. The supplier acknowledges it, and a purchase order with no acknowledgement is chased within a day.
- When goods arrive, the accounts payable clerk and the store count them against the purchase order and the delivery challan. The count is done at the gate or the store, not later from memory. Short or excess quantity is written on the receipt.
- The buyer inspects the goods and the store records the GRN with accepted and rejected quantities. A rejection is raised with the supplier straight away with the reason and a photo, so a credit note or replacement can be agreed.
- When the vendor bill comes, the stores supervisor matches three things: purchase order quantity and rate, GRN accepted quantity, and bill quantity and rate. If all three agree within tolerance, the bill goes for payment. If not, it is held and the difference is written next to it.
- Accounts pays only matched bills, on the agreed due date. The payment is recorded against the bill, and the bill number is written on the purchase order so the file is complete. The supplier's tax details on the bill are checked for accuracy before the bill is booked, and how any tax credit on it is claimed is for your accountant to decide.
Check the current rule on the official portal or with your CA before acting.
Who does what
| Role | What they do | Record they own |
|---|---|---|
| Buyer | Raises requisitions, gathers quotes, inspects goods, raises rejections | Requisition and supplier quote |
| Stores supervisor | Approves the PO, keeps the stock record, matches bill to receipt | Purchase order and GRN |
| Accounts payable clerk | Counts against documents, books matched bills, schedules payment | Vendor bill |
Common mistakes
- Placing an order by phone first and raising the purchase order afterwards, which leaves nothing to match against.
- Accepting the whole delivery into stock and finding the rejections later, when the supplier will not take them back.
- Letting the person who approves the PO also receive the goods and pass the bill, so one person controls every check.
- Paying a bill because the supplier is calling, with the match still open.
- Ignoring small rate differences. ₹5 on a high-volume item adds up quickly.
How to tell it is working
- Unacknowledged POs: count the purchase orders sent that the supplier has not confirmed after one working day. Divide by all POs sent that week for a percentage. It should be small and each one chased.
- Three-way mismatch: divide the number of bills that did not match on first check by the total bills received in the month. A high figure points to rate changes, loose receiving or supplier errors.
- Delayed receipts: count the POs past their delivery date with nothing received, and note how many days late each is. Use it to decide which suppliers need a conversation.
Questions people ask
Who owns procure to pay?
In a small firm, the stores supervisor often owns it, because the PO approval, the GRN and the match all pass through them. The buyer and the accounts clerk each own their own step.
What is the minimum record for procure to pay?
A purchase order, a GRN and the vendor bill, kept together under the PO number. A supplier quote is useful as the reason for the price. Without these three you cannot prove what was agreed, what arrived and what was billed.
When should a case stop?
Stop and hold payment when the three records do not agree beyond your tolerance, when goods are rejected and not credited, or when the supplier is not on the approved list. Release it only once the difference is explained and written down. Never settle by paying first.
Can a spreadsheet support this stream?
For a small number of orders, yes. Use one row per purchase order with columns for ordered, received, accepted and billed quantity, and add a check column. It becomes hard to trust when several people receive goods or when bills arrive in bulk.
What should the owner review?
Each week, check bills held for mismatch, purchase orders past delivery date, and the rejection list by supplier. Ask which suppliers keep appearing. Over a quarter, that shows who to renegotiate with.