Find vendor bill discrepancies with 3-Way Matching

Prev Next

Overview

3-Way Matching (3WM) is an automated system that checks your vendor bills against receipts and purchase orders and flags discrepancies between all three documents. This ensures you're not missing important errors that could impact your financials.


Who uses this feature

  • Administrators, office employees, managers, accountants, and bookkeepers

  • Applies to all business types

  • Applies to all trades

Feature configuration

Things to know

  • Order and invoice details including vendor, PO number, job number, and business unit are always checked in the 3-way match.

  • 3-Way Matching only looks for discrepancies in vendor bills related to purchase orders and does not include Non-PO bills.

Set up 3-Way Matching

To configure your 3WM settings:

  1. Go to the top toolbar and click Settings .

  2. In the side panel, go to Accounting > 3-Way Match Settings.

  3. For each kind of discrepancy, select Show all discrepancies or Create custom threshold.

  4. For Create custom threshold, select dollar amount, quantity amount, or percentage amount and enter in the value.

  5. When finished, click Save ThresholdSettings for identifying discrepancies in total amount and item quantity thresholds.

  6. (Optional) If you'd like to compare line items on the PO, receipt, and bill to identify discrepancies, click Line Item Discrepancy to enable it.        

    Note: Adjusting any of these settings impacts any bills that currently have discrepancies flagged and the flags may adjust or disappear.

Review and resolve discrepancies

To see actionable discrepancies:

  1. Go to the navigation bar and click Accounting .

  2. In the side panel, go to Accounts Payable > Bills.

  3. Under the Needs Review tab, find a Vendor Bill that has a discrepancy flag listed under the Bill No. column.

  4. Click the discrepancy flag to see a summary of the found discrepancies. Table displaying discrepancies in unit costs and subtotal amounts for various suppliers.

  5. To see individual discrepancies, click the Bill No.

  6. Click each discrepancy flag to display a tooltip that explains what isn't matching between the vendor bill, PO, and receipt. Discrepancy noted for Template Item Material 2 in billing and purchase order.

  7. Edit the bill, PO, and receipt as needed. The Bill No. discrepancy flag automatically updates to No discrepancies identified once every discrepancy is resolved.

  8. When finished, reconcile the bill.        

    Note: If you reconcile a bill that still has discrepancies that 3-Way Matching found, you are prompted to confirm your choice. The bill is then reconciled and the discrepancies will remain flagged on the bill for any future audits.

Discrepancies identified for bill reconciliation, highlighting amounts and missing receipts.

Want to learn more?