Skip to main content

CSV file format

This section describes the format of CSV files that can be retrieved from the Member's Portal.

The CSV file contains the following fields

  • id.
  • month
  • invoice_id
  • aws_account_id
  • product_name
  • rate_id
  • subscription_id
  • pricing_plan_id
  • usage_type
  • operation
  • availability_zone
  • reserved_instance
  • item_description
  • usage_quantity
  • rate
  • cost
  • resource_id
  • tag_value

Information on Detail Items​

id​

ID granted to the item of detail.

month​

This is the month in which the statement item occurred. The format is YYYY-MM.

Accounts and Billing​

invoice_id​

Billing ID. If it is undetermined, it is Estimated.

aws_account_id​

The 12-digit AWS account ID to be billed.

product_name​

This is the name of the AWS product. Example: Amazon Simple Storage Service

rate_id​

It is always empty (for compatibility).

subscription_id​

The ARN of the reserved instance is output.

pricing_plan_id​

It is always empty (for compatibility).

Product Usage Information​

usage_type​

Identify which behavior the detail item is due to. Example) USW1-BoxUsage:m2.2xlarge

operation​

Describe the contents of the detail item. Example: RunInstances.

availability_zone​

Identify which availability zone the fee was incurred in.

reserved_instance​

Y if the reserved instance is a specific item to which it is applied, and N otherwise. The cost of purchasing a reserved instance and the monthly payment statement will be shown as N.

item_description​

This is a description of the detail items.

Usage and Fees​

usage_quantity​

The amount of recorded resource usage, calculated in the units specified for each service. For example, the amount of storage, number of requests, and uptime. For more information, please visit here.

rate​

This is the rate per hour of operation as applied to the detail item.

cost​

This is the amount calculated at the rate for the statement item.

Resources and custom tags​

resource_id​

The ID of the AWS resource as defined in each AWS service.

tag_value​

If you have assigned cost allocation tags to a resource, each tag will appear as an additional column in the CSV file. The value using the CmBillingGroup tag you gave to classify the cost in the members' portal will be output here.

Reference​

Relatedly, we are offering the following announcements

We've changed the AWS billing reports we use in the members' portal