Docs
Specification
Adoption
About
Get Involved
Get Certified
Get Started

Implementation Use Cases Column Library Specification Tools & Assets

Docs navigation

Implementation
Implementation
- Get Started
  
  Get Started with FOCUS™ Datasets
- Data Generators
  
  Alibaba Cloud
  
  AWS
  
  Databricks
  
  Google Cloud
  
  Grafana Cloud
  
  Huawei Cloud
  
  Microsoft (Azure)
  
  Nebius
  
  Oracle Cloud Infrastructure
  
  OVHCloud
  
  Redis
  
  Tencent Cloud
  
  Vercel
Use Cases

Use Cases

Allocate multi-currency charges per application Analyze cost by participating entities Analyze effective cost by pricing currency Analyze purchase of virtual currency Analyze tag coverage Analyze total cost by allocated resource Determine target of virtual currency usage Identify resources with shared cost allocation Identify sources of billed cost Report corrections by subaccount for a previously invoiced billing period Track marketplace purchases across providers Verify accuracy of provider invoices aka invoice reconciliation

Analyze costs by service name Analyze service costs by region Compare resource usage month over month Identify anomalous daily spending by subaccount Identify anomalous daily spending by subaccount and region Identify anomalous daily spending by subaccount, region, and service Identify unused capacity reservations

Calculate consumption of virtual currency within a billing period Compare billed cost per subaccount to budget Track contract commitment burn-down over time Update budgets for each application Update budgets with billed costs

Verify accuracy of service provider invoices Verify accuracy of services charges across service providers Verify discount accuracy for a previously invoiced billing period (corrections excluded)

Calculate average rate of a component resource Forecast amortized costs month over month based on historical trends Forecast cashflow month over month based on historical trends by service Get historical usage and rates to enable cost forecasting

Report subaccounts by region

Reconcile Cost and Usage to Invoice Detail by Invoice ID Reconcile Multi-Currency Settlement using Lineage IDs Understand the billing account or sub account entity Validate Tax Variance

Determine contracted savings by virtual currency Join contract commitment details with usage charges Quantify usage of a component resource Report effective cost of compute

Calculate Commitment Discount Coverage Rate with Eligibility-Adjusted Denominator Commitment Discount Effective Cost Breakdown Compare Commitment Opportunities Across Providers (Cross-Provider with SaaS) Discount Effectiveness by Service Identify Eligible Capacity Reservation Spend Identify Eligible Uncovered Spend by Program Type Identify unused commitments Report commitment discount purchases

Analyze capacity reservations on compute costs Analyze marketplace vendors costs Analyze resource costs by SKU Analyze service costs by subaccount Analyze service costs month over month Analyze the different metered costs for a particular SKU Calculate unit economics Cash vs. Accrual Comparison by Billing Period Determine Effective Savings Rate Determine Effective Savings Rate by Service Effective Cost by Service and Region Report application cost month over month Report corrections for a previously invoiced billing period Report costs by service category Report costs by service category and subcategory Report on initial contract commitments Report service costs by providers subaccount Report spending across billing periods for a service provider by service category

Analyze credit memos

Analyze cost per compute service for a subaccount Analyze costs by availability zone for a subaccount Analyze costs of components of a resource
Column Library
Specification

Specification

1 Introduction

2 Supported Features

2.1 Account Structures 2.2 Billed Cost and Invoice Alignment 2.3 Charge Categorization 2.4 Commit Usage and Under Usage 2.5 Commitment Program Eligibility Details 2.6 Contract Commitments 2.7 Cost and Usage Attribution 2.8 Cost Comparison 2.9 Custom Columns 2.10 Data Generator-Calculated Split Cost Allocation 2.11 Data Granularity 2.12 Dataset Instance Metadata 2.13 Effective Cost Analysis 2.14 Invoice Reconciliation 2.15 Location 2.16 Marketplace Purchases 2.17 Participating Entity Identification 2.18 Recency Metadata 2.19 Resource Usage 2.20 Schema Metadata 2.21 Service Categorization 2.22 Service Provider Services 2.23 Verification, Comparison, and Fluctuation Tracking of Unit Prices

3 Datasets

3.1 Cost and Usage

3.1.1 Allocated Method ID 3.1.2 Allocated Method Details 3.1.3 Allocated Resource ID 3.1.4 Allocated Resource Name 3.1.5 Allocated Tags 3.1.6 Availability Zone 3.1.7 Billed Cost 3.1.8 Billing Account ID 3.1.9 Billing Account Name 3.1.10 Billing Account Type 3.1.11 Billing Currency 3.1.12 Billing Period End 3.1.13 Billing Period Start 3.1.14 Capacity Reservation ID 3.1.15 Capacity Reservation Status 3.1.16 Charge Category 3.1.17 Charge Class 3.1.18 Charge Description 3.1.19 Charge Frequency 3.1.20 Charge Period End 3.1.21 Charge Period Start 3.1.22 Commitment Discount Category 3.1.23 Commitment Discount ID 3.1.24 Commitment Discount Name 3.1.25 Commitment Discount Quantity 3.1.26 Commitment Discount Status 3.1.27 Commitment Discount Type 3.1.28 Commitment Discount Unit 3.1.29 Commitment Program Eligibility Details 3.1.30 Consumed Quantity 3.1.31 Consumed Unit 3.1.32 Contract Applied 3.1.33 Contracted Cost 3.1.34 Contracted Unit Price 3.1.35 Effective Cost 3.1.36 Host Provider Name 3.1.37 Invoice Detail ID 3.1.38 Invoice ID 3.1.39 Invoice Issuer Name 3.1.40 List Cost 3.1.41 List Unit Price 3.1.42 Pricing Category 3.1.43 Pricing Currency 3.1.44 Pricing Currency Contracted Unit Price 3.1.45 Pricing Currency Effective Cost 3.1.46 Pricing Currency List Unit Price 3.1.47 Pricing Quantity 3.1.48 Pricing Unit 3.1.49 Region ID 3.1.50 Region Name 3.1.51 Resource ID 3.1.52 Resource Name 3.1.53 Resource Type 3.1.54 Service Provider Name 3.1.55 Service Category 3.1.56 Service Name 3.1.57 Service Subcategory 3.1.58 SKU ID 3.1.59 SKU Meter 3.1.60 SKU Price Details 3.1.61 SKU Price ID 3.1.62 Sub Account ID 3.1.63 Sub Account Name 3.1.64 Sub Account Type 3.1.65 Tags

