How Three-Way Matching Works in Sage 100
The workflow connects purchasing, receiving, and accounts payable activities. A buyer creates a purchase order with approved quantities, item descriptions, prices, and terms. When the goods arrive, receiving staff record the quantities accepted. Accounts payable then enters the supplier invoice and compares its details with the purchase order and receipt information.
For example, a company orders 100 office chairs at $80 each. The receiving team records 100 chairs delivered, and the supplier invoice charges $8,000. When the quantities, unit prices, and relevant terms agree, the invoice meets the expected matching criteria and can proceed through the company's approval and payment workflow.
The exact screens, available fields, tolerances, and automation behavior depend on the Sage 100 version, installed modules, and configuration. Teams should confirm which matching checks are supported in their environment and establish procedures for reviewing exceptions.
Key Records and Matching Criteria
Reliable matching depends on complete, consistent records. Each document contributes different evidence to the verification process.
- Purchase order: Establishes the approved supplier, item or service, quantity, price, and purchasing terms.
- Goods receipt: Documents the quantity received and any shortages, damaged goods, or partial deliveries.
- Supplier invoice: Records the billed quantity, unit price, taxes, freight, discounts, and payment terms.
- Matching tolerances: Define acceptable differences in quantities or amounts when company policy and system configuration permit them.
- Approval record: Shows whether an invoice passed the required checks and received authorization for payment.
An Exact Match occurs when the relevant values agree according to the organization's matching rules. Some companies allow defined tolerances for rounding, freight, or minor price differences. Taxes and additional charges should be evaluated according to the applicable accounting treatment and purchasing policy.
Handling Exceptions and Partial Deliveries
A mismatch does not always mean the supplier invoice is incorrect. It may indicate a partial shipment, an unrecorded receipt, a revised purchase price, or an invoice that includes charges requiring separate approval. Accounts payable should identify the specific difference and route it to the responsible buyer, receiving employee, or approver.
Consider a purchase order for 100 units at $25 each, with an expected total of $2,500. The supplier delivers 90 units but invoices for all 100. The receipt and invoice quantities differ by 10 units. The matching review should flag the discrepancy so the team can verify the delivery, request a corrected invoice, or apply the company's approved process for the remaining quantity.
Clear exception ownership helps teams resolve discrepancies promptly while preserving an audit trail. The principles behind Three Way Match Procurement reinforce the connection between purchasing authorization, physical receipt, and financial settlement.
Benefits for Accounts Payable and Purchasing
Three-way matching helps businesses pay for goods that were authorized and received, maintain more dependable purchasing records, and improve visibility into outstanding supplier obligations. It also supports stronger internal controls by separating purchasing, receiving, invoice verification, and payment authorization where appropriate.
Finance teams exploring User-Friendly PO Automation Software for Finance Teams can examine how digital workflows connect requisitions, purchase orders, approvals, and spend visibility. Similarly, Automated Purchase Order: Features & ERP Integrations provides a relevant context for understanding how purchasing workflows and ERP records can support consistent matching practices.
For a broader explanation of invoice verification methods, Master AP Matching: 2-Way, 3-Way & No-Match Explained helps clarify how two-way comparisons differ from three-way checks and when each approach may be appropriate. A well-defined 3-way match process links purchasing controls to the procure-to-pay workflow, helping ensure that invoice approval is based on documented evidence rather than the invoice alone.
Configuration and Automation Best Practices
Businesses should establish consistent item descriptions, supplier records, purchase order prices, and receipt procedures before relying on matching reports. They should also define who resolves quantity differences, who approves price changes, and how unmatched invoices are documented.
The Hyperbots Platform supports company-specific configuration of ERP integrations, workflows, roles, and general ledger structures. Its Process Specific Capabilities address finance workflows, while Ready to Deploy Capabilities can support implementation through pre-trained agents and ERP connectors. Self Learning Capabilities help workflows adapt based on human feedback, and Human in the Loop oversight allows exceptions to be reviewed and routed for approval.
When evaluating any automation approach, confirm how it accesses Sage 100 data, identifies matching exceptions, records approval decisions, and preserves traceability. Review Three Way Match requirements against actual purchasing and accounting practices so that system behavior supports the organization's control policies.
Summary
Sage 100 Three-Way Match PO compares purchase orders, goods receipts, and supplier invoices to verify purchasing transactions before payment. Accurate records, appropriate matching tolerances, clear exception ownership, and documented approvals help finance teams maintain reliable accounts payable records and strengthen purchasing controls. When configured to support the company's workflow, three-way matching improves payment accuracy, supplier accountability, and financial reporting.