gcp-spend

Report actual GCP spend from BigQuery Cloud Billing export.

Updated Aug 23, 2026

Search Tags:#gcp #billing #cloud cost #bigquery #credits #invoice #spend

Ready to run

npx skills add https://github.com/neon-law-foundation/navigator --skill gcp-spend

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: gcp-spend
Source: https://github.com/neon-law-foundation/navigator/tree/main/.claude/skills/gcp-spend
Command: npx skills add https://github.com/neon-law-foundation/navigator --skill gcp-spend

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It turns the BigQuery Cloud Billing export into accurate GCP spend reporting so you can see what was actually charged instead of relying on estimates or rate-card approximations.

Core Features & Use Cases

Daily net spend reporting: Calculates gross cost, applied credits, and invoice-aligned net cost for a requested time window.
Service and SKU breakdowns: Summarizes spend by service or SKU to help identify which products are driving cost.
Billing-export driven accuracy: Uses the exported billing table and includes credits so the result matches invoiced spend, with a clear note that the newest day is partial due to export lag.

Quick Start

Use the gcp-spend skill to report actual GCP spend for the requested date range, including gross cost, credits, and net cost.

Frequently Asked Questions about gcp-spend

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I report actual GCP spend from BigQuery billing export instead of estimates?▼

To report actual GCP spend, query the BigQuery Cloud Billing export to sum gross cost and credits, producing invoice-aligned net cost results. This method matches invoiced spend precisely by using the exported billing table rather than relying on rate-card approximations.

Can I break down GCP cloud cost by service or SKU for a specific date range?▼

Yes, GCP spend can be broken down by service or SKU. The Skill summarizes the BigQuery billing export data for any requested date range, helping identify which specific products or services are driving costs within current or historical billing windows.

What GCP billing data do I need to analyze net invoice spend accurately?▼

Analyzing net invoice spend requires the BigQuery Cloud Billing export table. The Skill discovers the billing project from .env and the specific table via bq ls, then sums both costs and applied credits to ensure the reported net spend matches invoiced charges.

Why does my daily GCP spend report show the current day as partial?▼

The current day is flagged as partial in GCP spend reports due to export lag. Because the BigQuery Cloud Billing export data updates on a delay, the most recent day's cost and credit data is incomplete and will not reflect the final invoiced amount.

How do I get started querying GCP billing data for cost analysis?▼

Getting started requires setting the GCP project in a .env file and locating the billing table using bq ls. Once the billing table is discovered, the Skill can calculate gross cost, applied credits, and net spend for daily or arbitrary date ranges.

Does this approach to GCP cost analysis include applied credits?▼

Yes, this approach to GCP cost analysis includes applied credits. By summing both gross cost and credits from the BigQuery Cloud Billing export, it produces an invoice-aligned net cost that reflects actual charges rather than just gross usage estimates.