How Purchase Order Matching Works in Sage 100
The process starts when a buyer creates an approved purchase order containing the supplier, item descriptions, quantities, unit prices, and payment terms. When goods arrive, the receiving team records the delivered quantities. Accounts payable then enters the supplier invoice and checks the relevant information against the purchasing and receiving records.
For example, a company orders 200 units at $15 each, creating an expected purchase value of $3,000. The supplier delivers all 200 units and invoices $3,000. If the item details, quantities, prices, and applicable terms agree, the transaction can proceed through the required approval process. If the invoice shows $3,200, the $200 difference should be investigated before payment authorization.
The specific matching screens, tolerances, and automated checks available depend on the Sage 100 version, installed modules, and configuration. Teams should confirm which records the system compares and how unmatched transactions are routed for review.
Key Matching Criteria and Records
Effective matching depends on complete and consistent purchasing data. Each record provides evidence that helps finance teams determine whether a supplier invoice reflects the underlying transaction.
- Purchase order details: Confirm the authorized supplier, item, quantity, unit price, and purchasing terms.
- Receiving records: Verify the quantities delivered and identify partial shipments, shortages, or rejected goods.
- Invoice information: Compare billed quantities, prices, discounts, freight, taxes, and other charges with the approved terms.
- Matching tolerances: Apply company-approved limits for acceptable price or quantity differences where supported.
- Approval and posting records: Maintain evidence of discrepancy resolution, authorization, and accounting treatment.
A Purchase Order Vendor Portal can support the exchange of purchase order details, supplier confirmations, and invoice status updates. Consistent communication helps buyers, suppliers, receiving teams, and accounts payable work from aligned transaction information.
Handling Matching Exceptions
A mismatch indicates that one or more transaction details require review. It does not automatically mean the invoice is incorrect. Differences may arise from partial deliveries, approved price changes, unit-of-measure differences, freight charges, or receipts that have not yet been recorded.
Suppose a business orders 100 units at $40 each but receives only 80 units during the first delivery. The supplier invoices for all 100 units. The receiving record shows 80 units, while the invoice shows 100, creating a 20-unit discrepancy. Accounts payable should verify the delivery schedule and supplier terms, then follow the company's process for partial invoicing or subsequent receipt confirmation.
Clear exception ownership helps resolve discrepancies promptly. Buyers can verify contract prices, receiving staff can confirm delivered quantities, and accounts payable can validate invoice details. Documenting each decision creates a traceable record for audits and period-end reconciliation.
Invoice Validation and Automation
Matching works best when invoice data is captured accurately and compared against reliable purchasing records. Consistent supplier identifiers, item codes, purchase order references, and invoice numbers help reduce manual investigation and support dependable accounting entries.
Tailored Matching Policies: Optimize Vendor Invoice Processing explores how matching rules can vary by vendor type, transaction value, and general ledger account. Such policies help finance teams apply appropriate checks to different purchasing scenarios. Effective invoice matching also compares invoice details with supporting documents and transaction history to identify discrepancies before approval and posting.
How Vendor Portals Improve Invoice Transparency provides context for communicating invoice status and review progress to suppliers. These practices complement invoice capture, validation, and approval workflows, helping internal teams and vendors understand which transactions are ready for payment and which require additional information.
AP Automation Software can support invoice validation and payment planning, while automated invoice processing can capture invoice data and help route transactions through defined checks. Better procurement controls connect approved purchasing decisions to receiving and accounting activities, while consistent vendor management helps maintain accurate supplier records. Coordinated approval of payments supports cash-flow planning and ensures that supplier obligations follow company policy.
Payment Controls and Financial Reporting
Purchase order matching supports accounts payable by providing evidence that supplier invoices align with authorized purchases and received goods before cash leaves the business. Finance teams should also review duplicate invoice numbers, payment terms, credit notes, and approved exceptions before releasing payments.
A Purchase Order Matching Confirmation represents evidence that the relevant matching checks have been completed according to the applicable process. Businesses should retain the supporting records and document any approved overrides so reviewers can understand why an invoice proceeded despite a variance.
Regular reporting on unmatched invoices, exception reasons, resolution times, and recurring supplier differences helps managers identify patterns. For example, frequent price mismatches from one supplier may indicate that purchasing records need updating or that contract terms should be reviewed. Monitoring these patterns strengthens cost control, improves working-capital visibility, and supports more reliable financial statements.
Summary
Sage 100 Purchase Order Matching compares purchasing records with supplier invoices and, where applicable, goods receipts to validate transactions before payment. Accurate data, appropriate matching rules, clear exception ownership, and documented approvals help businesses improve invoice accuracy, maintain dependable accounting records, and strengthen supplier payment controls. Consistent matching practices support financial reporting, cash-flow management, and informed purchasing decisions.