Learn how to read new commerce invoice reconciliation files in Partner Center
Appropriate roles: Billing admin | Global admin | Admin agent | Sales agent
Using the recon file
This table explains and gives examples of the reconciliation file fields for new commerce transactions or billing event. See Use the reconciliation files.
| Column | Description | Sample value |
|---|---|---|
| PartnerId | CSP (Cloud Solution Providers) partner identifier. | 0e195b37-4574-4539-bc42-0e539b9684c0 |
| CustomerId | Customer identifier. | 196e2273-9651-43a3-ba7e-7cbcd918fc40 |
| CustomerName | Customer's organization. | Johnny Modern Cust DE2 |
| CustomerDomainName | Customer's domain name. | testcustomerdomain.onmicrosoft.com |
| CustomerCountry | Customer's location. See the full list of countries/regions for your region. | DE |
| InvoiceNumber | Invoice Number. | G002297372 |
| MPNID | Microsoft partner identifier. | 6034453 |
| ResellerMPNID | Reseller on record. | 6048879 |
| OrderId | Internal order identifier. When you contact support, this ID can be helpful. | 0ET2qaZvJGfF9wgSKnWzR5JLmhp10lOc1, 6dc5c039750a |
| OrderDate | UTC date of the transaction or billing event. | 10/3/2020 |
| ProductId | Product identifier. | DZH318Z0BNZ5 |
| SkuId | SKU identifier. | 006G |
| AvailabilityId | Availability identifier. | DZH318Z08B80 |
| SkuName | SKU name. | Tables - LRS |
| ProductName | Product name. | Tables |
| ChargeType | The type of charge or adjustment. | New |
| UnitPrice | Price per unit or license, as listed in the price list in supported currencies for applicable countries/regions. | 0.045 |
| Quantity | Units bought. Use BillableQuantity for reconciliation. | 1 |
| Subtotal | Pretax cost. See details: Usage-based: ROUNDDOWN(ROUNDDOWN(EffectiveUnitPrice * BillableQuantity, 2) * PCToBCExchangeRate, 2) License or seat-based: ROUNDDOWN(EffectiveUnitPrice * PCToBCExchangeRate, 2) * BillableQuantity |
0.01 |
| TaxTotal | Tax amount. Based on your market's tax rules and specific circumstances. | 0 |
| Total | Total cost. Equal to the subtotal plus the tax amount. | 0.045 |
| Currency | Billing currency. Your bill is generated in the context of the partner's billing currency. | EUR |
| PriceAdjustmentDescription | Unit price adjustment reason. The value is text-based information that can be rearranged or presented in different formats while keeping the same meaning. | ["15.0% Partner earned credit for services managed"] |
| PublisherName | Product publisher. | Microsoft |
| PublisherId | Publisher identifier. | NA |
| SubscriptionDescription | Service offering name, as defined in the price list. | Azure plan |
| SubscriptionId | Subscription identifier. This identifier isn't the same as the Subscription ID on the partner admin console. | 307628f1-d9d2-f09c-ea1f-4183f0cae308 |
| ChargeStartDate | Date when billing starts. | 9/1/2020 |
| ChargeEndDate | Date when billing ends. It depends on the charge cycle, billing plan, and coterminosity. Learn more at How are one-time and recurring charges calculated. | 9/30/2020 |
| TermAndBillingCycle | The duration of your subscription. For more information, see How do I find the billing term in a reconciliation file?. | Data Stored (GB/Month), One-Year commitment for monthly/yearly billing |
| EffectiveUnitPrice | Adjusted unit price. The unit price may vary because of discounts, adjustments, billable days, or other factors. | 0.03825 |
| UnitType | Billable unit type. | 1 GB/Month |
| AlternateId | Alternate order ID. | 6dc5c039750a |
| BillableQuantity | Number of licenses, usage hours, or quantity. | 0.005001 |
| BillingFrequency | Billing plan. Left blank for one-time payments and all unbilled billing line items. |
Monthly, Annual |
| PricingCurrency | Currency for pricing. If the product is available in multiple currencies, the customer's local currency is used. | USD |
| PCToBCExchangeRate | Exchange rate applied to convert pricing currency to billing currency. | 0.846202666 |
| PCToBCExchangeRateDate | The date that is used to determine the exchange rate. | 9/30/2020 |
| MeterDescription | Meter description. | Tables - LRS Data Stored (GB/Month) |
| ReservationOrderId | Order ID for Azure reservation or savings plan. To calculate monthly costs from daily charges, see "Note." | 55eebd03-c6e7-4593-8ba8-0bb7c0b25e02 |
| CreditReasonCode | Azure credit reason (not applicable to refunds). | Azure Credit, Sponsorship Credit, etc. |
| SubscriptionStartDate | Date of purchase or renewal of a subscription. | 5/1/2021 |
| SubscriptionEndDate | Date when the subscription ends or expires. | 4/30/2022 |
| ReferenceID | Concurrent transactions identifier. | 025d68a6-1bd6-42ab-9636-15e8d776a30e |
| ProductQualifiers | Purchase type identifier (add-on, a trial, or both). | ["Add-on"] |
| PromotionID | Promotion identifier. | CFQ7TTC0LDPB:1:CFQ7TTC0GZQJ |
Next steps
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for