AWS cost explorer report

Simple reporting tool to extract AWS cost on a daily, or monthly basis in regard with used services.

Running the report

Prerequisites

You must run the tool with python3 and AWS SDK for Python installed. To install the SDK you must run pip3 install boto3.

Your AWS account credentials must be setup in $HOME/.aws/credentials file.

It's recommented to use virtualenv though. As guide, take a look into the following command line example:

python3 -v venv venv3
source venv3/bin/activate
pip install boto3

python aws-cost-and-usage-report.py

Usage

By default the script will query the cloud for cost of the current month, which is equivalent with running it with --month 1 option.

Tool's help options are the following.

python aws-cost-and-usage-report.py  -h
usage: aws-cost-and-usage-report.py [-h] [--output FPATH] [--days DAYS]
                                    [--months MONTHS] [--disable-total]

AWS Simple Cost and Usage Report

optional arguments:
  -h, --help       show this help message and exit
  --output FPATH   output file path (default:report.csv)
  --days DAYS      get data for daily usage and cost by given days. (Mutualy
                   exclusive with 'months' option, default: 0)
  --months MONTHS  get data for monthly usage and cost by given months.
                   (Mutualy exclusive with 'days' option, default: 1)
  --disable-total  Do not output total cost per day, or month unit.

Output

The output is dumped into a CSV file which you can specify by --output option by path.

Example of an output for costs of current month could looks like the following, where the account id hidden by XXXXXXXXXXXX:

Time Period,Linked Account,Service,Amount,Unit,Estimated
09/2018,XXXXXXXXXXXX,AWS Cost Explorer,0.28,USD,True
09/2018,XXXXXXXXXXXX,AWS Key Management Service,0.5888888936,USD,True
09/2018,XXXXXXXXXXXX,Amazon Cognito,0,USD,True
09/2018,XXXXXXXXXXXX,Amazon DynamoDB,0,USD,True
09/2018,XXXXXXXXXXXX,Amazon EC2 Container Registry (ECR),0.0039653208,USD,True
09/2018,XXXXXXXXXXXX,EC2 - Other,1.6374118119,USD,True
09/2018,XXXXXXXXXXXX,Amazon Elastic Compute Cloud - Compute,0.0880057458,USD,True
09/2018,XXXXXXXXXXXX,Amazon Glacier,0.0000000011,USD,True
09/2018,XXXXXXXXXXXX,Amazon Route 53,0.501348,USD,True
09/2018,XXXXXXXXXXXX,Amazon Simple Notification Service,0,USD,True
09/2018,XXXXXXXXXXXX,Amazon Simple Storage Service,1.0107627425,USD,True
09/2018,XXXXXXXXXXXX,Amazon Virtual Private Cloud,0.2,USD,True
09/2018,XXXXXXXXXXXX,AmazonCloudWatch,1.3259258281,USD,True
09/2018,XXXXXXXXXXXX,Tax,1.07,USD,True
Total Cost: 6.706308343800001,,,,,