View and download the cost details of your invoice or statement

Overview

Cost table report with default report settings and filters.

The cost table report, available in the Google Cloud console, is a cost management tool that you can use to understand the costs that reconcile to your invoice. The report gives you a detailed, tabular view of your costs for a given invoice or statement (by invoice month). If you are viewing the report using filters in their default state, the cost table report totals match your invoice or statement totals, and the report generally includes all costs incurred during a given calendar month.

The cost table report includes project-level cost details from your invoices and statements, including your tax costs broken out by project. It also includes additional details you might need, such as service IDs, SKU IDs, and project numbers.

The report view is customizable and downloadable to CSV.

Beginning with your January 2021 invoice or statement (available in February 2021), to simplify the document format, we removed all cost details from the invoices and statements you receive (both PDF and CSV), including product-level costs and costs by subaccounts (for Resellers). The invoices and statements contain your company information (such as your billing address, your Cloud Billing account ID, and your payment terms), your cost totals, taxes, and remittance instructions. In place of providing the cost details, your invoice provides a link to the Cost table report for the Cloud Billing account.

In the cost table report, we use the term invoice month to refer to the time period that an invoice or statement covers. The detailed usage costs included for an invoice month might differ slightly from the detailed usage costs for a calendar month. For more details about these differences, see How costs are calculated for an invoice month.

Permissions required to access the cost table report

To view the cost table report for your Cloud Billing account, you need a role that includes the following permission on your Cloud Billing account:

To gain this permission, ask your administrator to grant you one of the following Cloud Billing IAM roles on your Cloud Billing account:

  • Billing Account Viewer
  • Billing Account Costs Manager
  • Billing Account Administrator

For more information about billing permissions, see:

Access the report

To view the cost table report for your Cloud Billing account:

  1. In the Google Cloud console, go to your Cloud Billing account.

    Go to your Cloud Billing account

  2. At the prompt, choose the Cloud Billing account for which you want to view reports. The Billing Overview page opens for the selected billing account.

  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.

How to read the cost table

The cost table shows you a detailed breakdown of all your costs and credits for the selected invoice or statement and provides tools for cost analysis.

Example of the default cost table report view.
Figure 1: Example of the default cost table report, grouped by Project -> Service -> SKU. The screenshot highlights the different sections of the report page.

The screenshot above highlights and enumerates the different sections of the cost table page. The following information provides an overview of each section (the numbers below match the number in the screenshot for each section).

  1. Header information for the invoice or statement. Starting with the September 2020 invoice month, the cost table report includes invoice or statement header information. The header includes your billing account ID, the invoice number and date, the invoice total, the currency of your Cloud Billing account, and the currency exchange rate (available starting April 2021, for accounts billed in a non-USD currency).

    If you are a Reseller, the invoice header information only displays on the parent Cloud Billing account, and is not displayed when viewing the report for one of your Cloud Billing subaccounts.

  2. Table view of your detailed costs. You can customize the table view using the report settings. Two different types of table views are available: nested table (default) and flat table. You can also control which columns are displayed in the table, and you can use filters to refine the report data to analyze your costs.

    To gain more flexibility when analyzing your data in the cost table, you can enable a floating summary bar when you select specific rows to analyze. The summary bar works in both nested and flat table views.

  3. Table footer that displays the totals of the costs in the table view.

    When you view the report using filters in their default state, the report data in the table returns all costs for the selected invoice month, and the total in the footer matches the total in the report header (1) and matches the invoice or statement total for the selected document.

    If you use the filters to adjust the data in the table (such as filtering on selected projects or services) the footer totals will change to reflect the results of the report filters. You can reset the filters to return the filters to their default (unfiltered) state.

    The totals in the footer include taxes (for each tax type), invoice corrections/billing modifications, and rounding errors (if applicable to your Cloud Billing account), as well as the total of the costs in the table, based on the selected filters.

  4. Table settings and report tools to adjust the display of the table and to download the report data to CSV.

  5. Report filters to refine the cost data returned in the cost table.

Understand the cost table views

The detailed cost information for the selected invoice month and filters is displayed in the table view of the cost table report. Two different types of table views are available: nested table and flat table. When analyzing your data in the cost table, you can enable a floating summary bar when you select specific rows to analyze. The summary bar works in both nested and flat table views.

