Three-Way Invoice Matching Template: Compare Purchase Orders, Receipts, and Supplier Bills
three-way matchaccounts payablepurchase orderssupplier invoicespayment controls

Three-Way Invoice Matching Template: Compare Purchase Orders, Receipts, and Supplier Bills

iinvoices.page Editorial Team
2026-11-20
7 min read

Use a three-way invoice matching spreadsheet to compare purchase orders, receipts, and supplier bills before approving payment.

A three-way invoice matching process compares the purchase order, proof of delivery or receipt, and supplier invoice before payment is approved. This guide provides a repeatable spreadsheet structure, practical variance calculations, and an accounts payable workflow for handling partial deliveries, price changes, duplicate bills, and missing documents.

Overview

Three-way matching is a payment control used to check whether a supplier bill agrees with what was ordered and what was actually received. The three records are usually:

  • Purchase order: what the business authorized, including the purchase-order number, item description, ordered quantity, agreed unit price, tax treatment, freight terms, and requested delivery date.
  • Receipt or proof of delivery: what arrived, when it arrived, and whether the delivery was accepted, rejected, or received with shortages or damage.
  • Supplier invoice: what the supplier is requesting for payment, including invoice number, invoice date, purchase-order reference, quantities, prices, tax, freight, credits, and payment terms.

The goal is not to force every document to look identical. The goal is to identify whether differences are expected, supported, and approved. A spreadsheet can make that decision visible without requiring a complex system. It should preserve the original document values, calculate variances, record the reason for each exception, and show who owns the next action.

For recurring work, create one row per purchase-order line or invoice line rather than one row per invoice. This makes partial receipts, backorders, mixed tax rates, and different unit prices easier to review. Link the result to your wider invoice filing system so the purchase order, receipt, invoice, and approval evidence can be retrieved together.

How to estimate

A useful invoice matching spreadsheet estimates the expected payable amount and compares it with the invoiced amount. Start with these calculations for each line:

  • Expected received value: received quantity × approved unit price.
  • Invoiced line value: invoiced quantity × invoiced unit price.
  • Quantity variance: invoiced quantity − received quantity.
  • Price variance: invoiced unit price − approved unit price.
  • Value variance: invoiced line value − expected received value.
  • Receipt completion: received quantity ÷ ordered quantity, provided the ordered quantity is greater than zero.

For a simple spreadsheet, use columns such as:

Match ID, supplier, purchase-order number, purchase-order line, invoice number, invoice date, receipt number, item or service description, ordered quantity, received quantity, invoiced quantity, approved unit price, invoiced unit price, tax rate, tax amount, freight, credit, expected subtotal, invoiced subtotal, quantity variance, price variance, value variance, variance reason, tolerance result, approval status, exception owner, due date, and notes.

At document level, calculate the expected total as the sum of approved received line values, plus approved freight and other charges, plus applicable tax, less documented credits. Compare that amount with the invoice total. Keep tax as a separate field rather than burying it in the unit price. This makes the review clearer when an invoice contains multiple tax treatments or when a tax amount must be checked independently.

Use a status field with controlled choices such as Pending documents, Matched, Matched with approved variance, Exception—buyer review, Exception—receiving review, Exception—supplier query, and Approved for payment. Avoid relying only on cell color; a text status can be filtered, exported, and reviewed during month-end close.

Before approving payment, compare the supplier name, invoice number, purchase-order number, bank or payment details held in your approved records, and total amount. A matching spreadsheet supports review, but it does not replace your organization’s authorization controls or fraud-prevention procedures.

Inputs and assumptions

Matching is only as reliable as the inputs. Establish a short document checklist before calculating a result:

  1. Confirm that the purchase order is approved and belongs to the correct supplier.
  2. Confirm that the receipt records quantities actually accepted, not merely quantities shipped.
  3. Confirm whether the supplier invoice is for the complete order, a partial delivery, or a service milestone.
  4. Confirm the unit of measure. “Each,” “box,” “case,” hours, and weight must not be compared as if they were interchangeable.
  5. Confirm whether freight, discounts, deposits, credits, and tax are included in the purchase-order terms or handled separately.
  6. Check whether the invoice number has already been recorded for that supplier.

