Skip to main content

Ripple - Account & Billing Group Registration: Mapping Sheet

How to bulk register accounts and billing groups in Ripple using the Mapping Sheet.

Written by Yo Fukuda
Updated yesterday

When registering multiple Linked Accounts, Billing Groups, and Payer Accounts in Ripple at once, you can do so by using the mapping sheet.


AWS Mapping Sheet

  1. Payer Account

  2. Billing Group Master (common across AWS, Azure, GCP)

  3. Mapping

  4. Account Discount Rate (AWS only)

Payer Account

A sheet to fill in the information required to register a Payer Account in Ripple.

Field

Details

AWS Payer Account ID

The AWS Payer Account ID (12-digit number) where the Cost and Usage Report (CUR) is stored

Report Name

The name of the CUR report stored in the S3 bucket

S3 Bucket

The S3 bucket where the CUR is stored

Report Path Prefix, or

Report Path

The report path prefix or report path

IAM Role ARN

e.g. arn:aws:iam::xxxxxxxxxxxx:role/crossaccount-access-for-alphaus

Billing Group Master

A sheet to fill in the Billing Group registration and billing calculation settings.

Description

Required

Description

Required

id

substitution_fee_calc_target

billinggroup_id

substitution_fee_target_usage

billinggroup_name

substitution_fee_calc_type

company_name

department

tax_rate (%)

email

discount_rate (%)

phonenumber

discount_target_usage

postalcode

discount_calc_logic

address

support_fee

personal

support_rate

payment

support_fee_calc_target

invoice_template

substitution_fee

custom_service

substitution_rate

service_discounts

substitution_fix

Mapping

A sheet for linking Billing Groups, Linked Accounts, and Payer Accounts.

Field

Details

Billing Group ID

The ID of the Billing Group to link

AWS Account ID

The AWS Linked Account ID (12-digit number) to link to the Billing Group

Account Name

The account name used for management in Ripple (AWS Linked Account, Azure Subscription, or GCP Project)

Payer Account ID

The AWS Payer Account (consolidated billing account)

Each row in the Mapping sheet defines which Billing Group a pair of Linked Account and Payer Account belongs to. Since a Billing Group is the unit used for invoice creation, it is typically set per client or department.

Account Discount Rate

A sheet to fill in discount rates per account. Please ensure all required fields are filled in before submitting.


Azure Mapping Sheet

The Azure mapping sheet consists of the following four sheets:

  1. MPN ID (Azure Partner ID)

  2. Billing Group Master (common across AWS, Azure, and GCP)

  3. Mapping

  4. Account Discount Rate

MPN ID

If you have already configured this in Ripple > Azure Settings, this sheet is not required.

The MPN ID is an 8-digit number assigned under an Azure CSP contract. You can find it in the Azure Partner Center under Account Settings or Partner Settings > Profile.

Billing Group Master

The fields are the same as the AWS Billing Group Master. Please refer to the table above.

Mapping

Field

Details

Billing Group ID

The ID of the Billing Group to link

Azure Subscription ID

The Azure Subscription ID (GUID) to link to the Billing Group

Subscription Name

The account name used for management in Ripple

MPN ID

The Azure Partner ID


Submitting the Mapping Sheet

Once the mapping sheet is filled out, please submit it via:

We will proceed with the batch registration and follow up with you once it is completed.

Did this answer your question?