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

Cost and Usage Reports contain much of the same data that detailed billing reports do, and they also include additional data about Reserved Instances on your account. If you've been using a detailed billing report, you've already activated billing reports on your account. If you haven't used billing reports before, activate them on your account.

If you're already ingesting the detailed billing report into the accounting or management software that your organization prefers, you might need to update your ingestion process 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 Cost and Usage Report.

The following additional fields are available in the 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

You might also consider using an Amazon Redshift data warehouse to manage your Cost and Usage Report.


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