Articles

How does a proof of revenue test reconcile the ledger to the bank?

Revenue, receivables, deferred revenue and the bank statements must reconcile; what does not reconcile is either a pricing problem or a cash problem.

A $24.00 million revenue line, with receivables up $0.70 million and deferred revenue up $0.30 million, implies $23.60 million of customer receipts. The bank shows $23.05 million; after $0.25 million of processor fees and refunds, $0.30 million is unexplained, 1.25% of revenue. If the sales are not real, EBITDA drops from $4.80 million to $4.50 million and an 8.0x price falls by $2.40 million; if the cash went to another account, the adjustment is $0.30 million.

The assumptions

Illustrative company, $ million, amounts exclude sales tax
ItemFY2025
Revenue per ledger24.00
Trade receivables, opening3.20
Trade receivables, closing3.90
Deferred revenue, opening1.10
Deferred revenue, closing1.40
Customer receipts per the bank statements23.05
Payment processor fees deducted before the money lands0.18
Refunds netted against receipts by the processor0.07
Reported EBITDA4.80
Price multiple8.0x

The tolerance for an unexplained difference is 0.5% of revenue, $0.12 million. A proof of revenue is a test of the ledger against an independent source, the bank, not a replacement for the audit.

Step 1: what cash the ledger implies

Revenue becomes cash unless it stays in receivables, and cash arrives before revenue when it goes to deferred revenue. So the cash a customer base must have paid is revenue less the increase in receivables plus the increase in deferred revenue.

Expected receipts = revenue − increase in receivables + increase in deferred revenue

Excel: =Rev-(ARclose-ARopen)+(DRclose-DRopen)

The receivables increase is 3.90 − 3.20 = 0.70 and the deferred revenue increase is 1.40 − 1.10 = 0.30. Expected receipts are 24.00 − 0.70 + 0.30 = $23.60 million.

Step 2: compare with the bank

The bank statements show $23.05 million received from customers. The raw difference is 23.60 − 23.05 = $0.55 million, 2.29% of revenue.

Step 3: remove the explained items

The processor keeps its fee and nets refunds before paying out, so the bank sees less than the customer paid. Both are documented in the processor statements.

Reconciliation of expected receipts to the bank
Line$ million
Expected receipts from the ledger23.60
Less processor fees−0.18
Less refunds netted−0.07
Expected bank receipts23.35
Bank receipts23.05
Unexplained difference0.30

The unexplained $0.30 million is 1.25% of revenue, 2.5 times the $0.12 million tolerance, so it has to be traced to invoices.

What if: the $0.30 million is revenue that was never collected

Two outcomes are possible and they are priced differently.

The common mistakes

Takeaway

Questions readers ask

How do you calculate the cash that revenue should have produced?

Revenue minus the increase in receivables plus the increase in deferred revenue. With revenue of $24.00 million, receivables up $0.70 million and deferred revenue up $0.30 million, expected receipts are $23.60 million.

What tolerance should a proof of revenue apply?

It is a judgement, set against the size of the business and what the test is meant to catch. This example uses 0.5% of revenue, $0.12 million, and the $0.30 million unexplained difference is 2.5 times that.

Why does it matter whether the difference is a fictitious sale or misplaced cash?

Fictitious revenue lowers EBITDA and is capitalised at the multiple, $0.30 million times 8.0 is $2.40 million of price. Misplaced cash lowers net debt by the amount itself, $0.30 million.

The workbooks behind this article

The free companion files for The Financial Due Diligence Associate rebuild a fictional buy-side quality of earnings engagement, with net debt, the working capital peg and the closing statement, and an editable toolkit for transaction services work. The proof of revenue in this article uses invented figures and is not in them. No account and no email address.

Open the companion files →

Not on Amazon: 11 paperbacks by Julian R. Sterling on banking, credit and payments, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: corporate finance, valuation and markets → · All 1908 articles →