Three-Way Match Calculator

Validate PO, receipt, and invoice for payment approval. Detect quantity and price variances.

Purchase Order (PO)

Authorized purchase quantity and price

Quantity authorized on purchase order

Agreed price per unit on PO

PO Extended Amount

$1,000

Receipt (Receiving Report)

Actual goods received and condition

Actual quantity received in warehouse

Condition of goods upon receipt

Received Value (at PO price)

$1,000

Vendor Invoice

Billed quantity and price from vendor

Quantity billed on vendor invoice

Unit price on vendor invoice

Invoice Extended Amount

$1,000

Tolerance Settings

Acceptable variance thresholds for auto-approval

Acceptable quantity variance (typically 1-5%)

Acceptable price variance (typically 1-3%)

Acceptable dollar variance (typically $25-$250)

Match Status: PASS

Three-way match validation result

Risk Level

low

Approval Required: automatic

All three-way match criteria met within tolerance thresholds. Approved for automatic payment.

Variance Analysis

Detailed comparison of PO, receipt, and invoice

Quantity Variance

match

PO

100

Received

100

Invoice

100

Variance: 0 (0.0%)

Price Variance

match

PO Price

$10

Invoice Price

$10

Variance: $0 (0.0%)

Amount Variance

match

PO Amount

$1,000

Invoice Amount

$1,000

Variance: $0 (0.0%)

Resolution Steps

Recommended actions to process this invoice

  1. 1. All validations passed. Invoice approved for payment per standard payment terms.

How Three-Way Matching Works

Document Comparison

Compare three critical documents to validate payment approval: Purchase Order, Receipt, and Vendor Invoice.

Three-Way Match Validation: 1. Purchase Order (PO) - Authorization • Approved quantity and unit price • Extended amount (quantity × price) • Terms and conditions 2. Receiving Report (Receipt) - Confirmation • Actual quantity received • Condition (good, damaged, partial) • Date received 3. Vendor Invoice - Payment Request • Billed quantity and unit price • Extended amount • Payment due date Validation Checks: • Invoice Quantity ≤ PO Quantity • Invoice Quantity ≤ Received Quantity • Invoice Unit Price ≈ PO Unit Price (within tolerance) • Invoice Amount ≈ (PO Quantity × PO Price) within tolerance • Receipt Condition = Good (not damaged) Example: • PO: 100 units × $10.00 = $1,000 • Receipt: 100 units received, good condition • Invoice: 100 units × $10.00 = $1,000 • Result: PASS ✅ All three documents match

Variance Calculation & Tolerance

Calculate variances between documents and apply tolerance thresholds to determine if discrepancies are acceptable.

Variance Formulas: Quantity Variance: • Variance = Invoice Quantity - PO Quantity • Variance % = (Variance / PO Quantity) × 100 • Pass if: |Variance %| ≤ Quantity Tolerance % Price Variance: • Variance = Invoice Unit Price - PO Unit Price • Variance % = (Variance / PO Unit Price) × 100 • Pass if: |Variance %| ≤ Price Tolerance % Amount Variance: • Variance = Invoice Amount - PO Amount • Variance % = (Variance / PO Amount) × 100 • Pass if: |Variance| ≤ Amount Tolerance $ Example with Tolerances (Qty: 2%, Price: 2%, Amount: $50): • PO: 100 units × $10.00 = $1,000 • Invoice: 98 units × $10.20 = $999.60 • Quantity variance: -2% (within 2% tolerance) ✅ • Price variance: 2% (within 2% tolerance) ✅ • Amount variance: -$0.40 (within $50 tolerance) ✅ • Result: PASS - Minor variances within tolerance

Match Status Determination

Determine overall match status based on variance analysis and receipt condition.

Match Status Logic: PASS (Auto-Approve): • All variances within tolerance • Receipt condition = Good • No exceptions detected → Automatic payment approval REVIEW (Manual Approval Required): • One or more variances outside tolerance BUT not critical • Receipt condition = Partial • Moderate discrepancies → Supervisor/Manager approval required FAIL (Reject/Hold): • Critical variances (>2× tolerance) • Receipt condition = Damaged • Invoice quantity > Received quantity → Vendor resolution required, payment held Approval Level Assignment: • Variance ≤ 5% and ≤ $1,000 → Supervisor • Variance 5-10% or $1,000-$5,000 → Manager • Variance >10% or >$5,000 → Director • Critical issues → Executive approval

Exception Handling & Resolution

Identify exceptions, generate resolution steps, and route for appropriate action.

Exception Categories: 1. Quantity Over-Billed • Invoice > Received • Action: Request corrected invoice or credit memo 2. Price Variance • Invoice price ≠ PO price • Action: Verify authorization for price change 3. Amount Variance • Extended amount outside tolerance • Action: Investigate cause (quantity or price) 4. Damaged Goods • Receipt condition = Damaged • Action: Initiate return/RMA, hold payment 5. Partial Receipt • Receipt < PO quantity • Action: Pay for received portion or await full delivery Resolution Workflow: 1. System flags exception 2. AP team investigates root cause 3. Contact vendor for resolution 4. Corrected invoice or approval obtained 5. Payment processed with documentation 6. Audit trail updated Typical Resolution Time: • Minor variances: 1-2 days • Moderate variances: 3-5 days • Major issues: 5-10+ days

Frequently Asked Questions

Get Expert Financial Guidance

Speak with our team about how we can help streamline your back office operations.

    Three-Way Match Calculator | Finvisor