(15 reviews) Author: ISBN : 9780470890462 New from $51.45 Format: PDFWith 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.
- Series: Wiley Corporate F&A (Book 558)
- Hardcover: 480 pages
- Publisher: Wiley; 1 edition (June 7, 2011)
- Language: English
- ISBN-10: 0470890460
- ISBN-13: 978-0470890462
- Product Dimensions: 1.7 x 7.5 x 10.5 inches
- Shipping Weight: 3 pounds (View shipping rates and policies)
Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations PDF
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.
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.By Drake Mandrake
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.
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.By Robert Notman
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.
No comments:
Post a Comment