Understand invoices with reports

To get a detailed view of your costs for a specific invoice or during a selected period, you often need to run a Cloud Analytics report.

Open in Reports

Note

This option is not available for Microsoft Azure, Google Workspace, or Office 365 assets.

The Open in Reports option on the main Invoices page allows you to run a report with the invoice data from your chosen time range and asset types.

1. Sign in to the DoiT console.

2. Select Billing from the top navigation bar, and then select Invoices.

3. Select Open in Reports:

   

   • Specify the time range of invoices.

   • Select invoice buckets to include the assets invoice data in your report.

4. Select Open.

5. Run the report. Note that if you run a report with a large amount of data, the process may take some minutes.

Allocation: Invoices

The Invoices allocation is used to analyze invoices issued to the following asset types, each invoice corresponds to an individual allocation rule:

• Amazon Web Services, Google Cloud: For costs incurred by AWS accounts, Google Cloud billing accounts and Google Cloud projects

  • If you're using custom bucketing, attributions follow the naming convention [{billing_profile_id}] {billing_profile_name} - {bucket_name}.

  • Otherwise, allocation rules follow the naming convention [{billing_profile_id}] {billing_profile_name} - {asset_type}.

• Looker: Looker invoices appear in the entry named Looker.

For other asset types, only Microsoft Azure billing data is available in Cloud Analytics; it will stay in the Unallocated.

Example

The example report below uses the Invoices allocations for invoices issued to a fictitious company:

• The company has a Billing profile US123123 – Example.com with custom buckets.

• The company has three custom buckets with the supported asset types.

You can add more dimensions to further break down the invoice. Below is an example of the invoice issued to assets in the bucket Dev.

The example below combines all three group allocations for Billing and invoicing for a breakdown of cost categories and savings.

DoiT Cloud Intelligence via AWS Marketplace

If you purchase a DCI Enhanced or Enterprise plan via AWS Marketplace, the total cloud spend used to calculate DCI charges is based on the previous billing period of the invoice.

Example

Below is an example that demonstrates the steps you can take to get a basic understanding of DCI charges.

Note

This example is provided for reference purposes. Except for the conditions explicitly stated, it does not take into account any other agreements you may have or any special scenarios that may apply.

Suppose you have an active DCI contract with a minimum service fee of US$2500 and a monthly cloud spend percentage of 2%.

1. Create a report to get the monthly spend of the three cloud providers: AWS, Azure, and Google Cloud, excluding credits and marketplace spend (filter by Cost Type not equals Credit and Marketplace not equals true).

   

2. Take the spend in March as an example: the 2% cloud spend is 168,384.49 × 0.02 = 3367,69, which exceeds the minimum fee of 2500 by 867,69.

3. Create another report for a full view over your DCI marketplace spend, grouping data by Service (Service equals DoiT Cloud Intelligence) and aws/item_desc.

   

   The AWS Marketplace software usage|us-east-1|Usage above contractual agreement item in April is the rounded value of the extra cost in March.