Menu
AWS Billing and Cost Management
User Guide (Version 2.0)

Understanding Your Usage with Billing Reports

Billing reports provide information about your usage of AWS resources and estimated costs for that usage. You can have AWS generate billing reports that break down your estimated costs in different ways:

  • By the hour, day, or month

  • By each account in your organization

  • By product or product resource

  • By tags that you define yourself

You can create tags for your AWS resources to add your own labels to nearly every line item in your reports. For example, you can use the billing reports to do any of the following:

  • Bring your billing data into an application that can read the data

  • Build an application that uses your billing data

  • Monitor your month-to-date charges

  • Forecast your monthly charges

  • Share your data with a partner

  • Import your billing data into your accounting system

  • Retrieve your bill for multiple accounts

AWS delivers the reports in CSV format to an Amazon S3 bucket that you specify, and updates the reports at least once a day. You can view the reports in applications that can read CSV files, such as Microsoft Excel, or you can write custom applications that import the billing data from the file for analysis. Some files in the reports can grow big enough to exceed the file size limitations of these programs. If an AWS Cost and Usage report exceeds the size limit of these programs, AWS splits the AWS Cost and Usage report into multiple files. If you are the account owner, you can download any of the reports using the Amazon S3 console, or you can retrieve the reports programmatically using the Amazon S3 APIs.

Note

During the current billing period (monthly), AWS generates estimated billing reports. The billing reports are not bills, but estimates of costs and charges for AWS usage. Only the monthly invoice that you receive contains your actual charges. Line items below a penny are rounded up to $0.01. All other charges are rounded to the nearest penny. All reports might include a line item to account for a rounding error of $0.01.

Controlling Access to Your Billing Report Files

Anyone who has permissions to access the specified Amazon S3 bucket can see your billing report files. Make sure that only people who have a business need to see your billing report files have this access. If necessary, you can edit the bucket policy to control access to the contents of the bucket. For more information about editing bucket policies, see Access Control.

Setting Up an S3 Bucket for Your Billing Reports

To receive billing reports, you must have an S3 bucket in your AWS account to store the reports in. You can specify an existing bucket or create a new one. To create a bucket, see Creating a Bucket in the Amazon Simple Storage Service Console User Guide.

You also must apply a resource-based permissions policy to your S3 bucket to allow AWS to write files to the bucket. For an example bucket policy and information about how to apply your policy to a bucket, see Step 2: Turn on AWS Cost and Usage reports.

Note

Storing the billing reports data in your S3 bucket is billed at standard S3 rates.

Types of Billing Reports

You can generate many different types of reports of your usage. For example, you can get AWS Cost and Usage reports, detailed billing reports, Amazon EC2 Usage Reports, and AWS Usage Reports. The AWS Usage Reports are provided for you, but you must set up the other billing reports in order to receive them.

Note

The billing reports are not bills, but estimates of costs and charges for AWS usage. Only the monthly invoice you receive contains your actual charges.

You can obtain the following billing reports for your AWS account usage.

AWS Cost and Usage report

Lists AWS usage for each product category used by an account and its IAM users in hourly or daily line items, as well as any cost allocation tags that you've created. If you choose the option to include individual resource IDs when you first create the report, the report lists the resource IDs for the AWS resources used by your account. The report is stored in an S3 bucket that you specify in your account. Standard AWS storage rates apply. For more information, see AWS Cost and Usage Report.

Format of the report file name:

<report-name>-<file-number>.csv.<zip|gz>

For more information about where to find AWS Cost and Usage reports, see AWS Cost and Usage Report.

Detailed billing report

Lists AWS usage for each product category that is used by an account and its IAM users in hourly line items. The report is stored in an S3 bucket that you specify in your account. Standard AWS storage rates apply. For more information, see Detailed Billing Report.

We strongly recommend that you use AWS Cost and Usage reports instead of the detailed billing reports. The data in the AWS Cost and Usage reports has been standardized, making the reports easier to read and understand than the detailed billing reports.

Format of the report file name:

<AWS account number>-aws-billing-detailed-line-items-yyyy-mm.csv.zip

Detailed billing report with resources and tags

Contains the same data as the detailed billing report, but also includes any cost allocation tags that you've created and resource IDs for the AWS resources used by your account. The report is stored in an S3 bucket that you specify in your account. Standard AWS storage rates apply. For more information, see Detailed Billing Report with Resources and Tags.

We strongly recommend that you use AWS Cost and Usage reports instead of the detailed billing reports. The data in the AWS Cost and Usage reports has been standardized, making the reports easier to read and understand than the detailed billing reports.

