Benford check

When Benford’s law applies, and when it does not

The digit tests compare your amounts with a pattern that many, but not all, real-world numbers follow. Whether the comparison means anything depends on the data more than on the statistics.

A deviation is a reason to look, not proof of fraud. The tests point at digits and amounts worth reading row by row. What explains them is found in the records: the vendor, the date, the approver, the contract. Most spikes turn out to have an ordinary cause.

What the law says

In many collections of measured or counted quantities the leading digit is 1 about 30% of the time and 9 under 5% of the time. Simon Newcomb noticed it in 1881 from the wear on logarithm tables; Frank Benford (1938) checked it on twenty sets of numbers, from river areas to street addresses, and gave the expected share of each first digit d as log10(1 + 1/d). The same reasoning gives the shares of the second digit and of the first two digits together.

The pattern appears when numbers are spread over several orders of magnitude and arise from growth, multiplication or the mixing of many different sources. Hill (1995) showed that picking numbers from a random mix of distributions leads to it. It is a property of the data-generating process, not a rule that every honest number obeys.

Data that usually fits

Data that does not, however honest

Reading the results

Start with the MAD verdict

The mean absolute deviation is the average gap, over all digits, between the share observed and the share Benford expects. Nigrini (2012, Table 7.1) set four ranges for it, from close conformity to nonconformity, from experience with many real files. The MAD is used instead of the chi-square because the chi-square grows with the number of records: on a file of 100,000 payments it rejects for differences too small to matter (Kossovsky 2021). The tool still shows the chi-square and the Kolmogorov–Smirnov statistic, with that caveat.

Then the digits

The MAD is an average and can hide a sharp spike. In the test suite, 400 invented amounts between 4,800 and 5,000, mixed into 20,000 genuine ones, leave the first-two digits MAD in close conformity, yet digits 48 and 49 have Z-scores of about 11 and 17. Look at every digit marked as over-represented at the 1% level (Z above 2.576). With 90 digits tested at once, one or two marks happen by chance; a cluster or a very large Z is worth a look.

Then the rows

Tap the digit. The tool lists the most frequent amounts in it, the largest ones and the first rows, and exports all of them with their original columns. Typical findings, roughly from most to least common:

The number duplication test lists repeated amounts directly. The summation test catches a different thing: a few very large amounts that dominate the total without changing the digit counts.

Negative amounts and amounts below 10

Credits and refunds come from a different process than payments, so they are tested on their own or, if you prefer, folded in as absolute values. Small amounts are usually immaterial and often fixed charges; by default they are left out, as in Nigrini’s practice. Both are switches on the tool page.

Conformity is not innocence

A file that fits Benford can still contain fraud: one inflated payment, a fictitious vendor billing ordinary-looking amounts, or invented numbers drawn to look natural. Digit tests are one screen among several, alongside the duplicate, threshold and outlier checks auditors already run.

Sources

Every formula and constant the tool uses, and how it was checked: Method and sources.