Number Duplication Test
This test will drill down into the data table to identify the exact transactions that were causing the spikes in the frist-order test and summation graphs. The NDT Test is based on Chapter 8 of Nigrini, Mark J., Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations, New Jersey: John Wiley & Sons, Inc., 2011: Print
IDEAScript: Number Duplication Test.iss
Author: Brian Element (brian.element@ideascripting.cm)
Purpose: This test will drill down into the data table to identify the exact transactions that were causing spikes in the first-order test and summation graphs. The NDT test is based on Chapter 8 of Nigrini, Mark J., Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations, New Jersey: John Wiley & Sons, Inc., 2011: Print
How to use: Start the script by selecting Number Duplication Test. iss. You will see the following menu:
Click on the select file button to select the IDEA file that you which to perform the analysis on. Once the file has been selected you will have a list of all numeric fields in the file in the drop down, select the field you wish to perform the analysis on. The final option is to choose one or more of the criteria to perform the analysis on. The first option looks at all amount greater than or equal to 10, the second option is all items between 0.01 and 9.99, the third and fourth are the same but for the negative amounts.
Click on OK button when you have made your selections.
You will be given the following file:
Above is an example of the output. The fourth column shows the first two digits and the ranking along with the number of records that were found in the file.