Cancel regular charges in billed periods

Scenario

If you cancel a regular charge in a period that has already been billed, you might encounter a rounding difference between CCV and the total invoiced amount. It is because the CCV calculation is based on the charge effective start date and end date, whereas the invoice amount calculation has a dependency on the actual billing timing.

Note that this scenario happens only if you select From effective end date to end of the current billing period from When bill credit for recurring charges, based on billed period or credit period? when defining billing rules.

Example

Suppose your customer creates a subscription to your storage service with a charge of $25 per month from Feb 11, 2020 to Mar 10, 2020. The bill cycle day is the 11th day of the month.

On Mar 1st, 2020, your customer cancels this subscription. The CCV data is then updated to $25 * 19 (actual day in this service period) / 29 (days in this billing period) = $16.379310344827586, and it may round up to $17.

Since you have already billed the invoice, you have to credit back the invoice amount $25 * 10/ 29 = $8.620689655172414, and it may round up to $9.

The following table describes the updated CCV and invoice data:

From the preceding table, the CCV is $17 while the invoiced amount is $16, which introduces a $1 difference between the booking and billing amount. 

Solution

You can select Based on the total billing period amount and charged amount from When bill credit for recurring charges, based on billed period or credit period? when defining billing rules.