Audit Routine Library

ScriptBasic is a computer language suitable for the implementation of commonly used audit functions. ScriptBasic is free, licensed under the LGPL license. The Windows install can be downloaded. ScriptBasic is free software. View license text. I have found ScriptBasic to be a useful and cost-effective audit support tool. One advantage of a tool like ScriptBasic is that the entire population can be tested (not just a sample). It is my hope that auditors and other analysts may benefit from the examples and code provided. All of the software is free and can be used for any purpose. Other Excel macros are also available at no cost. Some of the functions include:

  • data extraction
  • day of week testing
  • CMA sampling
  • highlighting data outliers
  • gap identification
  • selecting random samples
  • searching for patterns (e,g, duplicate payments)
ScriptBasic Template Library
Description Type Last Date Changed
Library Functions - Install
All the code and data here in install format Setup.exe 02-22-2007
All the code and data here in zip format ZIP 02-22-2007
Data Extraction
Extract data for FDA NDC firms Extract 10-22-2006
Perform CMA (DUS) sampling Sampling 11-04-2006
Access to MySQL database Database 10-22-2006
Misc Functions
Extract June 2004 Invoices over $300 Extract 11-03-2006
Ageing of accounts Extract 11-03-2006
Merge Match by Key Value Extract 10-27-2006
Check for Weekend dates Extract 11-08-2006
Check for Federal Holidays Extract 11-08-2006
Population Testing
Extract credits only Extract 10-22-2006
Population transaction statistics Extract 11-04-2006
Extract data from file with fixed length records Extract 11-09-2006
Find errors using Look-up Table Extract 11-09-2006
Benchmark statistical tests using Wake County Real Estate tax data Extract 11-17-2006
DataBase - Summarization and Selection
MySQL Select DataBase 10-22-2006
MySQL Aggregate Function DataBase 10-22-2006
ODBC Database Function DataBase 10-22-2006
Telephone Area Code / Zip Code Validation
Area Code/Zip Code Checking (C++ code) Zip 11-26-2006
Area Code/Zip Code Checking (C++ code) Setup 11-26-2006
Test Data for Code Validation (Congressional Phone Numbers) Note that errors have been deliberately introduced. Excel 11-25-2006
Area Code/Zip Code Overview PDF 11-26-2006
Zip Code data (www.populardata.com) URL 11-26-2006
Code Snippets
Date Handling Code 10-22-2006
Text Handling Code 10-22-2006
If/Then Logic Code 10-22-2006
Looping Code 10-22-2006
Math Functions Code 10-22-2006
Quick Sort Code 10-22-2006
Splitting strings Code 10-22-2006
Test Data Used in the Examples
PO test data file Data 11-03-2006
PO2 test data file Data 11-03-2006
FDA NDC Firms Data 10-22-2006
Invoices Data (TAB) 10-22-2006
Expense Reports Data (TAB) 10-22-2006
Sample Trans Data (TAB) 10-22-2006
Duplicate Invoice Data Test Data (TAB) 10-22-2006
USPS State Code Table (used for merge / match) Data (TAB) 11-09-2006

Also note the availability of macros for use in Excel. Five groupings of macros are provided: 1) General purpose, 2) Detection of Fraud, 3) Macros using VBA and 4) Examples of macros used in an audit of fixed assets, and 5) Examples of macros used in an audit of procurement. All of the macros and software may be downloaded at no cost and used for any purpose.

 

All of the above are free and may be used for any purpose. Comments, suggestions and user experiences are welcomed and can be sent to Mike.Blakley AT ezrstats.com.

Web Page last updated on 03-21-2008
© EZ-R Stats, LLC 2005-2008

© EZ_R Stats

Visit EZ_R Stats on the web at:

www.ezrstats.com