Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations / Edition 1

Hardcover (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $55.60
Usually ships in 1-2 business days
(Save 44%)
Other sellers (Hardcover)
  • All (13) from $55.60   
  • New (8) from $55.60   
  • Used (5) from $57.89   


Forensic Analytics Methods and Techniques for Forensic AccountingInvestigations

Forensic analytics is the use of electronic data to reconstructor detect financial fraud. The process of forensic analytics ismade up of data collection and preparation, data analysis, and thepreparation of a fraud report and the possible presentation of theresults.

In Forensic Analytics: Methods and Techniques for ForensicAccounting Investigations, author Mark Nigrini reviews the useof Microsoft Access and Excel in a forensic setting, together withmany rigorous analytical procedures to detect employee fraud,biases, and other irregularities including errors. The bookincludes a comprehensive chapter on financial statement fraud, andthe concluding chapter on credit/debit purchasing card fraud showsan 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 elevenchapters discuss data interrogation tests that could be used in aforensic setting to detect employee fraud, biases, and errors. Ineach chapter, the tests are discussed in general terms and are thendemonstrated using case studies with real data. In addition, thesteps needed to run the tests are illustrated with screenshots fromAccess and Excel. Two chapters review, with examples, arisk-scoring technique that can be used to score divisions, agents,or locations for fraud risk.

A full chapter presents various tests, along with real-worldexamples and case studies, to detect financial statement fraud. Theconcluding chapter is a case study showing an analysis ofpurchasing card data using selected tests from the prior chapters,and a presentation of the findings.

The companion website ( all the data tables used in the book, available for download.Along with notes and updates related to the book, the website alsoincludes end-of-chapter problems and assignments for use byinstructors, together with PowerPoint slides for presentations.

Read More Show Less

Editorial Reviews

From the Publisher
"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)
Read More Show Less

Product Details

  • ISBN-13: 9780470890462
  • Publisher: Wiley
  • Publication date: 6/7/2011
  • Series: Wiley Corporate F&A Series, #558
  • Edition number: 1
  • Pages: 480
  • Sales rank: 759,648
  • Product dimensions: 7.10 (w) x 10.00 (h) x 1.60 (d)

Meet 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.

Read More Show Less

Table of Contents

Preface xi

About the Author xv

Chapter 1: Using Access in Forensic Investigations 1

An Introduction to Access 2

The Architecture of Access 4

A Review of Access Tables 6

Importing Data into Access 8

A Review of Access Queries 10

Converting Excel Data into a Usable Access Format 13

Using the Access Documenter 20

Database Limit of 2 GB 24

Miscellaneous Access Notes 24

Summary 25

Chapter 2: Using Excel in Forensic Investigations 27

Pitfalls in Using Excel 28

Importing Data into Excel 30

Reporting Forensic Analytics Results 32

Protecting Excel Spreadsheets 34

Using Excel Results in Word Files 36

Excel Warnings and Indicators 40

Summary 41

Chapter 3: Using PowerPoint in Forensic Presentations43

Overview of Forensic Presentations 44

An Overview of PowerPoint 44

Planning the Presentation 45

Color Schemes for Forensic Presentations 46

Problems with Forensic Reports 50

Summary 61

Chapter 4: High-Level Data Overview Tests 63

The Data Profile 64

The Data Histogram 67

The Periodic Graph 69

Preparing the Data Profile Using Access 70

Preparing the Data Profile Using Excel 77

Calculating the Inputs for the Periodic Graph in Access 79

Preparing a Histogram in Access Using an Interval Table 81

Summary 83

Chapter 5: Benford’s Law: The Basics 85

An Overview of Benford’s Law 86

From Theory to Application in 60 Years 89

Which Data Sets Should Conform to Benford's Law? 97

The Effect of Data Set Size 98

The Basic Digit Tests 99

Running the First-Two Digits Test in Access 102

Summary 107

Chapter 6: Benford’s Law: Assessing Conformity109

One Digit at a Time: The Z-Statistic 110

The Chi-Square and Kolmogorov-Smirnoff Tests 111

The Mean Absolute Deviation (MAD) Test 114

Tests Based on the Logarithmic Basis of Benford's Law 115

Creating a Perfect Synthetic Benford Set 121

The Mantissa Arc Test 122

Summary 129

Chapter 7: Benford’s Law: The Second-Order andSummation Tests 130

A Description of the Second-Order Test 131

The Summation Test 144

Summary 151

Chapter 8: Benford’s Law: The Number Duplication andLast-Two Digits Tests 153

The Number Duplication Test 154

Running the Number Duplication Test in Access 155

Running the Number Duplication Test in Excel 164

The Last-Two Digits Test 167

Summary 172

Chapter 9: Testing the Internal Diagnostics of Current Periodand Prior Period Data 173

A Review of Descriptive Statistics 175

An Analysis of Alumni Gifts 178

An Analysis of Fraudulent Data 182

Summary and Discussion 189

Chapter 10: Identifying Fraud Using the Largest Subsets andLargest Growth Tests 191

Findings From the Largest Subsets Test 193

Running the Largest Subsets Test in Access 195

Running the Largest Growth Test in Access 197

Running the Largest Subsets Test in Excel 200

Running the Largest Growth Test in Excel 203

Summary 210

Chapter 11: Identifying Anomalies Using the Relative SizeFactor Test 212

Relative Size Factor Test Findings 213

Running the RSF Test 215

Running the Relative Size Factor Test in Access 216

Running the Relative Size Factor Test in Excel 226

Summary 232

Chapter 12: Identifying Fraud Using Abnormal Duplicationswithin Subsets 233

The Same-Same-Same Test 234

The Same-Same-Different Test 235

The Subset Number Duplication Test 236

Running the Same-Same-Same Test in Access 238

Running the Same-Same-Different Test in Access 239

Running the Subset Number Duplication Test in Access 244

Running the Same-Same-Same Test in Excel 248

Running the Same-Same-Different Test in Excel 252

Running the Subset Number Duplication Test in Excel 256

Summary 262

Chapter 13: Identifying Fraud Using Correlation 263

The Concept of Correlation 264

Correlation Calculations 272

Using Correlation to Detect Fraudulent Sales Numbers 272

Using Correlation to Detect Electricity Theft 276

Using Correlation to Detect Irregularities in Election Results278

Detecting Irregularities in Pollution Statistics 282

Calculating Correlations in Access 287

Calculating the Correlations in Excel 291

Summary 295

Chapter 14: Identifying Fraud Using Time-Series Analysis297

Time-Series Methods 299

An Application Using Heating Oil Sales 299

An Application Using Stock Market Data 303

An Application Using Construction Data 306

An Analysis of Streamflow Data 313

Running Time-Series Analysis in Excel 319

Calculating the Seasonal Factors 320

Running a Linear Regression 322

Fitting a Curve to the Historical Data 324

Calculating the Forecasts 325

Summary 330

Chapter 15: Fraud Risk Assessments of Forensic Units332

The Risk Scoring Method 333

The Forensic Analytics Environment 335

A Description of the Risk-Scoring System 336

P1: High Food and Supplies Costs 338

P2: Very High Food and Supplies Costs 339

P3: Declining Sales 340

P4: Increase in Food Costs 342

P5: Irregular Seasonal Pattern for Sales 344

P6: Round Numbers Reported as Sales Numbers 346

P7: Repeating Numbers Reported as Sales Numbers 347

P8: Inspection Rankings 347

P9: High Receivable Balance 348

P10: Use of Automated Reporting Procedures 348

Final Results 349

An Overview of the Reporting System and Future Plans 350

Some Findings 351

Discussion 353

Summary 353

Chapter 16: Examples of Risk Scoring with Access Queries355

The Audit Selection Method of the IRS 356

Risk Scoring to Detect Banking Fraud 360

Final Risk Scores 364

Risk Scoring to Detect Travel Agent Fraud 364

Final Results 369

Risk Scoring to Detect Vendor Fraud 369

Vendor Risk Scoring Using Access 376

Summary 385

Chapter 17: The Detection of Financial Statement Fraud388

The Digits of Financial Statement Numbers 388

Detecting Biases in Accounting Numbers 395

An Analysis of Enron’s Reported Numbers 398

An Analysis of Biased Reimbursement Numbers 399

Detecting Manipulations in Monthly Subsidiary Reports 404

Predictor Weightings 421

Conclusions 423

Summary 424

Chapter 18: Using Analytics on Purchasing Card Transactions425

Purchasing Cards 426

The National Association of Purchasing Card Professionals432

A Forensic Analytics Dashboard 433

An Example of Purchasing Card Data 433

High-Level Data Overview 435

The First-Order Test 438

The Summation Test 440

The Last-Two Digits Test 440

The Second-Order Test 441

The Number Duplication Test 442

The Largest Subsets Test 444

The Same-Same-Same Test 446

The Same-Same-Different Test 446

The Relative Size Factor Test 448

Conclusions with Respect to Card Purchases 449

A Note on Microsoft Office 450

A Note on the Forensic Analytic Tests 451

Conclusion 452

References 455

Index 459

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)