How to calculate a year-end rebate: formula, method and worked examples

A year-end rebate is calculated by applying the rate of the tier reached in the negotiated scale to the annual turnover achieved with a supplier, the rebate base: rebate = base × rate. Depending on the agreement, the rate applies to all of the turnover (whole rate) or slice by slice (marginal rate), and additional scales, per product family or for growth, can be added to the base scale. This article walks through the method step by step, with a complete worked example.

What is the formula for a year-end rebate?

The base is the turnover the agreement uses for the calculation. Most often it is the calendar-year turnover excluding VAT, net of credit notes, as declared by the supplier and validated by the purchaser. When turnover is declared cumulatively each period (from 1 January to the end of the period), the rebate base is simply the cumulative figure of the last period of the year.

The scale is a series of contiguous tiers, each with a lower bound, an upper bound and a rate. The tier reached is the one that contains the base. The last tier has no upper bound: it covers everything above its lower bound.

The result is an amount in euros owed by the supplier to the distributor and settled, under the terms of the agreement, usually by a credit note. For the difference between year-end rebates, volume rebates and discounts, see our article on rebate vocabulary.

How to calculate a rebate in five steps

1. Fix the base. Take the validated annual turnover: the cumulative figure of the last period, once checked. An unvalidated figure should never drive the final calculation.
2. Find the tier reached. Look for the tier where lower bound ≤ base < upper bound. Reaching a lower bound exactly is enough to reach the tier.
3. Apply the rate mode. With a whole rate, multiply the entire base by the rate of the tier reached. With a marginal rate, multiply each slice by its own tier’s rate and add the results.
4. Add the additional scales. A family scale applies to that family’s turnover; a growth bonus is determined by progress against the previous year.
5. Round, then negotiate. Round once per scale, to the euro or to the cent. The rate obtained is the computed rate: negotiation then sets the retained rate, which gives the final amount.

Worked example: a four-tier scale with a whole rate

Take an annual agreement with the following base scale:

The supplier’s validated annual turnover is €1,250,000. That base lies between €1,000,000 and €2,000,000, so the tier reached is the third one, at 2%.

The same example with a marginal rate

With a marginal rate, each slice of turnover earns the rate of its own tier, like income tax brackets. Same scale, same turnover of €1,250,000:

The rebate falls to €10,000, an effective rate of 0.8%. The marginal mode is more progressive and removes threshold effects; the whole mode rewards crossing a tier much more strongly. With an identical scale, the choice changes the amount considerably, as we explain in whole rate or marginal rate: how to choose.

Adding family scales and a growth bonus

Many agreements add to the base scale. A family scale rewards the turnover of one product family with its own tiers, on top of the base scale computed on the total. A growth bonus rewards the supplier’s progress against the previous year.

How growth bonuses work, by amount or by percentage, is covered in a dedicated article.

Rounding, bounds and edge cases

• Bounds are half-open. A tier “from €1,000,000 to €2,000,000” contains €1,000,000 but not €2,000,000, which belongs to the next tier. Writing tiers this way avoids gaps (“€500,001 to €1,000,000”) and overlaps.
• One rounding per scale. Compute the exact amount, then round once, to the euro or the cent, with halves rounded up. Rounding to the cent first and then to the euro can shift the result by a euro.
• Consistent families. In the last period, the families plus “other” must add up to the declared total. Without this rule, the base scale and the family scales do not work on the same figures.
• Unknown prior year. If last year’s turnover is missing, the growth bonus cannot be computed. Treating it as zero would count all turnover as growth.
• Declining business. A negative change falls into a 0% tier: no growth bonus, but the base scale still applies.

From computed rate to retained rate

The rate that comes out of the scale is the computed rate. It is the starting point of the year-end negotiation: the purchaser proposes a rate, the supplier accepts, refuses or counters. The rate finally accepted is the retained rate, and it determines the final amount.

In our example, the purchaser proposes 2.25% on the base scale, the supplier counters with 2.10%, and the purchaser accepts. The base rebate becomes €1,250,000 × 2.10% = €26,250. With the other scales at their computed rate, the total becomes €26,250 + €4,000 + €3,000 + €6,250 = €39,500, an effective rate of 3.16%. The levers of this negotiation are covered in our guide to negotiating rebates.

Distance to the next tier: the figure to watch

During the year, the most useful figure is not the rebate already earned but the distance to the next tier: the turnover missing to change rate. In the example the supplier is at €1,250,000 and the 3% tier starts at €2,000,000. The distance is €750,000, or +60%. If it were reached, the base rebate with a whole rate would rise to €2,000,000 × 3% = €60,000.

This distance informs year-end buying decisions and prepares the negotiation of next year’s scale: a tier never reached motivates nobody, while a tier reached too easily costs the supplier without changing anyone’s behaviour.

Key takeaways

To go further, the complete year-end rebate guide covers the whole yearly cycle, and the glossary defines every term.