Benford's Law

Benford's law is an advanced digital analysis technique that involves examining the actual frequency of the digits in the data. Benford's law calculates that numbers in sets of data with low first digits, such as 1, occur with more frequency than numbers with high first digits, like 8 or 9. Valid, unaltered data, without exceptional transactions, will follow the projected frequencies.

Benford's law has been found to apply to many sets of financial data, including corporate disbursements. Audit software can employ digital analyses using Benford's law to identify fraud and other irregularities in accounts payable, income tax forms, claims payments and other disbursements. Audit software, compatible with Excel, is available at no charge to so this analysis.

Conversely, data that meets the Benford's law criteria, but fails to follow the expected frequencies, may include fraudulent items. It is very difficult for people to make up credible numbers, as invented numbers are unlikely to follow Benford's law. Thus, Benford's law can be tested by the audit staff to spot irregularities, including possible error, fraud detection, or other anomalies. Audit software is available, including both Excel and a command language process for larger volumes.

The technique has been used in a variety of environments, including:

1. Detecting Irregularities in Insurance Claims
2. Highlighting Unusual Employee Expense Reports
3. Detecting possibly fraudulent tax returns
4. Fraud detection in medical insurance claims


Benford's law provides the internal auditor with an efficient means of fraud detection by measuring an expected population distribution against the actual distribution. By highlighting selected transactions, vendors or other groups, the internal auditor/researcher is better able to isolate and focus on a target group, and therefore potentially be more productive in identifying errors or unusual transactions.

The fraud detection techniques used are based upon mathematical theories which are explained in detail in various referenced articles. Because transaction volumes are often very significant, and needed computations would be tedious if done manually, the use of audit software , especially a command language, is generally recommended for fraud detection.

Suggested Audit Approaches

Benford's Law formulae and values in Excel

Downloads (audit software and papers)

Limitations and Cautions

Examples of Application of Benford's Law
This article is free for republishing
Source: http://www.financealley.com/article_168396_65.html
Occupation: IT Auditor
IT auditor with 27 years experience in information technology auditing, including five years with public accounting firms. Experience both internationally with a global petrochemical company, and domestically with governments, electric utilities and savings and loan associations. IT experience ranges all the way from audits of large IBM mainframe systems using CICS, DB2, IMS to mid-range Unix boxes as well as LANS. Has developed and implemented Oracle database systems using stored procedures as well as extensive experience with the audit use of Excel. Significant experience with MySQL and PHP in a web based environment. Author of four articles published on AuditNet. Scheduled speaker at the 2008 IIA Fraud Forum. Speaker at the 2002 IBM Share conference in San Francisco in 2002 on the topic of auditing mainframe software costs. Conducted training in Advanced Excel techniques on multiple occasions. Speaker at the Miami chapter of the EDPAA on auditing CICS. Founder of the audit consulting firm EZ-R Stats, LLC which provides a variety of audit software tools, Excel training and articles on numerous audit topics. Received a CPA certificate in Florida in 1975 and a CISA certificate in 1982. Currently the Senior Information Technology Auditor for the North Carolina Department of Health and Human Services auditing the Medicaid system which has an annual budget of a little over $10 billion.