01The short answer
You should pay only for what you ordered, at the price you agreed, and only for what you actually received. Three-way matching turns that common sense into a check that runs on every invoice.
Each of the three documents comes from a different person: the buyer issues the purchase order, the warehouse or the requester confirms the receipt, and the supplier sends the invoice. Because no single person controls all three, a mismatch is a reliable signal that one of them is wrong, incomplete or, occasionally, dishonest. That independence is what makes the control worth running. If you are new to the vocabulary, our glossary entries on the purchase order and on three-way matching give the one-paragraph definitions.
02The three documents, and what each one proves
| Document | Issued by | What it proves | Fields used in the match |
|---|---|---|---|
| Purchase order (PO) | Buyer | You committed to buy | PO number, item, quantity ordered, unit price, currency, tax code |
| Goods receipt (GRN) | Warehouse, site or requester | The goods or services were delivered | PO number, item, quantity received, date, condition |
| Supplier invoice | Supplier | The supplier asks to be paid | Invoice number, PO reference, item, quantity billed, unit price, tax, bank details |
The match works at line level, not at the level of the invoice total. An invoice whose total equals the PO total can still hide one line that is overbilled and another that is underbilled, or a line for an item you never ordered.
03How the match works, step by step
- Find the PO. The invoice must quote a valid, open purchase order. An invoice with no PO reference is the first exception, and the reason many companies adopt a "no PO, no pay" rule above a small amount.
- Pair the lines. Each invoice line is paired with a PO line, by item code where you have one, by description otherwise.
- Check quantities. Quantity billed must not exceed quantity received, and quantity received should not exceed quantity ordered.
- Check prices. The unit price billed is compared with the PO unit price, within your price tolerance.
- Recompute totals and tax. Line totals, tax amounts and the invoice total are recalculated rather than trusted.
- Look for duplicates. Same supplier and same invoice number, or same amount and date already paid, stops the invoice.
- Decide. If every line passes, the invoice is approved for payment. If any line fails, it goes to an exception queue with an owner and a reason.
04Worked example 1: a clean match (USD)
PO-1042 to an office equipment supplier: 20 monitors at $180.00 ($3,600.00) and 20 docking stations at $95.00 ($1,900.00), so $5,500.00 before tax.
The receiving clerk records 20 monitors and 20 docking stations, all in good condition. The invoice bills the same quantities at the same prices, plus the applicable sales tax. Every line agrees, so the invoice is approved without anyone opening it. This is the outcome you want for the large majority of invoices: no human time spent on documents that are already right.
05Worked example 2: a quantity gap (EUR)
PO-2210: 500 kg of packaging film at €4.20/kg, so €2,100.00 net. The receipt shows 460 kg: one pallet is missing. The invoice bills 500 kg, €2,100.00 net plus 20% VAT, so €2,520.00.
Quantity billed exceeds quantity received by 40 kg. The overbilling is 40 × €4.20 = €168.00 net, or €201.60 with VAT. There are two correct outcomes: hold the invoice until the missing pallet arrives and is received, or pay for the 460 kg received (€1,932.00 net) once the supplier sends a credit note for the difference.
The wrong outcome is "pay now and chase later". Money is far easier to hold than to recover, and a short delivery that is paid in full is rarely chased at all.
06Worked example 3: a price variance and a tolerance (GBP)
PO-3307: 1,200 machined parts at £2.50, so £3,000.00. The receipt shows 1,200 parts. The invoice bills 1,200 at £2.54, so £3,048.00.
The variance is £0.04 per unit, 1.6%, or £48.00 in total. Under a policy of 2% price tolerance capped at £50 per invoice, the invoice passes and the variance is logged. Under a 1% tolerance, it goes to the buyer, who either accepts the new price and updates the PO, or asks the supplier for a credit note.
Notice the cap. A percentage alone is dangerous on large invoices: 2% of a £400,000 invoice is £8,000 that would pass without anyone looking. Always pair a percentage with an absolute amount.
07Two-way, three-way and four-way matching
| Type | Compares | Typical use |
|---|---|---|
| 2-way | PO and invoice | Subscriptions, utilities, fixed-fee services where there is nothing physical to receive |
| 3-way | PO, receipt and invoice | Physical goods, and services with a confirmation step |
| 4-way | PO, receipt, quality inspection and invoice | Manufacturing inputs, regulated goods, food and pharmaceuticals |
For services, the "receipt" is a confirmation from the requester that the work was done: an approved timesheet, a signed milestone or a service entry in your system. Treating services as two-way by default is the most common gap in otherwise sound controls, because services are exactly where "was this actually delivered?" is hardest to see.
08How to set tolerances
There is no universal standard tolerance. Set your own by category and risk, then review it with real exception data. A starting policy might look like this:
| Category | Price tolerance | Quantity tolerance | Absolute cap per invoice |
|---|---|---|---|
| Raw materials | 1% | None above received | $250 / €250 / £200 |
| Office supplies | 3% | None above received | $50 / €50 / £40 |
| Freight and delivery charges | 5% | Not applicable | $100 / €100 / £80 |
| Services billed against a fixed PO | 0% above PO value | Not applicable | 0 |
A few rules hold everywhere. Keep price and quantity tolerances separate. Never apply a tolerance to a duplicate invoice or to a change of bank details. And when the same supplier lands in exceptions every month, fix the PO or the price list rather than widening the tolerance.
09Common exceptions, and who resolves them
- Invoice without a PO: the requester or buyer raises the PO after the fact, and the case is tracked as a policy breach so it does not become a habit.
- Quantity billed above quantity received: receiving confirms the count, or the supplier issues a credit note.
- Price above the PO: the buyer accepts and amends the PO, or disputes.
- Possible duplicate: accounts payable rejects it or confirms it is genuinely new.
- Changed bank details: verified by calling the supplier on a number already on file, never the number in the email that announced the change.
That last check matters. In the AFP 2025 Payments Fraud and Control Survey, 79% of organizations reported attempted or actual payments fraud in 2024, and 63% named business email compromise as the leading avenue. Three-way matching will not catch a fraudulent bank change on a legitimate invoice, so it needs this companion control.
10Why it is worth the effort
The ACFE 2024 Report to the Nations estimates that organizations lose 5% of revenue to fraud each year, and billing schemes (fake, inflated or duplicated invoices) appear in 22% of the cases it studied, with a median loss of $100,000. Matching blocks the simplest of these: invoices for goods that never arrived, and prices that quietly drifted above what was agreed. It also catches honest errors, which are far more frequent than fraud.
11Doing it in Excel, or in software
A spreadsheet works for a few dozen invoices a month. Our free Simple 3-Way Matching template compares order, receipt and invoice line by line and gives an OK or Check verdict, and the Purchase Order Register keeps committed and invoiced amounts side by side.
Beyond that volume, spreadsheets break on the cases that matter most: partial deliveries, one invoice covering several receipts, mistyped PO numbers. That is the point where matching belongs in your purchasing system, so it runs on every invoice as soon as it arrives. See how three-way matching works in Procura.
12Three-way matching checklist
- Every invoice above your threshold must quote an open PO number.
- Receipts are recorded by someone other than the buyer, on the day of delivery.
- Services have a confirmation step (timesheet, milestone or service entry).
- Matching is done line by line, not on invoice totals.
- Price and quantity tolerances are separate, and each has an absolute cap.
- Duplicates and bank detail changes are never covered by a tolerance.
- Each exception type has a named owner and a target resolution time.
- Exceptions are reviewed monthly to fix recurring causes at the source.