3 Way Match

This template covers three way matching. It verifies accounts payable expenses using a set of three different documents—the invoice, the purchase order, and the receipt listing.

Input Requirements

• A goods received listing file sourced from your inventory management system (SAP, Oracle, Microsoft Dynamics, etc.).

• An invoice listing file sourced from your ERP system (SAP, Oracle, Microsoft Dynamics, etc.).

• A purchase order listing file sourced from your ERP system (SAP, Oracle, Microsoft Dynamics, etc.).

• Parameters

  1. File Input Parameters

Output Expectations

• A population of purchase order entries compared against your goods received listing, tagged as passing or failing for any mismatched quantities.

• A population of purchase order entries compared against your goods received listing, tagged as passing or failing for any deliveries not in line with the requested delivery date.

• A population of purchase order entries compared against your invoice listing, tagged as passing or failing for any mismatched dollar amounts.

• A population of invoice listing entries compared against your goods received listing, tagged as passing or failing for any mismatched dollar amounts.