Currency Exchange Rates
After you have created currency records in NetSuite and defined a base currency, you need to set up exchange rates between the base currency and foreign currencies to apply to transactions. If you 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. For information about this page, see Currency Exchange Rates List Page.
You can update to exchange rates four ways.
-
You can manually update a rate between two currencies by adding a new rate for the same two currencies with a different effective date. See Updating Rates in the Currency Exchange Rates List.
-
You 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. See Currency Exchange Rate Integration.
-
You 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. See Currency Exchange Rates Import.
-
You 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. See Setting Exchange Rates Directly on Transactions