Assigned numbers
Invoice numbers, customer IDs, account codes and other identifiers are created by a system or person. Their digit pattern is not expected to follow Benford's Law.
Benford's Law for accounting and audit analysis
Use Benford's Law to identify unusual digit patterns—not to declare fraud
Benford's Law is a statistical pattern found in many naturally occurring numerical populations. Datplan applies first-digit analysis to supported Xero and QuickBooks accounting data, compares the observed frequencies with the expected Benford distribution, and lets the reviewer open the underlying Audit Evidence records.
- Xero + QuickBooks
- First-digit screening
- Expected vs observed
- Evidence drill-down
The short answer
What is Benford's Law?
In many datasets produced by real-world processes, the first significant digit is not evenly distributed. A leading 1 occurs much more often than a leading 9. Benford's Law gives the expected frequency for each digit, providing a reference distribution that can be compared with an observed accounting population.
A difference between expected and observed frequencies is a signal to investigate. It is not evidence by itself that a transaction is fraudulent, manipulated or incorrect.
Expected first-digit pattern
Benford frequencies are deliberately uneven
For the first significant digit, lower digits are expected more often than higher digits. These percentages are a statistical benchmark, not a target that every accounting dataset must match exactly.
| First digit | Expected frequency | Interpretation |
|---|---|---|
| 1 | 30.1% | Most common expected leading digit |
| 2 | 17.6% | Expected less often than 1 |
| 3 | 12.5% | Frequency continues to decline |
| 4 | 9.7% | Reference frequency for a suitable population |
| 5 | 7.9% | Reference frequency for a suitable population |
| 6 | 6.7% | Reference frequency for a suitable population |
| 7 | 5.8% | Reference frequency for a suitable population |
| 8 | 5.1% | Reference frequency for a suitable population |
| 9 | 4.6% | Least common expected leading digit |
Second-digit and first-two-digit tests use different expected distributions and are not controls in the current hosted dashboard. Do not apply the first-digit percentages above to another digit test.
Where Benford can help
Use it on populations shaped by genuine economic activity
Benford analysis is most useful when the selected values arise naturally across a reasonably broad range rather than being assigned or tightly constrained. Depending on the engagement and the available accounting data, a reviewer might consider transaction values, ledger amounts, invoice values or other numerical populations where the underlying process makes the test sensible.
The key decision is not simply whether the data came from Xero or QuickBooks. The reviewer must decide whether the population itself has characteristics that make a Benford comparison meaningful.
Questions before running the test
- Is the population large enough to interpret sensibly?
- Do values span a useful numerical range?
- Are the numbers generated by real transactions rather than assigned identifiers?
- Have minimums, maximums, price points or other rules constrained the values?
- Is the selected period and accounting population complete for the question being asked?
Where Benford can mislead
Not every unusual digit distribution is suspicious
Benford's Law is easy to overstate. A poor population choice can create an unusual chart even when every underlying transaction is legitimate.
Restricted values
Fixed fees, standard price lists, approval limits, minimum charges and narrow value ranges can distort the expected distribution for legitimate reasons.
Small populations
A small number of records can produce large percentage movements. The chart may be statistically unstable and should not be treated as a reliable fraud indicator.
Datplan workflow
Compare the pattern, then inspect the accounting evidence
The useful part of an audit analytic is the path from the chart back to the transactions that produced it.
- Select Xero or QuickBooks dataChoose the supported accounting population and reporting period relevant to the review.
- Use first-digit analysisDatplan compares the observed distribution with the corresponding expected Benford distribution.
- Review the Combo Bar + Line chartThe observed frequencies and expected pattern are shown together so departures can be seen clearly.
- Open Audit EvidenceInspect the underlying records used by the analysis rather than treating the chart as a conclusion.
- Corroborate the resultUse source documentation, the accounting platform's own audit history, other Datplan analyses and the engagement's required procedures to decide what the exception means.
Xero and QuickBooks
The same Benford question across both supported accounting platforms
Datplan Audit Analytics includes the same seven analyses for Xero and QuickBooks, allowing a consistent review approach across clients using different accounting systems.
Benford analysis in Xero
Run the test against a supported Xero accounting population and use Audit Evidence to inspect the records behind unusual first-digit frequencies.
Xero Audit Analytics guide →Benford analysis in QuickBooks
Apply the same conceptual test to supported QuickBooks data. Datplan's transaction analysis complements rather than replaces the QuickBooks Audit Log and source documents.
QuickBooks Audit Analytics guide →Six other audit analyses
Benford is only one view. Exceptional values, period-end activity, round amounts, possible duplicates, post-period reversals and rare high-value counterparties can surface different patterns.
See all seven tests →Investigate unusual accounting patterns
See how duplicates, unusual values, reversals and other accounting patterns can be followed through to the underlying records.
Read the fraud-risk guide →ISA (UK) 240
Relevant to fraud-risk work, but not prescribed by the standard
The revised ISA (UK) 240 is effective for audits of financial statements for periods commencing on or after 15 December 2026. Benford's Law is not a mandatory procedure in the standard. Where the population is suitable and the procedure is responsive to the assessed risk, it can be one analytical input used to identify records or patterns for further investigation.
ISA (UK) 315 remains relevant to identifying and assessing risks of material misstatement. Datplan can help prepare accounting populations and surface exceptions, but the auditor remains responsible for the risk assessment, procedure design, evidence evaluation and documentation.
How to interpret a Benford result
A Benford deviation may result from genuine business characteristics, data selection, accounting processes, value restrictions or random variation. Treat it as a prompt to inspect the underlying records and supporting evidence.
Benford's Law questions
Using digit analysis responsibly
What is Benford's Law?
Benford's Law describes a predictable distribution of leading digits that appears in many naturally occurring numerical datasets. In a suitable population, values beginning with 1 are expected more often than values beginning with 9.
Does a Benford's Law exception prove fraud?
No. A deviation can indicate that a population deserves further investigation, but it does not establish fraud, error or intent. The population must be suitable for Benford analysis and the underlying records still require professional review.
Can Datplan run Benford analysis on both Xero and QuickBooks?
Yes. Benford's Law is one of the same seven Audit Analytics analyses available for supported Xero and QuickBooks populations. Datplan can compare first-digit frequencies and provide Audit Evidence drill-down to the records behind the result.
When is Benford's Law not appropriate?
It is generally a poor fit for assigned numbers such as invoice identifiers, tightly constrained values, fixed-price lists, artificial minimums or maximums, and very small populations. The reviewer should understand the accounting population before interpreting the chart.
Does ISA (UK) 240 require Benford's Law?
No. ISA (UK) 240 does not prescribe Benford's Law or Datplan's seven tests. Benford analysis can be one analytical input where it is relevant to the auditor's fraud-risk assessment and planned procedures.
Try the Audit Analytics workflow in Datplan
Download the Windows app, then use a supported Xero or QuickBooks source plan for live Audit Analytics. Benford results remain indicators for professional review.
Current hosted rule: at least 250 eligible first-digit values
The published Xero, QuickBooks and Tally browser viewers use a 250-record minimum for first-digit Benford display. This is Datplan's product threshold, not a universal statistical rule or a guarantee that a population is suitable. Below 250, the viewer explains that there are insufficient records; larger populations can still be unsuitable.
Choose a comparable set of naturally occurring monetary values. Do not increase the count by treating both debit and credit sides of one accounting event as independent documents. Do not add an amount cut-off merely to make the chart look more convincing: truncation and fixed prices can distort the distribution. Keep source identifiers and source records unchanged.
The Tally preview offers posted accounting vouchers or sales/purchase-document populations. Zero values and excluded voucher states do not count as eligible observations. Its warnings distinguish a small population, restricted value range and repeated values. Read the Tally preview scope.