Update budgets with billed costs

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

Personas: Finance
Capabilities: Budgeting
KPIs: CSP Cloud Budget Burn Rate, Percentage Variance of Budgeted vs. Actual CSP Cloud Spend, Percentage Variance of Budgeted vs. Forecasted CSP Cloud Spend

Update budgets with billed costs

Runs on sample

Source: FOCUS 1.0 sample
Result rows: 3
Status: Runs on sample
Execution: PrecomputedRead-only
Result snapshot (UTC): 2026-10-11

Summarizes actual billed costs by provider and billing period for updating budgets. Defaults select March 2026 billing periods; the strict end filter uses April 2 to include periods ending April 1, and the sample's populated billing currencies are USD.

Billed costs by billing period

Query results
Provider name	Billing period start	Billing period end	Total billed cost
AWS	2026-03-01	2026-04-01	$833.61
Microsoft	2026-03-01	2026-04-01	$567.21
Oracle	2026-03-01	2026-04-01	$23.53

3 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_period_start as billing_period_start,
  billing_period_end as billing_period_end,
  sum(billed_cost) as total_billed_cost
from focus.cost_and_usage
where billing_period_start >= $1::timestamptz
  and billing_period_end < $2::timestamptz
group by provider_name, billing_period_start, billing_period_end
order by billing_period_start asc, provider_name asc, billing_period_end asc
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end

Original FOCUS SQL

SELECT
  ProviderName,
  BillingPeriodStart,
  BillingPeriodEnd,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
  ProviderName,
  BillingPeriodStart,
  BillingPeriodEnd

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