Symptoms

There is a difference in the NCE Azure usage file from CB Connect and Azure Usage Management tool on Microsoft Partner Center.

Cause

The discrepancy in the usage report in the Azure/Microsoft Portal and Connect usage report is due to the fact that Azure Usage Management is an informative tool that does not include discounts or credits that Microsoft applies to the partner. This is mentioned in their documentation - https://learn.microsoft.com/en-us/azure/cost-management-billing/costs/get-started-partners.

Therefore, it is expected to have some difference between the Microsoft portal vs Connect Usage.

Resolution

The connector uses the following formula:

cost rated = BillingPreTaxTotal / (1 - RateOfPartnerEarnedCredit)

Where BillingPreTaxTotal is partner cost (CR) and RateOfPartnerEarnedCredit (PEC) is going to be 0.15 if the partner has earned credit or 0 otherwise.

Use this formula if you want to check the exact amount which should be in the usage file.