Analyze Credit Memos | FOCUS Explorer

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

Totals credit charges (negative billed cost) per provider and invoice so their effect on net spend can be analysed. v1.0 has no InvoiceId, so credits are grouped at the invoice grain instead: invoice issuer, billing account and billing period. In this sample all 282 credit rows are AWS Open Source promotional credits on one March 2026 invoice.

Column adaptations (1)

Credits by invoice issuer

Query results
Provider name	Invoice issuer name	Billing account id	Billing period start	Credit line count	Total billed cost
AWS	Amazon Web Services, Inc.	1234567890123	2026-03-01	282	-$1,196.45

1 row. Scroll inside the table to see more.

Default parameters use the precomputed result, generated as the read-only focus_reader role.

Inspect Postgres SQL and original FOCUS SQL

Postgres SQL, as run

select provider_name as provider_name,
       invoice_issuer_name as invoice_issuer_name,
       billing_account_id as billing_account_id,
       billing_period_start as billing_period_start,
       count(*) as credit_line_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
  and charge_category = 'Credit'
group by provider_name, invoice_issuer_name, billing_account_id, billing_period_start
order by total_billed_cost asc nulls last, provider_name, invoice_issuer_name
limit 500

Parameters: $1 = period_start, $2 = period_end

Original FOCUS SQL

SELECT 
    ProviderName,
    InvoiceId,
    SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargePeriodStart >= ? and ChargePeriodEnd  < ?
AND ChargeCategory = 'Credit'
GROUP BY
    ProviderName,
    InvoiceId

Provider name

Invoice issuer name

Billing account id

Billing period start

Credit line count

Total billed cost

AWS

Amazon Web Services, Inc.

1234567890123

2026-03-01

282

-$1,196.45

select provider_name as provider_name, invoice_issuer_name as invoice_issuer_name, billing_account_id as billing_account_id, billing_period_start as billing_period_start, count(*) as credit_line_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 and charge_category = 'Credit' group by provider_name, invoice_issuer_name, billing_account_id, billing_period_start order by total_billed_cost asc nulls last, provider_name, invoice_issuer_name limit 500

SELECT ProviderName, InvoiceId, SUM(BilledCost) AS TotalBilledCost FROM focus_data_table WHERE ChargePeriodStart >= ? and ChargePeriodEnd < ? AND ChargeCategory = 'Credit' GROUP BY ProviderName, InvoiceId