FOCUSExplorer
Use cases
Read-only sample

FOCUS 1.0 billing data. Reference snapshots are dated on each page.

Understand the billing account or sub account entity

List all billing and sub-accounts with charges in the period, showing provider, account ID, name, and type. This list allows practitioners to map entity hierarchies and allocate costs.

← Invoicing & Chargeback
Source
FOCUS MCP snapshot
FOCUS editions
v1.2
Queries
1
Mode
Read-only
Library snapshot (UTC)
2026-10-08

This query uses the ProviderName column. ProviderName is deprecated in v1.3 and will be removed in v1.4.

Personas
Finance, FinOps Practitioner, Leadership
Capabilities
Invoicing & Chargeback, Planning & Estimating, Reporting & Analytics, Allocation

Understand the Billing Account or Sub Account Entity

Adapted to v1.0
Source
FOCUS 1.0 sample
Result rows
4
Status
Adapted to v1.0
Execution
PrecomputedRead-only
Result snapshot (UTC)
2026-10-11

Lists the billing accounts with charges in the window, with how many sub accounts each contains and their billed cost, to map the account hierarchy. BillingAccountType (v1.2) does not exist in v1.0 and is omitted; Oracle and Google Cloud billing accounts have no name in the sample.

Column adaptations (1)
  • BillingAccountType → (omitted): No v1.0 column describes the billing account type; sub_account_count and total_billed_cost were added to give the listing a measure.

Sub accounts per billing account

Query results
Provider nameBilling account idBilling account nameSub account countTotal billed cost
AWS1234567890123SunBird86$833.61
Microsoft/providers/Microsoft.Billing/billingAccounts/8611537SunBird11$567.21
Oracle20209880–4$26.08
Google Cloud00DD8H-A57456-A2H965–1$0.02

4 rows. Scroll inside the table to see more.

Precomputed result

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select provider_name as provider_name,
       billing_account_id as billing_account_id,
       billing_account_name as billing_account_name,
       count(distinct sub_account_id) as sub_account_count,
       sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where charge_period_start >= $1::timestamptz
  and charge_period_end < $2::timestamptz
group by provider_name, billing_account_id, billing_account_name
order by sub_account_count desc, provider_name, billing_account_id
limit 500

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

SELECT DISTINCT
    ProviderName,
    BillingAccountID,
    BillingAccountName,
    BillingAccountType
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?

Columns used

Column names from the source use case.

  • Provider Name
  • Billing Account ID
  • Billing Account Name
  • Billing Account Type
  • Charge Period Start
  • Charge Period End
Read the source on focus.finops.org ↗