Billing frequency changed from monthly to annual

As an example let's use a subscription with billing date - 7th of the month. On the 14th of May customer decides to change from monthly to annual billing frequency. Going forward subscription will have the new billing cycle day for subscription. New billing cycle date is 14th (day when frequency change was done) and first billing period with new cycle will be from 14/05/2019 till 14/05/2020.

mceclip0.png

 

 

InvoiceDateUtc

ChargeStartDate

ChargeEndDate

ChargeType

Quantity

UnitPrice

TotalPrice

Invoice 1

11/03/2019

07/03/2019

07/04/2019

Purchase Fee

102

62.93

6 418.86

Invoice 2

11/04/2019

07/04/2019

07/05/2019

Cycle Fee

102

62.93

6 418.86

Invoice 3

11/05/2019

07/05/2019

07/06/2019

Cycle Fee

102

62.93

6 418.86

Invoice 4

11/06/2019

14/05/2019

07/06/2019

Correction

1

-4 969.44

-4 969.44

Invoice 4

11/06/2019

14/05/2019

14/05/2020

Purchase Fee

102

755.16

77 026.32

Invoice 5

11/06/2020

14/05/2020

14/05/2021

Cycle Fee

102

755.16

77 026.32

In period 07/05/2019 - 07/06/2019 are 31 days. Monthly fee is 62.93, price for 1 day = UnitPrice/(days count in billing cycle) = 62.93/31=2.03.

In period 07/05/2019 – 14/05/2019 are 7 days, UnitPrice for 7 days = 7*2.03 = 14.21.

In period 07/05/2019 - 07/06/2019 used quantity is 102, TotalPrice = 102*14.21 =1 449.42.

In Invoice 3 - TotalPrice=6 418.86. 

Due to billing frequency change from monthly to annual on 14th of May, then for period 14/05/2019 – 07/06/2019 customer has not used subscription. As such monthly cycle and Invoice 4 contains Correction for period 14/05/2019 – 07/06/2019 for unused days = 1 449.42 - 6 418.86 =-4 969.44.

In Invoice 4, line with ChargeType = Purchase Fee is first fee after frequency change. UnitPrice = (monthly price) * (month count in period 14/05/2019 - 2020-05-14) = 62.93*12 = 755.16.

Was this article helpful?

0 out of 0 found this helpful

Add comment

Please sign in to leave a comment.