Display Amazon billing data

Changes to AWS billing

Configure properties

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

    

Configure AWS

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.

AWS permissions table

Configure resellers in Abiquo

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

AWS enterprise properties for resellers table

_

Configure reseller customers in Abiquo

To configure billing dashboards in Abiquo for customers of resellers

1. 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 enterprise properties for customers of resellers table