Understanding reconciliation files as a Reseller

Understanding reconciliation files as a Reseller

Downloading reconciliation files

Access reconciliation files in CloudCockpit by going to Administration > Invoices.

Choose the type of reconciliation file you want to download:
  1. One Time
  2. License
  3. Usage
  4. Daily rated usage

Click Generate File




Choose the regional format of the reconciliation file.
The format affects:
  1. How decimal values are separated, for example if values are separated with a "." or a ","
  2. The format of date columns
  3. The separator between each column



Onetime reconciliation

Onetime reconciliation files contain the charges for all your Customers of: 
  1. Azure Plan
  2. Azure Savings Plan
  3. Azure Reservations
  4. New Commerce Licenses (such as Office 365)
  5. Software Subscriptions
  6. Perpetual Software Subscriptions 
  7. Marketplace Subscriptions
Onetime: file column description
Column
DescriptionExample value
CustomerIdThe ID of the customer in CloudCockpit associated with the charge. Can be empty, for example when the CSP removed the relationship with the customer on the provider side and the customer wasn't in our system when that happened2C741C83-E111-4A77-BC5F-C2F065275FA9
CustomerNameThe company name of the customerCustomer name
CustomerDomainNameThe domain associated to the customer in Microsoft for the line itemtest@pte.onmicrosoft.com
CustomerCountryThe country of the customer associated with the line item (two-letter code - ISO 3166-1 alpha-2)IE
ResellerMpnIdThe MPN id of the reseller associated with the line item, if applicable (otherwise, it it is not set)3267
OrderDateThe date when the order was created1/31/2023 11:59:59 PM
ProductIdThe product unique identifier associated with the chargeDZH318Z0BNZF
SkuIdThe SKU unique identifier associated with the charge004V
AvailabilityIdThe availability unique identifier associated with the chargeDZH318Z0NRL7
SkuNameThe SKU nameStandard Page Blob - LRS
ProductNameThe product's nameStandard Page Blob
ChargeType
The type of charge on this line item. Possible values for the Microsoft provider include:
  • new
  • renew
  • cycleCharge
  • addQuantity
  • removeQuantity
  • moveQuantity
  • cancelImmediate
  • convert
  • changeBillingPlan
  • customerCredit
  • extendTerm
cycleCharge
QuantityThe quantity of the subscription associated with the charge1
CurrencyThe billing currency used for the line item (three-letter code - ISO 4217)EUR
PublisherNameThe publisher name associated with this purchaseMicrosoft
PublisherIdThe publisher id associated with this purchase12
SubscriptionDescriptionThe subscription description associated with this purchaseAzure Plan
SubscriptionIdThe ID of the subscription associated with the charge. Can be empty, for example when the subscription is no longer in our system03DE5ECE-EC93-42A9-8F15-9A770AC1F832
ChargeStartDateThe billing start date for this charge in the chosen format2/2/2023 12:00:00 AM
ChargeEndDateThe billing end date for this charge in the chosen format3/1/2023 12:00:00 AM
TermAndBillingCycleThe term and billing cycle associated with this purchase10K Read Operations
UnitTypeThe charging unit type1 Hour
AlternateIdThe alternate ID of the order associated to the line item in the provider532f0b0f8ee3
ResellerIdThe ID of the reseller in CloudCockpit associated with this charge (can be empty)B8E08E60-19F7-4F95-AE29-A82D3CD53F84
ResellerNameThe company name of the reseller associated with this chargeReseller name
CustomerInternalIdThe internal ID of the customer associated with this charge. Use this to identify a customer in your systemsCustomerTest
SubscriptionInternalIdThe internal ID of the subscription associated with this charge. Use this to identify a subscription in your systemsSubscriptionTest
UnitPriceForResellerThe price per single quantity that the reseller pays30.95
UnitPriceForCustomerThe price per single quantity that the customer pays30.95
SubtotalForResellerThe cost the reseller pays for the subscription on this charge before taxes.119.07
SubtotalForCustomerThe cost the customer pays for the subscription on this charge before taxes.119.07
TaxTotalForResellerThe taxes the reseller pays for the subscription on this charge4.76
TaxTotalForCustomerThe taxes the customer pays for the subscription on this charge4.76
TotalForReseller
The cost the reseller pays for the subscription on this charge after taxes.
TotalForReseller = ROUND(SubtotalForReseller + TaxTotalForReseller, 2)
123.83
TotalForCustomer
The cost the customer pays for the subscription on this charge after taxes.
TotalForCustomer = ROUND(SubtotalForCustomer + TaxTotalForCustomer, 2)
123.83
CustomerPriceMarginThe value of the margin applied at the customer level5
CustomerPriceMarginRuleThe margin rule applied at the customer level. The possible values are: markup, margin, splitmargin and erpminusdiscountmarkup
SubscriptionPriceMarginThe margin value applied at the subscription level. May not be set.
SubscriptionPriceMarginRuleThe margin rule applied at the subscription level. May not be set.
ERPPriceThe ERP for the whole term of the subscription associated with the charge, at the time indicated in SubscriptionStartDate10.10
BillableQuantity
The billed quantity of the subscription. This may value be different than Quantity
4
BillingFrequencyThe billing cycle of the subscription associated with the charge, can also be emptyMonthly
PricingCurrencyThe currency of the UnitPriceForReseller and UnitPriceForCustomer. This currency may differ from the invoice billing currency (three-letter code - ISO 4217)USD
MeterDescriptionThe meter description for the consumption line item1/31/2023 Microsoft Defender for Servers - Standard P2 Node/Hour
ProductType

