How do I migrate from a detailed billing report to the AWS Cost and Usage report?

Issue

I want to use the AWS Cost and Usage report to help me understand my billing. How do I migrate from a detailed billing report to the AWS Cost and Usage report?

Resolution

The AWS Cost and Usage Report contains much of the same data that detailed billing reports do. And the AWS Cost and Usage Report includes additional data about Reserved Instances on your account.

Note: If you haven't used billing reports before, activate them on your account.

You might need to update your accounting or management software to account for changes in naming conventions between the two reports:

Field name in the Detailed Billing Report Field name in the Cost and Usage Report
InvoiceId bill/InvoiceId
PayerAccountId
 bill/PayerAccountId
LinkedAccountId
 lineItem/UsageAccountId
ProductName
 product/ProductName
SubscriptionId
 reservation/reservationARN
UsageType
 lineItem/UsageType
Operation
 lineItem/Operation
AvailabilityZone
 lineItem/AvailabilityZone
ReservedInstance
 pricing/PurchaseOption
ItemDescription
 lineItem/LineItemDescription
UsageStartDate
 lineItem/UsageStartDate
UsageEndDate
 lineItem/UsageEndDate
UsageQuantity
 lineItem/UsageAmount
BlendedRate
 lineItem/BlendedRate
BlendedCost
 lineItem/BlendedCost
UnBlendedRate
 lineItem/UnblendedRate
UnBlendedCost
 lineItem/UnblendedCost
ResourceId
 lineItem/ResourceId

Note: The detailed billing report fields RecordType, RecordId, RateId, and PricingPlanId are not available in the AWS Cost and Usage Report.

The following additional fields are available in the AWS Cost and Usage Report:

  • lineItem/LineItemType
  • lineItem/NormalizationFactor
  • lineItem/NormalizedUsageAmount
  • pricing/LeaseContractLength
  • pricing/OfferingClass
  • pricing/PurchaseOption
  • pricing/publicOnDemandCost
  • pricing/publicOnDemandRate
  • pricing/unit
  • reservation/AvailabilityZone
  • reservation/NormalizedUnitsPerReservation
  • reservation/NumberOfReservations
  • reservation/ReservationARN
  • reservation/TotalReservedNormalizedUnits
  • reservation/TotalReservedUnits
  • reservation/UnitsPerReservation

Consider Uploading an AWS Cost and Usage Report to Amazon Redshift to help manage your Cost and Usage Report.

Getting Started

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2017-06-27

Updated: 2019-01-14