Verify accuracy of services charges across service providers

FOCUS Versions

v1.3 v1.4

Context

In order to verify that the charges found in the FOCUS dataset match those of the service providers’ invoices a FinOps Practitioner can aggregate cost data from service providers per service for a billing period and compare it to individual service charges found inside invoices.

FOCUS SQL Query

SELECT
  ServiceProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency,
  ServiceName,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
  ServiceProviderName,
  BillingAccountName,
  BillingAccountId,
  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 Billed Cost Billing Period Start Billing Period End

Previous Verify accuracy of service provider invoices Next Verify discount accuracy for a previously invoiced billing period (corrections excluded)