Articles

How much does a month-end cut-off error move monthly revenue, gross margin and EBITDA?

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.

The assumptions

One illustrative manufacturer, June close, $ millions
ItemValue
True June revenue8.00
Cost of sales62% of revenue (4.96)
Operating expenses1.84
True EBITDA (monthly)1.20
Trade receivables at 30 June (true)12.00
Shipped on 29 and 30 June, invoiced on 1 Julyrevenue 0.64, cost 0.40
Trailing twelve-month EBITDA, net debt13.2, 39.6
Materiality threshold5% of monthly EBITDA

Step 1: what the close shows

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.

Step 2: the margin barely moves, EBITDA does

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%.

Step 3: DSO moves the wrong way

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.

Step 4: how large an error matters

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%.

The same shipments at different sizes (margin on the item 37.5%)
Unrecorded revenueRevenue understatedGross margin reportedGross profit lostEBITDA understated
0.162.0%38.01%0.065.0%
0.324.0%38.02%0.1210.0%
0.648.0%38.04%0.2420.0%
0.9612.0%38.07%0.3630.0%
1.2816.0%38.10%0.4840.0%

What if: the error reverses in July

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.

The common mistakes

Takeaway

Questions readers ask

What is a cut-off error?

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.

Why does a small revenue error move EBITDA so much?

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%.

If the error reverses the next month, does it matter?

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 workbooks behind this article

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.

Open the companion files →

Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

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