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

In Abiquo 6.1.0+, replace the price_factor enterprise property with the Abiquo price factors for Amazon. See Manage price factors

In Abiquo 6.1.2+, you can also add a managed costs with price factors

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 the code of any items to discard. For example:
```
abiquo.ec2billing.parser.lineItemType.ignore=SppDiscount
```

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
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 amazon_bucket_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 be a partner account with pricing and billing permissions. See https://abiquo.atlassian.net/wiki/spaces/doc/pages/311370749/Obtain+AWS+credentials#Reseller-pricing-and-billing-credentials

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

Assign the privilege to View bills to your user roles
Edit the reseller enterprise and create the following enterprise properties:
1. amazon_bucket: bucket_name
2. amazon_bucket_region: code for the AWS region of the bucket, such as us-east-1
3. amazon_report_name: amazon_bucket/amazon_bucket_prefix/amazon_report_name/file.csv
4. amazon_bucket_prefix: amazon_bucket/ amazon_bucket_prefix /amazon_report_name/file.csv
5. amazon_billing_compress_format: ZIP or GZ
6. amazon_mpa: set to dedicated or no to use blended costs; if not present or shared, use unblended costs
7. amazon_discount: as agreed with Amazon, such as 0.03, 0.02
In Pricing view, create price factors for the reseller. You can also create and apply price factors for customers, as well as managed costs. See Manage price factors