You can customize the display of the table view using the table settings. You can also control which columns are displayed in the table, and you can use filters to refine the usage and cost data returned to the table. See configure your report views and settings for more information.

Nested table view

A nested table view is a hierarchical, tree-structured view of your cost data, grouped by various dimensions that you specify. Use nested views to see your invoice costs summarized by the grouping dimensions (such as Project -> Service -> SKU). You can drill down on the cost details for each grouping dimension to see the cost breakdown of each grouped row.

Example of a nested cost table report.
Figure 2 - 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 environment:test label row expanded to view the charges by SKUs tagged with that label key.

In the nested table view:

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

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

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

  • Starting with your September 2020 invoice month, your tax costs are broken out by each project. To view your tax costs by project in the nested table view, you must use or configure a Group by option with Project as the first grouping dimension. For example, group by Project -> Service -> SKU.

  • Prior to January 2022, if any of your projects have been deleted or moved to a different Cloud Billing account, the project associated with the costs is identified only by the Project number. Starting January 2022, historical project metadata is available with the addition of project hierarchy data. The values in the project hierarchy column are displayed in the nested table view only when you are grouped by Project > Service > SKU. Project hierarchy values are also displayed in the flat table view of the cost table.

Flat table view

A flat table view is an itemized list of each of the costs and credits incurred for the invoice month selected. The data displayed in the flat table view depends on the filters that you set. If you are using filters in their default state, the flat table view includes rows for all costs and credits incurred for the selected invoice month, and the cost table report totals match your invoice or statement totals.

Example of a flat cost table report.
Figure 3 - 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 (or project hierarchy).

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

  • Starting with your September 2020 invoice month, your tax costs are broken out by each project. In the flat table view, if you have incurred tax costs, each row with a Tax Cost type represents the total tax costs for a SKU description (specific tax type and percentage), for a Project ID.

  • The final row in the flat cost table is the Total. This number matches the total in the report table footer. If you are viewing the report using filters in their default state, this number matches your invoice or statement total for the invoice month.

  • Prior to January 2022, if any of your projects have been deleted or moved to a different Cloud Billing account, the project associated with the costs is identified only by the Project number. Starting January 2022, historical project metadata is available with the addition of project hierarchy data. The values in the project hierarchy column are displayed only when you are viewing a flat table view or when you are viewing a nested table view grouped by Project > Service > SKU.

Report views with summary bar

The summary bar is a tool you can use to perform quick cost analyses of the data returned in the table view. In the cost table, you select the rows you want to analyze; the summary bar displays the sum of the costs and credits, the percentage of savings earned, and the subtotal (net cost) of the selected rows. The summary bar works in both nested and flat table views.

Example of a cost table report displaying the summary bar.
Figure 4 - Summary bar displayed: Example of the cost table report showing the floating summary bar displayed, which automatically opens when you select specific rows to summarize. The summary bar is available for both nested and flat table views.

To open the summary bar, take one of the following actions:

  • Click the summary bar icon in the tool bar to open or close the summary bar.
  • Select individual rows in the table by clicking the row selector check boxes.

When open, you see a blue, floating summary bar appear on the bottom of the cost table page.

Information in summary bar

  • n selections: Indicates the number of rows selected.
  • Cost: The total, gross cost of all selected rows. Click on the Cost expander () to open a cost detail panel. In the panel, costs are grouped by projects, sorted by project name in ascending order.
  • Credits: The sum of all credits for the selected rows. Click on the Credits expander () to open a credits detail panel. In the panel, credits are grouped by projects, sorted by project name in ascending order.
  • Savings: The percentage of savings comparing costs to credits for the selected rows. Savings = -1 * Credits / Cost * 100%
  • Subtotal: The net cost of the selected rows. Subtotal = Cost - Credits.

    Click on the Subtotal expander () to open a subtotal detail panel. In the panel, subtotals are grouped by projects, sorted by project name in ascending order.

To close the summary bar, take one of the following actions:

  • Click the summary bar icon in the tool bar to open or close the summary bar.
  • In the summary bar, click close ().

