We can configure itemized bill of AWS to be uploaded S3. It can be done from "Billing Management Console" of AWS -> "Preferences", and turning on option "Receive Billing Reports". Now we can do analysis of "Detailed billing report with resources and tags", and get bill amount in INR, and know which resources are getting billed more etc.
Here is the script that provides analysis of itemized bill that's already uploaded to S3.
# This script uses command line utility q - Text as Data
# Download Page: https://harelba.github.io/q/
# This script expects aws - CLI already configured on the system
# Hard coded values first
account_id=xxxxxxxxx #AWS account ID
tax=15 # Service tax + Swacch Bharath + Krishi Kalyan
bucket_name="xxxxxx" #Name of S3 bucket where billing reports are uploaded automatically
month=`date +"%Y-%m"` #Current month
#month=2017-02 #Needed if bill of another month is needed
# Get currency conversion rate from Google
usd=`wget -q -O - "http://www.google.com/finance/converter?a=1&from=USD&to=INR" \
| grep "currency_converter_result" \
| sed 's/<[^>]*>//g' \
| cut -f4 -d ' '`
echo "Conversion Rate: $usd, Tax=$tax% "
echo " "
aws_url="s3://$bucket_name/$account_id-aws-billing-detailed-line-items-with-resources-and-tags-AISPL-$month.csv.zip"
rm -f bill_line_items*
aws s3 cp $aws_url bill_line_items.csv.zip --quiet
unzip -p bill_line_items.csv.zip > bill_line_items.csv
cat bill_line_items.csv | q -T -b -O -H -d "," -w all \
"select \
\"user:Name\" as Resource_Name, \
UsageType,\
strftime('%Y-%m-%d %H:%M', datetime(UsageStartDate,'+5.5 hours')) as Usage_Start_Time, \
round(Cost*$usd*(1+$tax/100.0),2) as \"Cost+Tax(INR)\" \
from - \
where cost<>0 and Rate <> '' \
order by UsageEndDate, Resource_Name"
echo " "
cat bill_line_items.csv | q -T -b -H -d "," -w all \
"select 'Total cost in INR including tax: ' || \
sum( round(Cost*$usd*(1+$tax/100.0),2)) \
from - where cost<>0 and Rate <> '' "
Sample output
Conversion Rate: 66.2050, Tax=15% Resource_Name UsageType Usage_Start_Time Cost+Tax(INR) node1 APS3-BoxUsage:t2.large 2017-03-03 16:30 9.06 Hadoop APS3-BoxUsage:t2.large 2017-03-06 17:30 9.06 Hadoop APS3-BoxUsage:t2.large 2017-03-06 18:30 9.06 ..... Cloudera1 APS3-EBS:VolumeUsage.gp2 2017-03-14 03:30 0.17 gw APS3-EBS:VolumeUsage.gp2 2017-03-14 03:30 0.09 hadoop APS3-EBS:VolumeUsage.gp2 2017-03-14 03:30 0.23 node1 APS3-EBS:VolumeUsage.gp2 2017-03-14 03:30 0.17 node2 APS3-EBS:VolumeUsage.gp2 2017-03-14 03:30 0.17 node3 APS3-EBS:VolumeUsage.gp2 2017-03-14 03:30 0.17 node4 APS3-EBS:VolumeUsage.gp2 2017-03-14 03:30 0.17 photos_os APS3-EBS:VolumeUsage.gp2 2017-03-14 03:30 0.09 Total cost in INR including tax: 297.81
