Detailed Billing Reports - Amazon Cost and Usage Reports
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China.

Detailed Billing Reports

Important

The Detailed Billing Report feature is unavailable for new customers as of 07/08/2019.

Detailed Billing Reports (DBR) contain similar information as Amazon CUR regarding your charges, but calculates the individual line items differently. If you've signed up for both the DBR and Amazon CUR, the line items will not match. However, when the reports are finalized at the end of the month, the total cost will align.

Amazon stores the DBR in Amazon S3 as csv files, using the following naming convention:

Amazon account number-aws-billing-detailed-line-items-yyyy-mm.csv.zip

Amazon recreates the DBR multiple times a day, overwriting the report. When Amazon overwrites a report, the line items might be in a different order than they were in the previous report. A final report is created at the end of the month. For the following month, Amazon creates a new report file instead of overwriting the final report from the previous month. Reports for previous months remain in your S3 bucket until you delete them.

For information on how to migrate your DBR to Amazon CUR, see Migrating from Detailed Billing Reports to Cost and Usage Reports.

Understanding unused reservation costs

Amazon Cost and Usage Reports (Amazon CUR) can be leveraged to better understand unused RI costs. Here’s four scenarios showing how.

Note

In the following tables, the columns and rows from Amazon CUR and DBR/DBR-RT are transposed for clarity. The values in the first column represent the headers of a report.

Scenario 1: RI usage is 100%

RI Fee line item has $0 unused cost and 0 usage hours.

Using the DBR/DBR-RT, you can understand your unused RI usage and costs by referring to the fields UsageQuantity and UnblendedCosts for RI Fee line items. RI Fee line items can be identified by the existence of ‘purchased hours’ information in the ItemDescription field. Table 1 illustrates the columns and information used to manage unused RI costs in the DBR and DBR-RT report.

Table 1 – Unused RI costs for a 100% RI usage in DBR and DBR-RT prior to June 17, 2019

ProductName

Amazon Elastic Compute Cloud

Amazon Elastic Compute Cloud

UsageType HeavyUsage:c3.8xlarge HeavyUsage:c3.8xlarge
Operation RunInstances RunInstances
Availability Zone us-east-1a us-east-1a
Reserved Instance Y Y
ItemDescription USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge (744 hours purchased, 744 hours used) USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge
Usage Quantity 0 744
Unblended Rate 0.1 0.1
Unblended Cost 0 74.4

Using Amazon CUR, you can understand your unused RI usage and costs by referring to the fields ‘reservation/ UnusedQuantity’ and ‘reservation/ UnusedRecurringFee’ for RI Fee line items. Table 4 below illustrates the current columns and information utilized to manage unused RI costs in Amazon CUR.

Table 2 – Unused RI costs for a 100% RI usage in Amazon CUR

lineitem/Productcode

Amazon EC2

Amazon EC2

UsageType HeavyUsage:c3.8xlarge USW2-BoxUsage:c3.8xlarge
lineitem/LineItemType RI Fee DiscountedUsage
lineitem/LineItemDescription USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge USD 0.00 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge
lineitem/UsageAmount 744 744
lineitem/NormalizedUsageAmount 47,616 47,616
lineitem/UnblendedRate 0.1 0
lineitem/UnblendedCost 74.4 0
reservation/UnusedQuantity 0
reservation/UnusedRecurringFee 0
reservation/UnusedAmortizedUpfrontFeeForBillingPeriod 0
reservation/RecurringFeeForUsage 74.4
reservation/AmortizedUpfrontCostForUsage 5
reservation/EffectiveCost 79.4

