Three-Way Matching: Process, Tolerances and Exceptions

How three-way matching compares the invoice with the purchase order and the receipt, how tolerances decide a pass or a hold, and who resolves each exception.

Paperwork Editorial10 min read
Contents
  1. What is three-way matching?
  2. Two-way, three-way and four-way matching
  3. The three-way match process, step by step
  4. Tolerances: how much difference is acceptable
  5. Common exceptions and who resolves them
  6. When three-way matching is not the right check
  7. What a match result should record
  8. Three-way matching with Document Automation
  9. Test cases to prepare before a pilot
  10. FAQ
Purchase order, goods received note and invoice feeding one check: reference and price agree, quantity is flagged

Three-way matching is an accounts payable control that compares a supplier invoice with the purchase order and the receiving record before the invoice is paid. Price is checked against the order. Quantity is checked against what was received. A difference beyond the agreed tolerance holds the invoice for review.

The same control is written 3-way matching or three-way match. This guide covers the process, the two-way and four-way variants, tolerances with worked numbers and the exceptions a team has to assign.

It does not repeat what each document contains. For that, see the guides to the purchase order, the goods received note and the delivery note.

Three-way match of one item: 100 ordered, 80 received, 100 billed at AED 20.00, with the quantity check on hold
One item, three records, three checks. The order reference and the price agree; the invoice bills 20 more than was received, so AED 400 before VAT is held for review.

What is three-way matching?

Three-way matching answers two questions with three documents: is the supplier charging the agreed price, and is it charging only for what arrived?

Microsoft's Dynamics 365 documentation defines it in those two parts: "Match the price information on the invoice to the price information on the purchase order. Also match the quantity information on the invoice to the quantity information on the product receipts that are selected for the invoice." Microsoft Learn: invoice matching.

Oracle's purchasing guide states the control as a payment condition: "Purchase order, receipt, and invoice quantities must match within tolerance before the corresponding invoice can be paid." Oracle Purchasing User's Guide.

Two-way, three-way and four-way matching

The level describes how many records an invoice has to agree with before payment.

LevelRecords comparedWhat Oracle requires to matchOften used for
Two-wayOrder and invoicePurchase order and invoice quantitiesServices and purchases with no goods receipt
Three-wayOrder, receipt and invoicePurchase order, receipt and invoice quantitiesPhysical goods
Four-wayOrder, receipt, inspection and invoicePurchase order, receipt, accepted and invoice quantitiesGoods that must pass inspection before acceptance

The labels are shared across systems, while the exact comparison is a setting. Oracle's two-way level is stated in quantities. Microsoft's two-way matching compares the price on the invoice with the price on the order. Write down what your own check compares before relying on the name.

The three-way match process, step by step

Find the purchase order the invoice quotes. An invoice with no order reference cannot enter the match; it goes back to the supplier or to the person who requested the purchase. In the UAE the reference is often labelled as an LPO number.

2. Find the receipts for that order

One order can be delivered in several shipments. Select the receipt or receipts that the invoice covers. A second copy of the same receipt is not a second delivery.

3. Compare the price with the order

Read the unit price or the line amount on the invoice against the same line of the order. Use the approved revision of the order, since an older revision can make a correct invoice look wrong.

4. Compare the quantity with the receipt

Read the billed quantity against the quantity recorded as received. Where the process uses inspection, compare with the accepted quantity.

This step on sample documents: 100 cartons billed against 80 recorded as received. The recording shows the invoice and receipt comparison; the order comparison is a separate check.

5. Apply the tolerance

Decide whether each difference is inside the limits the organisation has set. The next section works through the arithmetic.

6. Release, hold or return

An invoice inside tolerance continues to approval and payment. One outside it waits. Microsoft describes the choice for a price outside tolerance: the invoice can be saved "until it's approved for posting, or until you receive a correction from the vendor".

Tolerances: how much difference is acceptable

A tolerance is the difference a team accepts without review. It exists because rounding, small freight adjustments and pack sizes produce differences that are not worth an investigation each.

Tolerances are usually set in two forms. Microsoft's documentation says price totals matching "can be based on a percentage, an amount, or a percentage and amount", and that where both are set, a line has a discrepancy if either one is exceeded. The percentage can be configured for items, vendors or the whole legal entity.

The figures below are an illustration, with an assumed policy of 2% on unit price and AED 50 per line. They are not recommended values.

CaseOrder priceInvoice priceQuantityPrice differenceLine differenceResult
AAED 20.00AED 20.301001.5%AED 30Inside both limits
BAED 20.00AED 20.601003.0%AED 60Outside both limits
CAED 20.00AED 20.301,0001.5%AED 300Percentage passes, amount limit fails

