Skip to main content
Gainsight Inc.

Configure Multi-Currency Support

  1. Last updated
  2. Save as PDF

This article explains how multiple currencies are supported in Gainsight. Gainsight allows Admins to load currencies into the application with original currency codes such as USD, EUR, GBP, etc. without having to manually convert them into a specific currency code set in Gainsight.

Overview

This is the functional improvement which allows Admins to configure multiple currency codes, including one primary Corporate Currency code. All of the currency codes can be configured with a conversion rate with respect to the Corporate Currency code. This feature allows the currency data to be shown in the original currency code (as ingested into Gainsight) across Gainsight. A standard field, Currency ISO Code is created in all of the Gainsight objects to identify a currency code for all the currency values in every record.

Once Multi-Currency is enabled, it cannot be reverted to Single Currency. When the enablement of Multi-Currency is in progress, the following features are disabled:

  • Updating Corporate Currency is not allowed.
  • Creating custom objects from the Data Management is not allowed.

It takes a maximum of 24 hours to complete enabling Multi-Currency. You will be able to use the mentioned features again, once Multi-Currency is enabled.

Following are the major capabilities offered by Multi-Currency Support:

  • Customer Success Managers (CSMs)/Admins can see monetary data in the currency code of their selection (local currency) in applications like C360/R360, Reports, Dashboards, etc.
  • CSMs/Admins understand a more accurate and complete view of their Company/Relationship finances across Gainsight. This is achieved by introducing user level currency (local currency) setting and Corporate currency.
  • Conversion rates can be updated at the source and these are honored in the data aggregations across Gainsight.
  • There is a single field to manage multiple currencies for all the records in an object.

Business Use Cases:

  • For Multinational companies, CSMs work with customers across different regions. For each region, currency conversions are often in the local currency. Once Multi-Currency enabled, currencies are displayed in the local currency code.
  • Targets for CSMs and sales are often set in their local currencies and hence the aggregated data is best understood if it’s presented in the local currency.
  • Admins can ingest data from any CRM system with the original currency codes.

Key Terms

  • Multi-Currency: Supports multiple currencies for the currency data across Gainsight.
  • Corporate Currency: Gainsight’s primary currency which acts as the master for the calculation of supported currencies.
  • Supported Currency: A currency which is accepted and supported for the currency data, across Gainsight.
  • Currency ISO Code: A standard field in each Gainsight object which stores currency code for each record in the object.
  • Default Currency: A standard field in the User object which stores each Gainsight user’s preferred currency.
  • Conversion Rate: A conversion rate is a ratio between the supported currency and Corporate currency.

Corporate and Supported Currencies

Admins can set one currency code as the Corporate Currency and identify multiple supported currencies. For each supported currency, you should configure the conversion rate for the Corporate Currency. Admins can set up these configurations at the Administration > Currency Management page.

Corporate_and_Supported_Currencies.png

Admins should configure Corporate Currency for the following capabilities:

  • To apply conversion rates to other currency codes by comparing with Corporate Currency.
  • To display aggregated currencies in the unique currency code, which is Corporate Currency, for example: Rules.
  • To set Corporate Currency as a default code when the supported currencies are not configured.

Following options are available to edit the supported currencies:

  • Change conversion rate. 
  • Set to Corporate Currency.
  • Activate/Deactivate Currency code.

Options oif Currency Code.png

User Default Currency

Admins can set a single currency code to each Gainsight user which is called Default Currency, to display currencies in the user preferred currency code across Gainsight.

Currencies in the Timeline page are displayed in the user default currency. For example, CSMs working from Europe may want to see the currencies across Gainsight in Euros. Following are the applications in which currency data is shown in the user default currency:

  • Timeline Page
  • Renewal Center
  • Aggregated currency values in Reports and Dashboards on Gainsight data.

Default Currency setting for a Gainsight user is synced from the Salesforce Currency ISO Code field through field mappings in the Salesforce Connector. For more information on the Salesforce Connector field mappings, refer to the Multi-Currency Impact on Connectors section in this article.

User’s preferred currency code is synced from Salesforce and honored across Gainsight. For more information on the user currency setting in Salesforce, refer to the Set Your Personal Currency Salesforce article.

Admins can also assign or edit default currency to each Gainsight user from the User Management page.

User Default Currency.png

Currency Management Configurations

Configure Corporate Currency

To enable and configure Corporate Currency:

  1. Navigate to Administration > Currency Management. The default corporate currency is USD.
  2. Edit Corporate Currency as shown below:
    1. From the dropdown menu, select Edit Currency.

Configure Corporate Currency.png

  1. From the currency code dropdown, select a different currency as Corporate.
  2. Click Update.

Update Corporate Currency.png

Review Multi-Currency Impact

