View and download the cost details of your invoice or statement

Overview

Your PDF invoice or statement does not provide details for every resource cost but instead is summarized to show your total usage and cost per SKU. Note that if your computing usage volume is very high, your PDF invoice might be further simplified to display the cost per account or just the total cost. If you need a more granular view of your invoice costs, refer to the Cost Table report available in the Google Cloud Console.

The Cost Table report gives you a detailed, tabular view of your monthly costs for a given invoice or statement (by invoice month). The cost table matches your invoice or statement total and, like the invoice or statement, generally includes all costs incurred during a given calendar month.

The report includes project-level cost details from your invoices and statements, along with additional details you might need, such as service and SKU IDs. The report view is customizable and downloadable to CSV.

Permissions required to access the cost table report

To view the cost table report for your Cloud Billing account, you need to be a Billing Account Administrator or Billing Account Viewer on your Cloud Billing account. Specifically, you need the billing.accounts.getSpendingInformation permission on your Cloud Billing account.

For more information about billing permissions, see:

Accessing the report

To view the Cost Table report for your Cloud Billing account, for an invoice month:

  1. Sign in to the Google Cloud Console.

    Sign in to Cloud Console

  2. Open the console Navigation menu , and then select Billing.

    If you have more than one Cloud Billing account, do one of the following:

    • To manage Cloud Billing for the current project, select Go to linked billing account.
    • To locate a different Cloud Billing account, select Manage billing accounts and choose the account for which you'd like to see reports.
  3. From the Billing navigation menu, select Cost table.

By default, when you first access the report, you see the data for the most recent complete month, grouped by Project -> Service -> SKU, without any filtering of the data, and including all the applicable columns of data.

Example of the default cost table report view.
Figure 1: Example of the default cost table report view, grouped by Project -> Service -> SKU, without any filtering of the data, and including all the applicable columns of data.

How to read the cost table

The cost table shows you a detailed breakdown of all of your costs and credits for the invoice month.

Two different types of table views are available: flat table and nested table.

Flat table view

Example of a flat cost table report.
Figure 2 - Flat table view: Example of the cost table report with no grouping option selected, and a few columns deselected for display (such as billing account name and billing account ID).

In the flat table view:

  • Each column contains one type of data (for example, Project name, Service description, or SKU description)

  • Each row with a Usage cost type represents the total usage costs for a SKU, for a project.

    If you have selected a cost label key, each row represents the total usage costs for a label_key:label_value pair for a SKU, for a project.

  • If applicable to your Cloud Billing account, the cost table also includes rows for earned discounts, taxes, rounding errors, and any invoice adjustments.

  • The final row in the flat cost table is the Total. This number matches your invoice or statement total for the invoice month.

  • Below the table is a footer that displays any taxes, invoice corrections/billing modifications, and rounding errors (if applicable to your Cloud Billing account), as well as the total for the selected month. This total matches your invoice or statement total for the month.

Nested table view

Example of a nested cost table report.
Figure 3 - Nested table view: Example of the cost table report grouped by Custom grouping, setting the custom group by dimensions to use Labels and SKU ID, and with the env:dev label row expanded to view the charges by SKUs tagged with that label key.

In the nested table view:

  • A hierarchical, tree-structured view of your cost data is provided, so you can analyze your billing data online in the cost table report.

  • The first column in the table groups the cost details by the selected option. For example, the Project -> Service -> SKU group by option generates a single column called Project name / Service description / SKU description. If you configure a Custom grouping group by option, the first column of the table is titled Custom grouping hierarchy.

  • Each row in the nested table displays hierarchical cost data representing the costs by the grouping level (for example, total costs for a project, or for a service).

  • You can expand or collapse the hierarchical cost data in each of the grouped rows to analyze the cost breakdown of the grouped total.

  • Below the table is a footer that displays any taxes, invoice corrections/billing modifications, and rounding errors (if applicable to your Cloud Billing account), as well as the total for the selected month. This total matches your invoice or statement total for the month.

Configure your report view to analyze your billing data

You have many options available to configure the online view of your cost table report. By default, when you first access the report, you see a nested table displaying the data for the most recent complete month, grouped by Project -> Service -> SKU, without any filtering of the data, and including all the applicable columns of data.

To customize your online report view, do any of the following:

  • Choose the invoice month: Use the dropdown above the table to select the Invoice month.

  • Set one or many filters: Select Filter table (if viewing a flat table) or Filter tree (if viewing a nested table) to create filters by column value (for example, Project ID : my-project-194-1378).

  • Set or change the cost label key:

    To select or change the cost label, open the Table configuration dialog, select a Label key, and then click SUBMIT. When a label key is selected, the Labels column is automatically displayed in the table. For the items tagged by the selected cost label key, a label_key:label_value pair is displayed in the Labels column. You can also use the selected label key as a custom Group by grouping dimension.

    Learn more about creating and managing resource labels.

  • Set a group by option:

    Open the Table configuration dialog and choose one of the Group by settings to see a nested, hierarchical view of the cost data, grouped by the option selected. You can choose a pre-defined Group by option, or define a custom grouping. A nested table summarizes costs into expandable rows, letting you drill down to view the cost details of the rows.

    The group by options available are:

    • No grouping: Shows a flat cost table.

    • Project -> Service -> SKU: Shows a nested cost table and groups costs first by project, then service, then SKU. Click on the arrows ( or ) next to a row to expand and collapse the details of the row.

    • Service -> SKU: Shows a nested cost table and groups costs first by service, and then SKU. Click on the arrows ( or ) next to a row to expand and collapse the details of the row.

    • Custom grouping: Shows a nested cost table and groups costs by up to three grouping dimensions that you choose, nested hierarchically in the order you set for the selected dimensions. Click on the arrows ( or ) next to a row to expand and collapse the details of the row.

      Available grouping dimensions include Project ID, Service ID, and SKU ID. A Labels dimension is also available to select if you first set a Label key.

  • Select the columns to display: You can select or deselect the columns to show in the table using the Column display options selector. This setting also controls which columns download to CSV; that is, only the columns you specify are downloaded.

  • Change the sort order of the data: Click a column header to sort the data in the table by that column. You can toggle the sort between descending () and ascending () order.

Download report to CSV

You can download the cost table data to CSV using the Download CSV selector at the top, right of the table. The CSV report is a flat file, without any formatting, filtering, or grouping options, and downloads only the columns you selected to view.

Notes about the data downloaded to CSV:

  • The filters () you set only customize your online report view, affecting the rows that are displayed. When you download to CSV, all rows of the invoice are downloaded.
  • The cost grouping option () you select is used for online analysis, creating a nested table view. When you download to CSV, a flat file is downloaded, including all rows of the invoice with data in individual (not nested) columns.
  • The column selector () allows you to customize both your online report view and which fields are downloaded. When you download to CSV, only the columns you specify are downloaded.

Columns in the cost table

The following data is available in the Cost Table report (if applicable to your Cloud Billing account). Note that when you first load the cost table report, by default, some columns are not selected to display. You can choose which columns to view in the report using the column selector (). Also, when you download the report to CSV, only the selected columns are downloaded.

Cost Table Field Corresponding Invoice Field Description
Billing account name Account Name The name of the Cloud Billing account that the usage is associated with. (If you are a reseller, this might be the Cloud Billing Subaccount.)
Billing account ID Account ID The Cloud Billing account ID that the usage is associated with. (If you are a reseller, this might be the Cloud Billing Subaccount.)
Project name Source*
* N/A, starting with your November 2019 invoice
The name of the project that generated the Cloud Billing data.
Project ID N/A The ID of the project that generated the Cloud Billing data.
Project number N/A An internally-generated, anonymized, unique identifier for the project. In your support cases and other customer communication, Google will refer to your projects by this project number.
Credit ID N/A If present, indicates that a credit is associated with the product SKU, and identifies the type of credit. Credit ID values are either an alphanumeric unique identifier (for example, 12-b34-c56-d78), or a description of the credit type (such as Committed Usage Discount: CPU).

If the credit ID field is empty, then the product SKU is not associated with a credit.

Credit name N/A The name of the credit associated with the product SKU. This is a human-readable description of an alphanumeric Credit ID. Examples include Free trial credit or Spend-based committed use discount.

Credit name values are only present for SKUs with an alphanumeric Credit ID. If the value of the Credit ID is a description of the credit type (such as Committed Usage Discount: CPU), then the Credit name field will be empty.

Service description Product The invoice description of the Google Cloud service or Google Maps Platform API that reported the Cloud Billing data. For example, Compute Engine.
Service ID N/A The ID of the Google Cloud service or Google Maps Platform API that reported the Cloud Billing data. For example, 6F81-5844-456A.
SKU description Resource Type The invoice description of the resource SKU used by the service. For example, N1 Predefined Instance Core running in Americas.
SKU ID SKU ID The ID of the resource SKU used by the service. For example, 2E27-4F75-95CD.For the full list of SKUs, see Google Cloud SKUs.
Labels N/A The label_key:label_value pair. For example, environment:production. The label_key (for example, environment) is selected using the Label key selector accessible in the Table configuration dialog. The label_value (for example, production) is one of the values corresponding to the selected label key.

Learn more about creating and managing resource labels.

Cost type Description A description of the type of cost for the line item.
  • Usage represents the cost of the row's Google Cloud usage.
  • Adjustment represents any invoice-level, manual adjustments made (this is rare).
  • Rounding Error represents the total rounding error that occurred during cost calculation. (When calculating usage costs, all costs are converted to the lowest billable unit, then summed to determine the invoice total. Sometimes, small rounding errors occur due to this cost conversion.)
  • Tax represents invoice-level taxes on usage and adjustments.
  • Total represents the total cost for the invoice month.
Usage start date Start Date The date of the first occurrence of usage for this invoice month (see note above on the possibility of late-arriving usage).
Usage end date End Date The date of the last occurrence of usage for this invoice month (see note above on the possibility of late-arriving usage).
Usage amount Quantity The quantity of usage units used.
Usage unit Unit The billing unit of the usage (such as hour or gibibyte month).
Cost in micros N/A The calculated cost of the usage in micro units (µ). Micro is a unit prefix in the metric system denoting a factor of 10−6 (one millionth). When we calculate your usage costs, we convert all costs to micro units to provide the level of accuracy needed to calculate any rounding errors. Examples:
  • 999,741 Cost in micros = 1.00 Cost (in currency).
  • -10,011,960 Cost in micros = -10.01 Cost (in currency).
Cost Amount The calculated cost of the usage, in the currency the Cloud Billing account is configured to use.