FOCUS 1.0 with AWS columns (preview) compliance gaps - AWS Data Exports

FOCUS 1.0 with AWS columns (preview) compliance gaps

Preview note:

FOCUS 1.0 with AWS columns is in preview and can make mistakes. Please verify your cost data with AWS Cost and Usage Reports (CUR) or CUR 2.0.

The following table provides all of the compliance gaps that might exist in an export of the FOCUS 1.0 with AWS columns (preview) table. A particular compliance gap will not apply to your export if you're not receiving cost and usage data for the related scenario. For example, if your export doesn't have any line items that are corrections of a previous bill, then the compliance gap for ChargeClass column will not apply.

At this time, you will need to identify whether or not each individual compliance gap is relevant for your cost and usage analysis.

Compliance gap type Affected column FOCUS 1.0 requirement Compliance gap description
Missing data ChargeClass ChargeClass is a required column to indicate whether a particular line item is a correction for a past billing period. No line items will be identifiable as corrections in this column at this time.
ContractedUnitPrice ContractedUnitPrice must not be null for Usage and Purchase ChargeCategory line items that are not corrections. ContractedUnitPrice might be null for certain product offerings.
InvoiceIssuerName InvoiceIssuerName must not be null. InvoiceIssuerName might be null for certain charges.
ListUnitPrice ListUnitPrice must not be null for Usage and Purchase ChargeCategory line items that are not corrections. ListUnitPrice might be null for certain product offerings.
PricingUnit PricingUnit must not be null for Usage and Purchase ChargeCategory line items that are not corrections. PricingUnit might be null for certain product offerings.
ProviderName ProviderName must not be null. ProviderName might be null for certain charges.
ResourceName ResourceName is a required column for displaying a name that a user assigned to a given resource. This column will only have EC2 Instance and EBS volume resource names assigned by customers. No other resource names will appear in this column. Any resource names that are assigned as tags will appear in the tags column.
SkuPriceId SkuPriceId must not be null for Usage and Purchase ChargeCategory line items that are not corrections. SkuPriceId might be null for certain line items when it should not be.
SkuId SkuId must not be null for Usage and Purchase ChargeCategory line items that are not corrections. SkuId might be null for certain product offerings.
Incorrect data BilledCost The sum of BilledCost must match the invoice. There may be situations when the sum of BilledCost might not match the invoice.

BilledCost

EffectiveCost

BilledCost and EffectiveCost are columns that require discounts to be included in their values for easy validation of discounts.

For customers not on discount automation, these columns will not contain the correct costs for usage line items.

However, the discounts will appear as separate line items, so the summed total of costs will still be accurate.

ConsumedQuantity ConsumedQuantity is a required column for showing the amount of usage you actually used.

ConsumedQuantity will contain the amount of usage you were charged for. This means that ConsumedQuantity could be incorrect in situations where a minimum charge quantity applied for a particular service.

For example, there is a 10MB minimum for an Athena query and a 10 minute minimum Glue crawler run. For these services, ConsumedQuantity will show the value that includes the minimum charged quantity.

ContractedCost ContractedCost must equal ContractedUnitPrice x PricingQuantity for charges that are not corrections. ContractedCost might not be consistent with ListUnitPrice and PricingQuantity for certain charges, such as credits.
ContractedCost ContractedCost must reflect any agreed pricing with a provider. For any Usage line items covered by Savings Plans or Reserved Instances, ContractedCost will be equal to ListCost even if discounts apply.
ContractedUnitPrice ContractedUnitPrice must reflect any agreed pricing with a provider. For any Usage line items covered by Savings Plans or Reserved Instances, ContractedUnitPrice will be equal to ListUnitPrice even if discounts apply.
ListCost ListCost must equal ListUnitPrice x PricingQuantity for charges that are not corrections. ListCost might not be consistent with ListUnitPrice and PricingQuantity for certain charges, such as credits.
PricingCategory PricingCategory must be "Dynamic" for all Spot charges. PricingCategory might be incorrect for certain EC2 Spot line items.
ListCost ListCost must equal BilledCost for ChargeCategory of Credit. ListCost might not equal BilledCost for ChargeCategory of Credit.
Tags

Tags is a required column for displaying tags applicable to a given line item.

This column requires that a provider (i) adds a prefix to the keys of provider-created tags only, and (ii) does not modify tag names.

There are two gaps:

(i) User-created tag keys will have a prefix to indicate that it is a user-created tag.

(ii) Provider and user tag key names are normalized to have no capitalization, no spaces, and no special characters other than "_". When normalization causes tag key conflicts, only one tag value is kept.