Skip to main content

Manage currency conversion

Zuora

Manage currency conversion

This article describes foreign currency conversion in Zuora.

Foreign currency conversion

In a global subscription economy, sales can occur in multiple currencies. Zuora allows you to convert foreign currencies into your home currency for financial reporting. See Currencies and Their 3-Letter Codes for a list of currencies supported by Zuora.

Exchange rate

To calculate conversion rates in Zuora, you can use the exchange rates posted by the default exchange rate provider, Oanda, or import custom exchange rates through the Mass Updater.

Oanda does not support currency conversion for the following currencies. The value of conversions to home currency in finance reports and Data Source exports will be unavailable.

  • CFP Franc
  • Czechoslovak koruna (CSK) 
  • Venezuelan Bolivar (VED) 

If you use the default exchange rate provider, the rates are averaged for the 24-hour period ending at 22:00 UTC (Coordinated Universal Time) on the day before Oanda posts them. The bid rate is used.

Exchange rate date

Each transaction in Zuora has an Exchange Rate Date. If you are using Oanda, Zuora uses the exchange rates 1 or 2 days before the Exchange Rate Date depending on your time zone. If your time zone can catch the window when Oanda updates their rates, the offset will be 1 day; otherwise, the offset will be 2 days.

If Zuora does not successfully sync a rate from Oanda on a given date, the available rate on the most recent date is used.

For example, if the Exchange Rate Date is 2015-09-10:

  • If the exchange rate is 1.3 on 2015-09-10, the rate on 2015-09-10 is used.
  • If the exchange rate is not available on 2015-09-10, but 1.1 on 2015-09-09 and 1.2 on 2015-09-11, the rate on 2015-09-09 is used.
  • If the exchange rate is not available on 2015-09-10 and not available on 2015-09-09, but 1.1 on 2015-09-08 and 1.2 on 2015-09-11, the rate on 2015-09-08 is used.

If no valid rate is available on the Exchange Rate Date that is later than or equal to your tenant's 'Today', the rate for that date is left unavailable.

To see how Zuora gets the Exchange Rate Date for each transaction type, refer to How Zuora Calculates the Values of Foreign Currency Conversion Fields.

If you upload custom exchange rates, you can configure the rate date using the Provider Exchange Rate Date Offset setting as described below in How to Enable Foreign Currency Conversion.

Currency types

​The following table describes the different types of currency in Zuora.

Currency type Description

Default currency

The default currency set for your product rate plans. See Customize Currencies for more information.

Home currency

The currency you use to create financial reports. You only have one home currency.

Transaction currency

The currency used by the customer. See Billing and Payment Information.

Reporting currency Finance reports can be generated in Reporting Currency. The calculation of Reporting Currency is based on the Home Currency. The Reporting Currency can be configured at the Tenant, Organization, and Account levels.

Configure foreign currency conversion

