AP three-way match

Matches each invoice against its purchase order and goods receipt, approves lines within tolerance, and formats approved payments for the ERP

How it works

Upload a completed payment run

The match detail and payment upload tab as submitted to the ERP
Add the source files

The invoice register, open purchase order lines, goods receipts for the same reporting period, and the vendor master
Skipper learns the matching rules

How invoice lines match by purchase order number and line, the quantity and price tolerances, the treatment of tax and freight, and the ERP-required column order
Upload the new invoice register for each run

Skipper formats approved lines for the ERP and assigns exceptions a zero payment amount to prevent their release

invoice_register_202X-07.xlsx Invoices received this cycle, with PO reference, quantity, unit price, and tax
purchase_orders_202X-07.xlsx Open PO lines with ordered quantity, agreed unit price, cost center, and buyer
goods_receipts_202X-07.xlsx Quantities received against each PO line, with receipt dates
vendor_master.xlsx Payment terms, currency, and remittance details for each vendor

ap_three_way_match_202X-07.xlsx

Summary Count and value by match status, with the tolerances applied
Match Detail Invoice, purchase order, and goods receipt side by side, with quantity, price, and amount variances
Payment Upload Approved invoices in the ERP-required column order, with exceptions assigned a zero payment amount
Checks Reconciliation of approved and held amounts to the invoice register