Viewing Reconciliation Report

As a member of the Microsoft Cloud Solution Provider (CSP) program, you are regularly charged for selling Office 365 services. As a service provider, you charge your customers for using Office 365 services. To reconcile your charges with the charges of your customers, you can use reconciliation reports generated by Odin Automation.

A reconciliation report, which is generated for a specified period, contains information collected from completed orders of Office 365 subscriptions. Each item of a reconciliation report belongs to an order detail and contains the following columns:

  • PartnerId – The identifier of the provider/reseller account in the Microsoft Partner Center the row belongs to.
  • CustomerTenantId – The identifier of the corresponding customer account in the Microsoft Partner Center.
  • CustomerName – The name of the corresponding customer account in the Microsoft Partner Center.
  • MpnId – The value of the MPN_ID attribute. See the Configuring Offers for Resellers section for details.
  • ResellerID – The identifier of the provider/reseller account in Odin Automation the row belongs to.
  • OrderNumber – The number of the corresponding order in Odin Automation.
  • SubscriptionId – The identifier of the corresponding Office 365 subscription in Odin Automation.
  • SyndicationPartnerSubscriptionNumber – The identifier of the corresponding subscription in the Microsoft Partner Center (if the order detail belongs to an Office 365 resource). The identifiers of the corresponding subscriptions in the Microsoft Partner Center (if the order detail belongs to an Office 365 composite resource or an Office 365 subscription).
  • ResourceTypeId – The identifier of the corresponding Office 365 resource in Odin Automation (if the order detail belongs to an Office 365 resource). The identifiers of the corresponding Office 365 resources in Odin Automation (if the order detail belongs to an Office 365 composite resource or an Office 365 subscription).
  • DurableOfferId – The identifier of the corresponding offer from your partner price list (if the order detail belongs to an Office 365 resource). The identifiers of the corresponding offers from your partner price list (if the order detail belongs to an Office 365 composite resource or an Office 365 subscription).
  • OfferName – The name of the corresponding Office 365 resource in Odin Automation (if the order detail belongs to an Office 365 resource). The names of the corresponding Office 365 resources in Odin Automation (if the order detail belongs to an Office 365 composite resource or an Office 365 subscription).
  • SubscriptionStartDate – The start date of the corresponding Office 365 subscription in Odin Automation.
  • SubscriptionEndDate – The end date of the corresponding Office 365 subscription in Odin Automation.
  • ChargeStartDate – The value of the Detail Start Date property of the order detail.
  • ChargeEndDate – The value of the Detail End Date property of the order detail.
  • ChargeType – The type of customer charges (PURCHASE FEE for a setup fee, CYCLE FEE for a recurring fee).
  • UnitPrice – The value of the Unit Price property of the order detail.
  • Quantity – The value of the Quantity property of the order detail.
  • Amount – It is calculated in the following way: <the value of the Unit Price property of the order detail> * <the value of the Quantity property of the order detail> * <the value of the Duration property of the order detail>.
  • TotalOtherDiscount – The value of the Discount property of the order detail.
  • Subtotal – It is calculated in the following way: <the value of the Unit Price property of the order detail> * <the value of the Quantity property of the order detail> * <the value of the Duration property of the order detail> - <the value of the Discount property of the order detail>.
  • Tax – The value of the Tax Total property of the corresponding order in Odin Automation. Note that if an order contains several order details, Tax is only shown for the item of the first order detail.
  • TotalForCustomer – The value of the Extended Price property of the order detail.
  • Currency – The type of currency.

A reconciliation report can also be generated under a reseller account. To provide a reseller account with this ability, the reseller account must be subscribed to the Office 365 Customer Management service plan. This service plan is created in the following way:

  • It is based on the Office 365 service template.
  • Zero prices are set in all subscription periods of the service plan.
  • It does not contain any resource rates.

When subscribing a reseller account to the Office 365 Customer Management service plan, you will need to fill out the Office 365 subdomain form. In the form, select Sign up for a new Microsoft account and specify any available subdomain. After subscribing the reseller account to the service plan, the reseller account will obtain the above ability, whereas no actual provisioning will occur in the Microsoft cloud.

To view a reconciliation report, perform the following actions:

  1. Log in to Provider/Reseller Control Panel.

  2. In Provider Control Panel:

    1. Go to Services > Applications, and then select the Office 365 application.
    2. Select the Instances tab, and then select the application instance to generate the report for.

    In Reseller Control Panel

    1. Click Customer CP.
    2. Select the Office 365 tab.
  3. Select the Reconciliation Report tab.
  4. Specify a period by selecting Start Date and End Date, and then click Export Data.