Three-Way Matching & Invoice Variance Reconciler
Audit purchase orders against warehouse receiving notes (GRN) and vendor invoices. Detect unit price variance, unreceived short shipments, and automate Purchase Price Variance (PPV) journal entries.
1. Document Identifiers
2. Matching Tolerance Rules
AP Policy Guardrails3. Three-Way Itemized Line Reconciliation
Compare line items across Purchase Order, Goods Receipt Note (GRN), and Vendor Invoice.
| Item SKU / Description | PO Qty | PO Price | GRN Recv | Inv Qty | Inv Price | Approved ($) | Status | |
|---|---|---|---|---|---|---|---|---|
| $955.00 | Tolerance | |||||||
| $880.00 | Matched | |||||||
| $0.00 | Unreceived | |||||||
| $1440.00 | Price Var |
4. General Ledger (GL) Journal Entries
Simulated ERP accounting entries for clearing the Received Not Invoiced (GR/IR) liability against Accounts Payable.
5. Export Audit Workpapers
Generate official vector PDF audit certificates with sign-off blocks or export sanitized CSV schedules for ERP cutover audits.
Understanding Three-Way Matching in Accounts Payable
In corporate procurement and supply chain management, Three-Way Matching is the primary defense against overpayments, fraud, and inventory discrepancies. It enforces an automated or manual cross-check among three independent source documents:
Created by Purchasing / Procurement. Establishes legal quantity, contracted price, payment terms, and delivery window.
Created by Warehouse / Receiving dock. Confirms physical quantity, batch numbers, and absence of shipping damage.
Issued by the Vendor. Demands payment for billed quantities and unit rates including sales tax/VAT and freight.
Matching Levels: 2-Way vs 3-Way vs 4-Way Matching
Depending on whether goods are tangible or intangible, organizations configure different approval gates in ERP systems like Microsoft Dynamics 365, SAP S/4HANA, and Odoo:
| Matching Type | Documents Required | Typical Industry Application |
|---|---|---|
| Two-Way Matching | PO ↔ Vendor Invoice | Service contracts, software subscriptions, consulting retainers, office rent. |
| Three-Way Matching | PO ↔ Receiving Note (GRN) ↔ Invoice | Manufacturing raw materials, wholesale merchandise, MRO supplies, equipment. |
| Four-Way Matching | PO ↔ GRN ↔ Inspection/Acceptance ↔ Invoice | Pharmaceuticals, medical devices, defense aerospace, and regulated cleanrooms. |
How to use this tool
Enter Purchase Order (PO) line items and agreed unit prices
Input product SKUs, descriptions, ordered quantities, and contracted unit prices according to the signed vendor purchasing agreement.
Record warehouse Goods Receipt Notes (GRN)
Enter physical receiving quantities accepted at the loading dock, noting damaged or rejected units withheld from stock.
Enter Vendor Invoice line item quantities and billed rates
Input supplier commercial invoice quantities and billed unit costs to trigger real-time cross-document line reconciliation.
Configure matching tolerance bands and price variance thresholds
Set percentage and dollar price tolerances (e.g. ±1.0% or ±$10.00) and physical count receiving tolerances to govern automated payment clearing.
Review automated payment status, holds, and PPV journal entries
The engine flags lines as Matched, Within Tolerance, Price Variance, or Quantity Discrepancy, computing approved payment disbursements and General Ledger entries (GR/IR clearing and Purchase Price Variance).
Export AP Audit Certificate PDF or reconciliation CSV
Download an institutional 1-page vector PDF Accounts Payable reconciliation certificate with audit sign-off blocks, or export a formula-safe CSV ledger.
Frequently Asked Questions
What is three-way matching in accounts payable and why is it essential?
Three-way matching is the standard internal control procedure in enterprise accounts payable (AP) that cross-verifies three core documents before an invoice is approved for disbursement: the Purchase Order (PO) (agreed quantities and contract pricing), the Goods Receipt Note (GRN) / Receiving Slip (quantities physically received and accepted at the dock), and the Vendor Commercial Invoice (quantities and unit prices billed by the supplier). It prevents overbilling, fraudulent disbursements, phantom inventory, and double payments.
What is the difference between two-way, three-way, and four-way matching?
Two-way matching verifies only the Purchase Order against the Vendor Invoice; it is typically used for non-physical overhead services (legal, consulting, rent). Three-way matching adds the warehouse Goods Receipt Note (GRN) to confirm physical possession before payment. Four-way matching adds a mandatory formal Quality Inspection / Laboratory Acceptance certificate (standard in aerospace, medical devices, and pharmaceutical manufacturing) confirming that received goods meet rigorous technical tolerances before AP payment release.
How do invoice matching tolerances and Purchase Price Variance (PPV) work?
Enterprise ERP systems (SAP, Microsoft Dynamics 365, Odoo) establish matching tolerance rules (such as ±1.0% or ±$10.00). When an invoice variance falls within tolerance, the system auto-clears the invoice for payment and posts the minor discrepancy to a General Ledger Purchase Price Variance (PPV) account. If the variance breaches the tolerance band, an automated payment block / AP hold is placed on the voucher until the procurement buyer or department manager reviews and approves a formal adjustment.
What is the GR/IR (Goods Receipt / Invoice Receipt) clearing account in ERP accounting?
The GR/IR clearing account (or "Received Not Invoiced" liability account) serves as an accrual buffer between the physical receipt of goods and receipt of the vendor invoice. When goods arrive at the dock, inventory is debited (Dr. Inventory) and GR/IR is credited (Cr. GR/IR Accrual). When the invoice arrives, AP clears the accrual (Dr. GR/IR Accrual) and recognizes the liability (Cr. Accounts Payable). Any difference between the two postings represents a price or quantity variance reconciled during three-way matching.
Migrating to Automated ERP Accounts Payable?
DataDaur deploys official Microsoft Dynamics 365 Business Central and Odoo 19 with automated OCR invoice capture, three-way matching workflows, and zero-downtime cutover guarantees.
Related Free Engineering & Business Utilities
All tools operate 100% in your browser. No files or confidential business data are ever uploaded.
SadaSend — High-Throughput Transactional Email & Native MCP for AI Agents
Need programmatic email dispatch, human-in-the-loop approvals, or a native MCP server for your LLM agents? SadaSend provides dedicated IP pools, zero spam tolerance, and verified delivery webhooks.
Commercial Real Estate Cap Rate & NOI
Property valuation, Net Operating Income (NOI), DSCR debt coverage, and investor pitch deck.
Bank Statement & PDF to Excel
Client-side financial table extraction, balance reconciliation, and accounting CSV export.
OFX / QBO to CSV Converter
Banking transaction SGML/XML parser with sign inversion and QuickBooks formatting.