Consolidated Exchange Rate Automatic Calculation Example
The following is an example of the calculation that NetSuite uses to determine the consolidated exchange rates for subsidiaries with the following hierarchy:
-
U.S. Subsidiary is parent subsidiary, base currency is USD
-
U.K. Subsidiary is child subsidiary, base currency is GBP
The transactions during the period of January for the U.K. subsidiary are listed in the following table:
|
Transaction Date |
Currency Exchange Rate |
Amount |
Posting Account General Rate Type |
|---|---|---|---|
|
January 1 |
2 |
100 GBP |
Average |
|
January 1 |
2 |
300 GBP |
Historical |
|
January 15 |
2.5 |
200 GBP |
Average |
|
January 15 |
2.5 |
200 GBP |
Historical |
|
January 31 |
3 |
300 GBP |
Average |
|
January 31 |
3 |
100 GBP |
Historical |
When you click Calculate at the top of the Consolidated Exchange Rates page, the consolidated exchange rates from the U.K. subsidiary to the U.S. Subsidiary are derived as follows:
-
Current rate uses the GBP to USD rate from the Currency Exchange Rates list as of the end of the period (January 31).
Current rate =3
-
Average rate is a weighted average based on transactions amounts posted to all accounts with a general rate type of Average. The currency exchange rate for each transaction is the GBP to USD rate in effect on the transaction date.
Average rate =(2 ×100 +2.5 ×200 +3 ×300) ÷600 =2.6666667
-
Historical rate is a weighted average based on transactions amounts posted to all accounts with a general rate type of Historical. As for the average rate, the currency exchange rate for each transaction is the GBP to USD rate in effect on the transaction date.
Historical rate =(2 ×300 +2.5 ×200 +3 ×100 ÷600 =2.3333333
The results are the same if you click the calculate icon 
for each subsidiary pair.
In a Transaction saved search that includes consolidated exchange rates values, the values may not match the general ledger impact of these same transactions. The difference is because currency exchange rates are used to determine the general ledger impact of transactions, not consolidated exchange rates. For more information, see Consolidated Exchange Rate Types for Transaction Searches.