Payment Date vs Due Date


This script allows you to take two date fields and perform three different extracts:

  1. First date field is less than second date field,
  2. First date field is equal to second date field, and
  3. First date field is greater than second date field.

It will then summarize the findings based on year and month.  You can select which date field to use for obtaining the date and month information.

Script updated Feb 12, 2019

Text Search


The text search script gives you an alternatvie interface to performing a text search from within IDEA.  The script allows you to select up to 10 different search terms (you can use the wildcards), it also allows you decide if the search is case sensitve or not and the type of search, i.e.



Calculates the z-score of a selected numerical field.  The user has the option of having the analysis performed based on the population standard deviation or the sample standard deviation.

2nd - 3rd - 4th digit test


This script will perform the 2nd, 3rd and 4th digit test which is based on Benford's Law.  The test is based on Mark J. Nigrini's book Benford's Law Applications for Forensic Accounting, Auditing, and Fraud Detection.  The script will create one file for each digit test.

Feb 14, 2013 - Updated for IDEA v9.

Identify Blank / Repeat Fields


This script will identify any blank fields or fields in which the information repeats.  The scrpt will rename the fields based on a prefix that the user gives.  It also write a text file to the working directory of the fields which should be kept.  The script will then create a new IDEA file which will list the fields that contain empty or repeating data and allows the user to decide if they wish to keep or delete the field.  The user would then run the script a second time in order to delete the choosen fields.



The purpose of the GEL tests (GEL-1 and GEL-2) is to detect relationships or links within a data file that serve as potential indicators of fraud.

Compare multiple fields


This script will take the same file from different points and time and compare multiple fields. Currently the compare funciton in IDEA only allows to compare on one field based on an amount field. This will allow for comparison of text and date fields also.

GEL - 1


The GEL tests establish possible links between two selected fields over the entire data set. The first field is the key field and the second field is the element factor.

The test was updated in October 2015.

Subscribe to RSS - v8.5