This page explains how you will reconcile the Azure Reserved Instance charges our system generates for your customers with the charges you receive from Microsoft. For the reconciliation, you will use a report that you can create in your BSS.

Azure Plan Reserved Instance Reconciliation Report

For creating the reconciliation report you must do the following:

1. Navigate to BSS > Reports > Reports and select "New Report"
2. Step 1 - Select to create a report for Invoices and Invoice Items. Check also the option "Show the sums of the report only" for getting one line per Azure Reserved Instance. 
   
3. Step 2 - Select the following fields 
   1. Invoice #: The BSS invoice code.
   2. Account: The end customer.
   3. Billing To: - The reseller of the end-customer.
   4. Reservation Reference Order ID: The Azure Reservation ID from Microsoft.
   5. Total: The total of the invoice item.
      

   For the "Total" field, you must select the sum function. The rest fields will be for grouping.
   
   

4. Step 3 - Reports Criteria - In this step add the following criteria:
   1. Define the billing period by setting the first "Start Date" as "greater than or equal to" and the second "Start Date" as "less than or equal to" of the invoice items.
   2. Define that you want your report to include only the product types that are equal to Azure Reserved Instances. 
   3. Then, make sure that the rule is defined as "1 AND 2 AND 3".
      
      
      
5. Step 6 - Report Results - The results you will get from this report will have one line per Azure Plan Reserved Instance. You can export the results in an excel file for comparing them with the reconciliation file you have received from Microsoft for your "Azure Plan Reserved Instances" as well as the "Microsoft Azure Reserved Instances". 
   
   
   

Reconciliation Process

The total per Azure Plan Reserved Instance you have in your report is the amount you have charged to your customer. The reconciliation file from Microsoft includes the cost per Azure Plan Reserved Instance and Azure Reserved Instance that you are paying. For comparing the numbers, you must do the following:

1. Download the Azure Reserved Instance reconciliation file from Microsoft. You can find this file in Microsoft partner center portal in the Billing section.
   
   
   
2. Calculate the cost for each subscription in Microsoft reconciliation file by grouping the line per Reservation Order ID.
   
   
3. Compare the cost you calculated with the cost you have from Microsoft reconciliation file.