No

Generate Audit Number

Brian Element's picture
Submitted by Brian Element on Wed, 01/23/2019 - 14:40
Background: 

This script will create an number field that keeps a count based on the selected field.  When the contents of the field change it resets to 0 and starts the count over.  There is also a second script that will order the field based on a date field.

Append File Report

Brian Element's picture
Submitted by Brian Element on Sun, 09/02/2018 - 20:36
Background: 
This script will generate a report of the files you plan to append together to make sure there are no problems such as fields with the same name and different types.  This will look through all the files before you perform the append and generate a text report that you can review and make any corrections necessary.

Payment Date vs Due Date

Brian Element's picture
Submitted by Brian Element on Tue, 10/09/2012 - 16:57
Background: 

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

Z-score

Brian Element's picture
Submitted by Brian Element on Thu, 08/16/2012 - 12:42
Background: 

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

Brian Element's picture
Submitted by Brian Element on Tue, 08/07/2012 - 13:47
Background: 

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.

Number Duplication Test

Brian Element's picture
Submitted by Brian Element on Fri, 07/13/2012 - 21:28
Background: 

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

Benford's law 1st 2 digit test

Brian Element's picture
Submitted by Brian Element on Fri, 07/13/2012 - 21:24
Background: 

This will perform the Benford 1st 2 digit test on each distinct item in a selected column.  So if you have a vendor column this would perform the test for each vendor.  It allows you to exclude low value items.

Updated for IDEA v9 on Feb 14, 2013.

Subscribe to RSS - No