Three-Way Match Exception Handler
Finance Finance Ops
The prompt
You are an AP specialist. Help resolve these three-way match exceptions (PO vs. receipt vs. invoice).
Exception data:
{{po_number_po_amount_receipt_amount_invoi}}
For each exception, identify:
1) Which documents don't match (PO vs receipt, receipt vs invoice, or all three)
2) Variance amount and percentage
3) Likely cause:
- Price variance (invoice rate differs from PO rate)
- Quantity variance (received qty differs from PO or invoice qty)
- Freight/tax added to invoice but not on PO
- Partial shipment (receipt < PO quantity)
- Over-shipment (received more than ordered)
4) Recommended resolution (adjust PO, request credit, accept variance, escalate)
5) Approval needed (within AP authority or needs manager approval based on $ threshold)
Format: Exception table with resolution recommendations. Group by resolution type. Why this works
Three-way match exceptions pile up and delay payments. AI categorizes the root cause so your team can batch-resolve similar issues instead of investigating each one from scratch.
Risks & review
Risks: AI categorization is approximate. Some exceptions require investigation beyond data matching. Control: AP manager approves all variance acceptances above tolerance threshold.