Account level fixed-amount discount charge application to multiple subscriptions
This topic explains how to apply an account-level fixed-amount discount charge to multiple subscriptions, detailing the discount applying sequence, amount allocation, and MRR calculations.
This example demonstrates how an account level fixed-amount discount charge is allocated on the four regular charges that belong to the two subscriptions of the same customer account. You can see the following analysis in this example:
- The discount applying sequence
- The discount amount allocation
- The charge-level MRR calculation
- The subscription-level MRR calculation
Example1: Suppose a new customer account (as the subscription owner) has two subscription.
- Subscription 1 is a half year termed subscription with a rate plan containing two regular charges triggered on 1/1/2019.
- Charge 1 (R1) is a regular monthly charge of $300/month.
- Charge 2 (O1) is a regular one-time charge of a $100 flat fee.
- Subscription 2 has the same product rate plan (containing R2 and O2), but the effective term is from 1/16/2019 to 7/1/2019.
- An account-level discount charge of $1500/quarter is added to Subscription 1 for the first quarter.
The discounting logic and the MRR calculation for this example can be illustrated by the diagram below:
The discount applying sequence:
To apply an account-level discount, the regular charges in all the subscriptions of the target subscription owner account is sorted to the following sequence. See Sequence of applying a fixed-amount discount charge to multiple regular charges .
- R1
- R2
- O1
- O2
The discount amount allocation:
When applying a discount to a regular recurring charge, the discount must be evenly distributed and applied as a monthly recurring charge:
- When applying a discount on R1, the $1500/q recurring quarterly discount charge is viewed as a $500/m monthly recurring discount charge. The price of R1 in the charge period from 1/1 to 4/1 is $300/m, so at maximum, a recurring discount charge of $300/m can be applied to R1. The discount balance as a recurring monthly charge is $200/m (500-300) for the charge period from 1/1 to 4/1.
- The discount charge is then applied as a 200/m recurring discount charge on R2. As the price of R2 in the charge period from 1/16 to 4/1 is $300/m, the discount balance as a recurring charge is 0 in the charge period from 1/16 to 4/1 and $200/m in the charge period from 1/1 to 1/16.
To apply a discount to a one-time charge, the discount is applied as a total amount for the discount charge's effective time range.
- To apply the discount on O1, the discount balance as a total amount for the quarterly discount charge is 200 - 200*16/31=$96.744. As the price of O1 is $100, after the discount is applied to O1, the discount balance is 0.
- As no discount balance is available from 1/1 to 4/1, no discount can be applied to O2.
The charge-level MRR calculation:
The Gross MRR, Discount, and Net MRR of each charge or charge period are calculated as in the table below. O1 and O2 are one-time charges and are not counted in the MRR calculation.
|
Charge |
Charge Period |
Gross MRR |
Start Date |
End Date |
Applied Discount |
Discount Balance |
Discount MRR |
Net MRR |
|---|---|---|---|---|---|---|---|---|
|
R1 |
Charge Period 1 |
300 |
1/1 |
4/1 |
-300/m |
500/m-300/m=200/m |
300 |
0 |
|
Charge Period 2 |
4/1 |
7/1 |
0 |
n/a |
n/a |
300 | ||
|
R2 |
Charge Period 1 |
300 |
1/16 |
4/1 |
-200/m |
200/m-200/m=0/m |
200 |
100 |
|
Charge Period 2 |
4/1 |
7/1 |
0 |
n/a |
n/a |
300 |
The subscription-level MRR calculation:
By adding up the MRR of the charge segments or charge periods with the same start and end dates, the MRR of Subscription 1 and Subscription 2 is as shown in the table below:
|
Subscription |
Charge Period |
Start Date |
End Date |
Subscription Gross MRR |
Subscription Discount MRR |
Subscription Net MRR |
|---|---|---|---|---|---|---|
|
Subscription 1 |
R1 Charge Period1 |
1/1 |
4/1 |
300 |
300 |
0 |
|
R1 Charge Period 2 |
4/1 |
7/1 |
300 |
n/a |
300 | |
|
Subscription 2 |
R2 Charge Period 1 |
1/16 |
4/1 |
300 |
200 |
100 |
|
R2 Charge Period 2 |
4/1 |
7/1 |
300 |
n/a |
300 |