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:
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.
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
| Audit Routine Library | |
EZ-R Stats |
 |