Update budgets with billed costs

FOCUS Versions

v1.3 v1.4

Context

Finance manages tracking of budgets and must update long-term budgets with the actual costs billed each month so the budget is not exceeded.

FOCUS SQL Query

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

FOCUS Datasets

Contract Commitment Cost and Usage Billing Period Invoice Detail

FOCUS Columns

Service Provider Name Billing Period Start Billing Period End Billed Cost

Previous Update budgets for each application Next Verify accuracy of service provider invoices