NEW
FinOps for AI Training Now Available

Allocate multi-currency charges per application

Asset Library / FinOps Use Cases / Allocate multi-currency charges per application

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 Columns

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
Related KPIs
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 CSP Cloud Costs that are Tagging Policy Compliant

This KPI measures amount of compliance for cloud cost tagging, and requires an established organizational tagging policy.

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.

Related Personas
Finance