← All guides

Three-Way Matching in QuickBooks Online and Xero

Three-way matching in accounts payable means checking that the purchase order, receiving record, and vendor bill agree before payment, which is also the definition used in the US Department of the Interior payment-processing manual. A two-way match checks the order and bill without a receiving record. QuickBooks Online Plus and Advanced and every Xero plan can record purchase orders, with receipt evidence kept in the software or attached to the bill.

The match happens before approval. For every line, compare what was ordered, what arrived, and what the vendor billed. A clean match can move forward as a draft. A difference becomes an exception for a person to decide.

What you need before you start

Set up three things before matching invoices:

  1. Purchase orders. Create and approve the order before goods or services are delivered. Use item lines with the agreed quantity and unit price.

  2. Receipt evidence. Record an item receipt in the accounting system, or retain a signed packing slip or delivery note and attach it to the bill.

  3. Written tolerances. Decide which price differences may pass without another approval. A sensible starting point is 0.5% of the agreed unit price, with no quantity tolerance. Your company should choose and document its own limits.

Apply the same rules to every vendor. The person checking a bill should not have to invent a tolerance or receipt rule while processing it.

Three-way matching in QuickBooks Online

QuickBooks Online purchase orders are available in Plus and Advanced. Item receipts provide the receiving record for inventory.

  1. Turn on purchase orders. Go to Settings > Account and settings > Expenses > Purchase orders > Edit. Turn on Use purchase orders, then select Save > Done.

  2. Create the purchase order. Go to + Create > Purchase order. Choose the vendor and date, then add the quantity and agreed price under Item details. Only items marked as purchased from a vendor can be added. Select Save and close or Save and send.

  3. Choose the item-receipt method deliberately. Go to Settings > Account and settings > Sales > Inventory receiving method > Item receipts. Select Yes, permanently switch, then Save > Done. Intuit states that Item receipts cannot be turned off once enabled, so ask your accountant before making the switch.

  4. Record what arrived. Go to All apps > Inventory > Item receipts > New item receipt. Select the vendor, add the purchase order, enter the quantities received, and select Save and close. The purchase order shows the received quantities. With Item receipts enabled, the receipt updates quantity on hand rather than the later bill.

  5. Enter and link the bill. Go to + Create > Bill and select the vendor. Under Suggested transactions, choose Add for the related transaction. The bill is linked to the same purchase order and item receipt. Open purchase orders can also be added from the Payee selection, as described in Intuit’s purchase-order linking instructions.

  6. Compare the lines before saving. Check the bill’s unit price against the purchase order and its quantity against the item receipt. Record any difference with the ordered figure, received figure, billed figure, and reason. This comparison is a reviewer’s check before approval.

  7. Handle partial bills by line. Adjust the quantity or amount to the portion received or being paid. Multiple transactions can link to one purchase order, so later deliveries and bills can use the same order.

  8. Check the purchase-order status. QuickBooks Online closes a purchase order when all quantities have been added to bills, expenses, or checks. If a bill is unlinked, the order stays closed. Open the purchase order and change its status from Closed to Open when more activity is expected.

Three-way matching in Xero

Xero includes purchase orders in every plan. Xero Inventory Plus, an optional add-on for Growing and Established, can hold the receipt record inside Xero.

  1. Create and approve the purchase order. Go to Purchases > Purchase orders, create the order with the agreed items, quantities, and prices, and move it to Approved. Only an approved purchase order can become a bill.

  2. Record what arrived. With Inventory Plus, go to Purchasing > Purchase orders, open the order, and select the Receive tab. Choose Receive all or enter the received quantity for each line, then select Update Inventory. Xero permits partial receipt quantities. An over-received product receives a warning icon. Service lines need no receipt and move directly to ready to bill.

    Without Inventory Plus, the receipt record lives outside Xero. Keep the signed packing slip or delivery note and attach it to the bill.

  3. Create the bill from the order. Go to Purchases > Purchase orders, open the approved order, and select Create bill. Edit the items and quantities to match what arrived, then select Create bill. Xero’s bill-from-purchase-order process puts the purchase order number in the bill’s Reference field, and History and notes link back to the order.

  4. Handle partial or canceled quantities. Bill only the quantity received. If the remaining items will arrive later, leave them open. If they will not arrive, close the purchase order short. In Inventory Plus, products closed short do not appear on bills.

  5. Review before approval. Compare the bill price with the purchase order and the billed quantity with the Inventory Plus receipt or attached delivery evidence. Route differences for a decision before approving the bill.

Tolerances and common exceptions

Write the tolerance into the process. Use the tolerance your company wrote down. Use no quantity tolerance unless the company has deliberately approved one.

Add partial deliveries together by purchase order and item. If one order arrives in three shipments, compare the bill with the total received across all three.

For every exception, record the reason, both relevant figures, and the difference. Then handle it according to its type:

  • Unit price above the order. Hold the bill when the difference exceeds tolerance. Ask for a corrected bill or obtain documented approval for the changed price.

  • Billed quantity above the received quantity. Hold the excess. Ask the vendor for a corrected bill or a credit, and approve only the quantity supported by receipts.

  • Received but not billed. Accrue the received amount at month-end. A receipt still unbilled after about 60 days is stale and warrants a call to the vendor.

  • No purchase order reference. Hold the bill while the requester identifies the order. If no order exists, document the authorized exception before approval.

  • Possible duplicate bill. Hold the new entry and compare the vendor, invoice number, amount, and underlying obligation before approving either entry.

  • Services. Use a two-way match between the order and bill, plus sign-off from the person who requested the work. If two of four maintenance visits are complete, two visits may be billed.

An approval belongs to the figures reviewed. If the vendor sends a corrected invoice, obtain a fresh approval for the corrected quantity and amount.

Worked example

Suppose a purchase order covers 100 insulation boards at $12.50 each. The item receipt shows 90 boards arrived, but the vendor bill requests payment for 100 at $13.75 each.

The billed price is 10% above the agreed $12.50, far outside a 0.5% tolerance. The billed quantity is also 10 units above the quantity received. Both are exceptions.

Hold the bill. Ask the vendor for a corrected bill or a credit covering the 10 units and the price difference. Record the decision and approve only the corrected figures.

When to hand off the matching

Manual matching becomes hard to sustain when invoice volume makes the controller do daily clerk work, partial receipts accumulate, or received-not-billed accruals consume month-end time. The average AP invoice exception rate is 18.4%, according to Ardent Partners’ 2025 benchmark, so roughly one invoice in five may need a person.

The AP Desk handles recurring accounts payable work each morning inside the company’s QuickBooks Online or Xero records. It performs the match, documents differences, and puts exceptions in front of the appropriate person. Clean matches go to the ledger owner as drafts, while your own people keep approvals and release payments. A ten-business-day pilot begins read-only and then moves to drafts. Owners comparing that approach with adding staff can use the guide to hiring an AP clerk or outsourcing accounts payable.

Frequently asked questions

What is three-way matching in accounts payable?

It is a check that the purchase order, receiving record, and vendor bill agree before payment. The reviewer compares quantity and price, then routes any difference for a decision.

Can QuickBooks Online do three-way matching?

Yes. QuickBooks Online Plus and Advanced provide purchase orders, Item receipts, and bills. Link the records, then compare their line quantities and unit prices before approving the bill.

What tolerance should we use?

Set your own written policy. A 0.5% tolerance against the agreed unit price is a sensible starting point, with no quantity tolerance.

Do services need three-way matching?

Services usually use a two-way match between the purchase order and bill, plus sign-off from the person who requested the work. The sign-off confirms how much of the service was completed.