Audit Objective pr-25

Duplicate names and date of birth

Step 1

Duplicates

Using the main form, select the 'Duplicates' function in order to identify any duplicate transactions . The identification of duplicate transactions involves identifying the sort keys which result in the identification of a duplicate. Often the auditor will specify the criteria using "same, same, same". For example, a duplicate employee may be identified as same last name, same first name, same city. Similarly, a duplicate invoice may be the same vendor, same invoice number, same invoice amount. Note that the number of criteria used may range from one on up (limited only by the auditor's imagination).

Also, the input data does not need to be pre-sorted. There is a complete description of the procedure available for viewing.

Output from the process will be available in two formats:

1. As an extract file (text format)
2. As a summary line description on the status bar.

The Duplicate extract may be loaded into Excel for for further analysis or sorting.

Also, there is a separate process to determine invoices or other transactions which are similar, but not exactly equal. These may be identified using "fuzzy" matching. There is a complete description of this procedure.





Home



Application Area