Format of the report file name:

<AWS account number>-aws-billing-detailed-line-items-with-resources-and-tags-yyyy-mm.csv.zip

Monthly report

Lists AWS usage for each product category used by an account and its IAM users in monthly line items. You can download the report from the Bills page of the Billing and Cost Management console. For more information, see Monthly Report .

Format of the report file name:

ecvs_mm_yyyy.csv

Monthly cost allocation report

Contains the same data as the monthly report, but also includes any cost allocation tags that you've created. The report is stored in an S3 bucket that you specify in your account. Standard AWS storage rates apply. For more information, see Monthly Cost Allocation Report.

Format of the report file name:

<AWS account number>-aws-cost-allocation-yyyy-mm.csv

EC2 usage reports

Contains the same Amazon EC2 data as the detailed billing report, but also includes lease information and usage analysis for the Amazon EC2 resources that are used by your account.

Format of the report file name:

InstanceUsageReport_yyyy-mm-dd.csv or ReservedInstanceUsageReport_yyyy-mm-dd.csv

AWS usage reports

Lists AWS usage for each service, usage type, operation, and time period, at the chosen report granularity. This report is generated dynamically when you request it.

Format of the report file name:

report.csv

AWS Cost and Usage Report

The AWS Cost and Usage report tracks your AWS usage and provides estimated charges associated with your AWS account. The report contains line items for each unique combination of AWS product, usage type, and operation that your AWS account uses. You can customize the AWS Cost and Usage report to aggregate the information either by the hour or by the day. For Consolidated Billing customers, this report is available only to the payer account and includes activity for all the accounts linked to the payer account. Linked account owners can obtain the report only from the payer account owner.

AWS delivers the report files to an S3 bucket that you specify in your account, and updates the report at least once a day. The report is finalized at the end of each month. Finalized reports have the calculations for your blended and unblended costs, and cover all of your usage for the month. The report is available starting within 24 hours of the date that you created a report on the Reports page of the Billing and Cost Management console. For more information about setting up the report, see Turning On Billing Reports.

From S3, you can either download the report from the Amazon S3 console or upload the report into Amazon Redshift or Amazon QuickSight. For more information about uploading to Amazon Redshift, see Uploading an AWS Cost and Usage Report to Amazon Redshift. For more information about uploading to Amazon QuickSight, see Create a Data Set Using Amazon S3 Files in the Amazon QuickSight User Guide. If you chose to create Amazon Redshift and Amazon QuickSight manifests when you created your report, Billing and Cost Management provides the S3 data and Amazon QuickSight manifests for you.

Note

AWS supports five AWS Cost and Usage reports per account. The reports are free of charge, but standard S3 storage rates apply.

AWS Cost and Usage Report Files

The AWS Cost and Usage report is a CSV file or a collection of CSV files that is stored in an Amazon S3 bucket. During the report period, AWS delivers a new report and a new manifest file each time the report is updated. The new report includes all the information included in the previous report, as well as information new to the current report. AWS builds on previous reports until the end of the billing period. After the end of the billing period, AWS generates a new report with none of the information from the previous report. The size of an individual report can grow to more than a gigabyte, and might exceed the capacity of desktop spreadsheet applications to display every line. If a report is larger than most applications can handle, AWS splits the report into multiple files that are stored in the same folder in the S3 bucket.

The AWS Cost and Usage report uses the following S3 organization and naming conventions:

Copy
<report-prefix>/<report-name>/yyyymmdd-yyyymmdd/<assemblyId>/<report-name>-<file-number>.csv.<zip|gz>
  • report-prefix = The prefix that you assigned to the report when you created the report.

  • report-name = The name that you assigned to the report when you created the report.

  • yyyymmdd-yyyymmdd = The range of dates covered by the report. Reports are finalized at the end of the date range.

  • assemblyId = An ID that AWS creates each time that the report is updated.

  • file-number = If the update includes a large file, AWS might split the file into multiple files. The file-number tracks the different files in an update.

  • csv = The format of the report files.

  • zip or gz = The type of compression applied to the report files.

For example, your report could be delivered as a collection of the following files:

Copy
<example-report-prefix>/<example-report-name>/20160101-20160131/<123456789>/<example-report-name>-<1>.csv.<zip> <example-report-prefix>/<example-report-name>/20160101-20160131/<123456789>/<example-report-name>-<2>.csv.<zip> <example-report-prefix>/<example-report-name>/20160101-20160131/<123456789>/<example-report-name>-<3>.csv.<zip> <example-report-prefix>/<example-report-name>/20160101-20160131/<123456789>/<example-report-name>-Manifest.json