Configure your report views and settings

You can select the costs you want to analyze and configure the display of your cost table report using the invoice month, report filters, and table settings. As you configure the report filters, your page URL updates to include your selections. Use Share to copy the URL to share the report.

Example of the default cost table report view.
Figure 5: Example of the cost table report, highlighting the report filters, table settings, and share button.

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.

Invoice month

Invoice month selector in the filters panel.

In the filters panel, use the Invoice month selector to choose the invoice or statement you want to view.

Cost table reports are available for complete months (back to May 2019). Starting with your September 2020 invoice or statement, the invoice or statement number is appended to the month and year. For example, September 2020 - Invoice 1234567890.

Invoice month returns usage and cost details on the invoice or statement issued for the month selected.

For invoiced accounts, it is possible to receive more than one invoice in a calendar month. You can only select to view one invoice at a time. You can differentiate between invoices based on the invoice number appended to the invoice month (for example, two different invoices that were issued in April 2021 might look like this: April 2021 - Invoice 1002003011 and April 2021 - Invoice 1002003022).

For self-serve, online accounts, only one statement is issued each month.

Filters

The cost table report can show all costs and credits for the selected invoice or statement, or filtered to focus on a specific set of resources. By default, when you first access the report, the filters are configured to include all values, and the report total matches the total of your invoice or statement. As you set filters, the data displayed in the cost table report adjusts to represent the costs and credits based on the filters selected.

Various filter selectors in the filters panel.

  • Subaccounts: If you're viewing a primary billing account with subaccounts, you can select all subaccounts (default) or select a subset of subaccounts by clicking them in the list.

  • Folders & Organizations: Folders and organizations are components of a project hierarchy, the resource hierarchy mapping of a project. If the invoice month is configured to start on or after January 2022, you can select all folders/organizations (default) that are associated with the projects that are linked to the Cloud Billing account, or select a subset of folders/organizations.

    The values in the selector are listed in alphabetical order by resource name. To determine if a value is an organization or a folder, look at the ID number displayed below each name. ID numbers are prefaced with folders/ or organizations/ to indicate the type of resource.

    For the Cloud Billing account you are viewing, if none of the linked projects are associated with any folders or organizations, then this filter option is not displayed.

    To view the folders and organizations in the cost table report, look at the values displayed in the project hierarchy column.

    To learn more about organizations, folders, and project hierarchy, see Billing reports: Analyzing your costs by project hierarchy.

  • Projects: You can select all Cloud projects under the Cloud Billing account (default) or select a subset of projects by clicking them in the list.

  • Services: You can select all services (default) or select a subset of services by clicking them in the list.

  • SKUs: You can select all SKUs (default) or select a subset of SKUs by clicking them in the list. To learn more about SKUs, see the pricing table report.

Setting the Locations filters in the filters panel.

  • Locations: By default, all locations are enabled. By clicking the location tiles, you can filter on a subset of locations by geography (such as Europe), multi-region (such as Global), or region (such as us-east1). Specifically, the report is filtered by the regions and multi-regions selected.

    Use the tiles in geography to quickly select (or deselect) all regions and multi-regions in that geography. Multi-regions tiles are marked with an asterisk (for example, us*).

    Learn more about geography and regions.

Setting the Labels filters in the filters panel.

  • Labels: Labels are key/value pairs you attach to resource usage (for example, Compute Engine or Cloud Storage). To filter usage by label:

    1. Expand the Labels section.
    2. Select the label Key.
    3. Select the Value under that key you want to filter on (the default is all values under the selected key).

    To add another label with a different key, click + Add Label, and then select the key and value(s) for the label filter.

    To remove a label filter, click (delete) for each label key/value pair you want to remove.

    If you want to view costs for your Google Kubernetes Engine, you must enable cost allocation for your GKE clusters. After you have enabled cost allocation, you can filter your GKE resources by using these label keys:

    • goog-k8s-cluster-name: Filter or group GKE resources by cluster.
    • k8s-namespace: Filter or group GKE resources by namespace.

    When filtering by label keys, you cannot select labels applied to a project. You can select other user-created labels that you set up and applied to Google Cloud services. For more information about labels, see common uses of labels and creating and managing resource labels.

