Docs navigation

On this page

Allocate multi-currency charges per application

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

FOCUS Versions

v1.0 v1.1 v1.2

Context

Finance needs to allocate costs and perform chargeback for charges for all applications that come from different geographic locations and are in different currencies.

FOCUS SQL Query

SELECT 
  Tags["ApplicationId"],
  ProviderName,
  BillingAccountId,
  BillingAccountName,
  BillingCurrency,
  SUM(BilledCost) AS TotalBilledCost
FROM focus_data_table
WHERE
  BillingPeriodStart >= ? AND BillingPeriodEnd < ?
GROUP BY
  Tags["ApplicationId"],
  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 Tags Billing Period Start Billing Period End

Allocation Invoicing & Chargeback

Finance

Usage or Spend Apportionment Validation Method of apportioning shared costs based on usage or spend proportional amount. Percentage of Unallocated Shared CSP Cloud Cost Measure expenses that cannot be directly attributed to a specific project, team, or department within an organization. Percentage of Costs Associated with Untagged CSP Cloud Resources Calculate percentage of untagged cloud resources using an established organizational tagging policy. Percentage of Costs Associated with Unallocated CSP Cloud Resources Track expenses incurred for resources or services that are not directly attributed to specific projects, departments, or applications. General Ledger Recharge Rate Measure total cloud spend in the cloud management tool vs. amount charged in General Ledger (Finance application). General Ledger Recharge Rate per Cost Center See cloud spend in the cloud management tool per Cost Center vs. amount charged in General Ledger. Fixed Percentage Apportionment Validation Method of apportioning shared costs based on Fixed Percentage.

Next Analyze effective cost by pricing currency