How Purchase Order Invoice Variance Works
In Sage 100, purchase order and accounts payable workflows provide transaction records that can be compared to identify differences. The purchase order establishes the expected quantity, price, and purchasing terms. Receiving records document the goods delivered, while the supplier invoice states the amount requested for payment. The exact matching and posting behavior depends on the Sage 100 modules, configuration, and business procedures.
Finance teams should compare the invoice with both the purchase order and receipt where applicable. This three-way review helps determine whether the business ordered the items, received the expected quantities, and was billed according to the agreed terms. Invoice processing should also validate vendor details, tax treatment, freight, discounts, and general ledger account assignments.
Effective procurement controls establish who can approve price changes, confirm receipts, and resolve discrepancies. Clear approval rules allow legitimate variations to be accepted with supporting evidence while invoices requiring correction remain under review.
Common Types of Invoice Variances
Understanding the type of variance helps the team identify the right resolution. A price difference requires different evidence from a quantity discrepancy or an unexpected tax charge.
- Price variance: The invoice unit price differs from the purchase order price because of a pricing update, discount, or billing error.
- Quantity variance: The invoiced quantity exceeds or differs from the quantity ordered or received.
- Freight and charge variance: Shipping, handling, or additional fees appear on the invoice but do not match the approved terms.
- Tax variance: Tax rates, exemptions, or taxable amounts differ from the expected treatment.
- Timing or receipt variance: The invoice arrives before the receipt is recorded, or the transaction spans different accounting periods.
Each exception should be evaluated against contracts, purchase order amendments, receipt evidence, and applicable company policies. A documented, authorized change should be distinguished from an unsupported charge.
Calculating and Interpreting a Variance
A simple monetary variance can be calculated by subtracting the expected purchase order amount from the invoice amount. A positive result means the invoice exceeds the expected amount; a negative result means it is below the expected amount.
Invoice variance = Invoice amount − Expected purchase order amount
Variance percentage = (Invoice variance ÷ Expected purchase order amount) × 100
For example, assume a purchase order has an expected value of $5,000 and the supplier invoice totals $5,400. The variance is $5,400 − $5,000 = $400. The variance percentage is ($400 ÷ $5,000) × 100 = 8%. The invoice is therefore 8% above the expected amount.
A positive variance may reflect an approved price increase or an unplanned charge that requires investigation. A negative variance may indicate a discount, a partial invoice, or an omitted item. Neither direction automatically establishes an error. Finance teams should also compare quantities and unit prices separately because an overall invoice total can conceal offsetting differences.
Invoice Matching, Approval, and Automation
Consistent invoice matching helps identify discrepancies before posting and payment. Tailored rules can specify acceptable differences by supplier, transaction value, item category, or general ledger account. The process should retain the purchase order, receipt, invoice, variance explanation, and approval decision as an auditable record.
Invoice capture extracts relevant invoice data, while validation checks the extracted information against supplier and purchasing records. Accurate gl coding helps assign approved costs to the correct general ledger accounts. AP Automation Software can support invoice workflows and payment planning, and procurement tools can help connect purchasing approvals with receiving and accounts payable activities.
For a broader view of matching practices, invoice matching explains how invoice details are compared with purchase orders and receipts to detect differences. How Vendor Portals Improve Invoice Transparency provides context on communicating invoice status and resolution progress to suppliers. These practices help teams understand where a discrepancy sits in the workflow and what evidence is needed to resolve it.
Invoice Matching Approval is the authorization step used to confirm that matching results satisfy the organization's rules before an invoice proceeds. Accounts Payable Matching Approval focuses on authorization within the accounts payable workflow, while Payment Matching Approval concerns matching and validating payment-related records. Keeping these stages distinct helps prevent a resolved invoice discrepancy from being confused with payment settlement.
Best Practices for Managing Variances
Finance teams should define tolerance thresholds, document approval authority, and assign clear ownership for each exception. Minor differences may be handled under approved policies, while significant price, quantity, or tax differences should receive appropriate review. Teams should also monitor recurring variances by supplier and category to identify opportunities to improve purchasing terms and supplier records.
Strong vendor management supports timely communication about disputed charges, missing receipts, and revised invoices. Connecting purchasing records with invoice capture, validation, matching, and approval also improves visibility across the procure-to-pay process. When the organization changes purchase order terms or supplier pricing, it should ensure that the revised information is reflected in the relevant records before subsequent invoices are evaluated.
Regular reporting on variance amounts, exception frequency, resolution time, and recurring causes helps finance leaders prioritize improvements. These measures support more accurate expense recognition, controlled payments, stronger supplier relationships, and more reliable financial reporting.
Summary
Sage 100 PO Invoice Variance measures differences between expected purchase order details and supplier invoice amounts or quantities. Reviewing price, quantity, freight, tax, and receipt differences helps teams determine whether an invoice is correct, requires approval, or needs a supplier adjustment. Consistent matching rules, documented exception handling, and clear approval controls improve accounts payable accuracy and purchasing oversight.