FOCUSExplorer
Use cases
Read-only sample

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

Analyze credit memos

Locate provider-issued credit memos in billing data and analyze how each one reduces net spend.

← Unit Economics
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, Procurement
Capabilities
Invoicing & Chargeback, Planning & Estimating, Reporting & Analytics, Unit Economics

Analyze Credit Memos

Adapted to v1.0
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)
  • InvoiceId → invoice_issuer_name, billing_account_id, billing_period_start: A provider issues one invoice per billing account and billing period; this identifies the invoice but not individual credit-memo documents.

Credits by invoice issuer

Query results
Provider nameInvoice issuer nameBilling account idBilling period startCredit line countTotal billed cost
AWSAmazon Web Services, Inc.12345678901232026-03-01282-$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

Columns used

Column names from the source use case.

  • Provider Name
  • Invoice ID
  • Billed Cost
  • Charge Period Start
  • Charge Period End
  • Charge Category
Read the source on focus.finops.org ↗