In addition to matching the current functionality supported by DBR/DBR-RT, Amazon CUR has the following advantages:

  • Using Amazon CUR, you are able to access information regarding the EffectiveCost for the DiscountedUsage line item, which includes both the recurring and upfront fees. The DBR only accounts for recurring fees.

  • In Amazon CUR, the UsageType field is not transformed for the DiscountedUsage line items whereas DBR replaces the information with RI Fee line item information. This is because the user can group line items in Amazon CUR by ReservationARN in order to understand what usage was discounted by which RI.

  • In Amazon CUR, the LineItemDescription field is not transformed for the RI Fee line item. DBR appends the hours purchased and hours used.

Scenario 2: Partial RI usage

RI Fee line item has unused cost and usage.

Using the DBR/DBR-RT, you can understand your unused RI usage and costs by referring to fields UsageQuantity and UnblendedCosts for RI Fee line items. Table 3 illustrates the columns and information used to manage unused RI costs in the DBR and DBR-RT report.

Table 3 – Unused RI costs for a partial RI usage in DBR and DBR-RT prior to June 17, 2019

ProductName

Amazon Elastic Compute Cloud

Amazon Elastic Compute Cloud

UsageType HeavyUsage:c3.8xlarge HeavyUsage:c3.8xlarge
Operation RunInstances RunInstances
Availability Zone us-east-1a us-east-1a
Reserved Instance Y Y
ItemDescription USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge (744 hours purchased, 644 hours used) USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge
Usage Quantity 100 644
Unblended Rate 0.1 0.1
Unblended Cost 10 64.4

Using Amazon CUR, you can understand your unused RI usage and costs by referring to fields ‘reservation/ UnusedQuantity’ and ‘reservation/ UnusedRecurringFee’ for RI Fee line items. Table 4 illustrates the current columns and information utilized to manage unused RI costs in Amazon CUR.

Table 4 – Unused RI costs for a partial RI usage in Amazon CUR

lineitem/Productcode

Amazon EC2

Amazon EC2

UsageType HeavyUsage:c3.8xlarge USW2-BoxUsage:c3.8xlarge
lineitem/LineItemType RI Fee DiscountedUsage
lineitem/LineItemDescription USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge USD 0.00 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge
lineitem/UsageAmount 744 644
lineitem/NormalizedUsageAmount 47,616 47,216
lineitem/UnblendedRate 0.1 0
lineitem/UnblendedCost 74.4 0
reservation/UnusedQuantity 100
reservation/UnusedRecurringFee 0
reservation/UnusedAmortizedUpfrontFeeForBillingPeriod 10
reservation/RecurringFeeForUsage 64.4
reservation/AmortizedUpfrontCostForUsage 5
reservation/EffectiveCost 69.4

In addition to matching the current functionality supported by DBR/DBR-RT, Amazon CUR has the following advantages:

  • Amazon CUR has a separate column representing UnusedQuantity for the RI Fee line item vs. DBR / DBR-RT which overloads the UsageQuantity column with the unused hours

Scenario 3: Capacity reservation

DBR/DBR-RT filters out Capacity Reservations related UnusedBox and UnusedDed usage type line items when covered by an RI because the RI Fee line item already covers the unused amount in the UsageQuantity and UnblendedCost fields. Table 5 illustrates the columns and information utilized to manage unused RI costs in the DBR and DBR-RT report.

Table 5 – Unused RI costs for Capacity Reservation scenario in DBR and DBR-RT prior to June 17 2019

ProductName

Amazon Elastic Compute Cloud

Amazon Elastic Compute Cloud

UsageType HeavyUsage:c3.8xlarge HeavyUsage:c3.8xlarge
Operation RunInstances RunInstances
Availability Zone us-east-1a us-east-1a
Reserved Instance Y Y
ItemDescription USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge (744 hours purchased, 734 hours used) USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge
Usage Quantity 10 734
Unblended Rate 0.1 0.1
Unblended Cost 1 73.4

Amazon CUR shows these line items as DiscountedUsage. Table 6 illustrates the current columns and information utilized to manage unused RI costs in Amazon CUR.

Table 6 – Unused RI costs for the Capacity Reservation scenario in Amazon CUR