Setting the credits and invoice-level charges filters in the filters panel.

  • Credits: You can select all applicable credits (default) to be included in the cost calculations, or you can uncheck some or all of the credit options to exclude credits from the cost calculations.

    The credits filter displays only the specific credit types that you incurred in your Google Cloud costs. If a particular type of credit does not apply to your Cloud Billing account, you will not see that credit option in the list.

    See Cloud Billing Reports to learn more about credits.

  • Invoice level charges: You can select all invoice-level charges (default) to be included in the cost table report, or you can uncheck some or all of the invoice-level options. Invoice-level charges display in the cost table and in the footer below the table.

  • Reset button: In the cost table report, when filters are in their default state, the costs displayed in the report reconcile to the costs on your invoice or statement. If you set any filters during your report analysis, you can return the report filters to their default state by clicking the Reset button.

Table settings and report tools

Table settings and report tools on the cost table report.

The table settings and report tools are located above the table, and include options to set the table configuration (), control the columns displayed in the table (), toggle the visibility of the summary bar (), and download the report data to CSV ().

Table configuration

Table configuration dialog.

  • Label data:

    The cost label key setting controls which cost label values are displayed in the Labels column, and enables labels as a grouping dimension option when you are configuring a custom Group by option.

    To select or change the cost label values that display in the label column, open the Table configuration dialog, select a Label key, and then click Submit.

    • You can select one label key at a time.
    • When a label key is selected, a label_key:label_value pair is displayed in the Labels column for the resources tagged by the selected cost label key.
    • You can use the selected label key as a custom Group by grouping dimension.

    You can also filter on labels even if you do not set a cost label key. However, the labels column does not display any values until you set a cost label key in the table configuration dialog.

    Learn more about creating and managing resource labels.

  • Group by:

    The Group by setting controls your table view, letting you switch between a flat table view and various nested table views.

    Open the Table configuration dialog and choose one of the Group by settings to see a flat or 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 custom grouping dimensions include the following:

      • Project ID, Service ID, and SKU ID options are always available.
      • A Labels dimension is available to select if you first set a Label key. If you group your costs by labels, then you will see rows for resource costs grouped by the selected cost label key, and a row for Charges not tagged by the label key.
      • A Billing account ID dimension is available for primary billing accounts with subaccounts (reseller accounts). If you are viewing a primary account, the Billing account ID dimension allows you to group your costs by the Cloud Billing subaccount.

Column display options

Various filter selectors in the filters panel.

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

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

Summary bar visibility

Click the summary bar icon in the tool bar to open or close the summary bar.

Using the summary bar, you can quickly analyze a subset of data in the cost table. The summary bar works in both nested table views and flat table views. For more information, see report views with summary bar.

Download report data to CSV

Click the Download to CSV icon in the tool bar to download the report data to CSV. For more details on the CSV download, see download report to CSV.

Share or bookmark the URL of a customized report

You can bookmark or share the URL of a cost table report you have customized. As you configure your cost table report by setting the invoice month, cost grouping options, and report filters, your page URL updates to include your selections.

Note that column display settings () are not included in the URL, due to potential URL length limitations. Your shared URL will open the report with the default columns enabled to display.

Share button on the cost table report.

  • You can share the report by copying the URL. Click Share to copy the URL to your clipboard.
  • Optionally, in your browser, you can bookmark the URL to save the URL with your report settings.

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 or grouping options. The data that downloads is limited by any filters that you have set and includes only the columns that you have selected to view. Starting with your September 2020 invoice or statement, the CSV file also includes the invoice or statement header information.

Notes about the data downloaded to CSV:

  • The filters you set customize both your online report view (affecting the rows that are displayed in the table), and the data that is downloaded to CSV. If you want to download all of the cost data on your invoice, reset the filters to their default state.
  • The cost grouping option () you select is used for online analysis, affecting the cost 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.
  • Starting with your September 2020 invoice or statement, the cost table report includes header information pulled from the generated document, including the billing account ID, total amount of the invoice or statement, and currency of the invoice or statement amount. This header information is downloaded to CSV.

Columns in the cost table

The following data is available in the cost table report (if applicable to your Cloud Billing account).

