Verify discount accuracy for a previously invoiced billing period (corrections excluded)

FOCUS Versions

v1.3 v1.4

Context

FinOps Practitioners need to confirm that negotiated, live, and commitment-based discounts were correctly applied to charges in a closed billing period.

FOCUS SQL Query

SELECT
  ServiceProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency,
  ServiceName,
  SUM(EffectiveCost) AS TotalEffectiveCost,
  SUM(ListCost) AS TotalListCost,
  SUM(BilledCost) AS TotalBilledCost,
  ((SUM(ListCost) - SUM(EffectiveCost)) / NULLIF(SUM(ListCost), 0)) * 100 AS EffectiveDiscount
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
  AND ChargeClass != 'Correction'
GROUP BY
  ServiceProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency,
  ServiceName

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail Billing Period

FOCUS Columns

Service Provider Name Billing Account ID Billing Account Name Billing Currency Service Name Effective Cost List Cost Billed Cost Billing Period Start Billing Period End Charge Class

Previous Verify accuracy of services charges across service providers Next Calculate average rate of a component resource