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
matchPO
100
Received
100
Invoice
100
Variance: 0 (0.0%)
Price Variance
matchPO Price
$10
Invoice Price
$10
Variance: $0 (0.0%)
Amount Variance
matchPO Amount
$1,000
Invoice Amount
$1,000
Variance: $0 (0.0%)
Resolution Steps
Recommended actions to process this invoice
- 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 matchVariance 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 toleranceMatch 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 approvalException 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+ daysFrequently Asked Questions
Get Expert Financial Guidance
Speak with our team about how we can help streamline your back office operations.