The type of the offer associated with this charge.
Possible values:

  • license
  • softwaresubscription
  • perpetualsoftware
  • azureplan
  • azurereservation
  • azurelegacy
  • azuresavingsplan
license
ReservationOrderIdFor Azure Savings Plan this property corresponds to the savings plan order id on the Azure platform. For Azure reservations this is the reservation order id8A05BC26-0542-4B6F-B97F-ECA5BAC54E9E
SubscriptionStartDateThe start date of billing for the subscription in the chosen format. This value can change once a subscription renews12/2/2022 12:00:00 AM
SubscriptionEndDateThe end date of the term of the subscription in the chosen format12/2/2023 12:00:00 AM
IdThe ID that uniquely identifies an invoice line item7828D90D-2AC6-4F20-A95B-EE850BCD32A0
OfferProviderIdThe ID on the provider's side that identifies the offer associated with the chargeDZH318Z0BQJ7:01DJ
CustomerProviderIdThe ID of customer on the provider's side associated with this chargeCB0A371A-046A-46A9-A299-96BD755E67A8
SubscriptionProviderIdThe ID of the subscription associated to this charge on the provider's sideFA2A91FD-7286-4DCD-9718-20048CCA832A
SubscriptionPONumberThe purchase order number of the subscription associated with this charge. Use this to identify a subscription in your systems8543943821



License reconciliation

License reconciliation files contain the charges for all your customers of license legacy products.
License: file column description
Column
DescriptionExample value
CustomerIdThe ID of the customer in CloudCockpit associated with the charge. Can be empty, for example when the CSP removed the relationship with the customer on the provider side and the customer wasn't in our system when that happened2C741C83-E111-4A77-BC5F-C2F065275FA9
CustomerNameThe company name of the customerCustomer name
ResellerMpnIdThe MPN ID of the reseller associated with the line item, if applicable (otherwise, it it is not set)3267
OrderIdThe ID that identifies the order associated with the charge from the provider side569423888785251957
SubscriptionProviderIdThe ID of the subscription associated to this charge on the provider's sideFA2A91FD-7286-4DCD-9718-20048CCA832A
OfferProviderIdThe ID on the provider's side that identifies the offer associated with the chargeB4D4B7F4-4089-43B6-9C44-DE97B760FB11
OfferNameThe name of the offer associated with the subscriptionVisio Plan 2
SubscriptionStartDateThe start date of billing for the subscription in the chosen format. This value can change once a subscription renews12/2/2022 12:00:00 AM
SubscriptionEndDateThe end date of the term of the subscription in the chosen format12/2/2023 12:00:00 AM
ChargeStartDateThe billing start date for this charge in the chosen format2/2/2023 12:00:00 AM
ChargeEndDateThe billing end date for this charge in the chosen format3/1/2023 12:00:00 AM
ChargeType
The type of charge on this line item. Possible values for the Microsoft provider include:
  • Activation fee
  • Cancel fee
  • Cancel instance prorate
  • Cycle fee
  • Cycle instance prorate
  • Prorate fees when cancel
  • Prorate fees when convert away from current offering
  • Prorate fees when convert to a new offering
  • New purchase cycle fee
  • Prorate fees when purchase
  • Prorate fee when renew
  • Prorate fees when activate

