Book Description
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 highlevel 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 governmentrelated.
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 timeseries 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.
Table of Contents
 Cover
 Title Page
 Copyright
 Dedication
 Preface
 About the Author
 Chapter 1: Using Access in Forensic Investigations
 Chapter 2: Using Excel in Forensic Investigations
 Chapter 3: Using PowerPoint in Forensic Presentations
 Chapter 4: HighLevel Data Overview Tests
 Chapter 5: Benford's Law: The Basics
 Chapter 6: Benford's Law: Assessing Conformity
 Chapter 7: Benford's Law: The SecondOrder and Summation Tests
 Chapter 8: Benford's Law: The Number Duplication and LastTwo Digits Tests
 Chapter 9: Testing the Internal Diagnostics of Current Period and Prior Period Data
 Chapter 10: Identifying Fraud Using the Largest Subsets and Largest Growth Tests
 Chapter 11: Identifying Anomalies Using the Relative Size Factor Test

Chapter 12: Identifying Fraud Using Abnormal Duplications within Subsets
 The SameSameSame Test
 The SameSameDifferent Test
 The Subset Number Duplication Test
 Running the SameSameSame Test in Access
 Running the SameSameDifferent Test in Access
 Running the Subset Number Duplication Test in Access
 Running the SameSameSame Test in Excel
 Running the SameSameDifferent Test in Excel
 Running the Subset Number Duplication Test in Excel
 Summary

Chapter 13: Identifying Fraud Using Correlation
 The Concept of Correlation
 Correlation Calculations
 Using Correlation to Detect Fraudulent Sales Numbers
 Using Correlation to Detect Electricity Theft
 Using Correlation to Detect Irregularities in Election Results
 Detecting Irregularities in Pollution Statistics
 Calculating Correlations in Access
 Calculating the Correlations in Excel
 Summary

Chapter 14: Identifying Fraud Using TimeSeries Analysis
 TimeSeries Methods
 An Application Using Heating Oil Sales
 An Application Using Stock Market Data
 An Application Using Construction Data
 An Analysis of Streamflow Data
 Running TimeSeries Analysis in Excel
 Calculating the Seasonal Factors
 Running a Linear Regression
 Fitting a Curve to the Historical Data
 Calculating the Forecasts
 Summary

Chapter 15: Fraud Risk Assessments of Forensic Units
 The Risk Scoring Method
 The Forensic Analytics Environment
 A Description of the RiskScoring System
 P1: High Food and Supplies Costs
 P2: Very High Food and Supplies Costs
 P3: Declining Sales
 P4: Increase in Food Costs
 P5: Irregular Seasonal Pattern for Sales
 P6: Round Numbers Reported as Sales Numbers
 P7: Repeating Numbers Reported as Sales Numbers
 P8: Inspection Rankings
 P9: High Receivable Balance
 P10: Use of Automated Reporting Procedures
 Final Results
 An Overview of the Reporting System and Future Plans
 Some Findings
 Discussion
 Summary
 Chapter 16: Examples of Risk Scoring with Access Queries
 Chapter 17: The Detection of Financial Statement Fraud

Chapter 18: Using Analytics on Purchasing Card Transactions
 Purchasing Cards
 The National Association of Purchasing Card Professionals
 A Forensic Analytics Dashboard
 An Example of Purchasing Card Data
 HighLevel Data Overview
 The FirstOrder Test
 The Summation Test
 The LastTwo Digits Test
 The SecondOrder Test
 The Number Duplication Test
 The Largest Subsets Test
 The SameSameSame Test
 The SameSameDifferent Test
 The Relative Size Factor Test
 Conclusions with Respect to Card Purchases
 A Note on Microsoft Office
 A Note on the Forensic Analytic Tests
 Conclusion
 References
 Index
Product Information
 Title: Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations
 Author(s):
 Release date: June 2011
 Publisher(s): Wiley
 ISBN: 9780470890462