Learn how to read daily rated usage reconciliation files in Partner Center
Applies to: Partner Center | Partner Center for Microsoft Cloud for US Government
Appropriate roles: Billing admin | Global admin | Admin agent | Sales agent
This article explains how to read daily rated usage reconciliation files.
Note
You can retrieve your daily unbilled usage data through the API or the Partner Center portal. It might take up to 24 hours for this data to become available. However, it could take longer depending on where you are and when the usage gets reported.
There might be times when you can't see the latest unbilled usage until you get the billed usage for the previous month. This is to make sure you get your billed usage on time. Once you get your billed usage, you should be able to see all the unbilled usage from the start of the month.
Note
The following charges aren't included in the daily rated usage file (data):
- Azure reservation
- Azure savings plan
- Office
- Dynamics
- Microsoft Power Apps
- Perpetual software
- Software subscription
- Non-Microsoft SaaS product
Fields in daily rated usage reconciliation file
| Column | Description | Sample value |
|---|---|---|
| PartnerId | Cloud Solution Provider program (CSP) partner identifier. | 0e195b37-4574-4539-bc42-0e539b9684c0 |
| PartnerName | Partner name. | Fabrikam |
| CustomerId | Customer identifier. | 196e2273-9651-43a3-ba7e-7cbcd918fc40 |
| CustomerName | Customer's organization. | Contoso |
| CustomerDomainName | Customer's domain name. | testcustomerdomain.onmicrosoft.com |
| CustomerCountry | Customer location. | US |
| MpnId | Microsoft partner identifier. | 12345 |
| Tier2MpnId | Reseller on record. This field is optional in the unbilled usage data. | 67890 |
| InvoiceNumber | Invoice number. | G002297372 |
| ProductId | Product identifier. | DZH318Z0BNZ5 |
| SkuId | stock-keeping unit (SKU) identifier. | 006G |
| AvailabilityId | Availability identifier | DZH318Z08B80 |
| SkuName | Name of the stock-keeping unit (SKU). | Tables |
| ProductName | Name of the product. | Tables |
| PublisherName | Name of the publisher. | Microsoft |
| PublisherId | Publisher identifier. | |
| SubscriptionDescription | Service offering name. (Identical to OfferName). | Azure plan |
| SubscriptionId | Subscription identifier in the Microsoft billing platform. Not used for reconciliation. This ID is different from the Subscription ID shown on the partner admin console. | 307628f1-d9d2-f09c-ea1f-4183f0cae308 |
| ChargeStartDate | Billing start date. | 9/1/2020 |
| ChargeEndDate | Billing end date. It could be the last day of the month or the first day of the next month. This date doesn't affect the charges, which are calculated based on the Usage Date. | 9/30/2020 |
| UsageDate | Date of service usage/consumption. | 9/21/2020 |
| MeterType | Type of the meter. | 10K Batch Write Operations |
| MeterCategory | Top-level service for the usage. | Storage |
| MeterId | Meter identifier. | b9e5e77c-a0b3-4a2c-9b8b-57fa54f31c52 |
| MeterSubCategory | Azure service type. | Tables |
| MeterName | Name of the meter. | Batch Write Operations |
| MeterRegion | The location of the data center in the region. | |
| Unit | Unit used for charging. | 10K |
| ResourceLocation | Data center where the meter is running. | eastus |
| ConsumedService | Azure platform service used. | Microsoft.Storage |
| ResourceGroup | Resource container. | TestRG |
| ResourceURI | URI of the resource. | /subscriptions/fa568549-982e-40cb-bff0-41ac83a02505/resourceGroups/TestRG/providers /Microsoft.Storage/storageAccounts /customerstorage0207 |
| ChargeType | Reason for charging the amount. | New |
| UnitPrice | Cost of each item from the price list at the time of purchase. | 0.00036 |
| Quantity | Number of units that you're billed for. | 3.0146 |
| UnitType | Unit used for charging. | |
| BillingPreTaxTotal | The cost before tax and after any PEC deduction. | 1.0000044676 |
| BillingCurrency | Partner billing/invoice currency. | USD |
| PricingPreTaxTotal | Total cost before tax in the pricing currency. | 1.0000044676 |
| PricingCurrency | Currency in the price list. | USD |
| ServiceInfo1 | Number of Service Bus connections. | |
| ServiceInfo2 | Legacy field for service-specific metadata. | |
| Tags | Logical organization of Azure resources set by the user. | |
| AdditionalInfo | Additional information. | |
| EffectiveUnitPrice | Final price for each unit after applying any discounts or adjustments. | 0.000306 |
| PCToBCExchangeRate | Exchange rate used to calculate the cost from the pricing currency. | 1.0 |
| PCToBCExchangeRateDate | Date when the the exchange rate was calculated. | 9/30/2020 |
| EntitlementId | Azure subscription ID. | 55eebd03-c6e7-4593-8ba8-0bb7c0b25e02 |
| EntitlementDescription | Azure subscription name. | Demo subscription |
| PartnerEarnedCreditPercentage | Partner earned credit (PEC) percentage. Either 0 or 15 percent. | 15 |
| CreditPercentage | Percentage of charges covered by the credit. | 15 |
| CreditType | Type of credit used for the usage. | Partner Earned Credit Applied |
| BenefitOrderId | A unique ID for Azure savings plan, analogous to the reservation order ID for Azure reservations. This field is optional for other products. | fa568549-982e-40cb-bff0-41ac83a02505 |
| BenefitId | A unique ID for each savings plan on Azure. This field is optional for other products. | 427c1f90-dcd8-4779-a007-4e54fb4e7640 |
| BenefitType | An identifier indicating if this usage was covered by a savings plan. | SavingsPlan |
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