Forensic accounting: Use of CAATT

Teachers

Included in study programs

Teaching results

Upon finishing the course, the student will acquire knowledge, competences and skills necessary for a practice of an accounting professional conduct in order to detect irregularities and anomalies in accounting records with the use of computer assisted tools and techniques (CAATT), assessment of the findings and reporting of the final information.
Knowledge
The student will acquire knowledge on the anomalies and irregularities in accounting records, their relation to legal economic interests of respective stakeholders and the employment of (non)accounting data in their detection. In addition, he/she acquires knowledge on the securement of integration of processed and resulting records and on the requirements for their reporting to various stakeholder (including, but not limited to, bodies charged with control or governance over the entities, internal audit departments, statutory auditors, tax authors or police).
Competences
The student will be able to identify the requirements of respective stakeholders for checking the accounting records, to design both the procedures focused on the identification of anomalies and irregularities procedures for securing the integrity of the data and to communicate resulting findings to respective stakeholders in accordance with established criteria.
Skills
The student will be able to command the specific software for the computer assisted audit tools and techniques, to form and manages specific projects, to import the data from various environments and in different formats, to make their selection in accordance with distinct criteria, to make samples in accordance with established audit procedures, to document the process of acquisition and processing the data and to form a final report of the findings addressed to respective interested parties.

Indicative content

Scope and the content of forensic accounting, CAAT instruments and the IDEA software. Anomalies and irregularities in accounting records. Integrity of accounting data and the limits of the available office software in carrying out this requirement. CAATT and its application in the practice of an accounting professional. Management of analytical projects and protocols for the work with data.
Direct and indexed selection of data, selection of records with outliners and with key values. Selection of records with duplicates and gaps.
Summarization of data, age analysis and the use of the stratification.
Combination of partial data. Joining of data form the receivables ledger and bank account statements (example).
Equation editor: Character and numerical functions.
Equation editor: Date, matching, conditional and financial functions.
Sampling: random selection, systematic selection, stratified random selection and selection based on a monetary unit.
Pivot tables, Benford law and their applications in the IDEA software.
Ideascropt language. Use of the Idea software for the procession of accounting data form open sources

Support literature

1. TUMPACH, M. (2013). Forenzné účtovníctvo: využitie CAATT pri odhaľovaní ekonomickej kriminality. 1. vyd. Bratislava: EKONÓM. 145 s. ISBN 978-80-225-3579-3.
2. MUELLER, J. P. (2011). Mastering IDEAScript, with Website: The Definitive Guide. Hoboken: Wiley. ISBN 978-1118004487.

Syllabus

1. Zameranie a obsah forenzného účtovníctva, nástrojov CAATT a programu IDEA. Anomálie a nezrovnalosti v účtovných záznamoch. Požiadavka integrity účtovných dát a obmedzenia dostupných kancelárskych balíkov pri jej dodržiavaní. Nástroje CAATT a ich využite v praxi účtovného profesionála. 2. Správa analytických projektov a import údajov v rôznych elektronických formátoch a z naskenovaných dokumentov. Správa importovaných a vytváraných súborov. Záznam, stopy a opisné charakteristiky použitých analytických postupov. Práca so znakovými, dátumovými, časovými a číselnými poľami v programe IDEA. 3. Priamy výber údajov, indexovaný výber údajov, vyber podľa extrémnych a kľúčových hodnôt. Vyhľadávanie duplicít a prerušení radov. 4. Sumarizácia údajov, ich analýza podľa veku a využitie stratifikácie. 5. Zlučovanie parciálnych údajov. Párovanie údajov na príklade odberateľských faktúr a výpisov z bežného účtu. 6. Editor rovníc: Znakové a číselné funkcie 7. Editor rovníc: Dátumové, kriteriálne, podmienené a finančné funkcie 8. Výber vzorky: náhodný výber, systematický výber, stratifikovaný náhodný výber a výber podľa peňažných jednotiek 9. Využitie kontingenčných tabuliek v programe IDEA 10. Benfordov zákon a jeho aplikácia v programe IDEA 11. Tvorba mikroaplikácií s jazyka Ideascipt. Nástroj IdeaScript Editor, premenné a konštanty. Využitie podmienených výrazov, vykonávanie matematických operácií a práca s poľami. 12. Využitie Ideascipt na analýza dát. 13. Reporting of the findings

Requirements to complete the course

52 hours of seminars
26 hours of preparation for the seminars
26 hours of preparation for the continuous written essay (40 % of the overall grading)
26 hours of preparation for the final written exam (60 % of the overall grading)
Total study load (in hours): 130

Student workload

52 hours of seminars
26 hours of preparation for the seminars
26 hours of preparation for the continuous written essay (40 % of the overall grading)
26 hours of preparation for the final written exam (60 % of the overall grading)
Total study load (in hours): 130

Language whose command is required to complete the course

slovak

Date of approval: 10.02.2023

Date of the latest change: 15.05.2022