Understand your bill and reconciliation data in Partner Center

Appropriate roles: Global admin | Billing admin | Admin agent

Get a clear understanding of your bill. It's a complete list of all Partner Center charges for your program, products, and customers.

Find your reconciliation file

You can find your invoices in the Billing workspace in Partner Center.

You can also find your billing history or overview, Azure spending trends, and reconciliation files on this page.

To find your reconciliation file:

  1. Sign in to Partner Center and select Billing.
  2. Select a reconciliation file to view more detailed information.

You can access your most recent reconciliation file by clicking the link located at the top of the page under Account balance as of last invoice date on the Billing history page, or in the table on the Billing overview (NCE) page.

To download a reconciliation file:

  1. Sign in to Partner Center and select Billing.
  2. Find the invoice in the Billing history or Billing overview (NCE) page by choosing the appropriate year.
  3. Select the link next to Reconciliation (.csv).

Note

The Partner Center portal downloads all new commerce reconciliation files asynchronously.

Unallocated payments

Occasionally you might see an unallocated payment at your Billing workspace. An unallocated payment is a payment you've made to Microsoft that you haven't applied to an invoice.

To view your unallocated payments:

  1. Sign in to Partner Center and select Billing.
  2. In the Billing history section, see the Unallocated payment section.

Unallocated payments remain unallocated until you assign them to an invoice.

To apply an unallocated amount to an invoice:

  • Email bposcapp@microsoft.com to tell us which invoice to apply the payment to.

    Be sure to include all of the information that you would use if you were making a payment.

    Billing history | Unallocated payment is updated in five to six days.

Understand reconciliation files

The reconciliation files give a detailed list of your charges. You can use the customer and subscription IDs in the reconciliation files to create invoices for customers. For more information on reconciliation files, see How to use the reconciliation files.

What products are included in the new commerce invoice reconciliation data?

  • Azure pay-as-you-go
  • Azure reservation
  • Azure savings plan
  • License-based product (such as Office, Dynamics, and Power Apps)
  • Perpetual software
  • Software subscription
  • Third-party SaaS product

What products are included in the new commerce daily rated usage reconciliation data?

  • Azure pay-as-you-go
  • Azure reservation (only shows the usage, not the cost)
  • Azure savings plan (only shows the usage, not the cost)

Map taxes or VAT to your invoice reconciliation data

Here's how to validate an invoice with taxes or VAT:

  1. Add the Tax values from your legacy license-based reconciliation data.
  2. Add the TaxAmount values from your legacy usage-based reconciliation data.
  3. Add the TaxTotal values from your new commerce reconciliation data.

Why are some products only in the invoice reconciliation file but not in the daily rated usage file?

The daily rated usage file only includes products charged on a pay-as-you-go, fixed monthly, or one-time price, depending on daily usage. However, some products are charged solely on the number of licenses or seats per billing period, independent of usage. These products are charged once per billing period based on the billing plan or payment schedule and do not appear in the daily rated usage data.

Note

The invoice reconciliation shows any billing event that triggers a positive or negative charge, based on the billing plan.

Why does my reconciliation data show a zero tax amount when the corresponding invoice has taxes?

In some countries or regions, taxes are calculated based on the total cost of all transactions, not on the charges for each transaction. This can cause slight differences between the sum of line-item tax and total tax due to rounding. For example, let's say you have two transactions of $9.75 and $10.25 each with a 10% tax rate. The total amount before taxes is $20, and the total tax is $2. However, if you look at each line-item separately, you might see something like this:

Transaction Amount Tax
Product 1 $9.75 $0.98
Product 2 $10.25 $1.03

As you can see, there's a one-cent difference between the line-item level tax ($2.01) and the total tax ($2). This might not seem like a significant difference, but it's unacceptable from the compliance perspective.

To avoid this, taxes in these countries or regions are now only displayed on the invoices, not in reconciliation data. This way, you don't have to worry about discrepancies between your reconciliation data and invoices. The total amount due before taxes is the same for any billing period in both your reconciliation data and your invoice.

