Verify accuracy of service provider invoices

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 for a billing period and compare it to invoices.

FOCUS SQL Query

SELECT
  ServiceProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
  ServiceProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency

FOCUS Datasets

Contract Commitment Cost and Usage Invoice Detail Billing Period

FOCUS Columns

Service Provider Name Billing Account ID Billing Account Name Billing Currency Billed Cost Billing Period Start Billing Period End

Previous Update budgets with billed costs Next Verify accuracy of services charges across service providers