Several time-based methods are available for calculating absolute rebates. This page explains how to calculate those rebates quarterly over a specified period.
With quarterly rebates:
The cumulative total is calculated for the transactions from the start of the quarter up to the start of the calculation period, where:
The start of the first quarter is the validation period start date, and the same day is used for the subsequent quarters (every three months). For example, if the validation period starts on February 10, 2023, the quarter start dates will be February 10, 2023, May 10, 2023, August 10, 2023, November 10, 2023, February 10, 2024, and so on. However, if the validation period starts on a day that not all months have, only the affected month will be adjusted. For example, if it starts on March 31, 2023, the quarter start dates will be March 31, 2023, June 30, 2023, September 30, 2023, December 31, 2023, March 31, 2023, and so on.
The calculation period might not start on the same date as the validation period. In this example, the year starts in January, but the calculation starts in August.
Then, the transactions in the calculation period are added to that cumulative total and put into brackets accordingly. This ensures the calculation starts in the correct bracket.
In this case, you get the same total whether you calculate the individual months separately or the whole year in one calculation.
If the calculation period spans multiple quarters, the cumulative total is reset to $0 at the start of each quarter (as defined by the validation start date).
In the rule setup, click the Amounts Per dropdown list and select Quarter. By default, the quarterly calculation uses the same start date as the rule. If you want to change this, select Other, then select the month.
For example, suppose the rule setup uses the Percentage of Value calculation method, the Value bracket basis, and three brackets exist. The rule year starts in January.
Example 1: Start the quarters and calculation on the rule start date
This is a straightforward use case, so in the results, you get 12 rows, three for each quarter.
Example 2: Start the quarters on the rule start date but start the calculation on a different date
Example 3: Start the quarters in a different month to the rule start date