Configuring Cost and Usage Reports per billing group - AWS Billing Conductor

Configuring Cost and Usage Reports per billing group

You can create pro forma AWS Cost and Usage Reports (AWS CUR) for each billing group that you create. The pro forma AWS CUR has the same file format, granularity, and columns as the standard AWS CUR, and contains the most comprehensive set of cost and usage data available for a given period of time.

You can publish your pro forma AWS CUR to an Amazon Simple Storage Service (Amazon S3) bucket that you own.

AWS updates the report in your bucket once a day in comma-separated values (CSV) or Apache Parquet format. You can view the reports using spreadsheet software such as Microsoft Excel and Apache OpenOffice Calc. You can also access them from an application using the Amazon S3 or Amazon Athena APIs. For more information about the standard AWS CUR, see the AWS Cost and Usage Reports User Guide.

Use the following steps to generate a pro forma AWS CUR for a billing group.

To create pro forma Cost and Usage Reports for a billing group

  1. Open the AWS Billing console at https://console.aws.amazon.com/billing/.

  2. On the navigation pane, choose Cost & Usage Reports.

  3. In the top right of the report table, choose Settings.

  4. Enable the Pro forma data view.

  5. Choose Enable.

  6. Choose Create report.

  7. For Report name, enter a name for your report.

  8. For Data view, choose pro forma.

  9. For Billing group, choose a billing group.

  10. For Additional report details, select Include resource IDs to include the IDs of each individual resource in the report.

  11. For Data refresh settings, select whether you want the AWS Cost and Usage Reports to refresh with any new changes to your cost and usage data after finalizing your bill. When a report refreshes, a new report is uploaded to Amazon S3.

    Note

    Billing group Cost and Usage Reports don't include credits, tax, or support charges.

  12. Choose Next.

  13. For S3 bucket, choose Configure.

  14. In the Configure S3 Bucket dialog box, do one of the following:

    • Choose an existing bucket from the dropdown list, and then choose Next.

    • Enter a bucket name and the AWS Region where you want to create a new bucket, and choose Next.

  15. Select I have confirmed that this policy is correct, and choose Save.

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

    This step is optional for Amazon Redshift or Amazon QuickSight, but required for Amazon Athena.

    If you don't specify a prefix, the default prefix is the name that you specified for the report in step 4 and the date range for the report, in the following format:

    /report-name/date-range/

  17. For Time granularity, choose one of the following:

    • Hourly if you want the line items in the report to be aggregated by the hour.

    • Daily if you want the line items in the report to be aggregated by the day.

  18. For Report versioning, choose whether you want each version of the report to overwrite the previous version of the report or to be delivered in addition to the previous versions.

  19. For Enable report data integration for, choose whether you want to upload your Cost and Usage Reports to Amazon Athena, Amazon Redshift, or Amazon QuickSight. The report is compressed in the following formats:

    • Athena: parquet compression

    • Amazon Redshift or Amazon QuickSight: .gz compression

  20. Choose Next.

  21. After reviewing the settings for your report, choose Review and Complete.