Cycle fee
QuantityThe quantity of the subscription associated with the charge4
CurrencyThe billing currency used for the line item (three-letter code - ISO 4217)EUR
DomainNameThe domain associated to the customer in Microsoft for the line itemtest@pte.onmicrosoft.com
SubscriptionNameThe name of the subscription associated with the line itemVisio Plan 2 subscription
SubscriptionDescriptionThe subscription description associated with this purchaseVisio Plan 2
BillingCycleTypeThe billing cycle of the subscription associated with the charge, for example, Monthly, AnnualMonthly
ResellerIdThe ID of the reseller in CloudCockpit associated with this charge (can be empty)B8E08E60-19F7-4F95-AE29-A82D3CD53F84
ResellerNameThe company name of the reseller associated with this chargeReseller name
CustomerInternalIdThe internal ID of the customer associated with this charge. Use this to identify a customer in your systemsCustomerTest
SubscriptionInternalIdThe internal id of the subscription associated with this charge. Use this to identify a subscription in your systemsSubscriptionTest
UnitPriceForResellerThe price per single quantity that the reseller pays12.27
UnitPriceForCustomerThe price per single quantity that the customer pays13.11
AmountForResellerThe total price per quantity, not including taxes, for the reseller12.87
AmountForCustomerThe total price per quantity, not including taxes, for the customer13.27
SubtotalForReseller
The cost the reseller pays for the subscription on this charge before taxes.
SubtotalForReseller = ROUND(UnitPriceForReseller x Quantity, 2)
49.08
SubtotalForCustomer
The cost the customer pays for the subscription on this charge before taxes.
SubtotalForCustomer = ROUND(UnitPriceForCustomer x Quantity, 2)
52.44
TaxForResellerThe taxes the reseller pays for the subscription on this charge6.23
TaxForCustomerThe taxes the customer pays for the subscription on this charge6.83
TotalForReseller
The cost the reseller pays for the subscription on this charge after taxes.
TotalForReseller = ROUND(SubtotalForReseller + TaxForReseller, 2)
55.31
TotalForCustomer
The cost the customer pays for the subscription on this charge after taxes.
TotalForCustomer = ROUND(SubtotalForCustomer + TaxForCustomer, 2)
59.27
TotalOtherDiscountForResellerThe discount included in the charge on the reseller context1.31
TotalOtherDiscountForCustomerThe discount the customer receives for the subscription on this charge1.35
CustomerPriceMarginThe value of the margin applied at the customer level5
CustomerPriceMarginRuleThe margin rule applied at the customer level. The possible values are: markup, margin, splitmargin and erpminusdiscountmarkup
SubscriptionPriceMarginThe margin value applied at the subscription level. May not be set.
SubscriptionPriceMarginRuleThe margin rule applied at the subscription level. May not be set.
ERPPriceThe ERP for the whole term of the subscription associated with the charge, at the time indicated in SubscriptionStartDate10.10
SubscriptionId The ID of the subscription associated with the charge. Can be empty, for example when the subscription is not in our system03DE5ECE-EC93-42A9-8F15-9A770AC1F832
IdThe ID that uniquely identifies a license invoice line item26158c5a-6eee-4ada-910e-b245947bf1e0
CustomerProviderIdThe ID of customer on the provider's side associated with this chargeCB0A371A-046A-46A9-A299-96BD755E67A8
SubscriptionPONumberThe purchase order number of the subscription associated with this charge. Use this to identify a subscription in your systems8543943821
OfferIdThe ID of the offer in CloudCockpit to which the line item is associated withA1D4B7F4-4089-43B6-9C44-DE97B760FB22
 

