Sample calculation of home currency and reporting currency
This reference provides samples of home currency and reporting currency calculcation.
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