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