Cloud Billing Report

The Cloud Billing report provides full cost visibility by showing historical data for all services, including services that Commander does not manage, so all of your cloud costs are included in one report. Service providers can use this to generate accurate billing reports for their customers. The Cloud Billing report includes private cloud accounts. For more information on setting report options, see Running and Scheduling Reports.

This report is based on historical billing data that's retrieved nightly. To learn how to retrieve historical billing data, see:

Costs in this report are calculated using the current cost model. For objects no longer associated with a cloud account, Commander uses the global default cost model for cost calculations.

  • Taxes are not shown on the Cloud Billing report for Azure.
  • In some cases, the services listed in the report may not exactly match those shown in public cloud providers' management portals. Any discrepancies reflect the difference between the service type names providers use for their APIs and those customer-facing names that they present in their Web portals.
  • Storage costs for Azure shared disks are allocated based on VM ownership. If multiple VMs that reference a shared disk are assigned to different organizations, or to primary owners from different organizations, the cost for the shared disk is assigned to the organization that comes first alphabetically. If a VM that references a shared disk has multiple primary owners, the username that comes first alphabetically is considered the sole primary owner for determining cost allocation.

Report settings

Access:

Reports > Chargeback & IT Costing > Cloud Billing

or

Views > Cost Analytics > Cloud Billing Report

Available to:

All Access Rights Levels

During: Specify a time period for the report.

  • When you select By Period, the period will be the last completed timespan. For example, if the current month is May and you select Last 3 Months, the range for the report will be February, March, and April.

    For more information, see Time Range Filters

  • embotics.http.security.header
  • When you select By Dates, Commander populates the From Date field with the earliest date available for the selection; this is the date that the first historical data was added to Commander.

Cloud Type: Select private cloud, public cloud, or all cloud types. The cloud type you select will determine the availability of your cloud accounts.

Organization: If you are generating a billing report for a particular customer, you likely want to filter the report by organization.

  • Any Organization: VMs that aren't assigned to an organization are excluded from the results.
  • All VMs/Services: The report includes all VMs and services, regardless of organizational assignment.
  • Default Organization: The report includes all VMs and services assigned to Commander's default organization.

    You can also select a particular organization from the list. If you want to use a "contains" operator or filter on multiple organizations, use the advanced filter Organization Name instead.

Cost Adjustments — If you want the report to show your actual costs, keep the default of None. If you want the report to reflect any markups and discounts that you have set, select Include Markups and Discounts. This report can be shared with Service Portal users in the Published Reports section. When Service Portal users view this report with adjusted values, they won't see any indication that the costs are marked-up or discounted.

If you include Markups and Discounts in this report, you may want to add a comment in the Comment section to remind yourself that these costs are adjusted. Service Portal users will see the comment if they view the report, so the comment should be something that does not reveal that these are adjusted costs. For example: "Customer Report".

Currency: Select the currency for the report. The default setting will be your preferred currency setting. All costs shown in the report will be converted to this currency. You can also select No Conversion and costs in the report will be grouped based on their original native currencies.

Exchange Rate:

  • Select Actual Historical to use exchange rates that are provided by the European Central Bank.
  • Select Fixed Rates from USD to enter custom exchange rates. This is useful if you want to use a fixed exchange rate for monthly reports to customers.

These options aren't available if you selected No Conversion for currency.

Group By: Select a billing tag for grouping the report data. For example, you can group by cost center. If the report includes a section titled "Value not set", it contains entries with no value for the grouping option you selected.

Add Advanced Filters: You can further filter the report by charge type, cloud account, VM name (for private cloud), service name (for public cloud), resource ownership, and billing tags.

Unlike the basic Organization setting, the advanced filter Organization Name provides a "contains" operator. For example, if you have organizations named "Acme 1" and "Acme 2", filtering the report by "Organization Name contains Acme" ensures that the report contains data for both organizations. The advanced Organization Name filter does not take cost allocation into account.

If an organization name has been changed and you filter on the new organization name, billing data created prior to upgrading to Commander 7.5 won't be included in the report.

Each line of billing data is sorted into one of five Charge Types. Use Advanced Filters to remove these Charge Types from the Cloud Billing Report:

Charge Type Public CloudsAWSGCPAzure (Including Azure Enterprise)
Adjustment Rounding errorRounding error + AdjustmentN/A
Credit CreditCreditN/A
Resource Usage Left over after the above charges have been removedLeft over after the above charges have been removedAll Billing records
Tax TaxTaxN/A
CustomUser-specifiedUser-specifiedUser-specified
Charge Type Private CloudsVMwareSCVMM
Adjustment N/A N/A
Credit N/A N/A
Resource Usage All Billing records All Billing records
Tax N/A N/A
CustomUser-specifiedUser-specified

If you don't have permission on a cloud account, data pertaining to that cloud account won't be visible in the Cloud Billing report. If regions aren't selected on a cloud account, data pertaining to those regions won't be visible.

The Cloud Billing report displays one entry per service or cost category with the number showing the total usage and total cost over the specified reporting period. The summary table shows the sum of all the service costs per service type. The chart represents the top 10 most expensive service types. The remaining service types are grouped under the title “Others”.

Itemized costs are rounded to two decimal places. The exact total cost is calculated before rounding.