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 access your unbilled daily rated usage line items through the API or Partner Center portal. To ensure accurate data, allow up to 24 hours for availability. Depending on your location and when the meters report the usage, there might be further delays.
We prioritize on time delivery of billed daily rated usage data first. Occasionally, you might not see the most recent unbilled daily rated usage data until the previous month's billed usage data is available. Once you receive the billed usage data, you can then retrieve all the updated unbilled usage data from the start of the month.
Your understanding and patience are appreciated as we strive to provide the most accurate and timely information possible.
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. | aaaabbbb-0000-cccc-1111-dddd2222eeee |
| 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. | aaaa0a0a-bb1b-cc2c-dd3d-eeeeee4e4e4e |
| 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 | You used or consumed the service on this date. | 9/21/2020 |
| MeterType | Type of the meter. | 1 Disk/Month |
| 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. | Read 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/bbbb1b1b-cc2c-dd3d-ee4e-ffffff5f5f5f/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. | bbbb1b1b-cc2c-dd3d-ee4e-ffffff5f5f5f |
| 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 |