Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations

  • 8h 4m
  • Mark J. Nigrini
  • John Wiley & Sons (US)
  • 2011

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.

About the Author

Mark J. Nigrini, PhD, is an Associate Professor at The College of New Jersey, where he teaches auditing and forensic accounting. His current research addresses forensic and continuous monitoring techniques and advanced theoretical work on Benford's Law. Dr. Nigrini has published his Benford's Law and forensic accounting research in academic journals and in professional accounting and auditing publications. He has been interviewed on radio and television and his work has been discussed in publications including the Wall Street Journal and the New York Times.

In this Book

  • Using Access in Forensic Investigations
  • Using Excel in Forensic Investigations
  • Using PowerPoint in Forensic Presentations
  • High-Level Data Overview Tests
  • Benford's Law: The Basics
  • Benford's Law: Assessing Conformity
  • Benford's Law: The Second-Order and Summation Tests
  • Benford's Law: The Number Duplication and Last-Two Digits Tests
  • Testing the Internal Diagnostics of Current Period and Prior Period Data
  • Identifying Fraud Using the Largest Subsets and Largest Growth Tests
  • Identifying Anomalies Using the Relative Size Factor Test
  • Identifying Fraud Using Abnormal Duplications within Subsets
  • Identifying Fraud Using Correlation
  • Identifying Fraud Using Time-Series Analysis
  • Fraud Risk Assessments of Forensic Units
  • Examples of Risk Scoring with Access Queries
  • The Detection of Financial Statement Fraud
  • Using Analytics on Purchasing Card Transactions