Skip to main content

Ripple - Invoice Line Item Calculation Logic

How to understand the calculation logic for each line item in Ripple-generated invoices.

Written by Alphaus Support Team
Updated today

Overview

This article explains the calculation method for each line item found in invoices generated by Ripple. The calculations referenced here are based on the CSV data downloadable from the Invoices > Invoice Management menu in Ripple.

Invoice PDF Structure

Ripple invoices are structured as follows:

  • Each account or tag is displayed with its costs broken down by service (in USD).

  • The totals are displayed in the billing currency based on the configured exchange rate.

  • After all account/tag line items, a Subtotal section displays the final total in your preferred currency.

Account / Tag Section — Displayed Items

Each account or tag section displays the following items:

  • AccountID or TagName

  • Cost per service in USD

  • Account Subtotal / Tag Subtotal, which includes:

    • Charges: AWS Usage Fee (excluding Marketplace)

    • Marketplace Usage Fee

    • Total Usage Fee

    • AWS Maintenance Service Fee

    • Business Support Fee

    • Billing Service Fee

Account / Tag Section — Calculation Methods

Cost per Service (USD)

Costs per service are displayed on the invoice rounded to two decimal places. However, the actual calculation uses the full precision value (10+ decimal places) retrieved from the CUR.

Account Subtotal / Tag Subtotal

Charges: AWS Usage Fee (excluding Marketplace)

As the label indicates, this displays the usage fee excluding Marketplace charges, converted to the billing currency.

  1. Each service cost ($) × Exchange Rate = Each service cost (the billing currency)

  2. Apply the decimal rounding setting configured in Ripple under Settings > Invoice Settings (e.g. if set to round down: ¥123.456 → ¥123)

  3. Sum the rounded amounts for each service

Marketplace Usage Fee

Marketplace charges are converted to the billing currency using the same calculation method as the usage fee.

  1. Marketplace ($) × Exchange Rate = Marketplace (the billing currency)

  2. Apply decimal rounding

Total Usage Fee (_ACCOUNT_TOTAL)

The sum of Charges: AWS Usage Fee (excluding Marketplace) and Marketplace Usage Fee.

AWS Maintenance Service Fee (_SUPPORT_BUSINESS) / Business Support Fee

Displays the support fee (before discount) as configured in the Billing Group settings.

  1. Calculate the support fee based on the Total Usage Fee (the billing currency), following AWS's support plan calculation method stated here.

  2. Apply decimal rounding to the result

Billing Service Fee

Displayed when a Billing Service item has been added to the Billing Group.

  • For fixed costs, the configured fixed amount is applied as-is.

  • For percentage-based costs, the calculation is:

    • Total Usage Fee (after discount, $) × Exchange Rate × Billing Service percentage = Billing Service Fee (the billing currency)

Subtotal Section — Displayed Items

The Subtotal section includes the following line items:

  • Charges: AWS Usage Fee (excluding Marketplace)

  • Marketplace Usage Fee

  • Marketplace Lump Sum Usage Fee

  • Total Usage Fee

  • AWS Maintenance Service Fee

  • Discount

  • Subtotal after Discount

  • Agency Fee

  • Billing Service Fee

  • Subtotal (excl. tax)

  • Consumption Tax

  • Total (incl. tax)

Subtotal Section — Calculation Methods

Charges: AWS Usage Fee (excluding Marketplace)

The total usage fee for all accounts linked to the Billing Group.

  1. Apply the exchange rate to each account's service cost ($) to convert to the billing currency

  2. Apply the decimal rounding setting from Ripple Settings

  3. The CSV value for _ACCOUNT_TOTAL per account/service unit corresponds to step 2

  4. Sum of all step 3 values = Charges: AWS Usage Fee (excluding Marketplace)

Marketplace Usage Fee

Marketplace charges categorised as "Usage" in the CUR.

Note: AWS Marketplace invoices are typically issued separately. In that case, they are categorised as "Marketplace" in the CUR and appear in Ripple's recalculated billing data. However, there is a separate type of Marketplace charge categorised as "Usage" in the CUR — this section covers that latter type.

  1. Apply the exchange rate to each account's Marketplace cost ($) to convert the billing currency.

  2. Apply decimal rounding

  3. Sum of all step 2 values = Marketplace Usage Fee

Marketplace Lump Sum Usage Fee

Marketplace charges categorised as "Marketplace" in the CUR, included in the invoice from recalculated billing data.

  1. Apply the exchange rate configured per Marketplace item to each account's Marketplace cost ($) from the recalculated billing data, converting to the billing currency

  2. Apply decimal rounding

  3. Sum of all step 2 values = Marketplace Lump Sum Usage Fee

Total Usage Fee

The sum of Charges: AWS Usage Fee (excluding Marketplace), Marketplace Usage Fee, and Marketplace Lump Sum Usage Fee.

AWS Maintenance Service Fee / Support Fee

The total support fee for all accounts linked to the Billing Group.

  1. Calculate the support fee (based on each account′s usage), following the support settings configured in the Billing Group

  2. Apply the common exchange rate to convert to the billing currency

  3. Apply decimal rounding

  4. Sum of all step 3 values = AWS Maintenance Service Fee / Support Fee

Subtotal after Discount

The sum of the post-discount usage fee and the post-discount support fee.

Step 1: Post-Discount Usage Fee

  1. Apply the exchange rate to each account's usage fee ($) to convert to the billing currency

  2. Multiply by (1 − Discount Rate) to calculate the post-discount amount

  3. Apply decimal rounding

  4. Sum of all step 3 values (equivalent to applying steps 1–3 to _ACCOUNT_TOTAL in the CSV)

Step 2: Post-Discount Support Fee

  1. Calculate the support fee (based on each account′s usage), following the Billing Group's support settings

  2. Apply the exchange rate to convert to the billing currency

  3. Multiply by (1 − Discount Rate)

  4. Apply decimal rounding

  5. Sum of all step 4 values per account

The sum of Step 1 and Step 2 = Subtotal after Discount

Discount

Total Usage Fee − Subtotal after Discount = Discount

Agency Fee

The agency fee configured in the Billing Group, calculated based on each account's usage fee ($).

  1. Calculate the agency fee (based on each account's usage fee), following the fee settings configured in the Billing Group

  2. Apply the common exchange rate to convert to the billing currency

  3. Apply decimal rounding

  4. Sum of all step 3 values = Agency Fee

Billing Service Fee

Costs created using the Ripple Billing Service feature and added via the Billing Group settings. The configured amount is reflected as-is.

Subtotal (excluding tax)

The sum of Subtotal after Discount, Agency Fee, AWS Maintenance Service Fee / Support Fee, and Billing Service Fee.

Consumption Tax

Subtotal (excl. tax) × Tax Rate = Consumption Tax

Total (including tax)

Subtotal (excl. tax) + Consumption Tax = Total (incl. tax)

Need More Help?

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

Related Articles
Ripple - Create a Billing Group
Ripple - Contents of CSV Data
Ripple – Differences Between Aggregated Results and AWS Charges
Ripple - Adjusting Entries (Fee, Credit, Refund)
Ripple – Billing CSV Data Fields
Did this answer your question?