This work is licensed under CC BY 4.0 - Read how use or adaptation requires attribution

Compare billed cost per subaccount to budget

Asset Library / FinOps Use Cases / Compare billed cost per subaccount to budget

Context

Product wants to confirm charges are in line with expectations (budgets) for a business which has all its cost within a single subaccount. The ChargePeriod is used for filtering to capture items that apply to the period only (excludes adjustments from previous periods that were applied in the current BillingPeriod).

FOCUS Columns

FOCUS SQL Query

SELECT
  ProviderName,
  SubAccountId,
  SubAccountName,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE ChargeCategory = 'Usage'
  AND ChargePeriodStart >= ? and ChargePeriodEnd <= ?
  AND ProviderName = ?  
  AND SubAccountId = ?  
GROUP BY
  ProviderName,
  SubAccountId,
  SubAccountName
Related KPIs
Percentage Variance of Budgeted vs. Actual CSP Cloud Spend

Measure the variance or difference between estimated or budgeted costs for using public cloud services & the actual costs incurred.

CSP Cloud Budget Burn Rate

The rate at which an organization is consuming or spending its allocated budget for cloud services from a CSP.

Related Personas
Product
Related Capabilities
Budgeting