Filters

Configure the the available filters to narrow down the results and filter out irrelevant data.

The following filters are available:

• CSP Partner - The name of your organization

• Type of Product - Select between Legacy or New Commerce Experience products

• Microsoft Product Types - Filter the results by one or more specific product types

• MS Subscription ID - The MPC subscription ID

• IWCP Account ID - The interworks.cloud BSS account ID

• IWCP Billing Account ID - The Bill To account ID from the BSS

• Date Slider - Select the Reconciliation Period: Select the date range using the slider(s). Note that the Valid Recon Period displayed above is in mm/dd/yyyy format.

• Account ID: Use this filter if you wish to reconcile the subscriptions of a specific end customer. You should enter the ID of the BSS account record.

• Billing Account ID: For indirect CSPs, this filter can be used for reconciling the subscriptions of a specific reseller. You should enter the ID of the BSS account record.

• MS Subscription ID: You can use this filter to reconcile a specific Microsoft subscription for the defined reconciliation period.

• Microsoft Product Types: Use this filter for reconciling only specific types of Microsoft services:

  • Dynamics 365 - Legacy Dynamics 365

  • MSCloudServices - Legacy Office 365

  • MSOnlineServicesNceProductType - New Commerce Experience

  • MSAzurePlanProductType - Microsoft Azure Plan

  • MSSoftwareSubscriptionsProductType - Software Subscriptions

• CSP Partner - By default will be the name of your organization. This field will have more options only if you have country tenants and you have asked the same Power BI user to be able to reconcile all your country tenants.

• Results Filtering -

  • All - Show all entries subscriptions within the specified reconciliation period

  • Discrepancies - Only show entries subscriptions with discrepancies

  • Missing Data - Only show entries subscriptions where data is missing. It means that items are missing for the specific subscription in our system or MS reconciliation files.

Tables

Reconciliation Table

The reconciliation table is used to look up subscriptions contains the following columns:

• Subscription ID - The subscriptions for which there was a transaction during the specified reconciliation period

• BSS Total Cost - The total cost recorded by the BSS for the specified reconciliation period

• MS Total Cost - Same as above, recorded by Microsoft

• Cost Difference - Includes one of the following symbols:

  • Green Checkmark - No difference

  • Red X - A difference of over 1.00€

  • Yellow Exclamation Mark - Insufficient data

Hovering over an entry shows more details in an expanded tooltip.

BSS Data Table

This table contains data returned by the interworks.cloud platform API.

The table contains the following columns:

• Invoice Code - The invoice reference code

• Invoice Date - The date the invoice was issued

• Billing Account ID - The Bill To account

• BSS Subscription ID - The ID of the subscription in the BSS

• Product - The product the subscription is for

• Start Date/End Date - The start and end dates of the subscription

• Qty - Quantity; the amount of licenses

• Unit Cost - The cost per license

• Total Cost - The cost for the entire quantity

• Unit Price - The retail price without discount(s)

• Disc. % - The percentage of discount applied to the retail price

• Final Amount - The total amount for the entire quantity, with the discount applied

MS Data Table

This table contains data obtained from Microsoft.

• Type - Legacy or NCE

• Product - The product the subscription concerns

• Start Date/End Date - The start/end dates of the subscription

• Change Type - The type of change which created the record

  • New - A subscription was created

  • Renew - A subscription was renewed

  • Convert - The billing cycle of a subscription was changed (i.e. a monthly subscription becomes annual)

  • Add Quantity - License(s) added

• Charge Start Date/Charge End Date - The start and end dates that are charged

• Qty - Quantity; the amount of licenses

• Unit Price - The price for a single license

• Sub Total - The total for the entire quantity. VAT is not included.

• Total - The sub total including VAT

Detailed Invoices Tables

Select a subscription from the Reconciliation Table, and then select See Detailed Invoices to show the detailed invoices table.

The Detailed Invoices Table is separated into BSS Data and MS Data.

BSS Data

The BSS Data contains the following columns in addition to those seen in the previous section:

• Account ID - The account issuing the invoice

• Invoice Type - Is either debit or credit

• Invoice Stage - The status of the invoice

• Invoice Due Date - The expiration date of the invoice

MS Data

The MS Data contains only the ID of the subscription, in addition to the columns seen in the previous section.