AWS delivers all reports in a report date range to the same report-prefix/report-name/yyyymmdd-yyyymmdd folder. AWS gives each report a unique assemblyId and delivers it to the assemblyId subfolder in the date range folder. If the report is too large for a single file, the report is split into multiple files and delivered to the same assemblyId folder.

When the AWS Cost and Usage report is updated, AWS creates and delivers a manifest file. The manifest file lists all the detail columns that are included in the report to date, a list of report files if the report was split into multiple files, the time period covered by the report, and other information about a specific AWS Cost and Usage report. Manifest files also are stored in the date range and assemblyId folders, using the following naming conventions:

Copy
<report-prefix>/<report-name>/YYYYMMDD-YYYYMMDD/<report-name>-Manifest.json
Copy
<report-prefix>/<report-name>/YYYYMMDD-YYYYMMDD/<assemblyId>/<report-name>-Manifest.json

Each time that AWS creates a new AWS Cost and Usage report for a date range, it overwrites the manifest file stored in the date range folder with an updated manifest file. AWS delivers the same updated manifest file to the assemblyId folder along with the files for that update. Manifest files in the assemblyId folder are not overwritten.

If you chose the option to include an Amazon Redshift manifest in your report when you set up your AWS Cost and Usage report, AWS also creates and delivers an Amazon Redshift manifest file and a file with the SQL commands that you need to upload your report into Amazon Redshift. You can open the SQL file with a regular text editor. The manifest and SQL files use the following naming conventions:

Copy
<report-prefix>/<report-name>/YYYYMMDD-YYYYMMDD/<assemblyId>/<report-name>-RedshiftManifest.json
Copy
<report-prefix>/<report-name>/YYYYMMDD-YYYYMMDD/<assemblyId>/<report-name>-RedshiftCommands.sql

If you use the commands in the RedshiftCommands file, you don't need to open the RedshiftManifest file.

Important

The RedshiftManifest file determines which report files the copy command in the RedshiftCommands file uploads. Deleting or removing the RedshiftManifest file breaks the copy command in the RedshiftCommands file.

AWS Cost and Usage Report Details

The AWS Cost and Usage report contains details about your usage. The following sections describe most of the items and columns in the report.

All time intervals include the start time and exclude the end time. All times are in UTC. For example, an AWS Cost and Usage report with a bill/BillingPeriodStartDate of 2015-11-01T00:00:00Z and a bill/BillingPeriodEndDate of 2015-12-01T00:00:00Z includes the first second of November, but does not include the first second of December.

Identity Details

You can use the identity line items in the AWS Cost and Usage report to find specific line items that have been split across multiple AWS Cost and Usage report files.

identity/LineItemId

The ID associated with this line item. Use this ID to correlate line items that have been split across multiple AWS Cost and Usage report files.

identity/TimeInterval

The time interval that this line item applies to, in UTC.

Billing Details

You can use the billing line items in the AWS Cost and Usage report to find information about the charges covered by the report, such as the charge type and the beginning and end of the billing period.

billing/InvoiceId

The ID associated with this report. Until the report is finalized, the InvoiceId is blank.

billing/BillingEntity

The AWS seller that your account is with, such as AWS or AISPL.

billing/BillType

The type of bill that this report covers.

billing/PayerAccountId

The account ID of the paying account.

billing/BillingPeriodStartDate

The start date of the billing period covered by this report, in UTC.

billing/BillingPeriodEndDate

The end date of the billing period covered by this report, in UTC.

Line Item Details

You can use the line item columns to find information about your charges.

lineItem/UsageAccountId

The ID of the account that this line item applies to.

lineItem/LineItemType

The type of charge covered by this line item.

lineItem/UsageAccountId

The ID of the account that this line item applies to.

lineItem/UsageStartDate

When the usage for this line item started.

lineItem/UsageEndDate

When the usage for this line item ended.

lineItem/ProductCode

The product code of the service that this line item is for.

lineItem/UsageType

The type of usage covered by this line item. If you paid for a Reserved Instance, the report has one line that shows the monthly committed cost, and multiple lines that show a charge of 0.

lineItem/Operation

The AWS operation covered by this line item.

lineItem/AvailabilityZone

The Availability Zone associated with this line item charge.

(Optional) lineItem/ResourceId

If you chose to include individual resources IDs in your report, this column contains the ID of the resource to which this line item applies.

