Goods shipped before the month-end but invoiced after it leave revenue, cost of sales and receivables short. The percentage margin hides it; EBITDA and DSO do not.
A manufacturer with $8.00 million of June revenue ships $0.64 million of goods on 29 and 30 June and invoices them on 1 July. The close shows revenue of $7.36 million, down 8.0%, and a gross margin of 38.04%, almost unchanged from 38.00%. EBITDA falls 20.0%, from $1.20 million to $0.96 million, because operating expenses stay put, and DSO rises from 45.0 to 46.3 days. The revenue error that reaches a 5% EBITDA threshold is $0.160 million, 2.0% of revenue.
| Item | Value |
|---|---|
| True June revenue | 8.00 |
| Cost of sales | 62% of revenue (4.96) |
| Operating expenses | 1.84 |
| True EBITDA (monthly) | 1.20 |
| Trade receivables at 30 June (true) | 12.00 |
| Shipped on 29 and 30 June, invoiced on 1 July | revenue 0.64, cost 0.40 |
| Trailing twelve-month EBITDA, net debt | 13.2, 39.6 |
| Materiality threshold | 5% of monthly EBITDA |
The goods left the dock on 29 and 30 June, so control passed to the customer in June. The invoice was keyed on 1 July and nothing was booked in June: no revenue, no receivable and no relief of inventory to cost of sales. The close therefore understates both lines.
Reported revenue = true revenue − unrecorded shipments
Reported cost of sales = true cost of sales − cost of the unrecorded shipments
Excel: =Revenue-Unrecorded and =COGS-UnrecordedCost
Revenue is 8.00 − 0.64 = 7.36, a fall of 8.0%. Cost of sales is 4.96 − 0.40 = 4.56, so gross profit is 7.36 − 4.56 = 2.80 against a true 3.04.
The shipments carried a gross margin of (0.64 − 0.40) / 0.64 = 37.5%, close to the company’s 38.0%. The gross margin percentage therefore looks normal: 38.04% reported against 38.00% true. A margin check at the close would not catch the error.
EBITDA error = unrecorded revenue × margin on the item, because operating expenses do not move
Excel: =Unrecorded*(1-UnrecordedCost/Unrecorded)
The gross profit lost is 0.64 − 0.40 = 0.24. Reported EBITDA is 2.80 − 1.84 = 0.96 against 1.20, a fall of 20.0%. An 8.0% revenue error became a 20.0% EBITDA error: each 1% of revenue misstated moves EBITDA by 2.50%.
The unrecorded shipments are also missing from receivables: 12.00 − 0.64 = 11.36. DSO is receivables over revenue times 30 days.
DSO = receivables / revenue × days in the month
Excel: =AR/Revenue*30
True DSO is 12.00 / 8.00 × 30 = 45.0 days. Reported DSO is 11.36 / 7.36 × 30 = 46.3 days. Receivables fell 5.3% but revenue fell 8.0%, so the ratio rises by 1.3 days and the collections team appears slower than it was.
With the threshold at 5% of monthly EBITDA, or 0.06, the revenue error that crosses it is 0.06 / 37.5% = 0.160, which is only 2.0% of revenue. A rule that tests cut-off at 5% of revenue (0.40) would let through an error that moves EBITDA by 12.5%.
| Unrecorded revenue | Revenue understated | Gross margin reported | Gross profit lost | EBITDA understated |
|---|---|---|---|---|
| 0.16 | 2.0% | 38.01% | 0.06 | 5.0% |
| 0.32 | 4.0% | 38.02% | 0.12 | 10.0% |
| 0.64 | 8.0% | 38.04% | 0.24 | 20.0% |
| 0.96 | 12.0% | 38.07% | 0.36 | 30.0% |
| 1.28 | 16.0% | 38.10% | 0.48 | 40.0% |
July books the 0.64 invoice and the cost of 0.40, so July is overstated by the same amounts and the quarter is right. That does not repair June. On a covenant tested monthly on trailing EBITDA, June reads 12.96 instead of 13.20: leverage is 3.056x instead of 3.000x on 39.6 of debt. The 0.056x gap is small here, but a certificate signed on the June figure carries a wrong number for a month, and the July figure flatters the next.
A transaction booked in the wrong period. Goods shipped on 30 June belong in June revenue whatever the invoice date; if they are booked in July, June revenue, cost of sales and receivables are all understated.
Operating expenses do not change with the error, so the whole gross profit on the item reaches EBITDA. Here each 1% of revenue misstated moves monthly EBITDA by 2.50%.
Yes. The quarter is right but the month is not, and a monthly covenant, bonus or management report uses the wrong figure. In this example June leverage reads 3.056x instead of 3.000x.
The free companion files for The Financial Controller hold a month-end close with a double-booked accrual and unrecorded freight, the cut-off checklist and a leverage covenant with an add-back cap. The cut-off figures in this article are a separate illustration and are not in them. No account and no email address.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: corporate finance, valuation and markets → · All 1908 articles →