WebCAAT System

WebCAAT is an open source software system which provides data analytics support for auditors. Listed below are links to documents which explain how the system works and its features.
The software can be freely downloaded . The latest version is 3.21 which was released on 2012-10-14. It is approximately 296 MB in size. To install, download the software and unzip. To run the software, double click the executable "server2go.exe" in the root folder named "Server2Go". Default id and password to sign-in are "audit1".
The software license is LGPL3, and there is no license cost for the software. The software can be freely used for commercial, educational or personal purposes.
Questions or comments? I can be reached at Mike.Blakley@ezrstats.com
Document Description
Short video tutorials (You Tube)
Installation, start-up and shut down
Basic Web CAAT operations
Auditing property records
Monetary unit sampling
Excess or obsolete inventory
Latest documents
Working with data in Excel
Charting data with Web CAAT
Downloading and restoring Web CAAT data from the Intermet
Backing up the Web CAAT script files
Working with Scripts
Course information
CourseAbout.pdf
CourseAgenda-082012.pdf
CourseSchedule.pdf
Course Objectives-082012.pdf
Sampling
Attribute Sampling made Simple.pdf
Attribute Sampling.pdf
Monetary Unit Sampling Objectives.pdf
Monetary Unit Sampling made Simple.pdf
Monetary_unit_sampling.pdf
Penny Sampling.pdf
Variable Sampling made Simple.pdf
Variable Sampling.pdf
Application testing
Testing Accounts Receivable Records.pdf
Testing Benfords Law - Step by Step.pdf
Testing for Employee Vendors.pdf
Testing Journal Entries.pdf
Testing Payroll Records.pdf
Testing Property Records.pdf
Identifying Excess or obsolete inventory.pdf
Objectives - Auditing property records.pdf
Auditing Depreciation.pdf
Auditing fixed asset records.pdf
Auditing for duplicates.pdf
Auditing Inventory Records.pdf
About.pdf
Same, Same, Different Test.pdf
Audit tests using criteria.pdf
Auditing Procurement Cards.pdf
Auditing the Vendor master File.pdf
Auditing_for_Duplicate_Payments.pdf
Auditing_for_Duplicate_Payments.ppt
Auditors_guide_to_Duplicate_Payments.pdf
Auditors_guide_To_Duplicate_Vendors.pdf
Collaboration with Web CAAT on an Intranet.pdf
Comparative trend analysis using linear regression.pdf
Contact info.pdf
Continuous Monitoring using linear regression.pdf
Data import by pasting from Excel.pdf
Detection of Ghost Employees.pdf
Developing a transaction scoring system.pdf
Excess and Obsolete Inventory.pdf
Firewalls and Web CAAT.pdf
Course description - Data analysis for auditors
Formatting data in Excel for import.pdf
Fraud_detection_using_analytics.pdf
Duplicates
Duplicate_Payments_UserGuide.pdf
Identifying Duplicate transactions.pdf
Identifying duplicates using fuzzy matching.pdf
Data Import
Importing data from a file in comma separated value format.pdf
Importing data into the system from text files.pdf
Importing date values in various formats.pdf
Installation on a Macintosh
MAMP.pdf
MAMPandWebcaat.pdf
MAMPhtdocs.pdf
Articles
The fastest urologist in Texas.pdf
The hardest working man in the Show Me State.pdf
Matching Test using many to many join.pdf
Medicare Fraud in South Florida.pdf
Overview
Menu System.pdf
Logging in to the system.pdf
Other tests
Obtaining transaction control totals.pdf
POBox addresses.pdf
Practical application of Benfords law.pdf
Preparing a schedule using data extraction.pdf
Preventing duplicate payments.pdf
Procurement Card Fraud - NIH.pdf
Quantificiation of errors.pdf
Reconciling_accounts_on_an_automated_basis.pdf
Registration Instructions.pdf
Running the system on DVD.pdf
Script-Duplicate-Check.pdf
SQL as an audit tool.pdf
Starting the Web CAAT system.pdf
Summarizing Calculated Amounts.pdf
TE Fraud based on duplicates.pdf
Testing Accounts Payable Records.pdf
Testing_for_Duplicate_Payments.pdf
Testing_price_variations_for_goods_purchased.pdf
Transaction scoring narrative.pdf
Unix Installation procedures.pdf
Uploading data to the server.pdf
Use of Spike Analysis.pdf
Using frequencies as an audit tool.pdf
Validation of uploaded data.pdf
Vendor Master File Integrity Testing.pdf
Wake County Transportation fraud.pdf
Web CAAT and Joomla.pdf
Web CAAT forms.pdf
Web CAAT provides 12 Numeric procedures.pdf
Web CAAT server security.pdf
Web CAAT sign-in.pdf
Web CAAT software downloads.pdf
Web CAAT table selection.pdf
WebCAAT_UserGuide.pdf
What are tables and how are they selected.pdf
Working with Large Files.pdf
Scripts
Identification of outliers
Schedule of round number transactions
Data classification using a hirsotgram
Identification of duplicates
Tests using Benford's Law
006 Spike Analysis.pdf
Transactions on a holiday
Selection of transactions within a date range
Run an SQL statement
009 - DateNear.pdf
010 - Frequency.pdf
011 - Pareto.pdf
012 - LinearRegression.pdf
013 - AccountsReceivable.pdf
014 - Extremes.pdf
015 - Ageing.pdf
016 - Ageing By.pdf
017 - Summary.pdf
018 - Univariate.pdf
019 - BasicPopStats.pdf
020 - Stratify.pdf
021 - DuplicateInvoices.pdf
022 - Diagnostic.pdf
023 - CTA.pdf
024 - Distinct.pdf
025 - DateGap.pdf
026 - MT.pdf
027 - POBox.pdf
028 - CI.pdf
029 - VEM.pdf
030 - MUS.pdf
031 - Join.pdf
032 - OE.pdf
033 - SeqInv.pdf
034 - SKU.pdf
035 - Spike.pdf
036 - Union.pdf
037 - Trend.pdf
038 - BenBy.pdf
039 - DataImport.pdf
040 - FA.pdf
041 - AP.pdf
042 - PY.pdf
043 - JE2.pdf
Hamlets Mind
April 2013
February 2013
December 2012
October 2012
August 2012
June 2012
April 2012
February 2012
December 2011
October 2011
August 2011
June 2011
April 2011
February 2011
December 2010
October 2010
August 2010
June 2010
April 2010
February 2010
December 2009
October 2009
August 2009
June 2009
April 2009
February 2009
October 2008