Misplaced Pages

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

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
Browse history interactively← Previous editContent deleted Content addedVisualWikitext
Revision as of 16:59, 29 January 2014 editSomeone not using his real name (talk | contribs)11,896 edits Nominated for deletion; see Misplaced Pages:Articles for deletion/Comparison of specialized computer-aided audit tools. (TW)← Previous edit Latest revision as of 08:27, 16 February 2014 edit undoNickPenguin (talk | contribs)Extended confirmed users, Pending changes reviewers11,476 edits #redirect Computer-aided audit tools {{R from merge}}, per AfD 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
#redirect ] {{R from merge}}
<!-- Please do not remove or change this AfD message until the issue is settled -->
{{Article for deletion/dated|page=Comparison of specialized computer-aided audit tools|timestamp=20140129165928|year=2014|month=January|day=29|substed=yes|help=off}}
<!-- For administrator use only: {{Old AfD multi|page=Comparison of specialized computer-aided audit tools|date=29 January 2014|result='''keep'''}} -->
<!-- End of AfD message, feel free to edit beyond this point -->
{{Use dmy dates|date=May 2013}}
{{merge to|Computer-aided audit tools|date=July 2012}}
{{Technical|date=July 2012}}
This is a '''comparison of specialized ]''' (]) dedicated specialized data analytic software specifically for auditors.

==Comparison by specification==
{| class="wikitable sortable" style="text-align: left; font-size: 85%; width: auto; table-layout: fixed;"
|-
! style="width: 18em" | Product Name / Brand
! Developed by
! Latest stable version
! Latest release date
! OS
! ]
! ]
! Comments
|-
| ] || Arbutus Software || 5.5 || 2013-03-31 || ] || {{Nonfree|] ]}} || {{No}} ||
|-
| ] (ACL) || ACL Services Ltd. || 9.2 || 2011-09-18 || ] || {{Nonfree|] ]}} || {{No}} ||
|-
| ESKORT Computer Audit (SESAM) || Intrasoft International Scandinavia A/S || 7.7.1 || 2012-05-01 || ] || {{Nonfree|] ]}} || {{No}} || ''Requires Excel for showing graphs and result of ] analysis.''
|-
| ] (IDEA) || ]|| 9.1<ref name="idea9.1">{{cite web | title = IDEA Version 9.1 | url = http://www.auditware.co.uk/content/70/ideav9 | accessdate = 9 May 2013 }}</ref> || 2013-03-04 || ] || {{Nonfree|] ]}} || {{No}} ||
|-
| TopCAATs || Reinvent Data Ltd || 3.0.2 || 2013-09-06 || ] || {{Nonfree|] ]}} || {{No}} || ''Requires ] (TopCAATs is an Excel add-in)''
|}

==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).
#'''Benford's law''': Specifies whether the product supports finding abnormal distribution of specific digits accordingly to ].
#'''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.
#'''Drill-down (Table)''': Specifies whether the product supports ] features by zooming in (filtering) on selected rows in the table.
#'''Drill-down (Pivot)''': Specifies whether the product supports ] 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 instance, values compared are similar but not exactly the same (e.g., using ]).
#'''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 U.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 ] 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.

{| class="wikitable sortable" style="text-align: center; font-size: 85%; width: auto; table-layout: fixed;"
|-
! style="width: 18em" | Product Name
! Age Analysis
! ]
! 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
|-
| style="text-align: left" | ]|| {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}
|-
| style="text-align: left" | ] (ACL) || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{No}} || {{Yes}} || {{Yes}} || {{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}}
|-
| style="text-align: left" | ] (IDEA) || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}
|-
| style="text-align: left" | TopCAATs || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}
|}

