Report corrections for a previously invoiced billing period

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

Capabilities: Reporting & Analytics

Report corrections for a previously invoiced billing period

Not in v1.0 sample

Source: FOCUS use-case SQL
Status: Not in v1.0 sample
Results: Not run
Mode: Read-only
Library snapshot (UTC): 2026-10-08

The sample contains no ChargeClass = 'Correction' records, so corrections to previously invoiced billing periods cannot be reported.

Review the original SQL below and the required columns before using a newer FOCUS dataset.

Original FOCUS SQL

SELECT
  ProviderName,
  BillingAccountId,
  ChargeCategory,
  ServiceCategory,
  ServiceName,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
  AND ChargeClass = 'Correction'
GROUP BY
  ProviderName,
  BillingAccountId,
  ChargeCategory,
  ServiceCategory,
  ServiceName

Columns used

Column names from the source use case.

Read the source on focus.finops.org ↗