Report corrections for a previously invoiced billing period

FOCUS Versions

v1.3 v1.4

Context

When service providers issue corrections that adjust historical invoices, practitioners must reconcile those adjustments against prior records.

FOCUS SQL Query

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

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail Billing Period

FOCUS Columns

Service Provider Name Billing Account ID Service Category Billed Cost Billing Period Start Billing Period End Charge Class Charge Category Service Name

Previous Report application cost month over month Next Report costs by service category