lineItem/UsageAmount

The amount of usage incurred by the customer. For all reserved units, use the reservation/TotalReservedUnits column instead.

lineItem/CurrencyCode

The currency that this line item is given in.

lineItem/UnblendedRate

The rate that this line item would have been charged for an unconsolidated account.

lineItem/UnblendedCost

The cost of this line item after tiered pricing and discounted usage have been processed. For accounts that are part of a consolidated billing account family, this includes the tiered pricing that is available to the aggregated usage of the billing family.

lineItem/BlendedRate

The rate applied to this line item for a consolidated account.

lineItem/BlendedCost

How much this line is charged to a consolidated account.

lineItem/LineItemDescription

A description of the pricing tier covered by this line item.

lineItem/TaxType

The type of tax applied to this line item.

Reservation Details

You can use the reservation columns to find out more about a reserved resource. The columns include but are not limited to the following:

reservation/AvailabilityZone

The Availability Zone of the resource associated with this line item.

reservation/NumberOfReservations

The number of reservations covered by this subscription. For example, one Reserved Instance (RI) subscription may have four associated RI reservations.

reservation/ReservationARN

The ARN of the Reserved Instance that this line item benefitted from.

reservation/TotalReservedUnits

The total number of reserved units in the subscription. In the case of a Reserved Instance (RI), this is the total number of hours across all RIs in this subscription. This is calculated by multiplying the NumberOfReservations by the UnitsPerReservation.

reservation/UnitsPerReservation

The number of usage units reserved by a single reservation in a given subscription, such as how many hours a single EC2 RI has reserved.

Pricing Details

You can use the pricing columns to find information about the prices for a line item. The columns include but are not limited to the following:

pricing/LeaseContractLength

The length of time that your Reserved Instance is reserved for.

pricing/PublicOnDemandCost

The total cost for the lineItem based on public on-demand rates.

pricing/PublicOnDemandRate

The public On-Demand rate in this billing period for the specific line item of usage.

pricing/PurchaseOption

How you chose to pay for this line item. Valid values are All Upfront, Partial Upfront, and No Upfront.

pricing/rateType

The type of rate that applies to this line item, such as Fixed.

pricing/RateUnit

The pricing unit used for calculating your usage cost. For example, the pricing unit for EC2 instance usage is in hours.

pricing/term

Whether your AWS usage is Reserved or On-Demand.

Product Details

You can use the product columns to find information about the service and type of line item. Different services include different product columns in their reports. Examples include the following:

product/SKU

A unique code for a product. Use the SKU code to correlate product details and pricing.

product/InstanceType

If you used Amazon Elastic Compute Cloud (Amazon EC2), the type of Amazon EC2 instance is included in the product/InstanceType column.

product/OperatingSystem

If you used Amazon EC2, the type of operating system of an Amazon EC2 instance is included in the product/OperatingSystem column.

product/Region

If you used Amazon EC2, the Availability Zone of the Amazon EC2 instance is included in the product/Region column.

product/Tenancy

If you used Amazon EC2, the type of tenancy allowed on the Amazon EC2 instance, such as single tenant or multiple tenant, is included in the product/Tenancy column.

Resource Tags

You can use the resource columns to find information about the specific resources covered by a line item. These columns include user-defined cost allocation tags. Examples include the following:

resourceTags/user:Creator

You can use a user:Creator tag to track which user created a resource.

resourceTags/user:Name

You can use a user:Name tag to track which resources are associated with a specific user.

resourceTags/user:Owner

You can use a user:Owner tag to track which user owns a resource.

resourceTags/user:Purpose

You can use a user:Purpose tag to track why a resource was created.

Reserved Instances in the AWS Cost and Usage Report

You can use the AWS Cost and Usage report to track your RI utilization, charges, and allocations.

Reserved Instance Line Items in the AWS Cost and Usage Report

In the AWS Cost and Usage report, three line items are relevant to Reserved Instances (RIs). These three line items show the upfront fee, the recurring monthly cost of an RI, and the RI discount benefits that are assigned to a particular resource.

Fee

The Fee line item is added to your bill when you purchase an All Upfront or Partial Upfront RI. The following screenshot shows how this one-time fee appears in the AWS Cost and Usage report (some columns were omitted for clarity).

RI Fee

The RI Fee line item describes the recurring monthly charges that are associated with Partial Upfront and No Upfront RIs. The RI Fee initially is added to your bill on the day of purchase, and on the first day of each billing period thereafter. If you purchase an All Upfront RI, the RI Fee line item is not added to your bill.

