Back to Recent Posts

Accounting & Audit Alert- How auditors use Benford’s Law to assess transactions

An interesting tool called Benford’s Law can be effective in detecting fraud. But it also can be used during external auditing procedures to test journal entries for unusual numeric patterns. Here’s what you should know about this statistical technique, including its potential limitations.

Random data sets

According to Benford’s Law, in sets of random data, numbers beginning with smaller digits occur more frequently. For example, numbers beginning with 1 occur about 30% of the time, numbers beginning with 2 occur about 18% of the time, and so on, down to numbers beginning with 9, which occur less than 5% of the time. The law also makes predictions about the distribution of second digits, third digits and digit combinations.

These patterns become skewed when dishonest workers attempt to manipulate numbers in certain financial documents. In fact, it’s nearly impossible to manually enter data so that it conforms to Benford’s Law. So, auditors may be able to use Benford’s Law to test journal entries made for the following items:

  • Inventory records,
  • Expense reports,
  • Accounts payable or receivable,
  • General ledgers, and
  • Refund reports.

If anomalies appear when performing this analysis, auditors will perform analytical review procedures to determine whether specific unusual circumstances, business changes, random fluctuations or misstatements may have impacted the data set. And they may need to consider whether alternative audit procedures — such as physically tracing transactions to supporting documentation or comparing the transactions to prior years’ data — can be used to assess the validity of a questionable data set.

Spreadsheet analysis

When applying Benford’s Law, auditors typically run a spreadsheet program on the data set to examine the distribution of digits in random sets of numbers. By doing this, they calculate the frequency with which the digits 1 through 9 occur. The spreadsheet can be converted into a chart that highlights any significant deviations from the patterns the rule predicts.

For example, a chart that shows that 20% of the numbers in a data set begin with 9 and only 10% begin with 1 may indicate financial misstatement. But it doesn’t prove wrongdoing. Often, innocent explanations — such as duplicate entries and other human errors — lie behind suspicious patterns. That’s why it’s essential to dig deeper to understand what’s gone awry.

Limitations

Beware: Benford’s Law sometimes generates false positive and negative results. Examples of confounding variables include:

Small data sets. There must be enough journal entries to be statistically relevant. For instance, if a receivables clerk falsifies just one or two journal entries, the impropriety is unlikely to be caught with Benford’s Law.

Assigned numbers. The data being tested must occur naturally for Benford’s Law to work. Nonrandom numbers that were created by humans — such as invoice numbers — won’t conform to the prescribed pattern.

Artificial limits. If transactions are subjected to a floor or ceiling, some numbers won’t occur in the data set. For instance, if petty cash draws can’t exceed $50, the petty cash ledger won’t conform to Benford’s Law.

Also consider review thresholds. If a second signature is required on all disbursements greater than $5,000, the auditor might detect an unusually high occurrence of “4” in the first-digit position.

For more information

Despite its limitations, Benford’s Law can be a simple, cost-effective tool to test for data manipulation, processing inefficiencies and errors. Contact us to discuss whether this analysis can enhance your financial reporting. We can identify the types of transactions that are best suited for Benford’s Law-based testing.

Posted In: Alerts & Advisories