To enable foreign currency conversion, you must configure your home currency in Zuora and indicate whether to use the default exchange rate provider or upload custom exchange rates.

  1. Click your username at the top right and navigate to Finance Settings > Manage Currency Conversion.
  1. Complete the following fields:
    • Home Currency: Click and select your home currency.
      • Once you have set your home currency, you cannot change it.
      • If you have enabled the Multi-Org feature to configure the root or child organization, then the Home Currency field will be disabled.
    • Reporting Currency: Click and select your reporting currency. To enable the Reporting Currency option, submit a request at Zuora Global Support.
      • You must first select the home currency to select the reporting currency. Once you have set your reporting currency, you cannot change it.
      • If you have enabled the Multi-Org feature to configure the root or child organization, then the Reporting Currency field will be disabled.
    • Exchange Rate Provider: Select Oanda, the default exchange rate provider, or select Use a custom exchange provider if you want to import and use your own exchange rates. You must upload custom exchange rates through the Mass Updater. See Mass Updater and import custom exchange rates for more information.
      If you use a custom exchange rate provider, you must upload exchange rates for all transactions in an accounting period. Otherwise, you will receive an error when running a trial balance. Note that some transactions in a given accounting period might have transaction dates that are before that period.
      To enable the Use a custom exchange provider option, submit a request at Zuora Global Support.
    • Exchange Rate Date:
      • Daily: Select to use the daily exchange rate.
        • Provider Exchange Rate Date Offset: If you select Use a custom exchange rate provider in the Exchange Rate Provider field and if you select Daily exchange rate, you can specify a date offset.
          Sometimes, exchange rates from your vendor are not available on the same day due to processing delay. 
          Specify the exchange rate date offset. For example, if you set the offset to 2, the exchange rate from 2 days prior will be used when converting currencies.
          The default value is 0 days.
      • Day of the Month: Select to use the monthly exchange rate. 
        • Click and select the day of month to get the monthly exchange rate.
    • Use inverse rate: Select yes to use the inverse rates when converting currency amounts. The foreign currency amount is multiplied by the inverse rate to calculate the home currency amount. With an non-inverse rate, the foreign currency amount is divided by the rate to calculate the home currency amount. Typically, inverse rates are used for currency conversions.
    • Rounding Mode: Select whether to round half up or down when converting currency amounts. For example, if a foreign currency amount is being converted into USD:
      • If you select Down:
        • 10.001 USD is rounded to 10.00 USD
        • 10.005 USD is rounded to 10.00 USD
        • 10.009 USD is rounded to 10.00 USD
        • −10.005 USD is rounded to −10.00 USD
      • If you select Half Up:
        • 10.001 USD is rounded to 10.00 USD
        • 10.005 USD is rounded to 10.01 USD
        • 10.009 USD is rounded to 10.01 USD
        • −10.005 USD is rounded to −10.01 USD
    • Multi-Org: Click and select a root or child organization to configure any of the following:
      • Exchange Rate Provider
      • Exchange Rate Date
      • Use inverse rate
      • Rounding Mode
      • ​​​​​This feature is in Limited Availability. If you want to have access to the feature, submit a request at Zuora Global Support
      • You will not be able to update Home and Reporting Currency after you have enabled this feature. Based on the organization that you select the Home and Reporting Currency fields are populated automatically.
      • Under Multi-Org, you cannot configure the child organizations unless you have configured the Home and Reporting Currency for the root organization. For more information on the organization hierarchy, see Management of Entity and Entity Hierarchy.
  • Automatically include additional Currency Conversion information in data source exports: Select this check box if you want to access foreign currency conversion data through data source exports.
  1. Click save. Foreign currency conversion is now enabled.

Sample home currency and reporting currency calculation

Sample Calculation of Home Currency and Reporting Currency:

Sample 1: Transaction Currency, Home Currency, and Reporting Currency are different currencies.

Transaction Currency: USD
Transaction Amount: 903.23
Transaction Date: 15-06-2023
Home Currency: CAD
Home Currency Rate Date: 15-06-2023
Home Currency Exchange Rate: 1.5
Rounding Mode: Rounding Half up
Consider default decimal places for all the currencies used in this example is 2.

Home Currency Amount: (Transaction Amount) * Home Currency Exchange Rate = 903.23 * 1.5 = 1354.845 = 1354.85 (Rounding half up)
Home Currency Amount Rounding: Home Currency Amount without Rounding - Home Currency Amount = 1354.845-1354.85 = -0.005

Home Currency Amount: 1354.85
Home Currency Amount Rounding: -0.005
Reporting Currency: INR
Reporting Currency Rate Date: 15-06-2023
Reporting Exchange Rate: 90.375
Rounding Mode: Rounding Half up

Reporting Currency Amount: (Home Currency Amount + Home Currency Amount Rounding) * Reporting Currency Exchange Rate = (1354.85 + (-0.005)) * 90.375 = 122444.116875 = 122444.12 (Rounding half up)

Reporting Currency Amount Rounding: Reporting Currency Amount without Rounding - Reporting Currency Amount 122444.116875 - 122444.12 = -0.003125

Sample 2: Transaction Currency and Reporting Currency have the same currency. 

Transaction Currency: USD
Transaction Amount: 903.23
Transaction Date: 15-06-2023
Home Currency: CAD
Home Currency Rate Date: 15-06-2023
Home Currency Exchange Rate: 1.5
Rounding Mode: Rounding Half up
Consider default decimal places for all the currencies used in this example is 2.

Home Currency Amount: (Transaction Amount) * Home Currency Exchange Rate = 903.23 * 1.5 = 1354.845 = 1354.85 (Rounding half up)
Home Currency Amount Rounding: Home Currency Amount without Rounding - Home Currency Amount = 1354.845-1354.85 = -0.005

Home Currency Amount: 1354.85
Home Currency Amount Rounding: -0.005
Reporting Currency: USD
Reporting Currency Rate Date: 15-06-2023
Reporting Exchange Rate: 1
Rounding Mode: Rounding Half up

Reporting Currency Amount: Since transaction currency and reporting currency are the same, there will not be any currency conversion calculation. The transaction amount and reporting amount will be the same.  Transaction amount = 903.23 

Reporting Currency Amount Rounding = 0.0000


 

View data for foreign currency conversion

You can access foreign currency conversion data through: