Duplicate Invoice Reporting Tool
Duplicate Invoice key variables
Most ERP systems will not prevent duplicate invoice entries when there is a difference in more than one of the key variables, such as vendor, reference, amount and date. mightymacros Dat add-in cross-checks all of the key variables, looking for similarities and differences and reports on the items found.
The program compares all invoices, both historical and pending against unpaid bills, to produce a split tab report output in MS Excel that is based on the following variable rules:
- Different reference
- Different document date
- Different vendor number
- Different amount
- Different currency
- Different company
- Different document type
- Different document number
The program menu is designed for ease of use, and needs only four button clicks to generate the duplicate report:
Click-1: Upload all new invoices, including open items.
Click-2: Upload open items or bills to be paid.
Click-3: Run the analysis process using 'Prepare'
Click-4: Run 'Create' to output the report
The following sample shows the type of information that is represented in the report:
Note: the above sample data is fictitious and is not intended to represent any known business or organization.
Dat add-in also shows how much is saved over time:
The vendor stats function extracts a list of duplicates by the vendor including suppliers that have re-occurring invoice duplicates and this helps to detect fraudulent activity.
The 'Show Detail' function on the Stats menu displays the history in detail for a selected vendor.