When you first load the online view of the cost table report, by default, some columns are not selected to display. You can choose which columns to view in the report by setting the column display options. Also, when you download the report to CSV, only the columns that you have selected to view 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 have access to a primary billing account with subaccounts (a reseller account), 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 have access to a primary billing account with subaccounts (a reseller account), 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.

When viewing the report for an invoice month prior to January 2022, if a project has been deleted or moved to a different Cloud Billing account, this value is blank, and the project is identified by the Project number.

Starting with the January 2022 invoice month, Project hierarchy data is available. If a project has been deleted or moved to a different Cloud Billing account, the Project name is displayed when the Project hierarchy values are populated.

Project ID N/A

The ID of the project that generated the Cloud Billing data.

When viewing the report for an invoice month prior to January 2022, if a project has been deleted or moved to a different Cloud Billing account, this value is blank, and the project is identified by the Project number.

Starting with the January 2022 invoice month, project hierarchy data is available. If a project has been deleted or moved to a different Cloud Billing account, the Project ID is displayed when the Project hierarchy values are populated.

Project number N/A

An internally-generated, anonymized, unique identifier for the project. In your support cases and other customer communication, to protect your privacy, Google will refer to your projects by this project number.

When viewing the report for an invoice month prior to January 2022, if you delete a project or move the project to a different Cloud Billing account, the Project name and Project ID are removed from the cost table report views, but the Project number persists in your reports.

Starting with the January 2022 invoice month, Project hierarchy data is available. If a project has been deleted or moved to a different Cloud Billing account, the Project name, Project ID, and Project number are displayed when the Project hierarchy values are populated.

Note: When you first load the cost table report, by default, the Project number column is not selected to display. To view the Project number column in your cost table, select Project number in the column display options.

Project hierarchy N/A

Project hierarchy data is available starting on January 1, 2022.

Projects form the basis for creating, enabling, and using all Google Cloud services. Project hierarchy is the ancestry of a project, the resource hierarchy mapping of the project (Organization > Folder > Project). Projects can stand alone (that is, not be associated with any folders or organizations) or be the child of an Organization or Folder.

Project hierarchy tracks the current and historical project ancestry. For example, changing a project's name, or moving a project to a different folder or organization, affects the historical project ancestry.


Starting with the January 2022 invoice month, the cost table report returns a row for each distinct combination of Organization > Folder > Project, and the table includes columns for Project name, Project ID, Project number, and Project hierarchy.

The values listed in the Project hierarchy column show Organization name > Folder name.

  • Values in the project hierarchy column are populated starting with the January 2022 invoice month. Before January 2022, the column is blank.
  • The values in the project hierarchy column are displayed when you are viewing a flat table view or when you are viewing the default nested table view (grouped by Project > Service > SKU).
  • To see the project hierarchy values when the cost table is configured to use a nested table view, expand the hierarchical cost data in each of the grouped rows until you are viewing rows that display the costs for a SKU, for a project.

To analyze your costs by project hierarchy, set the Table configuration Group by setting to No grouping, and sort the cost table data on different columns:

  • To visualize all of the projects that have the same project hierarchy, sort the table by the Project hierarchy column.
  • To visualize if you have the same project associated with more than one ancestry, sort the table by the Project ID column.

To learn more about organizations, folders, and project hierarchy, see Billing reports: Analyzing your costs by project hierarchy.

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 description also includes different tax types. For example, State sales tax (4.71%) or PST/QST/RST (9.975%).
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.
Credit type N/A Describes the purpose or origin of the Credit ID. Credit types include discounts and promotions, such as:
  • Free tiers: Some services offer free resource usage up to specified limits. For these services, credits are applied to reflect the free tier usage.
  • Sustained use discounts: Sustained use discounts are automatic discounts that you get for running specific Compute Engine resources for a significant portion of the billing month.
  • Committed use discounts (resource based): Compute Engine offers the ability to purchase committed use contracts in return for deeply discounted prices for VM usage.
  • Committed use discounts (spend based): Spend-based committed use discounts provide a discount in exchange for your commitment to spend a minimum amount for a service in a particular region.
  • Spending based discounts (contractual): Discounts applied after a contractual spending threshold has been reached.
  • Subscriptions: Long term subscriptions to services that are purchased in exchange for discounts.
  • Reseller margin: For resellers only, this is the Reseller Program Discount credit earned on eligible items.
  • Promotions: Promotions are things like Google Cloud Free Trial and marketing campaign credits, or other grants to use Google Cloud. Promotional credits are typically considered a form of payment. When available, promotional credits are automatically applied to reduce your total bill.
  • Other: Any credits that do not fit into the discounts or promotional credits categories.

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