The RI Fee is calculated by multiplying your discounted hourly rate and the number of hours in the month. The following screenshot shows how the recurring monthly charges appear in the report.

Note

Recurring monthly charges are recorded differently for RIs that have an Availability Zone (AZ) or region scope. For RIs that have an AZ scope, the corresponding AZ is shown in the reservation/AvailabilityZone column. For RIs that have a region scope, the reservation/AvailabilityZone column is empty. RIs with a region scope have values for the lineitem/NormalizationFactor and reservation/TotalReservedNormalizedUnits columns that show the instance size.

Discounted Usage

The Discounted Usage line item describes the instance usage that received a matching RI discount benefit, and is added to your bill when you have usage that matches one of your RIs. AWS calculates RI discount benefits based on matching usage, for example, the use of an instance that matches the instance reservation. If you have matching usage, the cost associated with the usage line item is always zero because the charges associated with RIs are already accounted for in the two other line items (the upfront fee and the recurring monthly charges). The following screenshot shows an example of usage that received an RI discount benefit.

Note

EC2 DiscountedUsage line items always show UsageAmount and NormalizedUsageAmount. The value for UsageAmount is the actual number of hours used. The value for NormalizedUsageAmount is the value for UsageAmount multiplied by the value for NormalizationFactor. The value for NormalizationFactor is determined by the instance size. When an RI benefit discount is applied to a matching line item of usage, the ARN value in the reservation/ReservationARN column for the initial upfront fees and recurring monthly charges matches the ARN value in the discounted usage line items.

For more information about mapping instance size to normalization factor, see Modifying the Instance Size of Your Reservations in the Amazon EC2 User Guide for Linux Instances.

For more information about RI purchase options, see Billing Benefits and Payment Options in the Amazon EC2 User Guide for Linux Instances.

EC2 Reserved Instance Size Flexibility

Amazon EC2 Reserved Instances (RIs) that apply to a region provide Availability Zone flexibility and instance size flexibility. RIs that provide Availability Zone flexibility provide a discount on usage in any Availability Zone in the region. RIs that provide instance size flexibility provide a discount on usage, regardless of instance size within that family. To understand how instance size flexibility provided by your RI is applied to your usage, refer to the lineItem/NormalizationFactor and lineItem/NormalizedUsageAmount columns.

Note

Instance size flexibility is supported only by Linux/Unix Reserved Instances with default tenancy that are assigned to a region.

For example, let’s say that you purchase one m4.xlarge RI in a given region. This m4.xlarge RI can be applied automatically to all m4 instance usage in the same region. In the following image, AWS applied the m4.xlarge to two separate m4.large instances.

Note

The two m4.large usage line items have different ResourceIDs, and both received a discount benefit from the single m4.xlarge RI. This is shown by matching the reservationARN value across the usage and recurring monthly charge line items.

The following screenshot shows an account that has subscriptions for two m4.large RIs, with one RI in each subscription. In this example, the account uses a single instance of m4.xlarge for an hour and receives a separate discount benefit from each of the two m4.large RIs.

Note

The single hour of m4.xlarge usage is split into two lines of 0.5 hours (both usage lines still retain the same ResourceID) because different RI subscriptions were applied to each portion of that single hour. The reservationARN for each 0.5 hour matches the corresponding RI subscription.

Detailed Billing Report

Detailed billing reports are similar to AWS Cost and Usage reports. They contain the same information about your charges, but calculate the individual line items differently. If you sign up for both the detailed billing report and the AWS Cost and Usage reports, the line items will not match until the reports are finalized at the end of the month. We strongly recommend that you use AWS Cost and Usage reports instead as the data in the AWS Cost and Usage report has been standardized, making the data easier to read and understand than the detailed billing reports.

AWS stores the detailed billing reports in Amazon S3 as CSV files using the following naming convention:

Copy
123456789012-aws-billing-csv-yyyy-mm.csv

123456789012 = account ID

yyyy = year

mm = month

AWS recreates the detailed billing report multiple times a day, overwriting the report. When AWS overwrites a report, the line items might be in a different order than they were in the previous report. At the end of the month, AWS creates a final report. For the next month, AWS 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.

Detailed Billing Report with Resources and Tags

The detailed billing report with resources and tags adds additional dimensions by which you can view your AWS charges. This report includes resource identifiers for many of the AWS services. Amazon EC2, for example, provides a ResourceID value for each Amazon EC2 instance that is run under your account. You can use this field for viewing your charges for each AWS resource, as well as for data filtering and aggregation.

