Docs navigation

On this page

Verify Accuracy of Provider Invoices

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

FOCUS Versions

v1.0 v1.1 v1.2

Context

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

FOCUS SQL Query

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

FOCUS Datasets

Cost and Usage Invoice Detail Contract Commitment Billing Period

FOCUS Columns

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

FinOps Practitioner

Frequency of Data Updates Time (hours/days) between updates of cost data, e.g. the time since the last ETL run or sharing of data. ETL Processing Time This measures the cycle time taken to complete the ETL (Extract, Transform, Load) processes. Cost Visibility Delay Time (hours/days) between the cost occurring and the cost being ingested, normalized, and displayed to stakeholders.

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