You can edit almost every page by Creating an account. Otherwise, see the FAQ.

Comparison of specialized computer-aided audit tools

From EverybodyWiki Bios & Wiki

This is a comparison of specialized computer-aided audit tools (CAATs) dedicated specialized data analytic software specifically for auditors.

Comparison by specification[edit]

Product Name / Brand Developed by Latest stable version Latest release date OS Software license Open source Comments
Analyzer Arbutus Software 5.5 2013-03-31 Windows Proprietary commercial No
Audit Command Language (ACL) ACL Services Ltd. 9.2 2011-09-18 Windows Proprietary commercial No
ESKORT Computer Audit (SESAM) Intrasoft International Scandinavia A/S 7.7.1 2012-05-01 Windows Proprietary commercial No Requires Excel for showing graphs and result of Benford law analysis.
Interactive Data Extraction and Analysis (IDEA) CaseWare International Inc. 9.1[1] 2013-03-04 Windows Proprietary commercial No
TopCAATs Reinvent Data Ltd 3.0.2 2013-09-06 Windows Proprietary commercial No Requires Microsoft Excel (TopCAATs is an Excel add-in)

Comparison by analysis features[edit]

The following table compares features of specialized computer-aided audit tools. The table has several fields, as follows:

  1. Product Name: Product's name; sometime includes edition if a certain edition is targeted.
  2. Age analysis: Specifies whether the product supports making age analysis (stratification by date).
  3. Benford's law: Specifies whether the product supports finding abnormal distribution of specific digits accordingly to Benford's law.
  4. Calculated field: Specifies whether the product supports adding extra calculated fields into the table/file. Usually implies using an expression builder feature to build up expressions for defining the field calculation.
  5. Drill-down (Table): Specifies whether the product supports drill-down features by zooming in (filtering) on selected rows in the table.
  6. Drill-down (Pivot): Specifies whether the product supports drill-down features through pivot table.
  7. Matching: Specifies whether the product supports finding matching items for a specific field in a table/file. For example, this could be used to find duplicate billings of invoices within the sales ledger.
  8. Matching (Fuzzy): Specifies whether the product supports finding matching items for a specific field using fuzzy comparison. For instance, values compared are similar but not exactly the same (e.g., using Levenshtein matching).
  9. Sample (Random): Specifies whether the product supports selecting a random sample of rows from the table/file (population).
  10. Sample (Monetary unit): Specifies whether the product supports selecting a monetary unit sample of rows from the table/field (population). This is also known as dollar-unit sampling (when values are in U.S. currency).
  11. Sequence check (Gap): Specifies whether the product supports can find (identify) gabs (in sequences) for a specific field. For example, finding a broken sequence in an invoice number sequence.
  12. Sort field: Specifies whether the product supports sorting (indexing) by a specific field (column). Sorting helps identifying blank/empty values or excessive (out-of-band) values.
  13. Sort multiple fields: Specifies whether the product supports sorting by multiple fields (columns).
  14. Statistics: Specifies whether the product supports calculation and presentation of various statistics on a specific field (e.g., for a numeric fields values such as total number of positive numbers, total number negative numbers, average value (balance), etc.)
  15. Stratification: Specifies whether the product supports stratification on number (amount) values in specified intervals. Splits the population into strata (intervals) and aggregates (summarizes) values. Can be used to find largest, smallest and average amount transactions (rows).
  16. Total row: Specifies whether the products supports displaying a total row for the table/file, e.g. accumulated numerical value.
Product Name Age Analysis Benfords Law Calculated field Drill-down (Table) Drill-down (Pivot) Matching Matching (Fuzzy) Sample (Random) Sample (Monetary unit) Sequence Check (Gap) Sort field Sort multiple fields Statistics Stratification Total row
Analyzer - Arbutus Software Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
Audit Command Language (ACL) Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes Yes Yes
ESKORT Computer Audit (SESAM) No Yes Yes Yes No Yes No Yes Yes Yes Yes Yes Yes Yes Yes
Interactive Data Extraction and Analysis (IDEA) Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes
TopCAATs Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes

Comparison by other features[edit]

  1. Audit log: Specifies whether the product logs activity performed by the user (the auditor) for later reference (e.g., inclusion into audit report).
  2. Data graph: Specifies whether the product provides graphs of results.
  3. Export (CSV): Specifies whether the product support exporting selected rows to a comma-separated values formatted file. Usually also implies capability to the clipboard (in CSV format) for pasting into applications supporting pasting from CSV files such as Excel.
  4. Export (DBF): Specifies whether the product support exporting (saving) selected rows to a dBase Table file.
  5. Export (Excel): Specifies whether the product support exporting (saving) selected rows to an Excel file. Usually also implies capability to copy the rows to the clipboard (in some format) for pasting into Excel.
Product Name Audit log Data graph Export (CSV) Export (DBF) Export (Excel)
Analyzer - Arbutus Software Yes Yes Yes Yes Yes
Audit Command Language (ACL) Yes Yes Yes Yes Yes
ESKORT Computer Audit (SESAM) Yes Yes Yes Yes Yes
Interactive Data Extraction and Analysis (IDEA) Yes Yes Yes Yes Yes
TopCAATs Yes Yes Yes No Yes

Comparison by data preparation features[edit]

  1. Append/Merge: Specifies whether the product can combine two tables/files with identical fields into a single table/file. For example it could be doing a merge of two years of accounts payable tables/files into a single table/file.
  2. Import wizard: Specifies whether the product provides an import wizard to assist in importing (interpretation, conversion, formatting) data for analysis.
  3. Import (CSV): Specifies whether the product supports import data from a comma-separated values formatted file.
  4. Import (DBF): Specifies whether the product supports import data from dBase DBF files.
  5. Import (Excel): Specifies whether the product supports import data from Microsoft Excel workbook file. Note that different Excel format versions may apply.
  6. Import (SAF-T): Specifies whether the product supports import data from an OECD SAF-T file. As SAF-T is based on XML a more general XML import may cover the feature although direct SAF-T import improves the user experience. Note that different SAF-T format versions may apply.
  7. Import (SIE): Specifies whether the product supports import data from a SIE format file.
  8. Import (XBRL-GL): Specifies whether the product supports import data from a XBRL GL file. As XBRL-GL is based on XML a more general XML import may cover the feature although direct XBRL-GL import improves the user experience. Note that different XBRL-GL format versions may apply.
Product Name Append/Merge Import wizard Import (CSV) Import (DBF) Import (Excel) Import (SAF-T) Import (SIE) Import (XBRL-GL)
Analyzer - Arbutus Software Yes Yes Yes Yes Yes Yes Yes Yes
Audit Command Language (ACL) Yes Yes Yes Yes Yes ? ? Yes
ESKORT Computer Audit (SESAM) Yes Yes Yes Yes Yes No Yes No
Interactive Data Extraction and Analysis (IDEA) Yes Yes Yes Yes Yes[1] Yes Yes Yes
TopCAATs Yes Yes Yes Yes Yes Yes ? Yes

Notes[edit]

  1. 1.0 1.1 "IDEA Version 9.1". Retrieved 9 May 2013.

References[edit]


This article "Comparison of specialized computer-aided audit tools" is from Wikipedia. The list of its authors can be seen in its historical. Articles copied from Draft Namespace on Wikipedia could be seen on the Draft Namespace of Wikipedia and not main one.