After we have created currency records in NetSuite and defined a base currency, we need to set up exchange rates between the base currency and foreign currencies to apply to transactions. If we use NetSuite OneWorld and defined a different base currency per subsidiary, set up different exchange rates between each base currency and its foreign currencies. Exchange rates for a base currency apply to all subsidiaries that use the same base currency.
Currency exchange rates are used to convert foreign currencies to base currencies, providing default rates for transactions in currencies other than the base currency. Exchange rates are expressed in terms of base currency units per foreign currency (source) unit.
Exchange rates are stored in the Currency Exchange Rates list page at Lists > Accounting > Currency Exchange Rates.
We can update exchange rates in four ways.
- We can manually update a rate between two currencies by adding a new rate for the same two currencies with a different effective date.
- We can set a rate to be automatically updated one time each day by the Currency Exchange Rate Integration feature. Currency Exchange Rate Integration does not overwrite a rate if one is already stored for the same currency pair and effective date.
- We can use the Import Assistant to import currency exchange rates from an external system. The exchange rate values must be in a CSV file to import them into NetSuite.
- We can set the exchange rate on the individual transactions. The default exchange rate for transactions is determined by one of the other methods of setting and updating exchange rates.