A three-way match pays only for what you ordered and what actually arrived, at the price you agreed.
A three-way match compares the purchase order, the goods received note and the supplier invoice before payment. Quantity invoiced must not exceed quantity received, price must match the order within tolerance, and the supplier must be the same on all three. Any line that fails goes on hold with a named owner until it is resolved.
Each document comes from a different person. That separation is the control: the buyer can't confirm delivery, the receiver can't set the price and accounts payable can't invent either.
Zero tolerance creates a queue of trivial holds from rounding. A tolerance that is too wide quietly pays overcharges. Most teams set a small percentage on price and a small absolute amount per line, whichever is lower, and allow no tolerance at all on quantity. Write the tolerance down, have it approved, and review it once a year.
Put PO lines, receipts and invoice lines on three sheets keyed by PO number and line number. On a match sheet, one row per PO line:
=SUMIFS(Receipts!Qty,Receipts!PO,A2,Receipts!Line,B2)=SUMIFS(Invoices!Qty,Invoices!PO,A2,Invoices!Line,B2)=IFERROR(SUMIFS(Invoices!Value,Invoices!PO,A2,Invoices!Line,B2)/F2,0)=IF(F2>E2,"OVER-INVOICED","OK")=IF(AND(F2>0,ABS(G2-D2)>D2*Tolerance),"PRICE","OK")Name a cell Tolerance so the rule is visible and can be changed in one place. Filter H and I for anything other than OK before each payment run.
Every exception needs an owner and a date. An exception list nobody owns becomes a list of invoices that get paid anyway.
A two-way match compares PO and invoice only, which suits services with nothing physical to receive. A four-way match adds an inspection or quality step. Use the lightest match that still proves delivery.
For the approval rules around the match, see the invoice approval workflow. To catch the same invoice entered twice, see how to find duplicate invoices in Excel.
The method is the same in the UK and the US. Test the price on the net amount before VAT or sales tax, so a tax difference isn't mistaken for a price difference.
Supplier statement to AP ledger. Finds invoices you haven't posted, credit notes still to come, price differences, duplicate postings and payments in transit, and builds the supplier reconciliation. Runs in your browser on your own computer: nothing is uploaded.
Paste your invoice list and see likely duplicates in minutes. Free Excel file: enter your work email to download it.
The Accounts Payable Control System runs four duplicate-invoice tests, supplier master fraud checks and a three-way match on every invoice, with a payment run release gate that blocks release while exceptions are open. Excel, no macros, one-time price.
No. Apply it to goods and to services with a measurable delivery. Utilities, rent and subscriptions usually go through a two-way match or a contract check instead.
The person who physically received the goods or service, not the buyer and not accounts payable. Otherwise the match checks a document against itself.
Hold it. The invoice can be entered, but it shouldn't be released for payment until the receipt is recorded.
Last updated 21 October 2026. General guidance for finance teams; check it against your own policies, systems and local rules.