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.

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 new bucket, see Creating a Bucket in the Amazon Simple Storage Service Console User Guide.

You must also 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 will list 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 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 normalized, 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 normalized, 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:

<AWS account number>-aws-billing-csv-yyyy-mm.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. For more information about uploading to Amazon Redshift, see Uploading an AWS Cost and Usage Report to Amazon Redshift.

Note

AWS supports four 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 of 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:

<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:

<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

All reports in a report date range are delivered to the same report-prefix/report-name/yyyymmdd-yyyymmdd folder. Each report is given a unique assemblyId and delivered 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 of 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 are also stored in the date range and assemblyId folders, using the following naming conventions:

<report-prefix>/<report-name>/YYYYMMDD-YYYYMMDD/<report-name>-Manifest.json
<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:

<report-prefix>/<report-name>/YYYYMMDD-YYYYMMDD/<assemblyId>/<report-name>-RedshiftManifest.json
<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 number of usage measurements covered by this line item.

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

How much this line item would have cost for an unconsolidated account.

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 the following:

reservation/AvailabilityZone

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

reservation/ReservationARN

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

Pricing Details

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

pricing/LeaseContractLength

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

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/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.

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 normalized, making the data easier to read and understand than the detailed billing reports.

Detailed billing reports are updated multiple times a day, and are stored in Amazon S3 as CSV files using the following naming convention:

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

123456789012 = account ID

yyyy = year

mm = month

The current month's reports are overwritten throughout the billing period until final reports are generated at the end of the billing period. Then, new files are created for the next billing period. The reports for the previous months remain in the designated 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 utilized 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 QuickSight, select Redshift Manifest or QuickSight Manifest. If you select a manifest, your report is stored with .gz compression.

  7. Choose Next.

  8. 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.

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

  10. For Compression, choose how you want the report to be compressed.

  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 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: