Computer-aided audit tools: Difference between revisions

Content deleted Content added
m - extra tag
 
(23 intermediate revisions by 12 users not shown)
Line 1:
{{Short description|Data analysis software}}
{{Essay-like|article|date=August 2009}}
 
{{Multiple issues|
'''Computer-assisted audit tool''' (CAATs) or '''computer-assisted audit tools and techniques''' (CAATs) is a growing field within the IT audit profession. CAATs is the practice of using computers to automate the IT audit processes. CAATs normally include using basic office [[productivity software]] such as [[spreadsheet|spreadsheets]], [[word processors]] and text editing programs and more advanced software packages involving use [[statistical analysis]] and [[business intelligence]] tools. But also more dedicated [[#Specialized software|specialized software]] are available (see below).
{{Essay-like|article|date=August 2009}}
{{Cleanup rewrite|date=December 2023}}
}}
'''Computer-assisted audit tool''' (CAATs) or '''computer-assisted audit tools and techniques''' (CAATsCAATTs) is a growing field within the IT audit profession. CAATs is the practice of using computers to automate the IT audit processes. CAATs normally include using basic office [[productivity software]] such as [[spreadsheet|spreadsheets]], [[word processors]] and text editing programs and more advanced software packages involving use [[statistical analysis]] and [[business intelligence]] tools. But also more dedicated [[#Specialized software|specialized software]] are available (see below).
 
CAATs have become synonymous with [[data analytics]] in the audit process.
Line 17 ⟶ 20:
===Traditional audit vs CAATTs on specific risks===
 
Another advantage of CAATTs is that it allows auditors to test for specific risks. For example, an insurance company may want to ensure that it doesn't pay any claims after a policy is terminated. Using traditional audit techniques this risk would be very difficult to test. The auditor would "randomly select" a "statistically valid" sample of claims (usually e if any of those claims were processed after a policy was terminated). Since the insurance company might process millions of claims the odds that any of those 30–50 "randomly selected" claims occurred after the policy was terminated is extremely unlikely.
 
Using CAATTs the auditor can select every claim that had a date of service after the policy termination date. The auditor then can determine if any claims were inappropriately paid. If they were, the auditor can then figure out why the controls to prevent this failure. In a real-life audit, the CAATTs auditor noted that several claims had been paid after policies were terminated. Using CAATTs the auditor was able to identify every claim that was paid and the exact dollar amount incorrectly paid by the insurance company. Furthermore, the auditor was able to identify the reason why these claims were paid. The reason why they were paid was because the participant paid their premium. The insurance company, having received a payment, paid the claims. Then after paying the claim the participant's check bounced. When the check bounced, the participant's policy was retrospectively terminated, but the claim was still paid costing the company hundreds of thousands of dollars per year.
Line 55 ⟶ 58:
 
===CAATs Courses===
CAATs are the fundamental tool that is used by the auditors. This tool facilitates them to make search from the irregularities from the given data. With the help of this tool, the auditors and accountants of any firm will be able to provide more analytical results. These tools are used throughout every business environment and also in the industry sectors too. With the help of computer-assisted audit techniques, more forensic accounting with more analysis can be done. It’s really a helpful tool that helps the firm auditor to work in an efficient and productive manner. Working with the CAATs, it is essential for the accountant or the auditor to select the right data, the selection process is very much tricky, and you need to be professional for it. After selecting the right data, import that to the CAATs, now the tool will automatically generate the analytical data. This tool contributes to the efficiency of the auditors. The fundamental course outline <ref>International Computer Auditing Education Association (ICAEA), "CAATs (Computer Assisted Audit Techniques) Courses", {{cite web |url=http://www.iacae.org/English/Training/CAATs_Courses.php |title=Archived copyICAEA--Training |accessdate=2015-02-26 |url-status=dead |archiveurl=https://web.archive.org/web/20150205182521/http://www.iacae.org/English/Training/CAATs_Courses.php |archivedate=2015-02-05 }}</ref> include:
* Computer Auditing Overview
* Legal and Ethical Issues for Computer Auditors
Line 78 ⟶ 81:
===Creation of electronic work papers===
 
Keeping electronic work papers on a centralized audit file or database will allow the auditor to navigate through current and archived working papers with ease. The database will make it easier for auditors to coordinate current audits and ensure they consider findings from prior or related projects. Additionally, the auditor will be able to electronically standardize audit forms and formats, which can improve both the quality and consistency of the audit working papers.'''
 
===Fraud detection===
Line 101 ⟶ 104:
CAATTs and CAATs are used interchangeably. While CAATs has emerged as the more common spelling, CAATTs is the more precise acronym. The acronym CAATTs solves one of the two problems with defining the acronym. CAATs means:
 
'''C'''omputer '''A'''ided (or '''A'''ssisted) '''A'''udit '''T'''echniques (or '''T'''ools and '''T'''echniques)
 
The first "A" and the "T" can have two different meanings depending on who uses the term. By using the term CAATTs, one is clearly incorporating both "Tools" AND "Techniques."
Line 125 ⟶ 128:
| [[Easy2Analyse]] || QDAC.net. || 4.3 || 2015-05-15 || [[Windows]] || {{Nonfree|[[Proprietary software|Proprietary]] [[Commercial software|commercial]]}} || {{No}} ||Available in full and auditfiles version
|-
| Intrasoft Audit Support Computer Audit (Formerly known as ESKORT / SESAM) || Intrasoft International || 7.05<ref name="sesam78">{{cite web | title=Intrasoft COMPLIANCE Audit Support 7.0 | url=https://compliance.intrasoft-intl.com/| date=2021-09-02 | accessdate= 2021-09-02 }}</ref> || 2021-03-31 || [[Windows]] || {{Nonfree|[[Proprietary software|Proprietary]] [[Commercial software|commercial]]}} || {{No}} || ''Requires Excel for showing graphs and result of [[Benford law]] analysis.''
|-
| [[InfoZoom]] || humanIT || 9.0.5 || 2016-11-07 || [[Windows]] || {{Nonfree|[[Proprietary software|Proprietary]] [[Commercial software|commercial]]}} || {{No}} ||
|-
| [[Interactive Data Extraction and Analysis]] (IDEA) || [[CaseWare International| CaseWare International Inc.]]|| 11.1<ref name="idea9.1">{{cite web|url=https://casewareanalytics.com/blog/product-close-whats-new-idea-102|title=IDEA Version 10.2|last=|first=|date=|website=|accessdate=9 May 2013}}</ref> || 2016-10-26 || [[Windows]] || {{Nonfree|[[Proprietary software|Proprietary]] [[Commercial software|commercial]]}} || {{No}} ||
|-
| TeamMate Analytics (formerly TopCAATs) || Wolters Kluwer || 5.1 || 2017-09-18 || [[Windows]] || {{Nonfree|[[Proprietary software|Proprietary]] [[Commercial software|commercial]]}} || {{No}} || ''Requires [[Microsoft Excel]] (TeamMate Analytics runs within Excel)''