In addition, any cost allocation tags you have applied to your resources are appended to each line item in the report. You can filter or aggregate on these tags. For more information about creating these tags, see Using Cost Allocation Tags. You are not required to create and use cost allocation tags to get the detailed billing report with resources and tags.

Note

This report contains line items for every hour of operation for every resource and can grow quite large. The report is compressed into a ZIP file, but might exceed the maximum number of rows you can display in a desktop spreadsheet application.

As with the other detailed billing reports, you can sign up for this report on the Preferences page of the Billing and Cost Management console.

Monthly Report

You can download a monthly report of your estimated AWS charges from the Bills page of the Billing and Cost Management console. For Consolidated Billing customers, this report is available only for a payer account and includes activity for all the accounts linked to the payer account. Linked account owners can obtain the monthly report only from the payer account owner.

The report contains line items for each unique combination of AWS product, usage type, and operation that the account uses. The estimated report is updated up to several times per day. You can get monthly reports for previous months by selecting the statement period, starting with the report for the month when you signed up for monthly reports. Reports from before you signed up are not available.

Monthly Cost Allocation Report

You can create custom cost allocation tag sets for your AWS resources that can describe the business dimensions of your AWS usage. These tag sets enable you to organize and track your AWS costs. Many AWS services expose tagging in their feature sets. You create the tags within those services by using the console, API, or the AWS command line interface (CLI). For more information, see Using Cost Allocation Tags.

When you have created these tags, you can then obtain a monthly cost allocation report, which is essentially the monthly report with your cost allocation tag sets included.

The Billing and Cost Management console provides links to two Amazon EC2 reports designed to help you analyze your usage of Amazon EC2 resources and Reserved Instances:

Instance Usage Report

The instance usage report displays data about your Amazon EC2 instances. For more information, see the Instance Usage Reports in the Amazon EC2 User Guide for Linux Instances.

Reserved Instance Utilization Report

The Reserved Instance utilization report displays data about how an account used its Reserved Instances. For more information, see Reserved Instance Utilization Report in the Amazon EC2 User Guide for Linux Instances.

AWS Usage Reports

You can download dynamically generated AWS usage reports. Each report covers a single service, and you can choose which usage type, operation, and time period is included. You can also choose how the data is aggregated. For more information about generating AWS usage reports, see Turning On Billing Reports.

Turning On Billing Reports

Use the Reports page of the Billing and Cost Management console to turn on the AWS Cost and Usage reports and generate EC2 and AWS usage reports. Use the Preferences page to turn on detailed billing reports.

To create an AWS Cost and Usage report

  1. Sign in to the AWS Management Console and open the Billing and Cost Management console at https://console.aws.amazon.com/billing/home#/.

  2. On the navigation pane, choose Reports.

  3. Choose Create report.

  4. For Report name, type a name for your report.

  5. For Time unit, choose Hourly if you want the line items in the report to be aggregated by the hour. Choose Daily if you want the line items in the report to be aggregated by the day.

  6. For Include, to include the IDs of each individual resource in the report, select Resource IDs.

    To include manifests that enable you to upload the report to Amazon Redshift or Amazon QuickSight, select Redshift Manifest or QuickSight Manifest. If you select a manifest, your report is stored with .gz compression.

  7. For Enable support for..., select whether you want to upload your AWS Cost and Usage report to Amazon Redshift or Amazon QuickSight.

  8. Choose Next.

  9. For S3 bucket, type the name of the bucket where you want the reports to be delivered, and choose Verify.

    The bucket must have appropriate permissions to be valid. For more information on adding permissions to the bucket, see Editing Bucket Permissions. For an example policy, choose sample policy.

  10. For Report path prefix, type the prefix that you want prepended to the name of your report.

  11. Choose Next.

  12. Review the settings for the report. After you have reviewed them, choose Review and Complete.

Note

It can take up to 24 hours for AWS to start delivering reports to your S3 bucket. After delivery starts, AWS updates the AWS Cost and Usage report files at least once a day.

In addition to the AWS Cost and Usage reports, AWS Billing and Cost Management provides four different types of detailed billing report, two types of EC2 usage report, and the dynamically generated AWS usage reports.

To turn on detailed billing reports

  1. Sign in to the AWS Management Console and open the Billing and Cost Management console at https://console.aws.amazon.com/billing/home#/.

  2. On the navigation pane, choose Preferences.

  3. Select the Receive Billing Reports check box.

  4. Designate the Amazon S3 bucket where you want AWS to publish your detailed billing reports.

  5. After your S3 bucket has been verified, under Report, select the check boxes for the reports that you want to receive.

  6. Choose Save preferences.