Note: The first invoice month with Credit type data is July 2020, for usage that was recorded on or after July 8, 2020.

Credit ID N/A If present, indicates that a credit is associated with the product SKU. 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.

When you first load the cost table report, by default, the Credit ID column is not selected to display. To view the Credit ID column in your cost table, select Credit ID in the column display options.

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.

When you first load the cost table report, by default, the Credit name column is not selected to display. To view the Credit name column in your cost table, select Credit name in the column display options.

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 project-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).

When you first load the cost table report, by default, the Cost in micros column is not selected to display. To view the Cost in micros column in your cost table, select Cost in micros in the column display options.

List cost N/A

The List cost column is available for Cloud Billing accounts associated with a negotiated pricing contract, and represents the monthly cost of your usage calculated using list prices. The other cost columns, Unrounded cost and Cost, are calculated using the price that is applicable to your billing account (either list prices or negotiated prices). If your account has negotiated, custom pricing, you can compare List cost amounts to Cost amounts to determine how much you are saving with your negotiated prices.

When you first load the cost table report, by default, the List cost column is not selected to display. To view the List cost column in your cost table, select List cost in the column display options.

Unrounded cost N/A The calculated cost of the usage, in the currency the Cloud Billing account is configured to use, to a precision of up to six decimal places. Unrounded cost is calculated using the SKU prices associated with your Cloud Billing account and can be helpful when analyzing your cost details and understanding the source of any discrepancies due to rounding.

If you're using the CSV version of this report for analysis, we recommend using the Unrounded cost column for your calculations.
Cost Amount The calculated cost of the usage, in the currency the Cloud Billing account is configured to use, rounded to two decimal places. Cost is calculated using the SKU prices associated with your Cloud Billing account and represents the amount charged for usage.

Notes about the cost table report

Matching your invoice

When viewing the report using the default filter settings, the cost table report matches your existing invoice as closely as possible. On the cost table report, the display of credits and usage-based discounts (for example, promotional credits or sustained use discounts) are listed as separate line items. Online Cloud Billing reports and Cloud Billing Export to BigQuery do not break out credits and discounts into separate line items.

The Total amount listed in your invoice is the sum of all Unrounded cost line items, rounded to two decimal places. If you're using the CSV version of this report to reconcile to your invoice total, we recommend doing the following:

How costs are calculated for an invoice month

We use the term invoice month to refer to the time period that an invoice or statement covers.

  • The type of document you receive depends on the type of Cloud Billing account you are viewing.

    • Invoiced (offline) accounts receive invoices.
    • Self-serve (online) accounts receive statements.
  • Sometimes, at the end of a calendar month, there is a slight delay (up to a few days) 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; that is, those late-reported costs will show up on the next month's invoice or statement.

  • The cost table report is meant to match the charges on your invoice or statement. The possible result of late-reported usage is that your cost table report might include costs from more than one calendar month. For example, your October invoice or statement might include costs incurred at the end of September combined with the October costs.

  • To view your usage costs by actual usage date (calendar date or date range), see the online reports or analyze your exported billing data.

  • Invoice-level charges, including taxes, adjustments, and rounding errors, are included in the cost table footer. For guidance on understanding and analyzing any adjustments, see Understand memos and adjustments.

SKU Prices

Invoice usage details do not include a column for the SKU price. If you have negotiated pricing, the Unrounded cost and Cost amounts are calculated using the negotiated prices. The List cost amounts are calculated using the publicly-available list prices. You can compare List cost to Cost to determine how much you are saving with your negotiated prices.

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.

Historical project data

Prior to January 1, 2022:

