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.
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
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.
|
- 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 intoUSD
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)