Note

It can take up to 24 hours for AWS to start delivering reports to your S3 bucket. After delivery starts, AWS updates the detailed report files multiple times per day.

To turn on EC2 usage reports

  1. Sign in to the AWS Management Console and open the Billing and Cost Management console at https://console.aws.amazon.com/billing/home#/.

  2. On the navigation pane, choose Preferences.

  3. Select the Receive Billing Reports check box.

  4. Designate the Amazon S3 bucket where you want AWS to publish your detailed billing reports.

  5. After your S3 bucket has been verified, under Report, select the check box for Detailed billing report with resources and tags.

  6. Wait 24 hours or more for report data to be collected.

For information about how to use the EC2 usage reports, see Instance Usage Reports and Reserved Instance Utilization Report in the Amazon EC2 User Guide for Linux Instances.

To generate your AWS usage reports

  1. Sign in to the AWS Management Console and open the Billing and Cost Management console at https://console.aws.amazon.com/billing/home#/.

  2. Choose Reports.

  3. Choose AWS Usage Reports.

    The Usage Reports page opens.

  4. From the Service menu, select a service.

  5. Follow the instructions on the page and make your selections from the Usage Types, Operation, Time Period, and Report Granularity menus.

  6. Choose the appropriate Download report button for the type of report that you want to generate and download.

Viewing Your AWS Cost and Usage reports

You can use the Billing and Cost Management console to see a list of the AWS Cost and Usage reports that AWS is generating for you.

To view your AWS Cost and Usage reports

  1. Sign in to the AWS Management Console and open the Billing and Cost Management console at https://console.aws.amazon.com/billing/home#/.

  2. On the navigation pane, choose Reports. Your AWS Cost and Usage reports are listed on the Reports page.

Uploading an AWS Cost and Usage Report to Amazon Redshift

You can upload AWS Cost and Usage reports to Amazon Redshift, allowing you to analyze your AWS costs and usage.

Important

Amazon Redshift columns are case insensitive and have stricter character limitations than user-defined tags. To prevent conflicts between Amazon Redshift and user-defined tags, AWS replaces your tags with the tags userTag0, userTag1, userTag2, etc. After you create an Amazon Redshift table and upload your report into it, you can create an Amazon Redshift table that maps the AWS-defined tags to your user-defined tags. The tag table allows you to look up your original tags.

For example, if you have the tags OWNER and Owner, Amazon Redshift doesn't allow you to create a table with two columns named "owner". Instead, you create a report table with the columns userTag0 and userTag1 instead of OWNER and Owner, and then create a table with the columns remappedUserTag and userTag. The remappedUserTag column stores the AWS-defined tags userTag0 and userTag1, and the userTag column stores your original tags, OWNER and Owner

AWS provides the commands to create your Amazon Redshift table, upload your report, create your tag table, and insert all of the tag rows into your tag table. The commands are provided to you in the RedshiftCommands.sql file that is stored alongside your manifest file in S3, and in the Redshift file Helper file in the Billing and Cost Management console. AWS also provides a RedshiftManifest file, which controls which report the commands in the RedshiftCommand file uploads. Deleting or removing the RedshiftManifest file breaks the copy command in the RedshiftCommands file.

To find the RedshiftCommands.sql file in the Billing and Cost Management console

  1. Sign in to the AWS Management Console and open the Billing and Cost Management console at https://console.aws.amazon.com/billing/home#/.

  2. In the navigation pane, choose Reports.

  3. Choose the arrow next to the report that you want to upload to Amazon Redshift.

  4. Next to Helper files, choose Redshift file.

  5. Copy the commands from the dialog box and paste them into your SQL client.

The following procedure assumes familiarity with databases and Amazon Redshift.

