Welcome to Zuora Product Documentation

Explore our rich library of product information

Foreign currency conversion

Convert foreign currencies into your home currency for financial reporting

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.

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.

Note:

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.

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.

Home currency

The home currency, also known as the functional currency, is the currency of the primary economic environment or organization in which an entity operates. It's the currency in which the entity primarily generates and spends cash.

You can have only one home currency for each organization.

Transaction currency

The currency used by the customer account and in which the transaction originates.

Reporting currency

The currency in which a company prepares its financial statements. This currency is often used for roll-up reporting and to present the financial results to stakeholders, including investors, regulators, and tax authorities.

For currency conversion to reporting currency, transaction amounts will first be converted from transaction currency to home currency and then from home currency to reporting currency.

  • For single-organization tenants, the reporting currency can be configured at the Tenant level.

  • For Multi-Organization tenants, it can be configured at the Parent/HQ organization level, and the child organizations will automatically inherit it.

For example, consider a multinational corporation based in the United States. The currency types used in its entire business are explained below:
  • The transaction currency for this organization can be multiple, depending on the currencies in which the organization conducts its sale of products and services.
  • The home currency of its subsidiary in Japan is the Japanese Yen (JPY).
  • The home currency of its subsidiary in Germany is the Euro (EUR).
  • The reporting currency for the entire corporation is the US Dollar (USD), which means all financial statements from its global subsidiaries will be converted and consolidated into USD for reporting to shareholders and regulatory bodies.

Sample home currency and reporting currency calculation

Here are two samples of 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:

  • Summary journal entries;

  • Data source exports

  • Data Query

  • Accounting period Balances tab

  • Revenue detail exports

  • REST API (only for custom rates) .

  • Reporting(if "Reporting Currency FX Data" feature is enabled)