Before enabling Multi-Currency, admins must review the impact of Multi-Currency across Gainsight. The logged-in admin receives the Multi-Currency Analysis report through an email by clicking Review Multi-Currency Impact in the Currency Management page. Before enabling Multi-Currency in your Gainsight org, you can click the button and receive the Multi-Currency analysis report any number of times.

Review Multi-Currency Impact Button.png

This report contains the following Gainsight attributes, labels of which contain Currency ISO Code. You must edit labels of these attributes to remove Currency ISO Code. If these labels are not edited, you cannot proceed with enabling Multi-Currency.

  • Field Display name: You can edit the reported Field Display names from the Data Management > Select Object > Edit Field page as shown below.

  • Field name: You must contact Gainsight Support with the Object name > Field name, that you want to edit. You can edit the reported Display names and contact Gainsight Support with the corresponding Field names for editing from backend.

Field display name and field name.png

  • DB name: You must contact Gainsight Support with the reported DB names that you want to get edited.

The following image contains the Analysis Report with Display and Field names, that need editing for enabling Multi-Currency.

Analysis Report_Field names.png

This report can contain the S3 rules and S3 jobs that must be reviewed before or after enabling Multi-Currency. You must make required changes to the configurations as explained below. S3 rules and jobs should not be run after enabling Multi-Currency, without making required changes to the configurations. System does not stop you from enabling Multi-Currency, even if you do not make the required changes to the reported S3 Rule or S3 Job configurations. Following are the Gainsight components that can be included in the Analysis Report:

  • S3 Rules: Analysis report shows the list of Rules configured with S3 dataset tasks, which have currency field mappings, but not the currency ISO code. You should add currency ISO code in source and add mapping in the rule configuration, before or after enabling Multi-Currency. If this is not configured before enabling, the rules are marked as Inactive. If this is not configured even after enabling, the rule runs as scheduled and loads incorrect monetary currency values into the target objects.
  • S3 Jobs: Analysis report shows the list of S3 Jobs, which have currency field mappings but not the currency ISO code. You should add currency ISO code in source and add mapping in the S3 job configuration, after enabling Multi-Currency. If this is not configured even after enabling, the S3 job runs as scheduled and loads incorrect monetary currency values into the target objects.

Following image shows the list of S3 Rules in the Analysis report. You can click any rule name to navigate to the specific rule configuration page.

Analysis Report_S3 Jobs.png

Following image shows the list of S3 Jobs in the Analysis report.

Analysis Report_S3 Jobs1.png

Before enabling Multi-Currency, you must review the Multi-Currency analysis report and make required changes to the Gainsight configurations such as S3 rules, S3 jobs, and field names, so on.

You should click Review Multi-Currency Report to receive the Multi-Currency Analysis report, through an email. Analysis report is shared with the logged-in admin and the Enable Multi-Currency button is enabled.

Note: Before enabling Multi-Currency, you can request the Analysis Report again by selecting Review Multi-Currency Report from the dropdown.

Enable Multi-Currency

To enable Multi-Currency:

  1. From the Multi-Currency dropdown, click Enable Multi-Currency. It takes a maximum of 24 hours to complete migration from single-currency to Multi-Currency.

Enable Multi-Currency Button.png

  1. Select the checkbox to confirm that once you enable Multi-Currency, the org setting cannot be set back to Single currency.

Enable Multi-Currency Dialog.png

  1. Click SAVE.

Once you enable Multi-Currency, you can add supporting currencies by one of the following methods:

  • Add Currency Manually
  • Bulk Upload Currency

Add Currency Manually

Once Multi-Currency is enabled, all of the global currencies are loaded to Gainsight. You can add one supported currency at a time through this method.

To add a supported currency manually:

  1. From the Current Management page, click Add Currency.
  2. From the dropdown, select Add Currency Manually. The Add New Currency page is displayed.

Add New Currency 1.png

  1. From the Select Currency to add dropdown, select the required currency that you want to add to Gainsight.
  2. Enter the Conversion rate value with respect to Corporate Currency to the newly added supported currency.

Add New Currency 2.png

Note: Once you add a new Currency, deleting this is not allowed from the Currency Management page. However, you can deactivate the Currency.

  1. Click Add.

Bulk Upload Currency

Once Multi-Currency is enabled, you can add multiple supported currencies from a CSV file that you have created or downloaded from an external system. Your CSV file which is used to upload multiple currencies, should have the following configurations:

  • It should have headers.
  • It should have mandatory columns: Currency Code and Conversion Rate.
  • Values in the CSV file should be comma separated.
  • CSV file size should be  less than 1 MB.

