Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Several time-based methods are available for calculating absolute rebatesOf the many variations of calculating rebates, a primary differentiator is the period of calculation and payout. This page explains how to calculate those rebates quarterly over a specified periodand pay or receive rebates in quarterly periods.
With the Amounts per > Quarter option, you can choose when your year starts, in other words, when you want the quarterly periods to begin. This can be the same as the rule validation date or a different specified date.
Calculations are only allowed for 12 months, regardless of when your year starts.
With quarterly rebates:
The cumulative total is calculated for the transactions resets to zero every quarter.
The quarters start at the specified start of the year unless the calculation period is different.
When the calculation period starts in the middle of a quarter, the cumulative total from the start of the quarter
to the start of the calculation period
The start of the first quarter is the validation period start date, and the same day is used for the subsequent quarters (every three monthsis calculated and used as the starting point. Then the rebate is calculated until the end of that quarter, and following in a regular pattern with other quarters. Hence, in some cases, the results would have more than four quarterly periods.
When the calculation period starts outside the rule validation date, the calculation period is trimmed to the rule validation period. The quarters are calculated as above.
Setup
In the rule setup Brackets section, select Amounts per > Quarter, then select where thequarters start:
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.
Image RemovedImage RemovedExample 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 dateOn the rule start date: The quarters start on the same date as the rule starts (validation period start date). For example, if
the validation period starts on February 10, 2023this is January 1, the first quarter
start dateswill be
February 10, 2023, May 10, 2023, August 10, 2023, November 10, 2023, February 10, 2024from January to March, the next will be from April to June, and so on.
However, if the validation period starts on a day that not all months have, only the affected month will be adjustedOther: This option allows you to set a date different from the rule start date. For example, if
it starts on March 31, 2023you select February 1, the first quarter
start dateswill 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.
Image RemovedFor example, suppose the rule setup uses the Percentage of Value calculation method, the Value bracket basis, and three brackets exist. The ruleyear starts in January.from February to April, the next from May to July, and so on.
Example
In this basic example, two calculations are run for the same rule, yielding different results. The same calculation date range (Jan 1, 2022 to Dec 32, 2022) is applied to each calculation. The calculation start date is the same as the rule start date (Jan 1, 2022). The only difference is the date on which the quarters start.
(A) Where the quarterly year starts on the rule date
Suppose you start the calculation on the same date as the rule and run for the whole calendar year (12 months). Your quarterly year also starts on the rule start date.
Image AddedIn the results, you can see the brackets are applied to the quarters. At the start of each quarter, the total resets to zero. There are 12 bracket rows, 3 for each quarter.
Image Added(B) Where the quarterly year starts on a different date
Suppose you start the calculation on the same date as the rule and run for the whole calendar year (12 months), however, the quarters start on a different date (February 1). In this case, some of the transactions (January 1 to 31) will fall outside the range of the quarterly year.
Image AddedIn the results, you can see the brackets are applied to the month of January and reset to zero for the start of the first quarter on February 1. From there, the quarters are calculated as usual, resetting the total to zero each time. There are 15 bracket rows: the first 3 rows are for the month of January, and then there’s 3 rows for each quarter.
Image AddedOn this page
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|