1. Order Management
  2. SaaS Metric Reporting
  3. Subscription Metrics
  4. Installing and Setting Up the Subscription Metrics SuiteApp
  5. Setting Up KPI Formulas and Preferences
  6. Setting Up Reporting Using Constant Currency Exchange Rates

Setting Up Reporting Using Constant Currency Exchange Rates

You can set up reporting using constant currency exchange rates if you have a global customer base and need to accurately analyze metrics without being affected by currency exchange rate fluctuations. When you set this up, you can analyze MRR data and operational performance using fixed standardized currency exchange rates across currency pairs.

  1. Ensure that both the Multi-Currency and Currency Exchange Rate Type features are enabled.

  2. Creating the Currency Exchange Rate Type.

  3. Adding the Constant Currency Rates.

  4. Setting the Currency Exchange Rate Type.

Creating the Currency Exchange Rate Type

You need to create a new currency exchange rate type to enter the constant currency exchange rates. See Adding a Currency Exchange Rate Type for more information.

When creating the Currency Exchange Rate Type for the Constant Currency Reporting feature, use a name that identifies the exchange rate type for the feature. For example, Constant Currency Rates.

Adding the Constant Currency Rates

The entered currency rates with the Constant Currency Rates type will be used for the Constant Currency Reporting feature. You need to add the currency pairs that you want to use. You can configure the effective dates of each currency exchange rate. See Adding Rates to the Currency Exchange Rates List for more information.

Important:

You need to select the Currency Exchange Rate Type you created earlier as the Exchange Rate Type of the added rates. In this example, the created Currency Exchange Rate Type is named Constant Currency Rates.

Setting the Currency Exchange Rate Type

To use Constant Currency Rates Reporting, you need to set the created constant currency rates type as the Exchange Rate Type in the Subscription Metrics Preferences.

Only users with the Administrator role can set the currency exchange rate type.

To set the currency exchange rate type:

  1. Log in to NetSuite.

  2. On the Subscription Metrics tab, go to Setup, then click View.

  3. Click the Preferences subtab.

  4. In the Exchange Rate Type field, select the exchange rate type you created for Constant Currency Rates.

  5. In the Override Effective Date field, select a date.

  6. Click Save.

  • Override Effective Date - This date determines which currency exchange rate is applied. By default, the SuiteApp uses the current date. However, you can select any date to fit your requirements. If you leave the date field blank during setup, your preferences are saved without a date. The SuiteApp will automatically use the latest exchange rate effective as of the current date.

  • Exchange Rate Type - By default, the SuiteApp uses the standard currency exchange rate type. To use another type of exchange rate, create a new one at Lists > Accounting > Currency Exchange Rate Types > New and select it during setup.

Related Topics

General Notices