Accruing year-end rebates during the year: landing and forecasting

To accrue a year-end rebate before the year closes, first estimate full-year turnover, the landing, derive the expected tier and effective rate from it, then apply that rate to the turnover achieved so far. Applying the scale to the year-to-date figure alone almost always understates the rebate, because the rate depends on the annual level. Here is the method, three ways to estimate the landing and the precautions to take near a tier bound.

Why accrue rebates during the year?

For a distributor, year-end rebates are often a large share of the purchasing margin; for a supplier they are a liability to settle. Waiting for the negotiation to end, sometimes two months after year end, distorts monthly and quarterly results and concentrates every variance in a single closing. A regular accrual, updated each period, gives a realistic margin throughout the year and avoids surprises.

The principle: the rate depends on the annual level

A tiered scale applies to the whole year’s turnover. At the end of June, a supplier with cumulative turnover of €610,000 is only in the 1% tier; but if it ends the year around €1,250,000 its rate will be 2%. Accruing €610,000 × 1% = €6,100 would be half the right amount.

The usual method therefore has three steps:

1. Estimate the landing, the turnover expected for the full year.
2. Apply the scale to that landing to get the estimated annual rebate and the expected effective rate.
3. Apply that effective rate to the turnover validated to date.

Three ways to estimate the landing

Cross-checking all three is best practice: a large gap between them is information in itself and deserves a question to the supplier. The declarations behind these estimates should be validated (see reliable turnover declarations).

Example: the accrual at the end of June

Near a tier bound, accrue a range

With a whole rate, the accrual is stable while the landing stays away from a bound, and unstable as soon as it gets close. If the landing hesitates between €980,000 and €1,020,000, the estimated annual rebate moves from €9,800 (1%) to €20,400 (2%): it doubles for a 4% difference in turnover.

A marginal rate does not have this drawback: the rebate grows without jumps, and an estimation error of a few percent changes the accrual by only a few percent. It is one of the arguments in its favour (see whole rate or marginal rate).

On the accounting side

The distributor typically records the expected rebate as a rebate receivable, and the supplier as an accrued rebate liability. In France, the general chart of accounts has dedicated accounts for both (4098 for rebates to be received, 4198 for rebates to be granted). How to treat the negotiated part above the computed rate depends on your accounting policies and framework: confirm it with your accountant or auditor.

A common prudence rule is to accrue at the rate computed by the scale, and to recognise the negotiated difference only once the retained rate is accepted.

Across the supplier portfolio

An accrual is computed supplier by supplier, but read at account level. Three views help finance teams:

• Total projected rebates, the sum of every supplier’s estimated annual rebate, compared with budget and with last year.
• The average effective rate, total projected rebates divided by total landing: it sums up the yield of the agreements and flags drift when it moves from one quarter to the next.
• The list of suppliers close to a bound, sorted by distance to the next tier: they carry most of the accrual’s uncertainty, and often most of what is at stake at year end.

Concentration matters too: if five suppliers account for most of the turnover, an estimation error on one of them weighs more than all the others combined. Focus your checks where the money is.

The most common accrual mistakes

• Accruing on the year-to-date figure at the rate of the tier already reached: the accrual is understated all year, then caught up in one go at year end.
• Using unvalidated figures: one declaration ten times too large is enough to distort the month’s margin.
• Forgetting additional scales: family scales and growth bonuses come on top of the base scale and must be estimated the same way.
• Ignoring seasonality: a linear extrapolation in June overstates the turnover of a supplier whose business slows in the second half.
• Not analysing the final variance: without reconciling the accrual with the final amount, the same biases repeat the following year.

Track and adjust every period

• Update after each validation. The accrual follows validated turnover, not declared turnover: a figure awaiting review should not move it.
• Track the effective rate. Across all suppliers, the average effective rate (total rebates ÷ total turnover) gives a quick reading of back margin.
• Reconcile at year end. Once the retained rates are accepted, compare the accrual with the final amount and analyse the variance: landing estimate, change of tier or negotiation.

In Palier

Palier’s analysis dashboard shows, for each supplier and for the account, turnover validated to date, the landing declared by the supplier (or, failing that, a linear extrapolation flagged as an estimate), the projected rebate scale by scale, the effective rate, the year-over-year change and the distance to the next tier. Data exports to Excel, and finance can have read-only access. See Palier for finance teams.

Key takeaways