Workflow Guide

Three Way Match Invoices: Complete Excel Workflow for AP Reconciliation

Complete workflow to match purchase orders, invoices, and receiving documents using Excel after AI-powered PDF extraction

Three way match invoices is an accounts payable control process that validates invoices against purchase orders and receiving documents before payment. This workflow shows how to extract data from PDF documents into Excel and perform comprehensive matching using VLOOKUP functions and conditional formatting to catch discrepancies in quantities, prices, and vendor details.

Who This Is For

  • Accounts payable clerks processing vendor invoices
  • Finance managers implementing AP controls
  • Small business owners handling invoice approval workflows

When This Is Relevant

  • Processing vendor invoices over $500 that require approval
  • Implementing SOX compliance controls for purchase-to-pay
  • Reconciling month-end AP accruals against unmatched receipts

Supported Inputs

  • Vendor invoices in PDF format with line item details
  • Purchase order documents showing approved quantities and prices
  • Receiving reports or packing slips confirming delivered quantities

Expected Outputs

  • Excel reconciliation worksheet with match status flags
  • Exception report highlighting price, quantity, or vendor mismatches

Common Challenges

  • Manual data entry from PDF invoices takes 8-12 minutes per document
  • VLOOKUP formulas fail when PO numbers have leading zeros or extra spaces
  • Quantity discrepancies get missed when partial deliveries span multiple receipts
  • Price variances under $50 require different approval workflows than major discrepancies

How It Works

  1. Extract invoice data to Excel with fields: Invoice Number, PO Number, Vendor Name, Line Item Description, Quantity Invoiced, Unit Price
  2. Extract PO data with matching field structure plus Quantity Ordered and Approved Price columns
  3. Extract receiving data with Quantity Received and Receipt Date fields
  4. Create master reconciliation sheet using VLOOKUP to match PO Number across all three datasets
  5. Add calculated columns: Price Variance (Invoice Price - PO Price), Quantity Variance (Invoiced - Received)
  6. Apply conditional formatting to highlight variances exceeding tolerance thresholds (typically 5% for price, exact match for quantity)
  7. Generate exception report filtering rows where any variance flags are triggered

Why PDFexcel.ai

  • Extracts invoice line items with 99%+ accuracy on clear PDF documents, preserving item descriptions and pricing details
  • Handles batch processing of multiple invoices, POs, and receipts to Excel format for bulk reconciliation
  • Maintains data structure integrity with proper number formatting for accurate VLOOKUP matching
  • Processes scanned receiving documents and photos of packing slips using OCR technology

Limitations

  • Accuracy depends on document quality - faded or skewed scanned invoices may need manual review
  • Complex multi-page invoices with nested line items may require field customization for proper extraction
  • Handwritten quantities on receiving documents have limited recognition compared to printed text

Example Use Cases

  • Manufacturing company processing 200+ vendor invoices monthly with PO matching requirements
  • Healthcare organization implementing SOX controls for supply chain purchases over $1,000
  • Construction firm reconciling material delivery receipts against supplier invoices for job costing
  • Retail business validating merchandise invoices against receiving reports for inventory accuracy

Frequently Asked Questions

What tolerance levels should I set for price and quantity variances?

Most companies use 5% or $25 tolerance for price variances and zero tolerance for quantity variances. Critical items like IT equipment often require exact price matching regardless of dollar amount.

How do I handle partial deliveries in the three-way match process?

Create separate rows for each receipt against the same PO line. Use SUMIF to total received quantities by PO line number, then compare the sum against invoiced quantities rather than individual receipt quantities.

What Excel formula works best for matching PO numbers with different formatting?

Use VLOOKUP with TRIM and VALUE functions: =VLOOKUP(TRIM(VALUE(A2)),PO_Data,2,FALSE). This handles extra spaces and converts text-formatted numbers to values for proper matching.

How should I flag invoices that arrive before the receiving document?

Add a status column using IF(ISBLANK(Receipt_Date),"Missing Receipt","Complete"). These invoices should be held in a pending folder until receiving documents arrive to complete the three-way match.

Ready to extract data from your PDFs?

Upload your first document and see structured results in seconds. Free to start — no setup required.

Get Started Free

Related Resources