Set tolerances before reviewing exceptions. For example, a business might allow a small quantity difference caused by packaging or a minor price difference that was approved by the buyer. These are examples of internal assumptions, not universal rules. Record the tolerance as a number or percentage in the workbook, identify who approved it, and avoid silently rounding away a difference.

For a partial delivery, the received quantity is the quantity that can normally be matched at that point in time. Do not mark the full purchase order as received simply because the invoice references the full order. Leave the balance open and note the expected remaining quantity. If your process permits payment for delivered goods only, the payable amount should be based on the accepted received quantity and any separately approved charges.

For services, replace physical receipt fields with an approved timesheet, milestone acceptance, completion certificate, or other evidence appropriate to the engagement. A consulting invoice template or contractor invoice template may contain different line descriptions from a goods invoice, but the same control applies: compare the authorized scope, accepted work, and billed amount.

Where your accounting or procurement software supports spreadsheet imports or exports, use the platform’s current field names and import rules. Export a copy of the reviewed data in a stable format, retain the source documents, and record the date and person responsible for the export. Platform menus, supported file types, and matching features can change, so verify them in the software’s current documentation rather than assuming that an older workflow still applies.

Worked examples

Example 1: Partial delivery

A purchase order authorizes 100 units at an approved price of 12.00 per unit. The receipt records 60 accepted units, while the supplier invoice bills 60 units at 12.00. The quantity variance is zero against the receipt, and the line value is 720.00 before tax and other charges. Mark the line as matched if the tax, freight, invoice reference, and approval checks also agree. Leave the remaining 40 units open against the purchase order rather than treating them as an exception.

Example 2: Price change

A purchase order authorizes 20 units at 50.00, but the invoice charges 52.00. The price variance is 2.00 per unit and the total value variance is 40.00 before tax. Do not change the approved price in the original purchase-order record merely to make the match pass. Record the reason, such as an approved change order or supplier price confirmation, attach the evidence, and route the item to the designated buyer or budget owner. If no approval exists, place the invoice on supplier query or buyer review.

Example 3: Duplicate invoice

An invoice number appears twice for the same supplier, with the same purchase-order reference and amount. The second record should not be approved simply because its line values match. Mark it as a potential duplicate, compare invoice dates and document images, and check whether one record is a corrected submission, a credit, or an accidental resubmission. Keep the duplicate review outcome in the notes and retain both records according to your document-retention process.

Example 4: Missing receipt

An invoice agrees with the purchase-order quantity and price, but no receipt or delivery confirmation is available. Set the status to Pending documents or Receiving review, assign an exception owner, and record a due date for obtaining evidence. Do not infer receipt from the invoice alone unless your documented policy explicitly covers that type of purchase and the required approver authorizes the alternative evidence.

For month-end, summarize the workbook by status, supplier, purchase-order number, exception owner, and total value. This creates a practical queue: matched items can proceed, while open exceptions can be followed up before the payment run. Pair the review with an invoice reconciliation template when you also need to compare bills with payments, credits, and outstanding balances.

When to recalculate

Recalculate the match whenever an input changes, not only at month-end. This includes a new receipt, corrected invoice, credit note, approved price change, freight adjustment, tax correction, or cancellation of an order line. Reopen the calculation if a supplier sends a replacement invoice or if receiving staff update quantities after an initial review.

Run the workbook at each regular accounts payable cycle and perform a separate review before closing a period. Focus on unmatched invoices, invoices with large value or quantity variances, open partial deliveries, duplicate warnings, and items whose exception owner or due date is blank. If pricing inputs, tax treatment, purchasing rules, or software import requirements change, update the assumptions tab and version the template before the next cycle.

Finish each review with three actions: resolve or assign every exception, save the supporting documents using a consistent file name, and record the final approval status. A three-way matching template is most useful when it becomes a small operating procedure rather than a one-time spreadsheet. Combine it with an invoice checklist for document quality and an invoice aging report for follow-up after approved invoices enter the payment process.

Related Topics

#three-way match#accounts payable#purchase orders#supplier invoices#payment controls
i

invoices.page Editorial Team

Operations and Invoicing Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.