Reconciling Microsoft Subscriptions Quantities

Owned by Panagiotis Papanastasiou
Last updated: Jun 20, 2024
4 min read

For reconciling MS O365 BSS subscriptions with their Partner Center equivalents, we have implemented a tool called "Subscriptions Validation/Reconciliation" that is available in BSS Setup > Tools. The tool offers Partner Center details about each subscription, but more importantly, it validates BSS subscription vs Partner Center and reports the findings on a user-friendly interface. Additionally, it can be used to apply corrective actions if it detects an issue.

Reconciliation Options

On the field 'Validation With' you will see a drop-down list with 2 options. These options are the SubscriptionID and the Account. Each option will execute the process for a specific data set:



  1. SubscriptionID: The system will perform a check for a particular subscription. In order to locate the ID of a subscription, you must load the subscription in BSS and then locate the ID at the address bar of your browser and fill it in the field next to the drop-down list:



  2. Account: The system will perform a check for the subscriptions of a particular account. In order to locate the ID of an account, you must load the account in BSS and then locate the ID at the address bar of your browser and fill it in the field next to the drop-down list: 



Results Set

Since the release 3.28.148, the Get Hierarchy button, that was located beside the Microsoft Cloud Services Instance, is now remove because the Get Hierarchy process is now automated, whenever an instance is selected. Also, 
For running the validation process, you must click on the Validate button. The results are displayed in a tabular form:

The validation process will return one line for each synchronized BSS subscription (base and trial) along with extra lines for each subscription add-on. The information we return for each subscription/add-on is the following:

  1. Subscription / Addon ID: The BSS subscription ID.
  2. Is Trial: If the entry refers to a trial subscription or not.
  3. Is Addon: If the entry refers to a basic SU or to an Add-on.
  4. Is NCE Addon: If the entry refers to a New Commerce Experience (NCE) Add-on.
  5. Is Bundle Sub-Subscription: If the entry refers to a sub-subscription of a Bundle.
  6. Subscription Name: The BSS subscription Name.
  7. Microsoft ID:  The Microsoft Partner Center subscription ID.
    1. Change: This option under the Microsoft ID column (per Subscription) allows the change of the Subscription ID to another existing and valid subscription ID from inside the Microsoft Partner Center.
    2. View Subscription: This option, when clicked, redirects you to the view page of that subscription.
  8. Microsoft Start Date: The Microsoft Partner Center start date.
  9. Microsoft End Date: The Microsoft Partner Center end date.
  10. OfferURI: The subscription product MS code.
  11. Tenant ID: The MS tenant ID.
  12. Product Name: The product name. 
  13. Quantity: The quantity of the subscription in the BSS portal.
  14. Billing Cycle: The billing cycle of the entry (whenever applicable).
  15. Status: The status of the subscription in the BSS portal.
  16. Comments: The reconciliation results (errors, warnings, etc.).

The result table also contains two options per record:

  1. Change: a user can change the partner center subscription ID that is related to the BSS subscription.  

  2. View Subscriptions: the system fetches subscription information from the partner center without linking it to BSS subscriptions (this view contains all the tenants subscriptions regardless of validation entity).


    By hovering over the  'More Details' hyperlinked text in blue color, the tool will retrieve even more details from the Microsoft Partner Center:



Reviewing the Results

The subscriptions that you must investigate further for provisioning problems, are the ones that their background color is red. For these subscriptions, we suggest to first run the tool for the specific account in order to have the full picture of what Office365 subscriptions you have for this customer in BSS and what in partner center.

Then by checking the status and the quantities of the subscriptions in both systems you can decide for the next steps.

Table of Contents