To perform the bulk upload:

  1. From the Current Management page, click Add Currency.
  2. From the dropdown, select Bulk Upload Currency. The respective new configuration page appears.
  3. Drag and drop or click browse to upload a CSV file from your machine.
  4. Perform field mappings between the CSV headers and Gainsight fields for Currency Code and Conversion Rate.
  5. Click Save.

Sync Currencies from Salesforce

Prerequisites

  • Salesforce Connector is enabled.
  • Multi-Currency is enabled.
  • Corporate Currency is already added in the Currency Management page.

Supported currencies and conversion rates can be synced from Salesforce to Gainsight through Salesforce Connector. After Multi-currency is enabled, and out of the box, Currency Sync Job is created in the Salesforce Connector, to sync currency information. If Corporate Currency is the same between source and target, the following actions are performed in Gainsight:

  • Supported currencies and conversion rates with respect to Corporate Currency are synced from Salesforce to Gainsight.
  • Conversion rates of the existing supported currencies in Gainsight are updated from Salesforce when the currency codes such as USD, EUR, etc. are matched between source and target.

Note: If Corporate Currency in Gainsight does not match with Salesforce, execution of the Currency Sync job fails.

You should schedule this job to set the frequency of updating this currency information in Gainsight. For more information, refer to the Salesforce Connector > Configure Out of the Box Jobs article in the Additional Resources section.

Edit Supported Currencies

Following options are available from the menu of any supported currency:

  • Edit Conversion Rate: It is used to edit the existing conversion rate of any supported currency with respect to Corporate Currency.

To update the conversion rate of a supported currency:

  1. From the menu of supported currency, select Edit Conversion Rate. The Edit Currency window appears.

Edit Conversion Rate.png

  1. Update the conversion rate with respect to Corporate Currency.
  2. Click Update.

Edit Currency.png

  • Deactivate: It is used deactivate any supported currency. If a currency is deactivated, records from any source having currency in this code are not ingested through any channel. Existing records in the system before deactivating the respective currency code, remain as they are and all of these records honor conversion rates and Multi-Currency across Gainsight.

Deactivate.png

  • Make Corporate: It is used to mark any supported currency as Corporate. If a currency is marked as Corporate, the existing Corporate Currency is marked as an active supported currency. Conversion rates of all the supported currencies will be recalculated with respect to new Corporate Currency.

Make Corporate.png

Honor Source and Target Currency

Admins can ingest currency data into the Gainsight system through the following data ingestion channels:

  • CRM Connectors

    • Salesforce Connector
    • Dynamics Connector
  • S3 Connector
  • Load to Action Types from Rules Engine (E.g. Load to Company, Load to Gainsight Objects, so on.)

While configuring any data job or rule in the above ingestion channels, you can select either the source or target preferred currency code to upsert currency data and their respective ISO codes.

Business Use Cases:

  • If the source currency ISO codes for the records that you want to ingest are different from the target, Admins can select either source or target currency to populate the currency data with the respective ISO codes into the Gainsight objects.
  • If the currency ISO code and a few currency fields are updated for the existing records through data ingestion, other currency fields that are not updated in the target object display incorrect monetary values. This issue is addressed by selecting either Source or Target Currency to update all of the currency fields as per updated currency ISO code.

Source is data from different CRM systems, CSV files for S3 Connector, or Dataset for different rules from which you want to load currency data into the Gainsight system. Target is different Gainsight objects into which you want to load currency data, through the supported ingestion channels.

A toggle button is available in the field mappings section of each data job or rule action type configuration page, to select either Source or Target preferred currency code. Following is the toggle button available at the field mapping section of the S3 Connector configuration page while upserting data from a CSV file:

Honor Source Currency.png

The toggle button is set to honor Target Currency by default and it can be switched ON to honor Source Currency. A similar toggle button is available in the field mapping section of the job configurations in the data ingestion channels listed above.

If you select to honor source currency, system honors the following behavior while upserting currency values and the currency ISO codes:

Existing (target) record in the Gainsight object:

Company Name currency_iso_code ARR MRR
Company 1 USD 50 60

Input (source) record:

Company Name currency_iso_code ARR
Company 1 GBP 55

Output record in the Gainsight object:

Company Name currency_iso_code ARR MRR
Company 1 GBP 55 48.45

In the previous example, it is considered that:

  • Currency data is loaded into the Company object
  • Name field is selected as Upsert Key
  • Currency ISO Code and ARR fields are mapped between Source and Target 
  • MRR field is not mapped
  • EUR is selected as Corporate Currency

In the output:

  • USD is replaced with GBP in the output record. In this update, source currency (GBP) is honored.
  • ARR value (55) is updated as this field is mapped.
  • MRR value (60 USD) is converted to 48.45 GBP, per the conversion rate stored in the Gainsight Currency Management page.

