Comparison of specialized computer-aided audit tools: Difference between revisions

Revision as of 14:50, 6 July 2012

Revision as of 15:12, 6 July 2012

Line 26:

#'''Benfords law''': Specifies whether the product supports finding abnormal distribution of specific digits accordingly to [[Benfords law]].

#'''Calculated field''': Specifies whether the product support adding extra calculated fields into the table/file. Usually implies using an expression builder feature to build up expressions for defining the field calculation.

#'''Duplicates''': Specifies whether the product supports finding duplicate items within a specific field in a table/file. For example this could be used to find duplicate billings of invoices within the sales ledger.

#'''Duplicates (Fuzzy)''': Specifies whether the product supports finding duplicate items for a specific field using fuzzy comparison - i.e. values compared are similar but not exactly the same (e.g. using [[Levenshtein_distance|Levenshtein matching]]).

#'''Drill-down (Table)''': Specifies whether the product supports [[drill-down]] features by table.

#'''Drill-down (Pivot)''': Specifies whether the product supports [[drill-down]] features through pivot table.

#'''DuplicatesMatching''': Specifies whether the product supports finding duplicatematching items withinfor a specific field in a table/file. For example this could be used to find duplicate billings of invoices within the sales ledger.

#'''DuplicatesMatching (Fuzzy)''': Specifies whether the product supports finding duplicatematching items for a specific field using fuzzy comparison - i.e. values compared are similar but not exactly the same (e.g. using [[Levenshtein_distance|Levenshtein matching]]).

#'''Sample (Random)''': Specifies whether the product supports selecting a random sample of rows from the table/file (population).

#'''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 US currency).

Line 45:

! [[Benfords Law]]

! Calculated field

! Duplicates

! Duplicates (Fuzzy)

! Drill-down (Table)

! Drill-down (Pivot)

! Matching

! DuplicatesMatching (Fuzzy)

! Sample (Random)

! Sample (Monetary unit)

Line 58:

! Total row

|-

| style="text-align: left" | [[Audit Command Language]] (ACL) || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes?}} || {{No?}} || {{?Yes}} || {{?No}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{?}} || {{Yes}} || {{Yes}} || {{?}}

|-

| style="text-align: left" | [[ESKORT Computer Audit]] (SESAM) || {{No}} || {{Yes}} || {{Yes}} || {{Yes}} || {{No}} || {{Yes}} || {{No}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}