Multi-Currency Setup
If you will be dealing with customers or vendors who use currencies other than your base (domestic) currency, use the following process to set up exchange rates and other multi-currency features.
-
Make sure the general ledger accounts specific to currency exchange are set up in the Chart of Accounts:
- Realized Gain
- Realized Loss
- Unrealized Gain
- Unrealized Loss
- A/R Unrealized Offset
- A/P Unrealized Offset
- V/P Unrealized Offset
If you are not using Unit Code 4 for anything else, you might want to set Unit Code 4 to Accessible for these accounts, and use it for reporting the foreign currency impact of the different currencies. If you do this, the currency codes must be entered for Unit Code 4. For information about setting up unit codes, see Account Unit Code (1-4).
- Set the Domestic Currency on the Multi-Currency Parameters form.
- Set up currency and exchange rate variance accounts for the domestic currency and the Euro, to help you track realized and unrealized gains and losses due to exchange rate changes. These accounts should match the ones you set up in step 1.
- Also on the Multi-Currency Parameters form, specify whether to allow currency exchange rate overrides. If allowed, specify the type and amount.
-
Set up all other required currencies used by your vendors and customers in the Currency Codes form.
For each currency code, the unrealized and realized G/L accounts specified on this form default to the accounts set up in the Multi-Currency Parameters form. You can also designate expenses by currency code if you use unit code 3 or 4.
- Use the Currency Rates form to enter exchange rates between all currencies you set up in step 3 and the To currency. On the Currency Rates form, the To Currency field is typically your domestic currency.
- Use the Bank Reconciliations form to set up bank codes and accounts to use with foreign currency customers and vendors. The bank reconciliation, attached to the bank code, maintains a record of all receipts and payments for each currency/bank code. If you will be recording A/R or A/P payments in foreign currencies, you should set up the foreign bank codes (with applicable currency codes) on the Bank Reconciliations form. Then you can include those foreign bank codes on customer and vendor records.
- Use the Customers and Vendors forms to set up foreign currency customers and vendors.
- Optionally, you can use the Currency Codes tab on the Customers and Vendors forms to add multiple currencies for selected customers and vendors. These currencies can then be used as needed for the customer/vendor transactions.
- If your system will share currency information between multiple sites, set up Replication Rules for the Shared Currency replication category.
- Enter foreign currency customer orders and purchase orders. To see the amounts translated to your domestic currency, use the associated Domestic Currency forms.
- Periodically, update the exchange rates and run the Currency Revaluation Report. This utility uses the current exchange rate (from the Currency Rates form) to determine gains and losses due to currency fluctuations.
- Multi-Currency Overview
- Using Currency Exchange Rate Overrides
- Setting Up the Euro Currency Code
- Domestic Currency
- Euro Currency Overview
- How the System Handles Multi-Currency Transactions
- Converting the Domestic Currency to the euro
- Creating Customer Orders and Invoices in Foreign Currencies
- About Currency Conversions for Transfer Orders
- About Realized and Unrealized Gains and Losses