Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
There are several time-based methods for calculating rebatesOf the many variations of calculating rebates, a primary differentiator is the period of calculation and payout. This page explains about monthly rebateshow to calculate and pay or receive rebates in monthly periods.
With the Amounts per > Month option, the rule validation period (from start to end date) can be of any length greater than one month. However, the calculation period can’t be more than 12 months, regardless of when your year starts.
With monthly rebates, the :
The cumulative total resets to zero every month.
The cumulative total is calculated for the transactions from the start of the calendar month
up to the start of the calculation period.
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.
Setup
In the rule setup Brackets section, click the Amounts Per dropdown list and select select Amounts per > Month.
Image RemovedFor example, suppose the rule setupExample
Suppose the rule starts on January and it uses the Percentage of Value calculation method, the Value bracket basis, and there are has three brackets. The calculation results of the calculation depend on whether a cumulative total applies to the calculation period.
No cumulative total:(A) Full months
If the calculation period is from June
1st1 to July
31st31 (two full months), the results are split into two month periods. As the calculation started at the start of the calendar month, there's no cumulative total to factor in, so the rebate for each month is calculated as usual, based on the brackets that are hit in that period.
Image RemovedCumulative total: Image Added(B) Partial months
If the calculation period is from June
21st21 to July
31st31 (partial period), there is a cumulative total to factor in.
In this exampleTherefore, the
cumulative total from June 1st to 21st is 21,322. So, thepartial period from June
22nd22 until the end of June is already in the 5% bracket.
Image RemovedImage AddedOn this page
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|