3.2 Billing Period

3.2.1 Billing Period Created 3.2.2 Billing Period End 3.2.3 Billing Period Last Updated 3.2.4 Billing Period Start 3.2.5 Billing Period Status 3.2.6 Invoice Issuer Name

3.3 Contract Commitment

3.3.1 Billing Currency 3.3.2 Contract Commitment Applicability 3.3.3 Contract Commitment Benefit Category 3.3.4 Contract Commitment Category 3.3.5 Contract Commitment Cost 3.3.6 Contract Commitment Created 3.3.7 Contract Commitment Description 3.3.8 Contract Commitment Discount Percentage 3.3.9 Contract Commitment Duration Type 3.3.10 Contract Commitment Fulfillment Interval 3.3.11 Contract Commitment ID 3.3.12 Contract Commitment Last Updated 3.3.13 Contract Commitment Lifecycle Status 3.3.14 Contract Commitment Model 3.3.15 Contract Commitment Offer Category 3.3.16 Contract Commitment Payment Interval 3.3.17 Contract Commitment Payment Model 3.3.18 Contract Commitment Payment Upfront Percentage 3.3.19 Contract Commitment Period End 3.3.20 Contract Commitment Period Start 3.3.21 Contract Commitment Quantity 3.3.22 Contract Commitment Type 3.3.23 Contract Commitment Unit 3.3.24 Contract ID 3.3.25 Contract Period End 3.3.26 Contract Period Start 3.3.27 Invoice Issuer Name 3.3.28 Pricing Currency 3.3.29 Pricing Currency Contract Commitment Cost 3.3.30 Service Provider Name

3.4 Invoice Detail

3.4.1 Billed Cost 3.4.2 Billing Account ID 3.4.3 Billing Currency 3.4.4 Billing Period End 3.4.5 Billing Period Start 3.4.6 Charge Category 3.4.7 Invoice Detail Created 3.4.8 Invoice Detail Description 3.4.9 Invoice Detail Grain 3.4.10 Invoice Detail ID 3.4.11 Invoice Detail Last Updated 3.4.12 Invoice ID 3.4.13 Invoice Issue Date 3.4.14 Invoice Issuer Name 3.4.15 Invoice Issue Status 3.4.16 Payment Currency 3.4.17 Payment Currency Billed Cost 3.4.18 Payment Currency Invoice Detail ID 3.4.19 Payment Due Date 3.4.20 Payment Terms 3.4.21 Purchase Order Number 3.4.22 Reference Invoice ID

4 Attributes

4.1 Correction Handling 4.2 Currency Format 4.3 Custom Column Handling 4.4 Data Generator-Calculated Split Cost Allocation Handling 4.5 Dataset Completeness 4.6 Dataset Configuration 4.7 Date/Time Format 4.8 Delivery Handling 4.9 FOCUS Column Handling 4.10 JSON Object Format 4.11 Key-Value Format 4.12 Null Handling 4.13 Numeric Format 4.14 String Handling 4.15 Unit Format

5 Metadata

5.1 Data Generator 5.2 Dataset Instance 5.3 Recency 5.4 Schema

6 Schemas

7 Glossary

8 Appendix

8.1 Discount Handling 8.2 Examples: Commitment Discounts 8.3 Examples: Commitment Discount Flexibility 8.4 Examples: Commitment Program Eligibility Details 8.5 Examples: Contract Commitments 8.6 Examples: Correction Handling 8.7 Examples: Invoice Detail 8.8 Examples: JSON Object 8.9 Examples: Metadata 8.10 Examples: Participating Entity Identification 8.11 Examples: SaaS 8.12 Grouping Constructs for Resources or Services 8.13 Invoice and Billing Period Handling 8.14 Rounding Variance Tolerance

9 Credits

Changelog
Tools & Assets
Tools & Assets
- Tools
  
  MCP Server
  
  FOCUS Validator
  
  Query Sandbox
- Assets
  
  Supporting assets

On this page

Why Standardize Technology Billing Data?

ON THIS PAGE

Proudly supported by

Learn

What is FOCUS?
Intro to FOCUS Course
Certified FOCUS Analyst Course
FAQs

Use FOCUS Datasets

Get Started with Datasets
Column Library

Contribute

Become a Member
GitHub Repo
Support & Feedback

This work is licensed under Attribution 4.0 International

For web site terms of use, trademark policy and other project policies please see https://lfprojects.org.

The FOCUS specification is based on https://jointdevelopment.org