(020) 7242 5778

Book of the Month

Cover of Retained EU Law: A Practical Guide

Retained EU Law: A Practical Guide

Price: £65.00

Wildy, Simmonds & Hill

Just Published

The Complete List...

Offers for Newly Called Barristers & Students

Special Discounts for Newly Called & Students

Read More ...

Secondhand & Out of Print

Browse Secondhand Online


Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations 2nd ed (eBook)

ISBN13: 9781119585909
Published: July 2020
Publisher: John Wiley & Sons Ltd
Country of Publication: UK
Format: eBook (ePub)
Price: £75.00
The amount of VAT charged may change depending on your location of use.

Once the order is confirmed an automated e-mail will be sent to you to allow you to download the eBook.

All eBooks are supplied firm sale and cannot be returned. If you believe there is a fault with your eBook then contact us on ebooks@wildy.com and we will help in resolving the issue. This does not affect your statutory rights.

This eBook is available in the following formats: ePub.

In stock.
Need help with ebook formats?

Become the forensic analytics expert in your organization using effective and efficient data analysis tests to find anomalies, biases, and potential fraud—the updated new edition.

Forensic Analytics reviews the methods and techniques that forensic accountants can use to detect intentional and unintentional errors, fraud, and biases. This updated second edition shows accountants and auditors how analyzing their corporate or public sector data can highlight transactions, balances, or subsets of transactions or balances in need of attention. These tests are made up of a set of initial high-level overview tests followed by a series of more focused tests. These focused tests use a variety of quantitative methods including Benford’s Law, outlier detection, the detection of duplicates, a comparison to benchmarks, time-series methods, risk-scoring, and sometimes simply statistical logic. The tests in the new edition include the newly developed vector variation score that quantifies the change in an array of data from one period to the next. The goals of the tests are to either produce a small sample of suspicious transactions, a small set of transaction groups, or a risk score related to individual transactions or a group of items.

The new edition includes over two hundred figures. Each chapter, where applicable, includes one or more cases showing how the tests under discussion could have detected the fraud or anomalies. The new edition also includes two chapters each describing multi-million-dollar fraud schemes and the insights that can be learned from those examples. These interesting real-world examples help to make the text accessible and understandable for accounting professionals and accounting students without rigorous backgrounds in mathematics and statistics. Emphasizing practical applications, the new edition shows how to use either Excel or Access to run these analytics tests. The book also has some coverage on using Minitab, IDEA, R, and Tableau to run forensic-focused tests. The use of SAS and Power BI rounds out the software coverage. The software screenshots use the latest versions of the software available at the time of writing. This authoritative book:

  • Describes the use of statistically-based techniques including Benford’s Law, descriptive statistics, and the vector variation score to detect errors and anomalies
  • Shows how to run most of the tests in Access and Excel, and other data analysis software packages for a small sample of the tests
  • Applies the tests under review in each chapter to the same purchasing card data from a government entity
  • Includes interesting cases studies throughout that are linked to the tests being reviewed
  • Includes two comprehensive case studies where data analytics could have detected the frauds before they reached multi-million-dollar levels
  • Includes a continually-updated companion website with the data sets used in the chapters, the queries used in the chapters, extra coverage of some topics or cases, end of chapter questions, and end of chapter cases

Written by a prominent educator and researcher in forensic accounting and auditing, the new edition of Forensic Analytics: Methods and Techniques for Forensic Accounting Investigations is an essential resource for forensic accountants, auditors, comptrollers, fraud investigators, and graduate students.

eBooks, Accounting
List of Cases
About the Author
List of Abbreviations
Analytics Software used
Chapter 1. Using Microsoft Excel for forensic analytics
Chapter 2. The initial high-level overview tests
Chapter 3. Benford’s Law: The basic tests
Chapter 4. Benford's Law: Advanced topics
Chapter 5. Benford's Law: Completing the cycle
Chapter 6. Identifying anomalous outliers: Part 1
Chapter 7. Identifying anomalous outliers: Part 2
Chapter 8. Identifying abnormal duplications
Chapter 9. Comparing current period and prior period data: Part 1
Chapter 10. Comparing current period and prior period data: Part 2
Chapter 11. Identifying anomalies in time-series data
Chapter 12. Scoring forensic units for fraud risk
Chapter 13. Case study: An employee’s fraudulent tax refunds
Chapter 14. Case study: A supplier’s fraudulent shipping claims
Chapter 15. Detecting financial statement fraud
Chapter 16. Using Microsoft Access and R for analytics
Chapter 17. Concluding notes on fraud prevention and detection