Behavior in other scenarios:

  • Company records on which currency ISO code matches between source and target (through currency ISO code field mapping), values in the mapped currency fields (field mappings from source to target) are updated.
  • If the currency ISO code is not available in a source record while updating the existing company, target currency ISO code is considered and values in the other currency fields are updated from source to target.
  • If the currency ISO code is not available in a source record while inserting a new company record, the org’s Corporate Currency is assigned to the company record.
  • New company records with the currency ISO code are inserted from source to target.
  • If the currency ISO code field is not mapped while updating the existing company records, the target's currency ISO code is considered in the output and values in the other mapped currency fields are updated. In this use case, if the currency ISO code is not mapped, values in the mapped currency fields are considered as just numbers.
  • If the currency ISO code is not mapped while inserting a new company record, Corporate Currency is considered in the output and values in the other currency fields are updated.

If you want to honor target currency in your data job configuration, system honors target currency while upserting the currency values and currency ISO code from source to target. Following example explains honoring target currency:

Existing (target) record in the Gainsight object:

Company Name currency_iso_code ARR MRR
Company 1 USD 50 60

Input (source) record:

Company Name currency_iso_code ARR
Company 1 GBP 55

Output record in the Gainsight object:

Company Name currency_iso_code ARR MRR
Company 1 USD 68.24 60

In the above example, it is considered that:

  • Currency data is loaded into the Company object
  • Name field is selected as Upsert Key
  • Currency ISO Code and ARR fields are mapped between source and target 
  • MRR field is not mapped
  • EUR is selected as Corporate Currency

In the output:

  • USD is retained as currency ISO code in the output record. In this update, target currency (USD) is honored.
  • ARR value (55 GBP) from source is converted to 68.24 USD and stored in the target ARR field. This value is converted as per conversion rates stored in the Gainsight Currency Management page.
  • MRR value (60 USD) is not updated as target currency (USD) is honored and MRR field is not mapped from source to target.

The system behaves in other scenarios similar to how it is explained in the source preferred currency.

Multi-Currency Impact

The following table lists all the modules which are impacted due to Multi-Currency enablement.

Impacted Area In The Gainsight Application Description

360

 For more information about the impacts on the Company, Relationship, and 360 application after enabling Multi-Currency, refer to the Multi-Currency Impact on 360 article.

Cockpit and Success Plans

 For more information about the impacts on the Cockpit and Success Plans applications after enabling Multi-Currency, refer to the Multi-Currency Impact on Cockpit and Success Plans article.

Connectors

 For more information about the impacts on the Connectors such as S3, Salesforce, Dynamics, and Hubspot Connectors after enabling Multi-Currency, refer to the Multi-Currency Impact on Connectors article.

Data Management

 For more information about how Data Management is impacted when Multi-Currency is enabled in the org, refer to the Multi-Currency Impact on Data Management article.

Email Assist

 When Multi-Currency feature is enabled in your org, Email Assist allows you to map tokens in the Email Template to a new data type called CURRENCY. For more information, refer to the Multi-Currency Impact on Email Assist article.

Journey Orchestrator

 A new Currency data type field in Programs to store numeric currency values. For more information, refer to the Multi-Currency Impact on Journey Orchestrator article.

Renewal Center

 Renewal Center honors Multi-Currency at two levels; User level and Global level. For more information, refer to the Multi-Currency Impact on Renewal Center article.

Reports and Dashboards

 For more information on how Multi-Currency impacts various areas in Reports and Dashboards, refer to the Multi-Currency Impact on Reports and Dashboards article.

Rules Engine

 For more information about the impacts on the Rules Engine application after enabling Multi-Currency, refer to the Multi-Currency Impact on Rules Engine article.

Sally and Company Intelligence

 Multi-currency is available only for the users who are using Sally in Slack and In-App. For more information about the impacts on Sally and Company Intelligence, refer to the Multi-Currency Impact on Sally and Company Intelligence article.

Scorecards

 Scorecards honors Multi-Currency in two areas; Mass Edit reports and Habits reports. For more information, refer to the Multi-Currency Impact on Scorecards 2.0 article.

Surveys and CX Center

 For more information on the several impacted areas in Surveys and CX Center, refer to the Multi-Currency Impact on Surveys 2.0 and CX Center article.

Timeline

 Timeline does not support the Multi-Currency functional improvement. Fields displaying currency data can appear in Timeline, but these are either Number or String fields and do not have an associated currency code.

X-Org Migration

 In terms of Multi-Currency support, Cross-Org migrations deal with three different types of tenants. For more information, refer to the Multi-Currency Impact on X-Org Migration article.
  1. Back to top
  • Was this article helpful?

Recommended articles

  1. There are no recommended articles.
  1. Article type
    Topic
  2. Tags
    1. Multi-Currency
    2. Multi-Currency in Gainsight