Benefits:

  • Reduce errors and risks by ensuring compliance with tax regulations.
  • Save time and money by avoiding unnecessary calculations.
  • Improve transparency and trust by providing clear and consistent information to customers.
  • Enhance customer satisfaction by offering a smooth and easy billing process.

We've sent emails explaining this change and any actions you might need to take.

Why are the charges on my invoice reconciliation data different from the daily rated usage data?

Azure services offer two ways to track usage and billing: invoice reconciliation and daily rated usage data. However, they aren't exactly the same and might show some discrepancies. Here are some reasons why:

  • Exclusion of products: The charges in the daily rated usage reconciliation apply only to pay-as-you-go resources purchased under Azure subscriptions, while the charges in the invoice reconciliation reflect for all products and subscriptions across all your customers. To learn more about the products that are included in the daily rated usage reconciliation, see Products Included in the Daily Rated Usage Reconciliation.

If the charges for the same products or subscriptions from the two reconciliations don't match up, there could be several reasons:

  • Taxes and other fees: Your invoice reconciliation might include taxes and other fees that aren't shown in your daily rated usage data. To compare the charges for a specific product or subscription, verify the value of BillingPreTaxTotal in daily rated usage and the Subtotal in the invoice reconciliation. These values should be equal or very close before taxes and fees are applied.
  • Discounts and credits: Your invoice reconciliation might include discounts or credits that aren't reflected in your daily rated usage data. These discounts or credits might be applied based on your contract terms, service level agreements, promotional offers, negotiated or tier pricing. In that case, the Subtotal of the invoice reconciliation might be less than the BillingPreTaxTotal of the daily rated usage data.
  • Decimal round off: The daily rated usage reconciliation shows up the amount to 10 decimal places in the BillingPreTaxTotal, while the Subtotal in the invoice reconciliation rounds off to two decimal places during billing. This means that there might be a slight difference due to rounding.

It's important to understand that your invoice reconciliation and daily rated usage data might not match up exactly because of these differences. Contact support teams for further details of these differences, but be confident that you only pay for what you use, the lowest amount possible.

When should you contact the support team?

If you're unsure whether a reconciliation is correct, compare the attributes of both reconciliations before contacting our support team. If you notice any discrepancies, follow these steps:

  • Quantity or billable quantity: Compare the quantity or billable quantity of the same product or subscription to identify any differences.
  • Customer ID: This is a unique identifier that represents a customer account in our system. Compare pay-as-you-go charges for customer IDs in both reconciliations and look for any missing IDs.
  • Product ID, SKU ID, or Subscription ID: These are unique identifiers that represent a product, a SKU, or a subscription in our system. Compare pay-as-you-go charges for them in both reconciliations and look for any missing IDs.
  • Subtotal and BillingPreTaxTotal: This is the amount that has been charged for a product or service before applying any taxes. Compare these two amounts to identify any significant differences.

If you find any discrepancies, contact our support team for assistance.

Reconciliation data for indirect partners

You can get a detailed reseller view of reconciliation data using these attributes for partners in the indirect model.

MPNID Description
MPNID The Microsoft AI Cloud Partner Program identifier of the Cloud Solution Provider (CSP) partner (direct or indirect).
Reseller MPNID The Identifier of the reseller of record for the subscription. This information can be found in Partner Center under the specific subscription. Note that this attribute only applies to partners in the indirect model and will show up in the reconciliation data.

Reseller MPNID

When selling products and services, it's important to know the role of the reseller's MPN ID as a CSP. Use these guidelines to lean how the reconciliation data shows reseller's MPN ID:

  1. If you sell directly to the customer, the reseller's MPN ID is set to 0.
  2. If a reseller sells, fill in the reseller's MPN ID. The ID must be active and linked to the partner at the time of purchase.
  3. If you remove a reseller, the ID is set to -1.

To view or update the reseller MPNID:

  1. Sign in to Partner Center and select Customers.
  2. Select the customer from the list and then select Subscriptions.
  3. Choose the subscription from the list.
  4. Choose the Reseller (MPNID) from the list.
  5. Select Submit to update it.

Next steps