Display Amazon billing data

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

Changes to AWS billing

Changes to enterprise properties for AWS billing

Abiquo 6.0.0

Before you upgrade, add the amazon_bucket_region as an enterprise property. The value is the code for the AWS region where your billing bucket is located (for example, us-east-1)

Abiquo 6.1.0

The price_factor enterprise property is deprecated and replaced with the Abiquo price factor for Amazon. See Manage price factors

Configure properties

To configure Abiquo properties for AWS billing

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

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"
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
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
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. GZ or ZIP format
The AWS account with credentials to use in Abiquo should have the permissions in the AWS permissions table below.

AWS permissions table

Type	Privileges	Resources
Price list	Full access	All resources
S3	Full: list, read	Multiple

Configure resellers in Abiquo

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

The Abiquo users should have the privileges to Display hybrid dashboard tab, View bills, and optionally to Display VM cost view widget (hybrid tab)
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

Property	Description
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.
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
amazon_bucket_prefix	amazon_bucket/ amazon_bucket_prefix /amazon_report_name/file.csv
amazon_billing_compress_format	Compression format of the billing report file: ZIP or GZ
amazon_price_factor	Default provider markup for customer enterprises with no value This property is deprecated in Abiquo 6.1. The upgrade process will migrate the enterprise property to an Abiquo price factor. See Manage price factors
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.

_

Configure reseller customers in Abiquo

To configure billing dashboards in Abiquo for customers of resellers, create a price factor for the reseller. Optionally, create and apply price factors for customers.

See Manage price factors