Column dictionary

BilledCost

New in 1.4

Billed Cost · Invoice Detail dataset

Feature level
Mandatory
Data type
Decimal
Allows nulls
No
Column type
Metric

What it is

Billed Cost represents the cost of a charge as invoiced by the invoice issuer in a given billing period. For all charges, Billed Cost reflects all applicable pricing adjustments (e.g., reduced pricing from negotiated discounts or commitment discounts). For purchase charges, Billed Cost includes any portion invoiced in the given billing period. For usage charges, Billed Cost excludes any portion covered by related purchase charges (e.g., covering charges such as commitments, prepayments, or marketplace purchases), regardless of when those related charges are invoiced. Billed Cost is denominated in the Billing Currency. Billed Cost is commonly used to support FinOps activities, including invoice reconciliation, cash-based forecasting, budgeting, and cost allocation.

Requirements (14)

Verbatim from the specification. These are the statements the validator checks against.

  • BilledCost MUST be of type Decimal.
  • BilledCost MUST conform to NumericFormat requirements.
  • BilledCost MUST NOT be null.
  • BilledCost MUST be denominated in the BillingCurrency.
  • BilledCost MUST reflect all applicable pricing adjustments, including but not limited to negotiated discounts, commitment discounts, and other applicable discount programs.
  • BilledCost MUST NOT include any portion of a covered charge that is offset by a covering charge.
  • BilledCost MUST be 0 for charges that are fully covered by one or more covering charges.
  • The sum of BilledCost for a given InvoiceDetailId, InvoiceId, and InvoiceIssuerName MUST be equal to the payable amount provided in the corresponding entries on the issued invoice when InvoiceIssueStatus is "Issued".
  • When comparing BilledCost aggregated by InvoiceId and InvoiceIssuerName with CostAndUsage.BilledCost aggregated by CostAndUsage.InvoiceId and CostAndUsage.InvoiceIssuerName, BilledCost MUST adhere to the following requirements:
  • When ChargeCategory is not "Tax" and InvoiceIssueStatus is not "Open", the sum of BilledCost MUST NOT differ from the sum of CostAndUsage.BilledCost by more than MAX(100 × Subunit, (SQRT(Rows) × 0.5) × Subunit) as defined in Rounding Variance Tolerance.
  • When ChargeCategory is "Tax" or InvoiceIssueStatus is "Open", the sum of BilledCost MAY differ from the sum of CostAndUsage.BilledCost.
  • When comparing BilledCost aggregated by InvoiceDetailId, InvoiceId, and InvoiceIssuerName with CostAndUsage.BilledCost aggregated by CostAndUsage.InvoiceDetailId, CostAndUsage.InvoiceId, and CostAndUsage.InvoiceIssuerName, BilledCost MUST adhere to the following requirements:
  • When InvoiceIssueStatus is not "Open", the sum of BilledCost MUST NOT differ from the sum of CostAndUsage.BilledCost by more than MAX(100 × Subunit, (SQRT(Rows) × 0.5) × Subunit) as defined in Rounding Variance Tolerance.
  • When InvoiceIssueStatus is "Open", the sum of BilledCost MAY differ from the sum of CostAndUsage.BilledCost.

Check your own export

The FOCUS 1.4 validator checks this column and 122 others against your file, in your browser, with no size cap and nothing uploaded.

Other Invoice Detail columns

Definition taken from the FOCUS 1.4 specification. FOCUS is published by the FinOps Foundation under CC BY 4.0.

One column is a definition. A pipeline is a project.

Finitizer ingests FOCUS from every provider you run and reports across all of them.