Cost management with billing reports in GCP - Commands & Configuration

Introduction

Keeping track of your cloud spending helps avoid surprises in bills. Billing reports show how much you use and pay for cloud services, helping you manage costs better.

When you want to see how much each project or service costs in your cloud account

When you need to find which team or department is using the most cloud resources

When you want to set budgets and alerts to avoid overspending

When you want to export billing data for detailed analysis or reporting

When you want to understand trends in your cloud spending over time

Config File - billing_export_config.yaml

billing_export_config.yaml

billingExport:
  datasetId: billing_data
  projectId: my-gcp-project
  tableId: gcp_billing_export
  exportInterval: DAILY
  filter:
    projects:
      - my-gcp-project
    services:
      - Compute Engine
      - Cloud Storage

This YAML file configures billing export settings.

• datasetId: The BigQuery dataset where billing data will be stored.
• projectId: Your Google Cloud project ID.
• tableId: The table name inside the dataset for billing data.
• exportInterval: How often data is exported, here daily.
• filter: Limits export to specific projects and services to reduce data volume.

Commands

This command sets up daily export of billing data to a BigQuery dataset and table for analysis.

Terminal

gcloud beta billing export create --dataset=billing_data --project=my-gcp-project --table=gcp_billing_export --interval=DAILY

Expected Output

Billing export created successfully.

Dataset: billing_data

Table: gcp_billing_export

Export interval: DAILY

→

--dataset - Specifies the BigQuery dataset to store billing data

→

--project - Specifies the Google Cloud project ID

→

--interval - Sets how often billing data is exported

This command queries the last 30 days of billing data to find the top 5 most expensive services.

Terminal

bq query --use_legacy_sql=false 'SELECT service.description, SUM(cost) as total_cost FROM `my-gcp-project.billing_data.gcp_billing_export` WHERE usage_start_time >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 30 DAY) GROUP BY service.description ORDER BY total_cost DESC LIMIT 5;'

Expected Output

service.description       total_cost

Compute Engine            1234.56

Cloud Storage             789.01

BigQuery                  456.78

Cloud SQL                 234.56

Cloud Functions           123.45

→

--use_legacy_sql=false - Ensures the query uses standard SQL syntax

This command creates a budget alert to notify when spending reaches 50% of $1000 monthly budget.

Terminal

gcloud beta billing budgets create --billing-account=012345-6789AB-CDEF01 --display-name="Monthly Budget" --amount=1000 --threshold-rules=threshold_percent=0.5,spend_basis=CURRENT_SPEND

Expected Output

Created budget [Monthly Budget] with amount $1000 and alert threshold at 50%

→

--billing-account - Specifies the billing account to apply the budget

→

--amount - Sets the budget amount in USD

This command lists all budgets set on the billing account to review alerts and limits.

Terminal

gcloud beta billing budgets list --billing-account=012345-6789AB-CDEF01

Expected Output

NAME           AMOUNT  THRESHOLDS

Monthly Budget  1000    50%

→

--billing-account - Specifies the billing account to list budgets for

Key Concept

If you remember nothing else from this pattern, remember: exporting billing data to BigQuery lets you analyze and control your cloud costs easily.

Common Mistakes

Not enabling billing export before running queries

Without export enabled, billing data won't be available in BigQuery, so queries return no data.

Always set up billing export first using gcloud billing export commands.

Using legacy SQL syntax in BigQuery queries

Legacy SQL syntax is outdated and may cause errors or unexpected results.

Use --use_legacy_sql=false flag to run standard SQL queries.

Setting budget alerts without specifying the correct billing account

Budgets won't apply if the billing account ID is wrong or missing.

Verify billing account ID with gcloud billing accounts list before creating budgets.

Summary

Use gcloud commands to enable daily billing export to BigQuery for cost tracking.

Query billing data in BigQuery to find expensive services and usage patterns.

Create budgets with alerts to monitor and control cloud spending.

Practice

