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 data accuracy, 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, the most recent unbilled daily rated usage data might not appear until the previous month's billed data is available. Once you receive the billed data, you can then access all updated unbilled usage data from the start of the month.
Key points:
- Allow up to 24 hours for data availability.
- There might be further delays depending on your location and meter reporting times.
- Billed daily rated usage data is prioritized over unbilled data.
Your understanding and patience are appreciated as we strive to provide the most accurate and timely information possible.
Note
Charges for the following items 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 used to manage and authenticate Cloud Solution Provider program (CSP) partners within Microsoft's ecosystem. | aaaabbbb-0000-cccc-1111-dddd2222eeee |
| PartnerName | Partner name. | Fabrikam |
| CustomerId | Customer's Microsoft Entra ID—a unique identifier for customers used to manage access and security across Microsoft services. | 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 is independent of 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 |