How are promotion charges calculated in reconciliation files?

Introduction

This article explains how Microsoft and the Platform calculate and display promotion charges in Reconciliation Files. It addresses common discrepancies between Unit Price calculations and total amounts, helping Sellers understand why arithmetic calculations may not align across different columns in Microsoft's reconciliation data.

Understanding Microsoft's promotion calculation method

When Microsoft applies promotional Discounts to products, they handle pricing calculations in a specific way that can create confusion. Understanding this method is essential for accurate Invoice reconciliation and ERP system integration.

Microsoft displays promotion discount information in the Total Other Discount column of the Reconciliation File. The Unit Price is adjusted to reflect the applicable discount, but the Amount column continues to show calculations based on the original list Price from the pricelist. Meanwhile, the Subtotal column reflects the discount adjustment by incorporating the Total Other Discount deduction.

The Unit Price shown in reconciliation files includes only two digits after the decimal point, with any remaining digits truncated rather than rounded. This truncation creates scenarios where manual calculations by multiplying Unit Price with Quantity produce slightly different results compared to the Amount and Subtotal columns, leading to questions from Partners about data accuracy.

Reconciliation file structure and columns

Microsoft's Reconciliation File contains several key columns that work together to show pricing and discount information:

• Unit Price: The discounted price per License, displayed with two decimal places (digits after the decimal are cut off, not rounded)
• Quantity: The number of licenses purchased
• Amount: Calculated using the original list price from the pricelist multiplied by Quantity
• Total Other Discount: The total discount amount applied through promotions
• Subtotal: The final amount after applying the Total Other Discount deduction from the Amount

Microsoft calculates the Subtotal value based on the full Unit Price without applying any rounding until the final step, which cuts off all digits beyond the last two decimal places.

Example scenario with Microsoft 365 A3 for faculty

A Customer purchases Microsoft 365 A3 for faculty licenses, and in the following month the Offer becomes eligible for select partners with a promotion of 25%.

To incorporate the discount, Microsoft reduces the Unit Price from 41.62 EUR by 10.405 EUR to 31.21 EUR, representing a 25% reduction. However, Microsoft does not adjust the Amount column, which still reflects the calculation based on the original price of 41.62 EUR multiplied by the license quantity. The discount adjustment becomes visible in the Subtotal column.

Here is how the data appears in Microsoft's reconciliation file:

The Amount column shows 41.62 × 135 = 5,618.70 EUR, calculated using the original list price. The Subtotal amount includes the Total Other Discount deduction: 5,618.70 - 1,404.68 = 4,214.02 EUR.

Additionally, if customers multiply Unit Price with Quantity, they produce a different result compared to the Amount column: 4,213.35 EUR versus 5,618.70 EUR.

How the Platform handles promotion pricing

The Platform simplifies promotion pricing by displaying only the updated Unit Price that includes the discount already applied. This approach provides clearer pricing information and reduces confusion when Partners review reconciliation data and process invoices for their customers.

Summary

Microsoft's reconciliation files handle promotions by showing discounted Unit Prices while maintaining original list prices in the Amount column, with discounts visible in the Total Other Discount and Subtotal columns. The truncation of Unit Price to two decimal places can cause arithmetic discrepancies between manual calculations and the displayed totals. The system addresses this complexity by presenting Unit Prices with discounts already incorporated, offering a more straightforward view of promotional pricing for Partners and their customers.