==Comparison by other features==
#'''Audit log''': Specifies whether the product logs activity performed by the user (the auditor) for later reference (e.g., inclusion into audit report).
#'''Data graph''': Specifies whether the product provides graphs of results.
#'''Export (CSV)''': Specifies whether the product support exporting selected rows to a ] formatted file. Usually also implies capability to the clipboard (in CSV format) for pasting into applications supporting pasting from CSV files such as ].
#'''Export (DBF)''': Specifies whether the product support exporting (saving) selected rows to a dBase Table file.
#'''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.

{| class="wikitable sortable" style="text-align: center; font-size: 85%; width: auto; table-layout: fixed;"
|-
! style="width: 18em" | Product Name
! Audit log
! Data graph
! Export (CSV)
! Export (DBF)
! Export (Excel)
|-
| style="text-align: left" | ] || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}
|-
| style="text-align: left" | ] (ACL) || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}
|-
| style="text-align: left" | ESKORT Computer Audit (SESAM) || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}
|-
| style="text-align: left" | ] (IDEA) || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}
|-
| style="text-align: left" | TopCAATs || {{Yes}} || {{Yes}} || {{Yes}} || {{No}} || {{Yes}}
|}

==Comparison by data preparation features==
#'''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.
#'''Import wizard''': Specifies whether the product provides an import wizard to assist in importing (interpretation, conversion, formatting) data for analysis.
#'''Import (CSV)''': Specifies whether the product supports import data from a ] formatted file.
#'''Import (DBF)''': Specifies whether the product supports import data from ] DBF files.
#'''Import (Excel)''': Specifies whether the product supports import data from ] workbook file. Note that different Excel format versions may apply.
#'''Import (SAF-T)''': Specifies whether the product supports import data from an OECD ] file. As SAF-T is based on ] 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.
#'''Import (SIE)''': Specifies whether the product supports import data from a ] file.
#'''Import (XBRL-GL)''': Specifies whether the product supports import data from a ] file. As XBRL-GL is based on ] 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.

{| class="wikitable sortable" style="text-align: center; font-size: 85%; width: auto; table-layout: fixed;"
|-
! style="width: 18em" | Product Name
! Append/Merge
! Import wizard
! Import (CSV)
! Import (DBF)
! Import (Excel)
! Import (SAF-T)
! Import (SIE)
! Import (XBRL-GL)
|-
| style="text-align: left" | ]|| {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}
|-
| style="text-align: left" | ] (ACL) || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{?}} || {{?}} || {{Yes}}
|-
| style="text-align: left" | ESKORT Computer Audit (SESAM) || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{No}} || {{Yes}} || {{No}}
|-
| style="text-align: left" | ] (IDEA) || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}}<ref name="idea9.1"/> || {{Yes}} || {{Yes}} || {{Yes}}
|-
| style="text-align: left" | TopCAATs || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{Yes}} || {{?}} || {{Yes}}
|}

==Notes==
<References/>

==References==
* {{cite journal
| last = Lanza
| first = Rich
| title = Fraud data interrogation tools: Comparing best software for fraud examinations
| journal = Fraud Magazine
| date = November–December 2004
| url = http://www.informationactive.com/data/attachments/fraudsoftware.PDF }}
* {{cite web
| title = ESKORT Computer Audit (SESAM)
| url = http://www.eskort.eu/sesam
| accessdate = 7 July 2012 }}
* {{cite web
| title = IT-TECH FORUM
| url = http://forum.it-tech.com.br/
| accessdate = 17 July 2012 }}
* {{cite web
| title = Arbutus Software
| url = http://www.arbutussoftware.com/
| accessdate = 31 May 2013 }}
* {{cite web
| title = TopCAATs - Advanced Excel Auditing Made Easy
| url = http://www.topcaats.com/
| accessdate = 18 Oct 2013 }}



]

Latest revision as of 08:27, 16 February 2014

Redirect to:

  • From a merge: This is a redirect from a page that was merged into another page. This redirect was kept in order to preserve the edit history of this page after its content was merged into the content of the target page. Please do not remove the tag that generates this text (unless the need to recreate content on this page has been demonstrated) or delete this page.