Forensic Analytics

Beschreibung

Forensic Analytics Methods and Techniques for Forensic Accounting Investigations Forensic analytics is the use of electronic data to reconstruct or detect financial fraud. The process of forensic analytics is made up of data collection and preparation, data analysis, and the preparation of a fraud report and the possible presentation of the results. In Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations, author Mark Nigrini reviews the use of Microsoft Access and Excel in a forensic setting, together with many rigorous analytical procedures to detect employee fraud, biases, and other irregularities including errors. The book includes a comprehensive chapter on financial statement fraud, and the concluding chapter on credit/debit purchasing card fraud shows an authentic dashboard used by a Fortune 100 company. Nigrini devotes three chapters to a review of the use of Access, Excel, and PowerPoint in a forensic setting. The next eleven chapters discuss data interrogation tests that could be used in a forensic setting to detect employee fraud, biases, and errors. In each chapter, the tests are discussed in general terms and are then demonstrated using case studies with real data. In addition, the steps needed to run the tests are illustrated with screenshots from Access and Excel. Two chapters review, with examples, a risk-scoring technique that can be used to score divisions, agents, or locations for fraud risk. A full chapter presents various tests, along with real-world examples and case studies, to detect financial statement fraud. The concluding chapter is a case study showing an analysis of purchasing card data using selected tests from the prior chapters, and a presentation of the findings. The companion website (www.nigrini.com/ForensicAnalytics.htm) has all the data tables used in the book, available for download. Along with notes and updates related to the book, the website also includes end-of-chapter problems and assignments for use by instructors, together with PowerPoint slides for presentations.
Discover how to detect fraud, biases, or errors in your data using Access or Excel With over 300 images, Forensic Analytics reviews and shows how twenty substantive and rigorous tests can be used to detect fraud, errors, estimates, or biases in your data. For each test, the original data is shown with the steps needed to get to the final result. The tests range from high-level data overviews to assess the reasonableness of data, to highly focused tests that give small samples of highly suspicious transactions. These tests are relevant to your organization, whether small or large, for profit, nonprofit, or government-related. * Demonstrates how to use Access, Excel, and PowerPoint in a forensic setting * Explores use of statistical techniques such as Benford's Law, descriptive statistics, correlation, and time-series analysis to detect fraud and errors * Discusses the detection of financial statement fraud using various statistical approaches * Explains how to score locations, agents, customers, or employees for fraud risk * Shows you how to become the data analytics expert in your organization Forensic Analytics shows how you can use Microsoft Access and Excel as your primary data interrogation tools to find exceptional, irregular, and anomalous records.

Autor*in

Mark Nigrini

Themen in »Forensic Analytics«

Accounting Accounting Technology Forensik Rechnungswesen Rechnungswesen / Technologie

Stimmen zu »Forensic Analytics«

"Golden, a recognized, practice management advisor and marketing specialist I social media use and strategy, particularly in the Certified Public Accountant field, has written an accessible, comprehensive guidebook to social media for professionals and their firms with an emphasis on the accounting and legal industries. She sets forth a one-stop, reference handbook that can be read from cover-to-cover or by chapter, as needed." (Security Management)
()

Details

Link teilen