Daily rated usage reconciliation

Daily rated reconciliation files contain the charges for all your customers of azure plan charges grouped by Resource Group and Azure Entitlement of each Azure plan subscription. And also shows if Partner Earned Credit was granted.
Daily rated usage: file column description
Column
DescriptionExample value
BillingCurrencyThe billing currency code (three-letter code - ISO 4217)EUR
CustomerIdThe ID of the customer in CloudCockpit associated with the charge. Can be empty, for example when the CSP removed the relationship with the customer on the provider side and the customer wasn't in our system when that happened2C741C83-E111-4A77-BC5F-C2F065275FA9
CustomerNameThe company name of the customerCustomer name
CustomerInternalId
The internal ID of the customer associated with this charge. Use this to identify a customer in your systems
CustomerTest
SubscriptionIdThe ID of the subscription associated with the charge. Can be empty, for example when the subscription is not in our system03DE5ECE-EC93-42A9-8F15-9A770AC1F832
SubscriptionProviderIdThe ID of the Azure Plan subscription associated to this charge on the provider's sideFA2A91FD-7286-4DCD-9718-20048CCA832A
SubscriptionName
The name of the subscription associated with the line item
Azure plan subscription
SubscriptionInternalIdThe internal id of the subscription associated with this charge. Use this to identify a subscription in your systemsSubscriptionTest
EntitlementId
 The ID of the azure subscription associated to the charge
fd666eca-477d-4f30-95ac-9ff265ce22aa
EntitlementDescription
The name of the azure subscription associated to the charge
Subscription-Demo
ResourceGroup
The name of the resource group associated to the charge
Demo-RG
PecAwarded
A boolean value indicating if the PEC was awarded on this charge
TRUE
SubtotalForReseller
The cost the reseller pays for the subscription on this charge before taxes.
49.08
SubtotalForCustomer
The cost the customer pays for the subscription on this charge before taxes.
52.44
Id
The ID that uniquely identifies the invoice line item
7828D90D-2AC6-4F20-A95B-EE850BCD32A0
CustomerProviderId
The ID of the customer on the provider's side associated with this charge
CB0A371A-046A-46A9-A299-96BD755E67A8
ResellerPriceMargin
The value of the margin applied by the CSP at the reseller level.
5
CustomerPriceMarginRuleThe margin rule applied at the customer level. The possible values are: markup, margin, splitmargin and erpminusdiscountmarkup
CustomerPriceMargin
The value of the margin applied at the customer level
5
SubscriptionPriceMarginRuleThe margin rule applied at the subscription level. May not be set.
SubscriptionPriceMargin
The margin value applied at the subscription level. May not be set.

SubscriptionPONumberThe purchase order number of the subscription associated with this charge. Use this to identify a subscription in your systems8543943821

    • Related Articles

    • Understanding reconciliation files as a CSP

      Downloading reconciliation files Access reconciliation files in CloudCockpit by going to Administration > Invoices. Choose the type of reconciliation file you want to download: One Time License Usage Daily rated usage Click Generate File Choose the ...
    • Reconciliation and Invoices Overview

      What is reconciliation? Reconciliation is a process that involves analysing each product charge and confirming that the data is accurate. You configure price margins for your resellers, customers, subscriptions and expect that to be reflected in the ...
    • Understanding reconciliation files as a Customer

      Downloading reconciliation files Access reconciliation files in CloudCockpit by going to Company> Invoices. Choose the type of reconciliation file you want to download: One Time License Click Generate File Choose the regional format of the ...
    • Create Reseller CloudCockpit Portal

      Resellers can have a personalized CloudCockpit portal with its own custom domain. Take advantage of this feature to strengthen your brand presence and provide a better user experience for clients. The setup process has been streamlined and no longer ...
    • Migrate Reseller CloudCockpit Portal

      The CloudCockpit infrastructure that enables Resellers (Indirect Resellers) to have portals with their own custom domains is being upgraded. If your Resellers are using the old DNS configuration, please follow these steps to migrate their portals to ...