Forensic analytics : methods and techniques for forensic accounting investigations /: methods and techniques for forensic accounting investigations. (2020)

• Record Type: Book
• Further Information: Note: Mark Nigrini.
• Authors: Nigrini, Mark J (Mark John)
• Contents: List of Cases xiii About the Author xv Preface xvii Abbreviations xxi Analytics Software Used xxv Introduction 1 Temptation in an Occupation 2 Fraudulent Checks Written by the CFO 4 Fraudulent Purchases Made by a Purchasing Manager 7 Donna was a Gamblin’ Wreck at Georgia Tech 9 Forensic Analytics 11 An Overview of Tableau 13 The Risk Assessment Standards 19 Discussion 21 Chapter 1: Using Microsoft Excel for Forensic Analytics 23 The Fraud Types Relevant to Forensic Analytics 23 The Main Steps in a Forensic Analytics Application 25 The Final Report 27 An Overview of Excel 28 Importing Data into Excel 29 Some Useful Excel Formatting Features 30 Protecting Excel Spreadsheets 32 The Valuable "IF" Function 33 The PIVOTTABLE Routine 36 The Valuable VLOOKUP Function 38 Using Excel Results in Word Files 40 Excel Warnings and Indicators 42 Excel Dashboards 43 Dashboards in Practice 46 Summary 47 Chapter 2: The Initial High-Level Overview Tests 50 The Data Profile 51 The Histogram 56 The Periodic Graph 58 Descriptive Statistics 60 Preparing the Data Profile Using Excel 62 Preparing the Data Profile Using Access 64 Preparing the Histogram in Excel and Access 68 Preparing the Histogram in IDEA and Tableau 72 Preparing the Periodic Graph in Excel and Access 74 Summary 76 Chapter 3: Benford’s Law: The Basic Tests 79 An Overview of Benford’s Law 80 Some Early Discussions of Benford’s Law 83 Selected Articles from the Eighties 85 Selected Articles from the Nineties 88 Scenarios Under Which Data Should Conform to Benford 90 The Two Scenarios Under Which Accounting Data Sets Should Conform to Benford 93 Other Considerations for the Conformity of Accounting Data 94 Accounting Data Examples 95 Preparing the Benford Graph Using Excel 98 Preparing the Benford Graph Using Access 99 Summary 101 Chapter 4: Benford’s Law: Advanced Topics 103 Conformity and the Likelihood of Material Errors 103 The First Digits Versus the First-Two Digits 107 Measuring Conformity Using the Z-Statistic 109 The Chi-Square and the Kolmogorov-Smirnoff Tests of Conformity 111 The Mean Absolute Deviation (MAD) Test 112 The Effect of Data Set Size of Conformity to Benford 114 Using Benford’s Law in a Forensic Accounting Setting 116 Using Benford’s Law for Journal Entries in an External Audit 119 Using Benford for Subsidiary Ledger Balances in an External Audit 123 Preparing the Benford Graph in Excel 125 Summary 126 Chapter 5: Benford’s Law: Completing The Cycle 127 The Number Duplication Test 127 The Number Duplications in Accounting Textbooks 132 The Electric Utility Company Fraud Case 134 The Petty Cash Fraud Scheme 136 The Last-Two Digits Test 139 The Fraudulent Credit Card Sales Scheme 141 The Missing Cash Sales Case 142 Running the Number Duplication Test in Excel 144 Running the Number Duplication Test in Access 146 Running the Last-Two Digits Test in Excel 148 Running the Last-Two Digits Test in Access 149 Running the Number Duplication Test in R 151 Summary 153 Chapter 6: Identifying Anomalous Outliers: Part 1 154 The Summation Test 155 The Fraud That Was Red Flagged by Two Qualitative Outliers 158 The Largest Subsets Test 161 The Largest Subset Growth Test 165 The School District Transportation Fraud 168 The SkyBonus Fraud Scheme 170 Running the Summation Test in Excel 170 Running the Summation Test in Access 171 Running the Largest Subsets Test in Excel 172 Running the Largest Subsets Test in Access 173 Running the Largest Growth Test in Excel 174 Running the Largest Growth Test in Access 176 Running the Largest Subsets Test in R 179 Summary 180 Chapter 7: Identifying Anomalous Outliers: Part 2 182 Examples of Relative Size Factor Test Findings 184 The Scheme That Used a Vault That Was Over Capacity 186 The Scheme That Added Sold Cars to the Car Inventory Account 189 The Vice Chairman of the Board Who Stole 0.5 Percent of His Salary 193 Running the RSF Test in Excel 194 Running the RSF Test in Access 199 Running the RSF Test in SAS 208 Summary 212 Chapter 8: Identifying Abnormal Duplications 214 The Same-Same-Same Test 215 Duplicate Payments and Various Types of Fraud 217 The Same-Same-Different (Near-Duplicates) Test 220 The Near-Duplicates Fraud Scheme: Introduction 221 The Near-Duplicates Fraud: The Act 222 The Near-Duplicates Fraud: Getting the Legal Process Started 224 The Near-Duplicates Fraud: Two Sentencing Hearings 228 The Near-Duplicates Fraud: Epilogue 230 The Subset Number Duplication Test 231 Running the Same-Same-Same Test in Excel 233 Running the Same-Same-Different Test in Excel 235 Running the Subset Number Frequency Test in Excel 237 Running the Same-Same-Same Test in Access 239 Running the Same-Same-Different Test in Access 240 Running the Subset Number Frequency Test in Access 242 Summary 245 Chapter 9: Comparing Current Period and Prior Period Data: Part 1 247 A Review of Descriptive Statistics 249 An Analysis of the Purchasing Card Data 250 My Law: An Analysis of Payroll Data 255 An Analysis of Machine Learning Data 257 An Analysis of Grocery Store Sales 261 The Scheme That Used Bank Transfers to a Secret Bank Account 263 Running the Descriptive Statistics Tests in Excel 268 Running the Descriptive Statistics Tests in Minitab 269 Running the Descriptive Statistics Tests in SAS 270 Summary and Discussion 272 Chapter 10: Comparing Current Period and Prior Period Data: Part 2 274 Vectors and Measures of Change 275 An Analysis of the Purchasing Card Data 280 Taxpayer Identity Theft Refund Fraud 282 The Tax Return That Omitted a Million Dollar Prize 284 The Tax Returns for 2000 and 2001 285 The Indictment for Tax Evasion 291 The Tax Evasion Trial 292 The Verdict and Sentencing 298 An Analysis of Joe Biden’s Tax Returns 299 Running the VVS Test in SAS 303 Summary and Discussion 304 Chapter 11: Identifying Anomalies In Time-Series Data 306 An Analysis of the Purchasing Card Data 307 Using IDEA for Time-Series Analysis 311 The Fraud Scheme That Withdrew Funds from Customer Accounts 312 Employee Data Access After Termination 317 A Time-Series Analysis of Grocery Store Sales 321 Using Correlation to Detect Fraud and Errors 322 Using the Angle θ on Trial Balance Data 324 Using the VVS on Customer Rebates 327 Showing the VVS Results in a Dashboard 332 Running Time-Series Analysis in SAS 334 Summary and Discussion 336 Chapter 12: Scoring Forensic Units for Fraud Risk 338 An Overview of Risk Scoring 339 The Audit Selection Method of the IRS 340 The Fraudulent Vendor with a Post Office Box in the Head Office 344 Risk Scoring to Detect Vendor Fraud 348 Risk Scoring to Detect Errors in Sales Reports 354 The Predictors Used in the Sales Report Scoring Model
• Edition: Second edition
• Publisher Details: Hoboken, New Jersey : John Wiley & Sons, Inc
• Publication Date: 2020
• Extent: 1 online resource, illustrations
• Subjects: 363.25963; Forensic accounting; Fraud; Misleading financial statements
• Languages: English
• ISBNs: 9781119585909; 9781119585879
• Related ISBNs: 9781119585763
• Notes: Note: Includes bibliographical references and index.; Note: Description based on CIP data; resource not viewed.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.