When viewing reports for invoice months prior to January 2022, historical project metadata is not supported in the cost table report. If you delete a project or move the project to a different Cloud Billing account, the following values are no longer displayed in the cost table for the project: Project Name, Project ID, Billing account ID, and Billing account name. The Project number value is persisted after a project is deleted. If you have enabled the export of Cloud Billing data to BigQuery, you can find your historical project information in your BigQuery tables.

Starting on January 1, 2022:

When viewing reports for an invoice month on or after January 2022, with the addition of project hierarchy data, historical project metadata is supported in the cost table. Starting January 1, 2022, when you delete a project or move a project to a different Cloud Billing account, if that project incurred usage during the time period selected, the following values are listed in the cost table for the project: Billing account name, Billing account ID, Project Name, Project ID, Project number, and Project hierarchy. If you have enabled the export of Cloud Billing data to BigQuery, the cost table's project metadata information should match the historical project information in your BigQuery tables.

Taxes by project and by invoice

Starting from September 1, 2020, your cost details in the cost table show your tax costs for each of your projects, instead of as an invoice-level cost. Invoice-level tax totals continue to be displayed in the footer of the cost table report. You can identify and filter on your tax details using the Cost type column and the SKU description column.

For example, for costs recorded before September 1, 2020, your cost detail data looked similar to the following example, which shows a total tax cost of $10.

Billing account ID Project ID SKU description Cost type Cost
123456-ABCDEF-123456 example-project N1 Predefined Instance Core Usage $60
123456-ABCDEF-123456 test-project N1 Predefined Instance Core Usage $40
123456-ABCDEF-123456 0 State sales tax (10.0%) Tax $10

For costs recorded after September 1, 2020, the $10 tax total is broken out to attribute $6 for example-project, and $4 for test-project:

Billing account ID Project ID SKU description Cost type Cost
123456-ABCDEF-123456 example-project N1 Predefined Instance Core Usage $60
123456-ABCDEF-123456 example-project State sales tax (10.0%) Tax $6
123456-ABCDEF-123456 test-project N1 Predefined Instance Core Usage $40
123456-ABCDEF-123456 test-project State sales tax (10.0%) Tax $4

Viewing project-level taxes in the nested table view

To view your tax costs by project in the nested table view, you must use or configure a Group by option with Project as the first grouping dimension. For example, group by Project -> Service -> SKU.

Viewing project-level taxes in the flat table view

In the flat table view, if you have incurred tax costs, project-level taxes are displayed in rows near the end of the table. Each row with a Tax Cost type represents the total tax costs for a SKU description (specific tax type and percentage), attributed to a project.

About totals in the invoice header and the cost table footer

When your cost table report is configured to view all costs and credits for an invoice month, typically, the total in the invoice header and the cost table footer are the same. Rarely, you might notice the header total does not match the footer total.

Starting with the September 2020 invoice or statement, the cost table report includes header information for the document providing details such as the invoice number, the billing account ID, and the invoice or statement totals.

  • The invoice total amount due or statement total new activity listed in the header is determined based on the timing of when the invoice or statement document was generated. The total in the report header is not affected by any filters you might set in the cost table report.
  • The Total listed in the cost table footer is generated by summing all the Unrounded cost line items in the cost table report, then rounding to two places. If you set filters to refine the costs returned in the cost table, the footer total is calculated on the filtered costs.

In some cases, when viewing an unfiltered report, the two totals might not match. This might occur if your Cloud Billing account is issued more than one invoice or statement in a month, or if a credit or debit memo is issued for your billing account. For example:

  • If you close your Cloud Billing account, you might be issued more than one invoice or statement in the same month to cover the last of the charges incurred by your Cloud Billing account before it was closed. Sometimes there is a slight delay (up to a few days) in usage reporting. The totals mismatch can be due to timing differences between the reporting of usage costs and when the invoice or statement is generated.
  • If you are issued a credit or debit memo, those credits or charges might be applied to your invoice, but not be reflected in the cost line items on the cost table report. For guidance on understanding and analyzing any adjustments, see Understand memos and adjustments.

If you notice the totals in your cost table report's header and footer do not match, and you need help reconciling your invoice or statement, contact Cloud Billing Support for assistance.