To upload an AWS Cost and Usage report to Amazon Redshift

  1. Create an Amazon Redshift cluster. For more information, see Creating a Cluster in the Amazon Redshift Cluster Management Guide.

  2. Sign in to the AWS Management Console and open the Amazon S3 console at https://console.aws.amazon.com/s3/.

  3. Navigate to the S3 location where you store your AWS Cost and Usage report.

  4. Open the RedshiftCommands.sql file. The file contains customized commands to create an Amazon Redshift table, upload the AWS Cost and Usage report from S3, and create a tag table that allows user-defined tags to be imported into Amazon Redshift.

  5. In the copy command, replace <AWS_ROLE> with the ARN of an IAM role that has permissions to access the S3 bucket where you store your AWS Cost and Usage reports, and replace <S3_BUCKET_REGION> with the region your S3 bucket is in. For example, us-east-1.

  6. Use a SQL client to connect to the cluster. For more information, see Accessing Amazon Redshift Clusters and Databases in the Amazon Redshift Cluster Management Guide.

  7. Copy the SQL commands from the RedshiftCommands.sql file to your SQL client in the following order:

    • create table - This command creates an Amazon Redshift table with a schema customized to match your report.

    • copy - This command uses the provided IAM role to upload the AWS Cost and Usage report files from S3 to Amazon Redshift.

    • create tag table - This command creates a table that allows you to map AWS-defined tags to your user-defined tags.

    • insert - These commands insert the user-defined tags into the tag table.

  8. After you have copied all of the data from your AWS Cost and Usage reports into Amazon Redshift, you can query the data using SQL. For more information about querying data in Amazon Redshift, see Amazon Redshift SQL in the Amazon Redshift Database Developer Guide.

The number of columns in the AWS Cost and Usage report can change from month to month, such as when a new cost allocation tag is created or a service adds a new product attribute. We recommend that you copy the data from your AWS Cost and Usage report into a new table every month, and then copy the columns that interest you into a separate month-by-month table.

Downloading Billing Reports

You can download your billing report from S3 after AWS delivers it to your S3 bucket.

To download a report from Amazon S3

  1. Sign in to the AWS Management Console and open the Amazon S3 console at https://console.aws.amazon.com/s3/.

  2. Choose the bucket that you specified when you created the report.

  3. Select the report that you want to download.

  4. For Actions, choose Download.

  5. Open the context (right-click) menu for the download link, and choose Save Link As.

  6. Browse to the folder where you want to save the report, and choose Save.

Turning Off Billing Reports

You can turn off delivery of an AWS Cost and Usage report at any time by deleting the report from the Billing and Cost Management console. Deleting a report from the console does not delete reports from the S3 bucket. To delete a report from the S3 bucket, use the S3 console.

It can take up to 24 hours after deleting a report for the report to stop updating.

To delete an AWS Cost and Usage report data report

  1. Sign in to the AWS Management Console and open the Billing and Cost Management console at https://console.aws.amazon.com/billing/home#/.

  2. On the navigation pane, choose Reports.

  3. Select the report that you want to delete, and choose Delete.

  4. In the Delete dialog box, choose Delete.

To delete a report from an S3 bucket

  1. Sign in to the AWS Management Console and open the Amazon S3 console at https://console.aws.amazon.com/s3/.

  2. Choose the bucket that you specified when you created the report.

  3. Select the report that you want to delete.

  4. For Actions, choose Delete.

  5. In the dialog box, choose OK.

To turn off detailed billing reports

  1. Sign in to the AWS Management Console and open the Billing and Cost Management console at https://console.aws.amazon.com/billing/home#/.

  2. On the navigation pane, choose Preferences.

  3. For Receive Billing Reports, clear the check box.

  4. Choose Save preferences.

Note

If you turn off detailed billing reports, you can no longer download the monthly report from the Bills page.

Blended and Unblended Rates in AWS Billing Reports

AWS meters usage in hourly increments; for each product resource in use, a rate is applied for operations performed by usage type in that hour, with each operation comprising a line item. The reports shows both blended and unblended rates for each line item. An unblended rate is the cost per hour for a product, usage type, and the operation performed. A blended rate is an average rate calculated for identical instance usage in an Availability Zone for members of a Consolidated Billing family.

The inclusion of the blended and unblended rates allows you to use reports for the following:

  • Makes both the blended and unblended rates and costs for every hour of usage transparent. Unblended costs correspond to the published rate for a product and operation in a region with no discounts applied for eligible Reserved Instances in the account family. For more information about blended and unblended rates, see Understanding Consolidated Bills

  • Enables you to locate the exact time at which usage switched to lower costs pricing tiers based on volume. Lower rates apply automatically when usage reaches the next tier of volume rates. You can tell when a transition to a lower-priced tier occurs because two line items appear for two partial hours of usage, one each for the higher and lower rate, respectively.

  • Makes visible the way that Reserved Instance discounts are applied first to the linked accounts that purchased a Reserved Instance, and then to other accounts in the family running the same products in the same Availability Zone.

For more information about Consolidated Billing and the potential savings that apply when you purchase Reserved Instances, see the following topics: