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.

Notes: We use the term invoice month to refer to the month that an invoice or statement covered, even if your Cloud Billing account is not set up for invoiced billing. Sometimes, at the end of a calendar month, there is a slight delay in usage reporting. Late-reported usage might not be included on that invoice month's statement or invoice and instead might roll over to the next invoice month. As a result, your cost table report might include costs from more than one calendar month. To view your usage by calendar date or date range, use the online reports or analyze your exported billing data.

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.

Note: If someone else manages your Cloud Billing account, you may not have the necessary billing permissions. If this is the case and you think you should be able to view costs for your Cloud Billing account, contact the person in your organization who manages your Cloud Billing account.

For more information about billing permissions, see:

• Overview of access control
• Create custom roles for Cloud Billing
• Cloud Billing APIs access control
• Understanding predefined Identity and Access Management roles for Cloud Billing

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.

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

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.

  Note: Some usage costs are owned by the Cloud Billing account and are not included in a project (for example, Support costs). For these charges, the project name displays [Charges not specific to a project], and the project ID field is empty.

• 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

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.

  Note: Some usage costs are owned by the Cloud Billing account and are not included in a project (for example, Support costs). For these charges, the project name displays [Charges not specific to a project], and the project ID field is empty.

• 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.

  Note: Cost table reports are available going back to the May 2019 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).

  Note: If you want to set a filter by Labels (on a label_key:label_value pair) first select a label key using the cost label key selector. After you select a label key, you can then set a Labels filter.

• 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.

  Note: After you select a cost label key, you can then set a filter () on the label_key:label_value pairs. You can also choose to filter items that are not tagged with the selected cost label key by choosing (Empty) in the Labels filter.

• 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.

    Note: For reseller accounts, your cost will be grouped by subaccount first, and then grouped by project, then service, then SKU.

  • 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.

    Note: For reseller accounts, your cost will be grouped by subaccount first, and then grouped by service and then SKU.

  • 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.

    Note: A Billing account ID dimension is available for reseller accounts. If you are a reseller, the Billing account ID dimension allows you to group your costs by the Cloud Billing subaccount.

• 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.

  Note: Depending on the width of your screen and the number of columns you are displaying, you might need to scroll your online view of the report right and left to view all the columns.

• 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. Alert: Starting with your November 2019 invoice (available in December 2019), we removed the project-level cost detail from your invoices; that is, the Source field has been removed from the invoice CSV. The Cost Table report provides project-level cost details that are downloadable to CSV.
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. Note: The first invoice month with Credit ID data is July 2020, for usage that was recorded on or after July 8, 2020.
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. Note: The first invoice month with Credit name data is July 2020, for usage recorded on or after July 8, 2020.
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.

Notes:

The cost table report is designed to match your existing invoice as closely as possible. The display of credits and usage-based discounts (for example, promotional credits or sustained use discounts) are listed as separate line items on your invoice as well as in the cost table report. Online Cloud Billing reports and Cloud Billing Export to BigQuery do not break out credits and discounts into separate line items.

Invoice usage details do not include a column for the SKU price. If you have negotiated pricing, the invoice amount has that pricing applied to it. To view your prices per SKU, see the Pricing table report or export your Cloud Billing prices to BigQuery. If you have questions regarding pricing per SKU, contact your Account Representative for more details.

The Cost Table report does not currently support historical metadata. If you delete a project or move the project to a different Cloud Billing account, the following values will not be listed in the Cost Table: Project Name, Project ID, Project number, Billing account ID, Billing account name. If you have enabled the export of Cloud Billing data to BigQuery, you can find your historical project information in your BigQuery tables.

Related topics

• Get an invoice, statement, or receipt
• Understand your monthly invoice
• View your Cloud Billing reports and cost trends
• Export Cloud Billing data to BigQuery
• View your cost and payment history