Table of contents

Use the reconciliation files to bill your customers

Last Updated: 10/20/2016

Applies to

  • Partner Center operated by 21Vianet

For a detailed line-item view of each charge in a billing cycle, download the reconciliation files from the Partner Center dashboard. The details include charges for each customer's subscriptions, and detailed events (such as a mid-term addition of seats to a subscription).

Itemize by partner

Partners in the indirect model can use these additional fields in license-based reconciliation files to itemize by reseller.

MPN IDDescription
MPN ID

The MPN ID of the CSP partner (direct or indirect).

Reseller MPN ID

Only appears on reconciliation files for partners in the indirect model.

The MPN ID of the reseller of record for the subscription. This corresponds to the reseller ID listed for the specific subscription in Partner Center.

To view or update the reseller, in the Dashboard menu, select Customers, then choose the customer from the list. In the customer menu, select Subscriptions, choose the subscription from the list. Select Update to change the reseller (MPN ID).

If a CSP partner sold the subscription directly to the customer, their MPN ID is listed twice, as both the MPN ID and the Reseller MPN ID.

If a CSP partner has a reseller with no MPN ID, this value is set to the partner’s MPN ID instead.

If the CSP partner removes a reseller ID, this value will be set to -1.

License-based file fields

To reconcile your charges against your customer's orders, compare the Syndication_Partner_Subscription_Number from the reconciliation file against the Subscription ID from Partner Center.

ColumnDescriptionSample Value
OperatingUnit

Unique identifier for a specific billing entity, in GUID format. Not required for reconciliation, however may be useful information. Same in all rows.

8ddd03642-test-test-test-46b58d356b4e
CustomerNumber

Unique identifier for the customer. May be useful to identify the customer when contacting support but not for reconciliation.

123456789
OrderID

Unique identifier for an order. May be useful to identify the order when contacting support but not for reconciliation.

566890604832738111
SubscriptionID

Unique identifier for a subscription. May be useful to identify the subscription when contacting support but not for reconciliation.

This is not the same as the Subscription ID on the Partner Admin Console. Please see Syndication_Partner_Subscription_Number.

usCBMgAAAAAAAAIA
SyndicationPartnerSubscriptionNumber

Unique identifier for subscriptions. A customer can have multiple subscriptions for the same plan, so this is important for reconciliation file analysis.

This field maps to the Subscription ID in the Partner Admin Console.

fb977ab5-test-test-test-24c8d9591708
OfferID

Unique offer ID. Standard offer ID as per price list.

306855
DurableOfferID

Unique durable offer ID, as defined in the price list.

1017D7F3-6D7F-4BFA-BDD8-79BC8F104E0C
OfferName

The name of the service offering purchased by the customer, as defined in the price list.

Office 365
SubscriptionStartDate

The subscription start date, set to the day after the order is submitted. By looking at the subscription start date in conjunction with the end date, you can determine if the customer is still within the first year of the subscription or if the subscription has been renewed for the following year.

The time is always the beginning of the day, 0:00.

2/1/2015 0:00
SubscriptionEndDate

The subscription end date: 12 months + x days after start date (to align with partner billing date) or 12 months from renewal date.

At renewal, prices are updated to the current price list. Customer communication may be required in advance of automated renewal.

The time is always the beginning of the day, 0:00.

2/1/2015 0:00
ChargeStartDate

Start day of the charges.

When a customer changes seat numbers, this number is used to calculate per-day (pro-rata) charges.

The time is always the beginning of the day, 0:00.

2/1/2015 0:00
ChargeEndDate

End day of the charges.

When a customer changes seat numbers, this number is used to calculate per-day (pro-rata) charges.

The time is always the end of the day, 23:59.

2/28/2015 23:59
ChargeType

The type of charge or adjustment.

Charges:
  • PURCHASE_FEE: Initial charge for a subscription
  • CYCLE_FEE: Periodic charges for a subscription
ConvertResources
  • CANCEL_USAGEFEE: Access usage fee upon cancellation for unpaid usage during the current billing period
  • CYCLE_USAGEFEE: Access usage fee for the current billing period
Prorations:
  • PURCHASE_PRORATE: Prorated fees upon purchase
  • CANCEL_PRORATE: Prorated refund for unused portion of service upon cancellation
  • ACTIVATION_PRORATE: Prorated fees from activation until end of billing period
  • RENEW_PRORATE: Prorated fees upon subscription renewal
InstanceProrates:
  • CANCEL_INSTANCEPRORATE: Prorated charges refunded to the customer when associated seats are changed
  • CYCLE_INSTANCEPRORATE: Prorated charges assessed from the customer when associated seats are changed
Credits:
  • CREDIT: Credit applied to a payment instrument
Offsets:
  • OFFSET_LINEITEM: Partial or whole refund to a line item
  • ONE_TIME_REFUND: One Time Refund processed for the customer
  • TAX_REFUND: Refund due to validation of tax exemption certificate
Discounts:
  • ACTIVATION_DISCOUNT: Discount applied when subscription activated
  • CYCLE_DISCOUNT: Discount applied on periodic charges
  • RENEW_DISCOUNT: Discount applied when subscription renewed
  • CANCEL_DISCOUNT: Charges applied when discounts cancelled

UnitPrice

Price per seat. Ensure this matches the information stored in your billing system during reconciliation.

6.82
Quantity

Number of seats. Ensure this matches the information stored in your billing system during reconciliation.

2
Amount

Total of price for quantity. Useful to check that the amount calculation matches how you calculate this for your customers.

13.32
TotalOtherDiscount

Amount of discount applied to these charges. IUR or new subscriptions eligible for an incentive will also contain a discount amount in this column.

2.32
Subtotal

Total before tax. Checks that your subtotal matches your expected total, in case of a discount.

11
Tax

Tax amount charge, based on your market's tax rules and specific circumstances.

0
TotalForCustomer

Total after tax. Checks if you are charged tax in the invoice.

11
Currency

Currency type. Each billing entity has only one currency. Check that it matches your first invoice and then after any major billing platform update.

EUR
CustomerName

Customer's organization name as reported in Partner Center. This is very important for reconciling the invoice with your system information.

Test Customer A
MPNID

MPN ID of the CSP partner.

4390934
ResellerMPNID

MPN ID of the reseller of record for the subscription.

4390934
© 2017 Microsoft