Case C is the reason to set both. A percentage alone lets a small unit difference grow with the order size. An amount alone treats AED 30 on a small order the same as AED 30 on a large one.

Quantity has its own tolerance. Oracle describes a quantity received tolerance as "the maximum acceptable over-receipt Tolerance percent". With an assumed 5% on an order of 100, receiving can record up to 105 before the receipt needs approval.

A tolerance is a policy decision. It should be written down, owned by someone and reviewed, since a limit set too wide passes real overcharges without review.

Common exceptions and who resolves them

A failed match is a question addressed to a specific team. The result is more useful when it says which one.

ExceptionWhat the match showsUsually resolved by
Billed above received quantityInvoice 100, receipt 80Receiving confirms the count; the supplier delivers the balance or issues a credit
Price above the orderInvoice price outside toleranceProcurement confirms whether a revision was approved
No receipt recordedInvoice and order agree, receipt missingReceiving records the delivery or confirms nothing arrived
No order referenceInvoice cannot be linkedAccounts payable returns it to the supplier or the requester
Received above ordered quantityReceipt outside the over-receipt toleranceProcurement accepts or returns the excess
Same invoice twiceSecond invoice against an already matched receiptAccounts payable
Units differOrder in cartons, invoice in piecesProcurement supplies the conversion

The first row is worked through with documents in the goods received note guide: 20 cartons, AED 400 before VAT, with the possible explanations.

Record the reason when an exception is released. "Approved" tells the next reviewer nothing; "balance delivered on a second receipt" does.

When three-way matching is not the right check

Three-way matching assumes a physical receipt. Some purchases do not have one.

PurchaseWhy the receipt comparison does not fitWhat is compared instead
ServicesThere is no goods countThe invoice with an acceptance record, a timesheet or a milestone
Advance paymentsMoney moves before delivery, against a proforma invoiceThe tax invoice and the receipt, once they exist
Inspected goodsGoods can be received and then rejectedThe accepted quantity, which is the four-way level
Low-value purchasesThe review can cost more than the riskThe invoice with the order only, below an amount the organisation sets

What a match result should record

A single "matched" or "failed" label is not enough for the person who has to act on it. A usable result records:

  • the invoice, order and receipt references that were compared;
  • each compared value and the document it was read from;
  • the tolerance applied and whether it was exceeded;
  • the specific line and difference behind a hold;
  • who released an exception, and why.
Document Automation line comparison showing 100 cartons on the invoice and 80 on the goods received note, with the other lines agreeing
A recorded line comparison on sample documents. The carton row is flagged with both values, and the two other rows agree.

A wrong extracted value and a correct value that disagrees need different follow-up. If the receipt says 80 and the system read 800, the problem is the reading. If both say 80 and the invoice bills 100, the problem is commercial.

Three-way matching with Document Automation

Document Automation identifies the uploaded documents, extracts their fields and line tables, applies the configured checks and returns a result a reviewer can open.

The recording above checks an invoice against a goods received note: order reference, buyer, invoice arithmetic, then line items by SKU and quantity. An invoice-and-PO template is already available. A full three-way scenario adds the customer's receiving rules and tolerances, which are agreed and tested against expected results before use.

A match shows that records agree. It does not show that a file is genuine. For edited PDFs or altered amounts, add Fraud Detection.

Discuss a three-way matching workflow with Document Automation.

Test cases to prepare before a pilot

Prepare the expected result for each case before running it, so a correct exception can be told apart from a failed reading.

  1. A clean package where all three records agree.
  2. A quantity shortage, such as 100 billed against 80 received.
  3. A price difference inside tolerance.
  4. A price difference outside tolerance.
  5. One order delivered on two receipts.
  6. The same invoice submitted twice.
  7. An invoice with no order reference.
  8. A line where the unit differs between the order and the invoice.

Frequently asked questions

What is the difference between two-way and three-way matching?

Two-way matching compares the invoice with the purchase order. Three-way matching adds the receiving record, so the invoice is also checked against what arrived.

Is 3-way matching the same as a three-way match?

Yes. Three-way matching, 3-way matching and three-way match are names for the same control.

Who performs three-way matching?

Accounts payable usually runs the match, using the order from procurement and the receipt from the receiving team. Where bookkeeping is outsourced, an accounting firm may run it on the client's documents. Exceptions go back to the team that owns the record in question.

Does a three-way match prove an invoice is genuine?

No. It shows that three records agree within tolerance. Whether a document was altered is a separate check.

What happens after the match?

A matched invoice goes to approval and payment. Matching the payment to the invoice in the bank statement is covered in the bank reconciliation guide.

Sources

See PaperWork on your documents

Request demo