What Benford's law means, why it matters, and how finance teams control it in practice.
The pattern in many natural data sets where smaller leading digits appear more often than larger ones, used as a screening test for unusual data.
In data such as supplier payments or expense claims, the digit 1 leads about 30% of numbers and 9 leads under 5%, because of how values grow. Invented or manipulated figures often do not follow this shape.
A Benford test highlights where to look in a large population, such as a spike of amounts just under an approval limit.
For amounts of 1 or more, extract the first digit with =--LEFT(TEXT(ABS(A2),"0"),1), count each digit and compare the share with the expected pattern. Use it only on large, unrestricted data sets; fixed prices, small populations or capped amounts will not follow the pattern. A deviation is a reason to look closer, not proof of fraud.
Risk-ranks every journal entry with an on-device AI and 17 audit tests, catches descriptions posted to the wrong account, runs Benford's law and selects a repeatable sample. Runs in your browser on your own computer: nothing is uploaded.
The Invoice & Payment Fraud Defence Kit puts every payment through a Release, Hold or Pulled-from-run decision, with a bank detail change verification log, supplier checks, an incident log, a staff training record and a Fraud Defence Playbook (PDF). Excel, no macros, one-time price.
All glossary terms · All payment fraud guides
Last updated 15 November 2026. General guidance for finance teams; check it against your own policies, systems and local rules.