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.

Precomputed result

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