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.
| Item | FY2025 |
|---|---|
| Revenue per ledger | 24.00 |
| Trade receivables, opening | 3.20 |
| Trade receivables, closing | 3.90 |
| Deferred revenue, opening | 1.10 |
| Deferred revenue, closing | 1.40 |
| Customer receipts per the bank statements | 23.05 |
| Payment processor fees deducted before the money lands | 0.18 |
| Refunds netted against receipts by the processor | 0.07 |
| Reported EBITDA | 4.80 |
| Price multiple | 8.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.
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.
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.
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.
| Line | $ million |
|---|---|
| Expected receipts from the ledger | 23.60 |
| Less processor fees | −0.18 |
| Less refunds netted | −0.07 |
| Expected bank receipts | 23.35 |
| Bank receipts | 23.05 |
| Unexplained difference | 0.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.
Two outcomes are possible and they are priced differently.
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.
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.
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 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.
Not on Amazon: 11 paperbacks by Julian R. Sterling on banking, credit and payments, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: corporate finance, valuation and markets → · All 1908 articles →