lineitem/Productcode

Amazon EC2

Amazon EC2

Amazon EC2
UsageType HeavyUsage: c3.8xlarge USW2-Reservation: c3.8xlarge USW2-BoxUsage: c3.8xlarge
lineitem/LineItemType RI Fee Usage DiscountedUsage
lineitem/LineItemDescription USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge USD 0.00 per Reservation Linux/UNIX (Amazon VPC), c3:8xlarge Instance Hour USD 0.00 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge
lineitem/UsageAmount 744 744 744
lineitem/NormalizedUsageAmount 47,616 47,216
lineitem/UnblendedRate 0.1 0 0
lineitem/UnblendedCost 74.4 0 0
reservation/RecurringFeeForUsage 64.4
reservation/AmortizedUpfrontCostForUsage 5
reservation/EffectiveCost 69.4

Scenario 4: Size flexible reservations

Utilizing the DBR/DBR-RT, you can understand your unused RI usage and costs by referring to fields UsageQuantity and UnblendedCosts for RI Fee line items. RI Fee line items can be identified by the existence of ‘purchased hours’ information in the ItemDescription field. Table 9 illustrates the columns and information utilized to manage unused RI costs in the DBR and DBR-RT report.

Table 7 – Unused RI costs for a size flex RI scenario in DBR and DBR-RT prior to June 17, 2019

ProductName

Amazon Elastic Compute Cloud

Amazon Elastic Compute Cloud

UsageType HeavyUsage:c3.8xlarge HeavyUsage:c3.8xlarge
Operation RunInstances RunInstances
Availability Zone us-east-1a us-east-1a
Reserved Instance Y Y
ItemDescription USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge (744 hours purchased, 644 hours used) USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge; UsageType: BoxUsage:c3.large
Usage Quantity 100 644
Unblended Rate 0.1 0.1
Unblended Cost 10 64.4

Using Amazon CUR, you can understand your unused RI usage and costs by referring to fields ‘reservation/ UnusedQuantity’ and ‘reservation/ UnusedRecurringFee’ for RI Fee line items. Table 8 illustrates the current columns and information utilized to manage unused RI costs in the Amazon CUR.

Table 8 – Unused RI costs for a size flex RI scenario in Amazon CUR

lineitem/Productcode

Amazon EC2

Amazon EC2

UsageType HeavyUsage:c3.8xlarge USW2-BoxUsage:c3.8xlarge
lineitem/LineItemType RI Fee DiscountedUsage
lineitem/LineItemDescription USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge USD 0.00 hourly fee per Linux/UNIX (Amazon VPC), c3:8large
lineitem/UsageAmount 744 644
lineitem/NormalizedUsageAmount 47,616 2,576
lineitem/UnblendedRate 0.1 0
lineitem/UnblendedCost 74.4 0
reservation/UnusedQuantity 100
reservation/UnusedRecurringFee 70.37
reservation/UnusedAmortizedUpfrontFeeForBillingPeriod 5.5
reservation/RecurringFeeForUsage 4.03
reservation/AmortizedUpfrontCostForUsage 0.5
reservation/EffectiveCost 4.53

In addition to matching the current functionality supported by DBR/DBR-RT, Amazon CUR has the following advantages:

  • Amazon CUR has the NormalizedUsageAmount and quantity. The DBR / DBR-RT do not have columns representing this.

  • Amazon CUR UsageType and Operation are not transformed for the DiscountedUsage lineitem. The DBR / DBR-RT replaces these values with the RI Fee line item.

  • Amazon CUR LineItemDescription is not transformed for the DiscountedUsage line item. In DBR / DBR-RT, which replaces with the RI Fee line item description and appends the DiscountedUsage line item Usage Type to the end of the string i.e. “USD 0.10 hourly fee per Linux/UNIX (Amazon VPC), c3:8xlarge; UsageType: BoxUsage:c3.large”