Skip to main content

Ripple – Billing CSV Data Fields

This article explains the fields contained in the billing CSV data.

Written by Yo Fukuda
Updated over 2 weeks ago

Overview

This article explains the key fields found in the billing CSV data downloadable from Ripple. You can also select and download only the necessary fields at the time of download.


Invoice Management CSV

BillingGroupID: The ID of the billing group.

BillingGroupName: The name of the billing group.

CompanyName: The company name of the billing group.

CustomerID: The AWS account ID registered in the billing group.

CustomerName: The AWS account name registered in the billing group.

ServiceType Values

Indicates the type of service. Possible values are: Account, Product, or Service.

  • Account Represents _ACCOUNT_TOTAL for ServiceName.

  • Product Represents _SUPPORT_BUSINESS, _SUBSTITUTION, or _TOTAL for ServiceName.

  • Service Represents the lineItem/ProductCode value from the CUR.

    • Marketplace Usage Amount is displayed as Service.

    • Marketplace One-time Usage Amount is displayed as ServiceFee.

ServiceName Values

  • _SUPPORT_BUSINESS AWS support fees (tax excluded) as configured in the billing group's invoice settings.

  • _SUBSTITUTION Agency fees (tax excluded) as configured in the billing group's invoice settings.

  • _TOTAL Total amount (tax excluded) for the BillingGroupID.

  • _ACCOUNT_TOTAL Total amount per CustomerID (tax excluded).

  • Other values The lineItem/ProductCode value from the AWS Cost and Usage Report (CUR).

Charge: Amount per ServiceName (tax excluded).

DiscountCharge: Amount after discount (tax excluded).

DiscountCharge - TaxFree: Amount after discount for usage fees, excluding tax-exempt portions (tax excluded).

FreeFormat: Amount added as "Invoiced Service"

CustomService: Amount added as "Billing Service."

Tax: Tax amount.

  • [DiscountCharge - TaxFree] when ServiceName is _TOTAL

  • [Consumption tax rate set in the billing group's invoice settings]

Total: Total amount for the BillingGroupID (tax included).

Billing Group Page: Billing Group Settings CSV

BillingGroupID: The ID of the billing group.

BillingGroupName: The name of the billing group.

CompanyName: The company name of the billing group.

Billing Group Page: Invoice Settings CSV

Vendor: Cloud Vendor

BillingGroupName: The name of the billing group.

CompanyName: The company name of the billing group.

DiscountRate: Discount rate

TaxRate: Tax rate

SupportFeeSettings: Support fee settings

SupportFee - PercentageOfUsage: Support fee (percentage)

SupportFee - FixedFee: Support fee (fixed cost)

AgencyFeeSettings: Agency fee settings

AgencyFee - PercentageOfUsage: Agency fee (percentage)

AgencyFee - FixedFee: Agency fee (fixed cost)

ResourceType: Resource type (Azure only)

UsageSubjectToDiscount: Service discount surcharge settings

BillingAgentServiceCalculationTarget: Billing Service settings

MiscItem: Other Costs settings


Need More Help?

If any errors occur during the process or if you have any questions, please reach out to us:

Did this answer your question?