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 | 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
These charges aren't included in the daily rated usage data:
- Azure reservation
- Azure savings plan
- Office
- Dynamics
- Microsoft Power Apps
- Perpetual software
- Software subscription
- Non-Microsoft or marketplace SaaS product
Fields in daily rated usage reconciliation file
| Column | Description | Sample value |
|---|---|---|
| PartnerId | Partner's Microsoft Entra ID—a unique identifier for Cloud Solution Provider program (CSP) partners. | 0e195b37-4574-4539-bc42-0e539b9684c0 |
| PartnerName | Partner name. | Fabrikam |
| CustomerId | Customer's Microsoft Entra ID—a unique identifier for customers. | 196e2273-9651-43a3-ba7e-7cbcd918fc40 |
| CustomerName | Customer's company name. | Contoso |
| CustomerDomainName | Domain name within the customer company using the product. | testcustomerdomain.onmicrosoft.com |
| CustomerCountry | Customer's country or region. See the full list of countries/regions for your country/region. | US |
| MpnId | Microsoft partner identifier. | 12345 |
| Tier2MpnId | Identifier of the reseller on record. This field is optional in the unbilled usage data. | 67890 |
| InvoiceNumber | Invoice number—a unique identifier for the invoice. | 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 | A unique identifier of the publisher. | |
| SubscriptionDescription | Service offering name. (Identical to OfferName). | Azure plan |
| SubscriptionId | A unique identifier used in Microsoft's billing system, typically indicating the Azure plan ID for pay-as-you-go resources. | 307628f1-d9d2-f09c-ea1f-4183f0cae308 |
| ChargeStartDate | Billing start date in a specific billing period. | 9/1/2020 |
| ChargeEndDate | Billing end date in a specific billing period. This date doesn't influence the charges, as they’re calculated based on the Usage Date. | 9/30/2020 |
| UsageDate | Date when the service was used or consumed. | 9/21/2020 |
| MeterType | Type of the meter. | 10K Batch Write Operations |
| MeterCategory | Top-level service for the usage. | Storage |
| MeterId | A unique identifier of the meter. | 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 to determine the charge amount. | 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 | Type of charge or credit. | New |
| UnitPrice | Cost of each unit in the price list at the time of purchase. | 0.00036 |
| Quantity | Number of billed units. | 3.0146 |
| UnitType | Unit used for billing. | |
| BillingPreTaxTotal | Cost in the billing currency after PEC deduction but before tax. | 1.0000044676 |
| BillingCurrency | Partner's billing/invoice currency. | USD |
| PricingPreTaxTotal | The cost in the pricing currency before tax. | 1.0000044676 |
| PricingCurrency | Currency in the price list. Azure plan products are only priced in USD. | USD |
| ServiceInfo1 | Number of Service Bus connections. | |
| ServiceInfo2 | Legacy field for service-specific metadata. | |
| Tags | User-defined logical structuring of Azure resources. | |
| AdditionalInfo | Additional information. | |
| EffectiveUnitPrice | Adjusted unit price after discounts or credits. | 0.000306 |
| PCToBCExchangeRate | Exchange rate used for converting the cost from pricing currency to billing currency. | 1.0 |
| PCToBCExchangeRateDate | Date when the the exchange rate is calculated. | 9/30/2020 |
| EntitlementId | Azure subscription identifier (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 identifier for Azure savings plan, similar to the reservation order ID for Azure reservations. This field is optional for other products. | fa568549-982e-40cb-bff0-41ac83a02505 |
| BenefitId | A unique identifier for each Azure savings plan. This field is optional for other products. | 427c1f90-dcd8-4779-a007-4e54fb4e7640 |
| BenefitType | An identifier indicating if this usage is covered by an Azure savings plan or subject to pay-as-you-go charges. | SavingsPlan |