Display Azure billing data

This page describes how to configure Azure billing data for resellers with CSP accounts.

For standard accounts see Display Azure billing data for standard accounts.

The platform populates the billing dashboard with data from the cloud provider, so you will need to allow programmatic access to billing in the cloud provider.

After you configure this feature, the platform may take up to 2 days to display data in the Estimated bill section of the Hybrid dashboard.

You should add credentials from each CSP account to the corresponding Abiquo enterprise within a reseller and tenant hierarchy. For more details, see Add public cloud or Abiquo cloud reseller guide

To display billing data for reseller tenants and their customers, do the following steps.

Configure Azure account

CSP resellers must give consent for the use of the CSP account in the platform. Contact Customer Service for more information.
The consent process will generate the accessToken and the refreshToken, which are part of the pricing credentials.

Configure Abiquo configuration properties

On the Abiquo Server, edit the abiquo.properties file and configure the following properties as required.

By default, the platform will retrieve billing data for the last two months. To change this value, and add the following property with the number of months to retrieve:

abiquo.enterprise.property.billing.monthoffset=2

By default, Abiquo will bill SaaS resources, such as a Twilio subscription, to the enterprise that the subscription is assigned to. This corresponds to the billing scope ID of a billing line item.

To exclude products from specific publishers from Azure billing, add the following property, and enter a string of publishers to exclude from billing line items in CSV format

abiquo.azure.billing.parser.lineitem.publisher.ignore=Microsoft Office

To use excluded publishers with the public-cloud-billing-check-tool for Azure, use the "--excludedPublishers" option.

In Abiquo configure enterprise properties for the reseller

In Abiquo, edit the reseller enterprise and create the enterprise properties:

Property	Description	Previous value	Migration

Property	Description	Previous value	Migration
azurecompute-arm_discount	Decimal value (with dot separator), used to calculate the user invoice for billing dashboard. CSP APIs return prices with a discount applied, which we remove to display for customers. This is done using the formula total = TotalFromCSP/(1 - azurecompute-arm_discount )		-
azurecompute-arm_price_factor	Default value for enterprises that do not have this value in their hierarchy. Also used to calculate the user invoice for billing dashboard. Also used for retrieving hardware profile prices from the provider. The platform will apply changes to the price factor in the next billing period.		-
azurecompute-arm_currency_code	Default is "USD". Three character currency code of the bill. WARNING! Different from currency_code used for conversion factor	Currency
billing.azure.country_code	Two digit ISO code representing the country where you purchased the subscription. The default of "US" is set in abiquo.properties in Remote Services as abiquo.billing.azure.country_code. So you only need to set this enterprise property to change the default value.	RegionInfo

The following properties are deprecated in Abiquo 5.2.0 and the upgrade process will remove them:

OfferDurableID
Locale

Configure enterprise properties for reseller customers

For reseller customers, edit the enterprise and create the following properties:

Property	Description	Previous value	Migration

Property	Description	Previous value	Migration
azurecompute-arm_discount	Decimal value (with dot separator), used to calculate the user invoice for billing dashboard.		-
azurecompute-arm_price_factor	The value of the discount or markup applied by the partner to the end user. The default value is 1.		-

Configure enterprise properties for reseller customers with Azure plans

For reseller customers with Azure plans under “CSP” subscriptions, create the following properties:

Property	Description	Previous value	Migration

Property	Description	Previous value	Migration
azurecompute-arm_only_bill_subscription	For Azure plans under CSP accounts only. If this property is "true", for an Azure plan, only bill for usage - do not include the customer's products and services in the billing data for this enterprise.	New	-

Configure credentials and privileges in Abiquo

For any reseller customer that will not use the compute features of the provider, to display data on the Billing dashboard, enter compute Credentials on the Public tab in the format Subscription##TenantId.
See Add credentials of reseller customers for billing only.
In Abiquo, edit the reseller enterprise and go to Credentials → Pricing and add the Pricing credentials,
In Abiquo, users will require the privileges to Display hybrid dashboard tab and View bills. See Configure dashboard display