O365 Reconciliation Report

Using our reporting engine, you can group the O365 invoice items per O365 subscription along with the add-ons. The items can be grouped by:

• Subscription: The name of the O365 subscription.
• SubscriptionId: The internal identifier we keep for a subscription.
• Subscription External Id: The Id of the O365 subscription in Microsoft systems.
• Addon External Id: The Id of the O365 add-on in Microsoft systems.

For creating the reconciliation report you must do the following:

Navigate to BSS > Reports > Reports and select "New Report"

1. 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 O365 subscription. 
   Image RemovedImage Added
2. 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. Subscription - : the name of the BSS O365 subscription.
   5. Subscription External Id - : Microsoft Subscription ID.
   6. Addon External Id - Microsoft : Microsoft Add-on ID.
   7. Total - the : The total of the invoice item.
   8. Unit Cost - It : It is the cost per unit (e.g the cost for 1 license for item's billed period).
   9. Total Cost- : It is the unit cost multiplied by the invoice item quantity.
   10. Unit Price - : It is the price per unit.
   For the "Total" field you must select the sum function. The rest fields will be for grouping.
   Image RemovedImage Added
3. Step 3 - Reports Criteria - In this step add the following criteria:
   1. Define the billing period by setting the "Start Date" of the invoice items. 
   2. Define that you want your report to include only the O365 invoice items by defining that the field "Product Type" is equal to "Azure Active Directory; Azure Multi-Factor Authentication; Enterprise Mobility Suite; Intune; Microsoft Cloud Services; Microsoft Dynamics; MS Office 365 & Exchange Services; Windows OS; Yammer Enterprise". 
   3. Define "Is Analysis" is equal to "Yes".
      Image RemovedImage Added
4. Step 4 - Report Results - The results you will get from this report will have one line per O365 subscription along with the add-ons.
   Export them in an excel file for comparing them with the reconciliation file you have received from Microsoft for your O365 subscriptions and add-ons.
   Image RemovedImage Added

Reconciliation Process

The total per O365 subscription you have in your report is the amount you have charged to your customer. The reconciliation file from Microsoft includes the cost per O365 subscription and add-ons that you are paying. For comparing the numbers, you must do the following:

1. Download the O365 reconciliation file from Microsoft. You can find this file in Microsoft partner center portal  in Billing section.
   
2. Calculate the cost for each subscription in the Microsoft reconciliation file by grouping the line per Syndication Partner Subscription Number. The cost is the column Amount
   
   
   
3. Compare the cost you have included in your BSS report with the cost you have from the Microsoft reconciliation file.