Use the reconciliation files

Applies to

  • Partner Center
  • Partner Center for Microsoft Cloud for US Government
  • Partner Center for Microsoft Cloud Germany

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 both license-based and usage-based reconciliation files to itemize by reseller.

MPN ID Description
MPN ID

The Microsoft Partner Network (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.

eTo view or update the reseller, in the Partner Center 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.

Column Description Sample Value
PartnerId

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
CustomerID

Unique Microsoft ID, in GUID format, used to identify the customer.

12ABCD34-001A-BCD2-987C-3210ABCD5678
OrderID

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

566890604832738111
SubscriptionID

Unique identifier for a subscription in the Microsoft billing platform. 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.

Note: This value does not match Offer ID from the price list. See DurableOfferID below.

FE616D64-E9A8-40EF-843F-152E9BBEF3D1
DurableOfferID

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

Note: This value matches the Offer ID from 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.

Microsoft Office 365 (Plan E3)
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. See Mapping charges between an invoice and the reconciliation file

See Mapping charges between an invoice and the reconciliation file

UnitPrice

Price per seat, as published in the pricelist at the time of purchase. 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. See Itemize by partner.

4390934
DomainName

Customer's domain name, used to help identify the customer. This field may appear blank until the second billing cycle.

example.onmicrosoft.com
SubscriptionName

Subscription nickname. If no nickname is specified, Partner Center uses the OfferName.

PROJECT ONLINE
SubscriptionDescription

The name of the service offering purchased by the customer, as defined in the price list. (This is an identical field to Offer name).

PROJECT ONLINE PREMIUM WITHOUT PROJECT CLIENT

Usage-based file fields

To reconcile your charges against your customer's usage, compare the ResellerID/ResellerName/ResellerBillableAccount from the reconciliation file, the customer name, and the Subscription ID from Partner Center.

The following fields explain which services were used and the rate.

Column Description Sample value
PartnerID

Partner ID, in GUID format.

DA41BC5F-C52D-4464-8A8D-8C8DCC43503B
PartnerName

Partner Name.

Acme Incorporated
PartnerBillableAccountID

Partner Account ID.

1010578050
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. See Itemize by partner.

4390934
InvoiceNumber

Invoice number where the specified transaction appears.

D020001IVK
ChargeStartDate

Start date of billing cycle except when presenting dates of previously uncharged latent usage data (from previous bill cycle).

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

2/1/2014 0:00
ChargeEndDate

End date of billing cycle except when presenting dates of previously uncharged latent usage data (from previous bill cycle).

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

2/28/2014 23:59
SubscriptionID

Unique identifier for a subscription in the Microsoft billing platform. 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.

usCBMgAAAAAAAAIA
SubscriptionName

Nickname of the service offering.

Microsoft Azure
SubscriptionDescription

Line of business of the service offering

Microsoft Azure
OrderID

Unique identifier for an order in the Microsoft billing platform. May be useful to identify the subscription when contacting support but not for reconciliation.

566890604832738111
ServiceName

The name of the Azure service in question.

VIRTUAL MACHINES
ServiceType

The specific type of Windows Azure service.

  • Service Bus – Individual or Pack
  • SQL Azure database – Business or Web Edition
ResourceGUID

Specific unique identifier for all the service data and pricing structure.

DA41BC5F-C52D-4464-8A8D-8C8DCC43503B
Resource Name

The name of the Azure resource.

  • Data Transfer In (GB)
  • Data Transfer Out (GB)
Region

The region the usage applies to. Primarily used to assign rates to data transfers, as rates vary by region.

Asia Pacific, Europe, Latin America, North America
SKU

MSFT unique identifier for offer

7UD-00001

DetailLineItemId

An ID and quantity for itemizing the different rates for a service or resource in a given billing period. For Azure tiered rating, there may be one rate up to a certain quantity of billable units, then a different rate after that.

1
ConsumedQuantity

The amount of service consumed (hours, GB, etc.) during the reporting period.

Also includes any unbilled usage from previous reporting periods.

11
IncludedQuantity

Units included as part of the offer. Not typically present in CSP.

0

OverageQuantity

Units not included as part of the offer, that must be paid for by the partner.

Equal to the ConsumedQuantity - IncludedQuantity.

11
ListPrice

Offer price in effect at subscription start date.

$0.0808
PretaxCharges

ListPrist times OverageQuantity, rounded to the nearest cent.

$0.085
TaxAmount

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

$0.08
PostTaxTotal

Total after tax, when tax is applicable.

$0.93
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
PretaxEffectiveRate

Pretax price per unit. Equal to PretaxCharges / OverageQuantity, rounded to the nearest cent.

$0.08
PostTaxEffectiveRate

Post tax price per unit. Equal to PostTaxTotal / OverageQuantity, or PretaxEffectiveRate + tax rate per unit amoun, rounded to the nearest cent.

$0.08
ChargeType

The type of charge or adjustment. See Mapping charges between an invoice and the reconciliation file

See Mapping charges between an invoice and the reconciliation file

CustomerBillableAccount

Unique account ID in the MSFT billing platform.

1280018095
UsageDate

Date of service deployment.

2/1/2014 0:00
MeteredRegion

This column identifies the location of a data center within the region for services where this is applicable and populated.

East Asia, South East Asia, North Europe, West Europe, North Central US, South Central US
MeteredService

This column is utilized to track the individual Microsoft Azure service that may not be specifically identified in the Service Name column. For example, data transfers are reported as "Microsoft Azure - All Services" in the Service Name column. This MeteredService column will indicate to which specific service the usage pertains.

AccessControl, CDN, Compute, Database, ServiceBus, Storage
MeteredServiceType

A subheading that further clarifies the individual Microsoft Azure service beyond the level provided by the MeteredService field.

EXTERNAL
Project

Customer-defined name for their service instance

ORDDC52E52FDEF405786F0642DD0108BE4
ServiceInfo

The number of ServiceBus connections that were provisioned and utilized on a given day.

For example: if you had an individually provisioned connection during a 30 day month, Service Info 1 would read “1.000000 Connections / 30 days”. If you had a 25 pack of ServiceBus connections provisioned and you had utilized 1 during that day, your daily usage statement for that day would indicate “25 Connections / 30 Days – Used: 1.000000”.
CustomerID

Unique Microsoft ID, in GUID format, used to identify the customer.

ORDDC52E52FDEF405786F0642DD0108BE4
DomainName

Customer's domain name, used to help identify the customer. This field may appear blank until the second billing cycle.

example.onmicrosoft.com
Unit

The unit of the resource Name

GB or HOURS

One-time purchase file fields

Field Definition
PartnerId Partner ID, in GUID format.
CustomerId Unique Microsoft ID, in GUID format, used to identify the customer.
CustomerName Customer's organization name as reported in Partner Center. This is very important for reconciling the invoice with your system information.
CustomerDomainName The customer’s domain name.
CustomerCountry The country in which the customer is located.
InvoiceNumber Invoice number where the specified transaction appears.
MpnId 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 reservation. This corresponds to the reseller ID listed for the specific reservation in Partner Center. If a CSP partner sold the reservation 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.
OrderId Unique identifier for an order in the Microsoft billing platform. May be useful to identify the Azure reservation when contacting support but not for reconciliation.
OrderDate The date the order was placed.
ProductId The ID for the product.
SkuId The ID for a particular SKU.
AvailabilityId The ID for a particular Availability. “Availability” refers to whether or not a particular SKU is available for purchase for the given country, currency, industry segment, etc.
SkuName The title for a particular SKU.
ProductName The name of the product.
ChargeType The type of charge or adjustment.
UnitPrice Price per product ordered.
Quantity Number of products ordered.
Subtotal Total before tax. Checks that your subtotal matches your expected total, in case of a discount.
TaxTotal The total of all applicable taxes.
Total The total amount of this purchase.
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.
DiscountDetails Detailed listing of any relevant discounts.

Mapping charges between an invoice and the reconciliation file

Your invoice provides a summary of charges, while your reconciliation file provides a detailed breakdown of line-item transactions, including charge types.

To cross-reference charge amounts between the invoice and reconciliation file, you can use Microsoft Excel's filter options to filter by charge types on the reconciliation file to map the invoice charges to a set of charge breakdowns on reconciliation file.

Reconciliation files, both usage- and license-based, only show usage related transactions and charges (units consumed and related charges). One off credits, discounts or refunds which appear on the invoice as “Adjustments” are not shown in the reconciliation file.

The table below shows the mappings between an invoice section and associated charge types that might show up on the reconciliation files.

Invoice charge description

Reconciliation file charge description (ChargeType column)

What is this charge?

How do I map these ChargeTypes to the invoice?

License-based charges

Activation fee

The amount charged to the customer when they use the subscription after purchasing it

From license-based file, sum the Amount column

Cancel fee

Prorated charges refunded to the customer when associated seats are changed

Cycle fee

Periodic charges for a subscription

Cycle instance prorate

Prorated charges assessed from the customer when associated seats are changed

Prorate fees when cancel

Prorated refund for unused portion of service upon cancellation

Prorate fees when purchase

Prorated fees upon purchase

Purchase fee

Initial charge for a subscription

Prorate fee when renew

Prorated fees upon subscription renewal

Renew fee

Charge for renewing a subscription

Prorate fees when activate

Prorated fees from activation until end of billing period

Usage Charges

Assess usage fee when cancel

Access usage fee upon cancellation for unpaid usage during the current billing period

From usage-based file, sum the PretaxCharges column

Assess usage fee for current cycle

Access usage fee for the current billing period

Credits

Offset a line item

Partial or whole refund to a line item, including taxes

From license-based file, sum the TotalForCustomer column

From usage-based file, sum the PostTaxTotal column

Usage-based discounts

Activation discount

Discount applied when subscription activated

From usage-based file, sum the PretaxCharges column

Cycle discount

Discount applied on periodic charges

Renew discount

Discount applied when subscription renewed

Cancel discount

Charges applied when discounts cancelled

License-based discounts

May be applied to multiple charge types

From license-based file, sum the TotalOtherDiscount column

Taxes or VAT

May be applied to multiple charge types

Exception: "Offset a line item" already includes taxes. See Credits, above.

Taxes or value-added taxes (VAT)

From license-based file, sum the Tax column

From usage-based file, sum the TaxAmount column