April 22, 2008 by Mike.Blakley.

Version 1.56 includes faster sorting speeds for files of up to 2 billion rows with sorting by up to 200 columns. Also included is the ability to run XL Audit Commander using either Excel macros or through the Windows Scripting Host. A paper on the topic is available which describes the process. An Excel macro workbook named Macros.xls is included with the installation software. Note that version 1.56 is required in order to run these macros or scripts. The setup program (11.9 MB) is available for download.

Hope to see you at the IIA Fraud Forum in Bonita Springs, FL on May 16th. Topic is the use of digital analysis for the detection of fraud patterns.

Posted in Data Extraction, Data Classification, Audit Software | 2 Comments »

February 23, 2008 by Mike.Blakley.

Support is now provided for both comma separated value format files (CSV), as well as “print” files through the use of file specifications. Further information is available. Also, there are now a variety of tutorials available in shockwave format to demonstrate the system in action. Information about system limitations is now available.

Posted in Data Extraction, Error identification, Audit sampling, Data Classification, Audit Software, Data Validation and conversion, Data Validation | No Comments »

November 27, 2007 by Mike.Blakley.

The latest version, released 11/24/2007, includes support for CSV files and “print” files and also includes a “help” button on the forms screen. Further, there are several  examples demonstrating its use: 1) interval sampling, 2) testing Benford’s law in MS-Access database, 3) Data Stratification and 4) Date checking. Other examples and articles have been added.

A demo of the system is available for viewing.

Posted in Data Extraction, Audit sampling, Data Classification, Audit Software | No Comments »

October 28, 2007 by Mike.Blakley.

Updates

Version 1.34 adds chart results for certain of the audit commands, such as population statistics, weekday analysis, Benford’s Law, etc. These charts are produced in industry standard GIF format and may optionally be saved or stored on the computer for inclusion in reports or used as the basis for editing.

Version 1.34 also includes two additional audit commands used for running a series of command language statements at once. This facilitates performing a series of analytical procedures in a documented and standard manner. The new audit command is called “bc” for batch command, and executes a series of commands on consecutive rows in a worksheet. There are examples provided in the QuickStart workbook at http://ezrstats.com/online/inno/QS.xls.

Version 1.36 adds three commands: query, graphics and trendline. The purpose of the query command is to import data from databases to a worksheet for further analysis. The trendline command is used to chart a series of points. Also, in version 1.36, the charts have been made a little larger, along with the option to specify a title, using the title= parameter. The graphics command is used to set the color theme of the charts displayed

Software is an Excel addin, which is available for free download.

Posted in Data Extraction, Audit sampling, Audit Software | No Comments »

October 5, 2007 by Mike.Blakley.

The latest version has been upgraded to include the ability to obtain cross-tabulations, test for round numbers, do data extractions and perform calculations. Several mini “Audit Guides” have been released - including “Round Numbers” , “Holiday Date testing“, and “Data Stratification“. There is no charge for the software which can be downloaded and installed using a standard setup.exe. An Operation Guide is available with details, as well as online help.

Posted in Data Extraction, Audit Software | No Comments »

June 29, 2007 by Mike.Blakley.

I have established a web page devoted to sharing articles and ideas on IT auditing. Part of it consists of tutorial modules as shown below. Some are VBA classes for use within Excel, others pertain to use of the XL Audit Commander.

Posted in Data Extraction, Data Classification, Audit Software, Data Validation | No Comments »

April 8, 2007 by Mike.Blakley.

Excel is among the most common platforms for analysis by auditors, analysts and researchers. I have established a beta site for development/testing of various types of data extracts using PHP. In order to use this, upload your Excel data to the server and then code and test the PHP script to perform the analysis. Results are returned in a format that can then be pasted back into Excel. Examples and help screens are provided.

Posted in Data Extraction, Audit Software, Validation | No Comments »

November 20, 2006 by Mike.Blakley.

Proc CR is a procedure to facilitate cash recovery. Cash recovery from supplier overpayments is often possible regardless of how well the internal controls have been designed. Best practices and stringent controls can reduce duplicate invoice payments to less than half a percent. However, this error rate seems largely unaffected by automation. There are a variety of reasons why this is the case, e.g. multiple (non-integrated or non-communicating) systems, human error, intentional override, system failures, etc.

Posted in Data Extraction | No Comments »

November 20, 2006 by Mike.Blakley.

Merge two files based upon key field common to both files.

Posted in Data Extraction | No Comments »

November 20, 2006 by Mike.Blakley.

Shows an example of how to extract data from a file with fixed length records, using the ScriptBasic language.

Posted in Data Extraction | No Comments »