Display Amazon billing data

Changes to AWS billing

The following changes apply to 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 using a price factor. See Manage price factors

Configure AWS to supply billing data

To configure AWS to supply billing data for standard or reseller accounts, 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. Configure Cost & Usage Reports

   1. Go to Cost & Usage Reports

   2. Enter the Report  name, and note the value 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

4. The AWS account with credentials to use in Abiquo should be an account with pricing and billing permissions.

   1. For partner accounts, see https://abiquo.atlassian.net/wiki/spaces/doc/pages/311370749/Obtain+AWS+credentials#Reseller-pricing-and-billing-credentials

   2. For standard accounts, see https://abiquo.atlassian.net/wiki/spaces/doc/pages/311370749/Obtain+AWS+credentials#Standard-account-pricing-and-billing-policy

Configure dashboard display in Abiquo

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

1. Edit the reseller or standard 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

For resellers

1. Create an additional enterprise property for resellers:

   1. amazon_discount: as agreed with Amazon, usually with a value such as 0.03, 0.02

2. In Pricing view, create price factors as required for the reseller, the customers, and for a percentage of managed costs. See Manage price factors

3. For your customer enterprises, add the Account ID as a public cloud credential

4. Assign the privilege to View bills to your user roles

5. Optionally, configure Abiquo properties

   1. By default, the platform will retrieve billing data for the last two months. To change this value, on the Abiquo Server, set the following property

      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, set the following property with a list of codes of any items to discard.

      abiquo.ec2billing.parser.lineItemType.ignore=SppDiscount