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

Revision as of 00:44, 25 August 2012

Revision as of 19:47, 11 December 2012

Line 24:

==Comparison by analysis features==

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

#'''Product Name''': Product's name; sometime includes edition if a certain edition is targeted.

#'''Age analysis''': Specifies whether the product supports making age analysis (stratification by date).

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

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

#'''Drill-down (Table)''': Specifies whether the product supports [[drill-down]] features by zooming in (filtering) on selected rows in the table.

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

#'''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.

#'''Matching (Fuzzy)''': Specifies whether the product supports finding matching items for a specific field using fuzzy comparison. -For i.e.instance, 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 USU.S. currency).

#'''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.

#'''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.

#'''Sort multiple fields''': Specifies whether the product supports sorting by multiple fields (columns).

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

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

#'''Total row''': Specifies whether the products supports displaying a total row for the table/file, e.g. accumulated numerical value.