Retrospective rebates
- Denise McGettigan
You might be unfamiliar with the term retrospective when thinking about rebates. However, retrospective rules follow the standard understanding of the word. These rules look back and perform an action on past events, as they are typically calculated after a specific period has passed. This approach contrasts with the pro rata rules that look forward.
In the context of rebates, a retrospective is an adjustment. The highest accrued rebate is retrospectively applied to the applicable transactions in the specified date range to adjust their rebate value. This description can be broken down into the following points:
The highest accrued rebate is the highest bracket that the cumulative total hits. This is the starting point for all retrospective rebates.
The applicable transactions are those that meet the condition.
The condition is the Retrospective setting in the rule. It’s the method by which you want to apply the adjustment, which can be a threshold, such as from the start of their lowest bracket value, from the start of positive growth compared to their previous period, or from a specific amount or percentage. Alternatively, the condition can include all the transactions in the calculation period.
The specified date range is the calculation period.
The calculation results for retrospective rebates look similar to those for non-retrospective rebates in that there is a line for each bracket that is met, but there is an additional line for the retrospective adjustment.
Why use retrospective rebates?
The general goal of retrospective rebates is to incentivize large sales or purchases, long-term commercial relationships, or consistent growth year on year. Applying the highest accrued rebates to the applicable transactions gives the customer or vendor a higher rebate rate across all their sales for that period. Specific use cases are given for each method below.
Retrospective rebate methods
There are several ways to apply retrospective rebates, depending on whether the rule calculation type is Absolute or Growth.
Retrospective method | Absolute rule | Growth rule |
|---|---|---|
No | ✓ | ✓ |
Full amount | ✓ | ✓ |
From the start of growth |
| ✓ |
From the lowest bracket | ✓ | ✓ |
From a specific amount | ✓ | ✓ |
From a specific percentage |
| ✓ |
In the rule setup, click the Retrospective dropdown list and select the required method.
No retrospective rebates
When the Retrospective setting is set to No, there are no retrospective rebates; the calculated rebates are not adjusted. The bracket percentage or value is only applied to the transactions that have met the criteria for that bracket. This method works like income tax brackets.
The full amount
Any rules with the previous Retrospective setting of Yes will have this method selected by default.
The full amount retrospective method is available for absolute and growth rules. It applies the highest accrued bracket to all the transactions in the calculation period, including negative transactions. This type of rebate application is commonly referred to as a back-to-dollar-one rebate because the rebate is not just applied to the transactions in the highest accrued bracket but to all the transactions in that period, right back to the first dollar earned or spent.
This method is available for absolute and growth rules. With absolute rules, you’re dealing with an absolute amount, whereas with growth rules, you’re dealing with the rate of growth in the current period compared to that in the previous period.
This method is suitable when you want to pay or receive the highest rebate accrued to encourage a larger volume of sales or purchases.
From the start of growth
The start of growth retrospective method is available for growth rules only. As its name suggests, the condition (threshold) is the start of growth. It applies the highest accrued bracket to all transactions in the calculation period that contribute to positive growth from the previous period.
If the previous period doesn’t exist, the cumulative total for the previous period is considered 0, so every transaction in the current period is eligible for the retrospective rebate.
This method is suitable, for example, in payable rebates, when you want to use brackets as a baseline and reward customers for any increase in sales. But you don’t want to pay any retrospective rebates if there’s no growth in the current period.
From the lowest bracket
The lowest bracket retrospective method is available for absolute and growth rules. The condition (threshold) is the lowest bracket in the rule setup. Therefore, when applying the highest accrued bracket to the transactions in the calculation period, it doesn’t include transactions lower than the first bracket. Unlike the full amount method, not all transactions get the retrospective adjustment.
This method is suitable, for example, in payable rebates, when you want to use brackets as a baseline and encourage customers to spend more. But you don’t want to pay any retrospective rebates for transactions below the first bracket. It’s not enough for customers to spend more; you want customers to spend a minimum amount or grow their spending by a minimum percentage. The lowest bracket is the minimum requirement for the rebate; anything less than that is not eligible.
You can then clone the rebate rule for other customers or scenarios then change the brackets as required.
From a specific amount
The specific amount retrospective method is available for absolute and growth rules. The condition (threshold) is an amount specified by you in the rule setup. Therefore, when applying the highest accrued bracket to the transactions in the calculation period, it doesn’t include transactions with a cumulative total lower than that amount. Unlike the full amount method, not all transactions get the retrospective adjustment. If the specified amount is higher than a bracket amount, the transactions that fall into brackets lower than that amount will only get the bracket rebate, not the adjustment.
This method is suitable, for example, in payable rebates, when you want to use brackets as a baseline and encourage customers to spend more than a specific amount. You don’t think it’s fair to pay a high rebate amount for transactions with a cumulative total below that amount. You can then clone the rebate rule and set an individual threshold for each customer.
From a specific percentage
The specific percentage retrospective method is available for growth rules only. It works the same as the specific amount method above but uses a specified percentage of growth instead of an amount. The condition (threshold) is a percentage specified by you in the rule setup. Therefore, when applying the highest accrued bracket to the transactions in the calculation period, it doesn’t include transactions with a cumulative total lower than that percentage of growth. Unlike the full amount method, not all transactions get the retrospective adjustment. If the specified growth percentage is higher than a bracket growth percentage, the transactions that fall into brackets lower than that percentage will only get the bracket rebate, not the adjustment.
This method is suitable, for example, in payable rebates, when you want to use brackets as a baseline and encourage customers to grow their spending by a specific percentage. You don’t think it’s fair to pay a high rebate amount for transactions with a cumulative total below that growth rate. You can then clone the rebate rule and set an individual threshold for each customer.