Verify Accuracy of Service Provider Invoices v1.3

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

Aggregates billed cost by service provider, billing account, and currency for comparison with external invoices. ServiceProviderName uses provider_name for direct cloud services and publisher_name for marketplace sellers where the publisher differs from the invoice issuer; the defaults include March 2026 because the source uses a strict BillingPeriodEnd upper bound.

Column adaptations (1)

Billed cost by service provider

Query results
Service provider name	Billing account id	Billing account name	Billing currency	Total billed cost
AWS	1234567890123	SunBird	USD	$789.21
Microsoft	/providers/Microsoft.Billing/billingAccounts/8611537	SunBird	USD	$567.21
Datadog Inc.	1234567890123	SunBird	USD	$40.98
Oracle	20209880	–	USD	$23.53
Red Hat Inc.	1234567890123	SunBird	USD	$3.42
Oracle	20209880	–	–	$0.00

6 rows. Scroll inside the table to see more.

Precomputed result

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select case when publisher_name is not null and publisher_name is distinct from invoice_issuer_name then publisher_name else provider_name end as service_provider_name,
       billing_account_id as billing_account_id,
       billing_account_name as billing_account_name,
       billing_currency as billing_currency,
       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 service_provider_name, billing_account_id, billing_account_name, billing_currency
order by total_billed_cost desc nulls last, service_provider_name, billing_account_id, billing_account_name nulls last, billing_currency nulls last
limit 500

Parameters: $1 = billing_period_start, $2 = billing_period_end_before

Original FOCUS SQL

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