Display Amazon billing data

This section describes how to configure Amazon billing data for resellers. For standard accounts see Display Amazon billing data for standard accounts.

To configure Abiquo properties for AWS billing

1. By default, the platform will retrieve billing data for the last two months. To change this value, on the Abiquo Server, edit the abiquo.properties file and add the following property with the number of months to retrieve:

   abiquo.enterprise.property.billing.monthoffset=2

2. By default, the platform will process all items in the CSV file, so the partner discount (SppDiscount) value can be visible on customer dashboards. To discard items from the CSV file, on the Remote Services server, edit the abiquo.properties file and add the following property with any items to discard. 

   abiquo.ec2billing.lineItemType.ignore=SppDiscount

To configure AWS to supply billing data, do the following steps.

1. Create an S3 bucket, for example, "costandusagebillingreport"

   1. Within the bucket, create a folder where AWS will store your reports. Give it the name of your report, for example "costandusagebillingreport"

   2. Note the billing bucket name, for example, "costandusagebillingreport"

2. Create a new user, such as "programmaticbilling" to create the reports
   1. Assign the AmazonS3ReadOnlyAccess policy

   2. Activate the IAM user's access to billing information. See https://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/control-access-billing.html

3. Optionally configure legacy billing reports

   1. Go to Billing → Billing preferences

   2. Open the Detailed Billing Reports [Legacy] section

   3. Select the option to Turn on the legacy Detailed Billing Reports feature to receive ongoing reports of your AWS charges

   4. Click Configure and enter your S3 bucket details

   5. Select all of the available reports including
      1. Monthly report
      2. Detailed billing report
      3. Cost allocation report
      4. Detailed billing report with resources and tags

   6. Click Save preferences

4. Configure Cost & Usage Reports

   1. Go to Cost & Usage Reports

   2. Enter the Report  name, which you will need to enter in Abiquo later, then click Next

   3. Click Configure and select the S3 bucket. Click Next, then select  I have confirmed that this policy is correct.
   4. By default, Amazon will put the reports in a folder with the name format "/report-name/date-range/". Note this as the value for the report prefix in Abiquo. Click Next
   5. Review your configuration and check that the following parameters are set: 
      1. bucket name
      2. path (folder/subfolder)
      3. time detail: Hourly
      4. GZIP or ZIP format
5. The AWS account with credentials to use in Abiquo should have the permissions in the AWS permissions table below.

To configure billing dashboards in Abiquo for resellers, do these steps.

1. The Abiquo users should have the privileges to Display hybrid dashboard tab, View bills, and optionally to Display VM cost view widget (hybrid tab)
2. In Abiquo, edit the reseller enterprise and create the enterprise properties in the AWS enterprise properties for resellers table below
3. In Abiquo, edit the enterprises of the customers of the reseller and create the enterprise property (amazon_price_factor) in the AWS enterprise properties for customers of resellers table.
   You can also set the default value of this property in the reseller.

AWS permissions table

AWS enterprise properties for resellers table

Property	Description	Previous name	Migration for v5.2.0
amazon_bucket	Name of the S3 bucket where Amazon stores billing data. Change value for v5.2.0. This was previously reseller ID in the yaml configuration file.	billing_bucket	Enter the new value
amazon_bucket_region	Code for the AWS region where the bucket configured is located (for example us-east-1).		-
amazon_report_name	amazon_bucket/amazon_bucket_prefix/amazon_report_name/file.csv	report_name
amazon_bucket_prefix	amazon_bucket/ amazon_bucket_prefix /amazon_report_name/file.csv	report_prefix
amazon_billing_compress_format	Compression format of the billing report file: ZIP or GZIP		-
amazon_price_factor	Default provider markup for customer enterprises with no value		-
amazon_mpa	Set to "dedicated" or "no" to use blended costs. If not present or "shared", use unblended costs		-
amazon_discount	Discount you have agreed on with Amazon. Typical values are 0.03, 0.02 or similar.		-

_

AWS enterprise properties for customers of resellers table

Property	Description	Previous name	Migration for v5.2.0
amazon_price_factor	Markup or discount applied by the partner to their customer. The default value is 1.		-