Learn how to read the line items in your Partner Center reconciliation files

Appropriate roles: Billing admin | Global admin

You can download your reconciliation files from Partner Center for a detailed, line-item view of each charge in a billing cycle. Line-item details include charges for each customer's subscriptions, and detailed events (such as a mid-term addition of licenses to a subscription).

For information on how to read your invoice, see Read your bill.

Understand reconciliation file fields

Understand charge types in reconciliation files

To understand the types of charges in reconciliation files (the ChargeType column), see Reconciliation file charge types.

Fix formatting issues

Occasionally, a reconciliation file might contain formatting issues. For example, this issue might occur if the en-US locale is not used.

Follow these steps for fix any formatting issues in your reconciliation files:

  1. Open the reconciliation file (in .csv format) in Microsoft Excel.
  2. Select the first column in the file.
  3. Open the Convert Text to Columns Wizard. On the ribbon, select Data, then select Text to Columns.
  4. In the wizard, select Delimited file type. Then, select Next.
  5. In the Delimiters field, select Comma. (If Tab is already selected, you can leave this option selected.) Then, select Next.
  6. In the Column data format field, select Date:MDY. Then, select Next.
  7. In the Column data format field, select Text for all amount columns. Then, select Finish.

Download reconciliation files programmatically

Reconciliation files can be very large and are sometimes difficult to download. To download reconciliation files programmatically, see Get invoice line items.

If your file exceeds the row limit in Excel

If you’re able to download a reconciliation file but not open it in Microsoft Excel, it probably means the file contains more rows than Excel will allow. If this happens, you can use either of the procedures below to open the file.

Open a recon file in Power BI

  1. Download the reconciliation file as you normally would.
  2. Download, install, and open an instance of Microsoft Power BI.
  3. On the Power BI Home tab, select Get data.
  4. In the list of Common data sources, select Text/CSV.
  5. When prompted, open your recon file.

Open a recon file in an Excel pivot table

  1. Download the reconciliation file as you normally would.
  2. Open a new file in Microsoft Excel.
  3. On the Data tab, select Get data, select From file, and then select Text/CSV.
  4. When prompted, open your recon file. Your data will appear.
  5. In the Load dropdown menu, select Load to, and then select OK.
  6. In the Import Data dialog box, select PivotTable Report to open your file.

Negative amount displayed

You may see a negative amount in your reconciliation file. This is probably caused by one of the following things:

  • You recently canceled or reduced your number of licenses
  • You received credit for either a service license agreement (SLA) or for Azure consumption

To get more information about this transaction, review its charge type attribute in your reconciliation file.

Map taxes or VAT

To map Taxes or value-added tax (VAT) to your invoice:

  • Sum the Tax column from the license-based file.
  • Sum the TaxAmount column from the usage-based file.

Itemize reconciliation files by partner

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

MPN ID Description
MPN ID The Microsoft Partner Network (MPN) identifier of the Cloud Solution Provider (CSP) partner (direct or indirect).
Reseller MPN ID The MPN identifier of the reseller of record for the subscription. This field corresponds to the reseller ID listed for the specific subscription in Partner Center. Only appears on reconciliation files for partners in the indirect model.

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 MPN ID, this value will be set to -1.

To view or update the Reseller MPN ID:

Note

To learn more about the workspaces interface, see Getting around Partner Center.

  1. Sign in to the Partner Center dashboard.

  2. Select the Customers tile, and then select the customer from the list.

  3. In the customer menu, select Subscriptions.

  4. Choose the subscription from the list.

  5. Select Update to change the Reseller (MPN ID).

How to find Azure credits in the monthly reconciliation and daily rated usage files?

You can identify and verify Azure credits for your customers using the monthly reconciliation and daily rated usage files or APIs.

The credit lines should include an "Azure credit" value in the CreditReasonCode attribute, and the corresponding ChargeType attribute should show the text "customerCredit" in the monthly reconciliation file. In addition, the "Total" amount for the credit lines should be negative.

However, the daily rated usage file will have two attributes, CreditPercentage and CreditType to locate the Azure credits. The credit percentage should show the percentage of credit given for the relevant resource on that day, and the type should indicate the credit category.

Note

Some Azure credits may not appear in the daily rated usage file because they are calculated only after closing the billing period. In that case, you can check the monthly reconciliation file for confirmation.

Next steps