PRIVATE, LOCAL-FIRST FORENSIC ANALYTICS

Benford's-law tests on your ledger, in your browser.

Choose a CSV of payments, expense claims, invoices or journal entries. The page runs Mark Nigrini's Benford test suite (first digit, second digit, first two digits, last two digits, summation, number duplication), checks for amounts piling up just under an approval limit, ranks vendors or employees by how far their amounts stray, and gives you a list of records to pull. The file never leaves your device.

1. Your data

Any CSV with an amount column. Comma, semicolon or tab separated; $1,234.56, (1,234.56) and 1.234,56 all read. A vendor, employee or card-holder column turns on the per-group ranking. No export handy? : 2,565 made-up expenses with three planted problems.

Common questions

Does a failed Benford test mean fraud?

No. A digit test says where the numbers differ from what Benford's law predicts, not why. Price lists, fixed fees, caps, a few vendors that bill the same amount every month, or a narrow range of amounts all fail the tests with nothing wrong. Use the results to choose which records to look at, then look at them.

How many records do I need?

About 300 amounts for the first-digit test and about 1,000 for the first-two-digits test, which is the most useful one. The page says so when a file is smaller, and the per-vendor ranking only includes vendors with at least 50 amounts by default.

What is MAD and why is it the headline?

MAD is the mean absolute deviation between the observed and expected digit proportions. Mark Nigrini proposed it as the conformity measure for Benford tests because chi-square rejects almost any large file for trivial differences. The verdict bands (close, acceptable, marginally acceptable, nonconformity) are his, from Benford's Law (Wiley, 2012). Chi-square and its p-value are shown too.

Which data fits Benford's law?

Amounts that arise from many independent transactions and span several orders of magnitude: vendor payments, expense claims, invoice lines, journal entries, sales. Not assigned numbers (invoice or check numbers, ZIP codes), not amounts bounded by a rule (a $50 meal cap), and not a price list. The applicability notes under the summary check the range and skew of your file.

Is my data uploaded?

No. The CSV is read in your browser and never leaves your device. The optional usage counter stores only that an audit ran, in your own browser, and contains no amounts or names.

Who this is for, a worked example and when to use something else: Benford's-law testing for internal auditors, fraud examiners and bookkeepers. Looking for the same invoice paid twice rather than unusual digits? The duplicate payment audit pairs up likely double vendor payments, also in your browser.