First page of the Three-Way Match Exception LogExcel workbook preview

Procure-to-pay and accounts payable

Three-Way Match Exception Log

Three way match exception log in Excel: PO, receipt and invoice compared line by line, tolerance test, exception types, owners, ageing and a summary sheet.

Excel workbook · 18 KB General finance practice

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

A three-way match compares three documents before an invoice is paid: the purchase order that set the price and quantity, the receipt that shows what actually arrived, and the supplier invoice. Most invoices agree and pass automatically. The ones that do not are the exceptions, and auditors, controllers and procurement leads want to see that each one was recorded, owned and cleared, not quietly approved to keep the supplier happy.

This log has 11 worked exceptions for Ashcombe Group, covering price and quantity variances, missing receipts, a missing purchase order, a suspected duplicate, unplanned charges and an invoice carrying new bank details. Formulas compute the variances, test them against your tolerance inputs and age every open item with TODAY(). The bank detail guidance follows the FBI Internet Crime Complaint Center advice to verify change requests through a secondary channel.

Who it is for

The accounts payable lead whose auditor asked how invoices that fail the PO, receipt and invoice match are tracked and cleared.

What is inside

  • Exception log with 11 worked exceptions across 7 exception types plus 20 blank formatted rows
  • Quantity variance, price variance percentage and variance value calculated from PO, receipt and invoice figures
  • Match result formula: No PO, No receipt, Within tolerance or Outside tolerance, tested against your own limits
  • Tolerances sheet with three input cells (price percentage, value per line, quantity) that drive the match result
  • Days open with TODAY() and red highlight on open exceptions past their due date
  • Summary sheet: exceptions logged, open, overdue, outside tolerance and average days to resolve
  • Tables by exception type (logged, open, variance value, average days open) and by status
  • Notes on bank detail red flags drawn from FBI IC3 guidance on business email compromise

How to use it

Set your price, value and quantity tolerances on the Tolerances sheet, then log each held invoice as one row.

Files

  • XLSXthree-way-match-exception-log.xlsx18 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Based on general finance practice, not on one published standard. A template to adapt, not legal, tax or accounting advice.

Questions about this template

What is a three way match in accounts payable?

It is the check that the invoice agrees with the purchase order and with the goods or services actually received. Quantity is compared with the receipt and price with the purchase order. An invoice that agrees within the tolerances you set can be paid. One that does not is held and recorded as an exception until it is resolved.

What tolerance should a three way match use?

There is no official figure. Each company sets its own limits, usually a small percentage of the line value with a cap in currency, and a zero tolerance on quantity. The worked example uses 2 percent, USD 250 per line and zero units. Put your approved limits on the Tolerances sheet and every match result updates.

Why log an invoice that shows new bank details?

The FBI Internet Crime Complaint Center warns that business email compromise often works by redirecting a legitimate payment, and it advises verifying requests to change account information through a secondary channel. An invoice that matches a real order but carries new remittance details is a classic sign, so it is held, verified by callback and recorded.