1. What is the main purpose of billing reports in Google Cloud Platform?

easy

A. To monitor network traffic between services

B. To deploy new cloud resources automatically

C. To manage user permissions and roles

D. To track and understand cloud costs over time

Solution

1. Step 1: Understand billing reports function

   Billing reports show how much you spend on cloud resources over time.

2. Step 2: Identify the correct purpose

   Tracking and understanding costs helps manage budgets effectively.

3. Final Answer:

   To track and understand cloud costs over time -> Option D

4. Quick Check:

   Billing reports = track costs [OK]

Hint: Billing reports show cost details, not deployments or permissions [OK]

Common Mistakes:

• Confusing billing reports with deployment tools
• Thinking billing reports manage user roles
• Assuming billing reports monitor network traffic

2. Which gcloud command lists billing accounts available to your user?

easy

A. gcloud iam roles describe

B. gcloud billing accounts list

C. gcloud projects create

D. gcloud compute instances list

Solution

1. Step 1: Identify command for billing accounts

   The command to list billing accounts is 'gcloud billing accounts list'.

2. Step 2: Eliminate unrelated commands

   Other commands manage compute, projects, or IAM roles, not billing accounts.

3. Final Answer:

   gcloud billing accounts list -> Option B

4. Quick Check:

   List billing accounts = gcloud billing accounts list [OK]

Hint: Billing commands start with 'gcloud billing' [OK]

Common Mistakes:

• Using compute or IAM commands to list billing accounts
• Confusing project creation with billing listing
• Typing incorrect command syntax

3. Given this snippet of a billing report summary:

Project: my-project
Cost: $120.50
Month: April

What does this report tell you?

medium

A. The project budget is $120.50 for April

B. The project has $120.50 remaining in April

C. The project spent $120.50 in April

D. The project was created in April

Solution

1. Step 1: Read the billing report details

   The report shows cost as $120.50 for the project in April.

2. Step 2: Understand cost vs budget

   Cost means money spent, not budget or remaining funds.

3. Final Answer:

   The project spent $120.50 in April -> Option C

4. Quick Check:

   Cost = money spent [OK]

Hint: Cost means money spent, not budget or leftover [OK]

Common Mistakes:

• Confusing cost with budget or remaining funds
• Assuming project creation date from cost report
• Misreading the month field

4. You tried to generate a billing report but got an error: Permission denied. What is the most likely cause?

medium

A. You do not have Billing Account Viewer role on the billing account

B. The billing account is closed

C. The project does not exist

D. The billing report feature is disabled by default

Solution

1. Step 1: Analyze the error message

   "Permission denied" means lack of access rights.

2. Step 2: Identify required role for billing reports

   Billing Account Viewer role is needed to view billing reports.

3. Final Answer:

   You do not have Billing Account Viewer role on the billing account -> Option A

4. Quick Check:

   Permission denied = missing Billing Account Viewer role [OK]

Hint: Permission errors usually mean missing roles [OK]

Common Mistakes:

• Assuming billing account closure causes permission errors
• Thinking project existence affects billing report access
• Believing billing reports are disabled by default

5. You want to reduce your monthly cloud costs. Which billing report action helps you find the biggest cost sources?

hard

A. Filter the report by service to see which services cost the most

B. Delete all projects with costs over $100

C. Disable billing reports to save money

D. Increase your budget limit in the billing account

Solution

1. Step 1: Understand how to identify cost sources

   Filtering billing reports by service shows which services use most money.

2. Step 2: Evaluate other options

   Deleting projects blindly or disabling reports won't help find cost sources; increasing budget doesn't reduce costs.

3. Final Answer:

   Filter the report by service to see which services cost the most -> Option A

4. Quick Check:

   Filter by service = find big costs [OK]

Hint: Filter reports by service to spot big costs fast [OK]

Common Mistakes:

• Deleting projects without analysis
• Disabling reports thinking it saves money
• Confusing budget limits with cost reduction