How Three-Way Matching Works in Sage 100
The workflow brings together three documents that represent different stages of a purchase transaction. The purchase order records what the business authorized, the goods receipt confirms what arrived, and the supplier invoice states what the vendor expects to be paid.
- Purchase order: Establishes the approved items or services, quantities, prices, and purchasing terms.
- Goods receipt: Records the quantities received and provides evidence that the ordered goods arrived.
- Supplier invoice: Specifies the billed quantities, unit prices, taxes, and total amount payable.
The accounts payable team compares these records to determine whether the invoice meets the company's requirements. For example, if a purchase order authorizes 100 units but the receiving record confirms only 90 units, the invoice should be evaluated against the quantity received and the company's partial-delivery policy before payment approval.
This workflow connects procurement controls with invoice review. The article Purchase Order and Invoice Process: Automation Insights explains how requisitions, purchase orders, goods receipts, and invoice processing fit together across the purchasing lifecycle.
Matching Rules and a Worked Example
Matching rules define which fields must agree and how differences are evaluated. Common checks include vendor identity, purchase order number, item description, quantity, unit price, invoice total, and applicable tax. Companies can establish tolerances for permitted price or quantity variations, subject to their accounting policies and approval requirements.
Consider a supplier invoice for 90 units at $50 per unit. The purchase order authorizes 100 units at the same price, while the goods receipt confirms that 90 units were delivered.
Expected invoice value: 90 units × $50 = $4,500.
Invoice comparison: If the supplier bills $4,500 before tax, the invoice amount agrees with the quantity received and the agreed unit price. If the supplier instead bills $5,000 before tax, the additional $500 requires review because the invoice covers 10 units beyond the recorded receipt.
The result depends on the applicable receipt records, matching configuration, and business approval rules. A match supports the next processing step, while a discrepancy can be routed to purchasing, receiving, or accounts payable for investigation.
Automation, ERP Integration, and Exception Handling
Automated matching can capture invoice data, retrieve relevant purchasing records, compare key fields, and route exceptions to the appropriate reviewer. In a Sage 100 environment, the available integration determines how purchase orders, receipt records, invoice details, and processing statuses are exchanged between systems.
Hyperbots Platform supports company-specific configurations for ERP integration, workflows, roles, and general ledger structures through a no-code framework. Its Process Specific Capabilities support finance workflows with AI automation tailored to the process. Ready to Deploy Capabilities include pre-trained agents and pre-built ERP connectors, with configuration options for business requirements.
Self Learning Capabilities allow the system to use human feedback to refine workflows and improve coding decisions. Human in the Loop provides a model for routing exceptions to employees who can review evidence and authorize the appropriate next step.
The guide Master AP Matching: 2-Way, 3-Way & No-Match Explained compares matching approaches and explains how businesses can align invoice verification with their purchasing controls. In procurement workflows, a 3-way match connects purchase authorization, receipt confirmation, and invoice review. The article Automated Purchase Order: Features & ERP Integrations also discusses how purchase order systems connect with ERP processes and matching activities.
Business Benefits and Practical Applications
Three-way matching helps businesses verify supplier charges before releasing funds. It supports invoice accuracy, purchasing compliance, clear documentation, and dependable accounts payable reporting. These benefits are especially useful for distributors, manufacturers, and other organizations that purchase inventory or equipment and record physical receipts.
The term Three Way Match describes the general control of comparing purchase orders, receipt records, and invoices. Three Way Match Procurement emphasizes its role in procurement, where the control links authorized spending to goods received. An Exact Match means the relevant compared fields agree according to the defined criteria; some organizations also permit documented differences within approved tolerances.
For best results, maintain accurate vendor and item records, record receipts promptly, establish clear tolerance rules, and assign responsibility for resolving quantity or price differences. Purchasing and receiving teams should coordinate with accounts payable so invoice decisions reflect the actual transaction rather than invoice information alone.
Summary
Sage 100 Three-Way Match compares purchase orders, goods receipt records, and supplier invoices to verify that billed amounts align with authorized purchases and recorded deliveries. Defined matching rules, suitable ERP integration, and clear exception ownership help finance teams process invoices consistently. When applied effectively, three-way matching strengthens payment controls, supports accurate financial reporting, improves vendor management, and helps businesses protect cash flow.