Configuring Cost and Usage Reports using Billing Conductor pro forma billing data
You can create pro forma Amazon Cost and Usage Reports (Amazon CUR) for each billing group that you create in Billing Conductor. The pro forma Amazon CUR has the same file format, granularity, and columns as the standard Amazon CUR. Pro forma contains the most comprehensive set of cost and usage data available for a given period of time. For more information about Billing Conductor, see the Billing Conductor User Guide.
Topics
Understanding the differences between Billing Conductor Amazon CUR and standard Amazon CUR
There are a few differences between the standard Cost and Usage Reports and pro forma Amazon CUR created using the Billing Conductor configuration.
The standard Amazon CUR computes the cost and usage for each account in your consolidated billing family. A pro forma Amazon CUR per billing group only includes the accounts in the billing group at the time of computation.
The standard Amazon CUR populates the invoice column once and invoice is generated by Amazon. A pro forma Amazon CUR doesn't populate the invoice column. Currently, no invoice is generated, or issued by Amazon based on pro forma billing data.
Create pro forma Cost and Usage Reports for a billing group
Use the following steps to generate a pro forma Amazon CUR for a billing group.
To create pro forma Cost and Usage Reports for a billing group
Sign in to the Billing and Cost Management console at https://console.amazonaws.cn/billing/home#/
On the navigation pane, choose Cost & Usage Reports
On the top right of the Report table, choose Settings.
Turn on the Pro forma data view.
Choose Enable.
Choose Create report.
For Report name, enter a name for your report.
For Data view, choose pro forma.
Choose a billing group.
For Additional report details, choose Include resource IDs to include the IDs of each individual resources in the report.
For Data refresh settings, choose if you want Cost and Usage Reports to refresh if Amazon applies refunds, credits, or support fees to your account after finalizing your bill. When a report refreshes, a new report is uploaded to Amazon S3.
Choose Next.
For S3 bucket, choose Configure.
In the Configure S3 Bucket dialog box, do one of the following:
Choose an existing bucket from the drop down list and choose Next.
Enter a bucket name and the Amazon Region where you want to create a new bucket and choose Next.
Review the bucket policy, select I have confirmed that this policy is correct, and choose Save.
-
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 7, and the date range for the report in the following format:
/report-name/date-range/ -
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.
-
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.
Overwriting reports can save on Amazon S3 storage costs. Delivering new report versions can improve auditability of billing data over time.
-
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 format
Amazon Redshift or Amazon QuickSight: .gz compression
-
Choose Next.
-
After you have reviewed the settings for your report, choose Review and Complete.