FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Forensic Analytics: Metho... has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations (Wiley Corporate F&A) Hardcover – 17 Jun 2011

1.5 out of 5 stars 2 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
£45.97 £35.62
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£70.00 FREE Delivery in the UK. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Special Offers and Product Promotions

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Product details

  • Hardcover: 480 pages
  • Publisher: John Wiley & Sons; 1 edition (17 Jun. 2011)
  • Language: English
  • ISBN-10: 0470890460
  • ISBN-13: 978-0470890462
  • Product Dimensions: 18.5 x 3.9 x 26.2 cm
  • Average Customer Review: 1.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 1,348,614 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description


"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)

From the Inside Flap

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.

See all Product Description

Customer Reviews

1.5 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See both customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Kindle Edition
I had to purchase this book for class, the book was very confusing and didn't help me. I would not recommend this book. It did not help with access or excel. There is probably a better book out there to purchase for a more reasonable price!!!
Comment One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Hardcover Verified Purchase
I had to stop reading it in the middle, it definitively proved a time waster for several reasons:
1) I tried to find the purpose to use Access for analytical and audit review: ACL is much more productive in my view, so why bother? For instance, 4 chapters about Bendford Law can be put in practice in a few minutes using ACL Bendford feature.
2) There is no practical description about the Excel new pivot table and statistical features, and it totally misses the new Excel 2010 features (although the book is issued in 2011).
3) Examples of analytical review cover "oil consumption in a US State" and "poll results in California"... not really practical for our usual auditing reviews.
4) Writing style is confusing and overly academic, totally lacking any humor.
Typical university book, not adapted to practical investigations.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 5.0 out of 5 stars 22 reviews
6 of 6 people found the following review helpful
5.0 out of 5 stars Palantir stone for auditors & forensic accountants 8 Nov. 2012
By Kurt S. Schulzke - Published on Amazon.com
Format: Hardcover
No auditor or forensic accountant really knows the craft without absorbing Mark Nigrini's highly readable, entertaining and insightful tome, Forensic Analytics. The book's major contribution is a suite of mathematical tests dubbed the "Nigrini Cycle," an amazingly easy tool for quickly zeroing in on possible waste, fraud, and inefficiency in A/R, A/P, travel expenses, payroll, Medicare billings, and P-cards, to name a few.

Financial analysts of all stripes -- external auditors, forensic investigators, and internal auditors -- not only can but should read this book, as a matter of professional due diligence. I love how Mark walks the reader, screen-by-screen, through the Nigrini Cycle using MS Excel and Access. Sr. Manager - Partner types who think themselves incapable of using Access might want to reconsider. With Nigrini's help, MS Access really is like falling off a log. (Bad pun that only readers of the book can appreciate.)

After dabbling in Benford's Law in the summer semester, 2012, now, in the fall semester, the use (not just the reading) of Forensic Analytics is a requirement of my Forensic Accounting students in Kennesaw State University's Master of Accounting program. With the Nigrini Cycle in their professional tool-kit, our grads will have a significant leg up on the competition -- until everyone else catches on, as they certainly should.

Back in the summer, I introduced Benford's Law to a local large-firm audit partner. This morning, he told me that they have now used Benford's Law on some of their audit engagements. Describing the experience, his face lit up as if he were describing a favorite golf club. "This thing really works! And the clients love it." In the auditing business, a math tool that triggers such a response is something special. No, I am not writing on commission. Yes, you will love this book and what it does for your understanding of numbers, especially financial ones.
9 of 10 people found the following review helpful
5.0 out of 5 stars Helpful for forensic testing using Excel and Access 21 Jun. 2011
By Drake Mandrake - Published on Amazon.com
Format: Hardcover
I found this to be a helpful book. The data analysis tests in Forensic Accounting can be used as high-level reasonableness tests to determine whether private or public sector data is free of fraud, errors or biases. While the tests can't guarantee that everything is clean and correct, they will detect the larger and more obvious errors. The author starts with some high-level overview tests and then drills deeper into the data to find irregular patterns. The Relative Size Factor tests and the Same-Same-Different test have been used with much success in detecting problems with accounts payable data.

Benford's Law fans will not be disappointed--the book includes four full chapters on Benford's Law and it is also covered in three other chapters. The final chapter on purchasing card fraud has interesting examples of actual fraud, an Excel dashboard, and an example of a real analysis of real company data. The book has tests that will be new and valuable to seasoned forensic accountants as well as some basic tests that will be immediately usable for beginners. If you have Excel or Access and your own data, then you could probably use many of the tests in the book right away. This book shows how to run most of the tests in both programs. It should be useful to forensic accountants, auditors, and other accounting and finance types who work with data.
5 of 5 people found the following review helpful
5.0 out of 5 stars Forensics for Purchasing Card Administrators 1 Oct. 2011
By Robert Notman - Published on Amazon.com
Format: Hardcover
Dr. Nigrini's book on forensic analytics is nothing short of amazing especially for those of us that haven't used statistics or analysis since high school or college. I'll admit that when I first received the book I was disappointed that there was only one chapter (18) that deals specifically with purchasing cards (PCards). However, as I began to read the book I realized that all of the other chapters help you understand your PCard records and are explanation of tools to help you perform analysis.

The book covers using MS Access, Excel and PowerPoint for forensic investigation or presentation of forensic analysis. The author also includes many tests that you can apply to look for fraud (misuse/abuse). You also have access to a website that has a lot of examples and data from the various chapters to help you understand the text.

Reading the book was my first introduction in using Benford's Law and applying it to card data. It was interesting to see my data reviewed with Benford's Law. I haven't attempted to apply the other tests to my data yet, but will as I complete reading the book.

If you are a Purchasing Card Administrator interested in mitigating risk, this is a book that can help you understand how to review the data.
6 of 7 people found the following review helpful
4.0 out of 5 stars A very good review of the topic 5 Mar. 2012
By Duncan Williamson - Published on Amazon.com
Format: Kindle Edition
Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations (Wiley Corporate F&A)I bought this book to help me with a course I was about to run on detecting fraud. I know Excel very well, I know Access a bit, I am very familiar with statistics. I have been a fan of Benford's Law for several years and have even had articles on the topic published.

Nevertheless, I knew that Dr Nigrini was one of THE leading lights in this topic and I have to say I was not disappointed. I bought the Kindle version of the book so I have to say that I cannot comment on the layout of the book and so on because Kindles are not the best place to see perfect layouts!

The contents are good and the progression of topics is good and logical. I have to say, however, that personally speaking, I didn't need the information on Access and PowerPoint but I can see why they were included.

I did learn a few things from this systematic study of forensic analytics and was pleased to see Dr Nigrini's views on how to deal with results from a Benford's Law analysis. Learning these things made my own understanding and presentations a little better.

I have to say that I didn't have a lot of time to consider the mantissa arc and Kolmogorov-Smirnoff tests but I liked the correlation test: nice, simple and easy to use and explain.

There is a batch of cases to work on, heating oil sales, stock market information and construction data. There is even a very large database of invoice information to work with (approx 189,000 invoices) that will stretch your Excel resources but which will be useful for anyone wanting to work with a real data set.

Overall I found the explanations nice and clear and for anyone looking for a good introduction to the topic, this is a good start.
2 of 2 people found the following review helpful
5.0 out of 5 stars Another winning title from Dr. Nigrini 24 Oct. 2011
By Richard Lanza - Published on Amazon.com
Format: Hardcover
The book is written for forensic accountants, internal auditors, external auditors, and almost anyone else that has an interest in detecting fraud and other anomalies in corporate or government data. The focus is on getting practical results, and the text would be readily understood by readers with a business degree and an enthusiasm for data analysis. Topics include duplicates testing, ratio testing, relative size factor testing, risk scoring, purchasing card fraud, financial statement fraud, correlation and time series analysis, and risk assessment of forensic units.

Dr. Nigrini is best known for his pioneering work, starting in the 1990's, on the uses of Benford's Law of digit frequencies in forensic investigation. Roughly a third of the book is concerned with Benford-related digit-frequency analysis. Here the treatment is slightly more thorough and academic in flavor, but it remains focused on real-world results. Nigrini continues to produce original insights on this theme, with a lengthy description of a brand-new `second order' Benford test technique. Instead of focusing on the digit frequencies of individual items, this test focuses on the digit frequencies of the differences between ranked items. Nigrini shows how this can highlight problems not found by standard Benford testing.

All the tests described in the book are run using Microsoft Excel or Microsoft Access, with numerous screenshots to illustrate the steps. There are some challenges in doing high-level statistical analysis using these tools, and for very large data sets users might prefer an add-in tool, or a package like SAS. For most purposes however standard Excel or Access are quite sufficient. The reader is referred to a companion website which provides sample data sets, class assignments, and PowerPoint slides for anyone wanting to use the book as a text.

The book is a unique resource with regard to Benford, and lays out a solid foundation for financial forensic work in general. Strongly recommended.
Were these reviews helpful? Let us know