Where is the reconciliation file in the Microsoft CSP portal? How can I verify my usage there? Also, what to do if Azure unbilled usage is not reflecting in the cloud automation platform?

Location of reconciliation file in the Microsoft CSP Portal

To get the reconciliation file:

1. Login to CSP Portal.

2. Navigate to Dashboard >> CSP >> Billing.

3. Under Billing, there are 2 tabs: 

   • Recurring

   • Recurring and one-time purchase USD

4. Select “Recurring and one-time purchase USD”. 

5. Select the ‘Year’ and ‘Month’ from the tabs below.

6. Download the “Daily rated usage reconciliation-xxxxxx-closed” sheet.

See Screenshot

Open

Verify your Azure usage

To verify the total usages amount:

1. Login to CSP Portal.

2. Navigate to Dashboard >> CSP >> Billing.

3. Under Billing, there are 2 tabs: 

   • Recurring

   • Recurring and one-time purchase USD

4. Select “Recurring and one-time purchase USD”. 

5. Select the ‘Year’ and ‘Month’ from the tabs below.

6. Download the “Daily rated usage reconciliation-xxxxxx-closed” sheet.

7. On the downloaded sheet, apply a filter based on the EntitlementId Name field.

See Screenshot

Open

8. Now, you need to sum the column “BillingPreTaxTotal”.

9. Now, apply the formula to verify the total usages amount.

The formula: BillingPreTaxTotal = (EffectiveUnitPrice* PCToBCExchangeRate)* Quantity

Steps to take if Azure unbilled usage is not reflecting in the Cloud Automation Platform

To view the Azure unbilled usages:

1. Login to CSP Portal.

2. Navigate to Dashboard >> CSP >> Azure Spending.

3. Under Azure Spending, there are 2 tabs: 

   • Azure

   • Azure Plan

4. Here, you can see the current estimate.