Prorated charges for addon subscriptions

Appxite

Introduction

This article explains how prorated charges are calculated and displayed for Add-on Subscriptions in Reconciliation Files by Microsoft and the Platform. It covers billing cycle alignment, charge calculations, and important considerations for understanding reconciliation data accuracy.

In this article:

Understanding prorated charges for Add-on Subscriptions

When Customers purchase Add-on Subscriptions, Microsoft aligns the billing cycle with the Parent Subscription billing cycle starting from the next Billing Cycle. This alignment affects how prorated charges are calculated and presented in Reconciliation Files.

Key points about prorated charge calculations:

  • Microsoft includes a charge line in the Reconciliation File for each different Quantity of Licenses used for a specific number of days.
  • Microsoft recalculates the unit price for prorated charges based on the number of days Licenses were used.
  • Microsoft calculates Amount and Subtotal columns based on the full unit price without rounding.
  • The unit price shown in the Reconciliation File displays two digits after the decimal point, with remaining digits truncated.
NOTE! Arithmetic calculations may not align between the multiple of unit price and Quantity versus the sum in the Amount and Subtotal columns. This can lead to questions from Partners about data accuracy.
WARNING! Reconciliation Data from Microsoft cannot be automatically imported into most ERP systems that calculate Invoice amounts by multiplying unit price with Quantity as a default setting.

The Platform currently follows the same calculation principles as Microsoft.

Example scenario

A Customer purchases the Add-on Subscription "Microsoft 365 Audio Conferencing." The Add-on Subscription inherits the Parent Subscription billing cycle starting from the next Billing Cycle.

In this example, the Add-on Subscription is purchased on April 14, 2021, and the Parent Subscription has a Billing Cycle Day of 24. From the next month, the Cycle Fee period for the Add-on Subscription will be April 25, 2021 – May 24, 2021.

Example with corresponding Charge Start and Charge End Dates:

No Offer Name Charge Start Date Charge End Date Charge Type
1 Microsoft 365 Audio Conferencing 4/14/2021 4/24/2021 Prorate fees when purchase
2 Microsoft 365 Audio Conferencing 4/25/2021 5/24/2021 Cycle fee
3 Office 365 E1 4/25/2021 5/24/2021 Cycle fee

How charge dates impact prorated calculations

The Charge Start Date and Charge End Date impact prorated charge calculations as follows:

Line 1 (Full billing cycle): Charge Start Date and Charge End Date are April 25, 2021 – May 24, 2021, resulting in the full list price of 35.26 EUR multiplied by Quantity.

Line 2 (Prorated billing cycle): Charge Start Date and Charge End Date are April 14, 2021 – April 24, 2021. This charge is prorated to follow the Parent Subscription cycle. To determine the unit price for line 2, Microsoft divides the Add-on Subscription price by the number of days in the month, then multiplies by the number of days in use: 35.26 / 31 * 11 = 12.5116129 EUR.

NOTE! Microsoft uses the full unit price to calculate Amount and Subtotal columns (12.5116129 x 10 = 125.12 EUR) and truncates all digits beyond the last two decimal places. This can lead to scenarios where Customers multiply unit price with Quantity and get slightly different results compared to Amount and Subtotal columns: 125.12 EUR versus 125.10 EUR.

Microsoft reconciliation file structure

Below are lines from the Microsoft Reconciliation File regarding the Add-on Subscription:

No Unit Price Quantity Amount Subtotal Comments
1 35.26 10 352.6 352.6 Cycle Fee for the next period (paid upfront for License-Based Subscriptions).
2 12.51 10 125.12 125.12 Charges for period from April 14, 2021 until April 24, 2021 for 10 Licenses.

Platform charge types

The Platform follows the same logic as Microsoft with slight differences in charge type naming.

NOTE! There are slight differences in charge type naming between Microsoft and the Platform. Prorated Add-on Subscriptions upon purchase have the charge type "Prorate fees when purchase" in Microsoft Reconciliation Files, while the Platform billing engine uses "Purchase Fee" as the charge type.
No Offer Name Charge Start Date Charge End Date Charge Type
1 Microsoft 365 Audio Conferencing 14.04.2021 24.04.2021 Purchase Fee
2 Microsoft 365 Audio Conferencing 25.04.2021 24.05.2021 Cycle Fee
3 Office 365 E1 25.04.2021 24.05.2021 Cycle Fee

For an extensive overview of naming conventions between charge types, refer to the Charge-Types article.

Summary

The article explains how prorated charges are calculated and displayed for Add-on Subscriptions in Reconciliation Files by Microsoft and the Platform. Microsoft aligns Add-on Subscription billing cycles with Parent Subscription billing cycles and recalculates unit prices based on the number of days Licenses were used. The unit price shown in Reconciliation Files is truncated to two decimal places, which can cause discrepancies when Customers manually calculate charges. The Platform follows the same calculation principles as Microsoft with minor differences in charge type naming conventions.

Was this article helpful?

0 out of 0 found this helpful

Add comment

Please sign in to leave a comment.