Enter foreign exchange rates
You can enter foreign exchange rates for a single or multiple period file. In multiple period files, the exchange rates for fiscal periods can be separate from their sub-periods, even if the period is based on its sub-periods as defined in the Engagement Properties. For example, the foreign exchange rate set for the first quarter of a year may be different from each month in that quarter and from the exchange rate for the year.
To enter foreign exchange rates for a single period:
- On the ribbon, click Account | Trial Balance.
- In the Trial Balance, click the Foreign Exchange tab.
- Enter the opening and year-to-date rates in their applicable columns.
- (Optional) Repeat the process for additional columns (Prior Rates, Budget Rates, Forecast Rates, etc.).
The foreign exchange rates are set for the period.
For multiple period files, the reporting period date sequence in the Engagement Properties must be monthly, quarterly, or semi-annual.
To enter foreign exchange rates for multiple periods:
- On the Navigation toolbar, click the Period Context Selector and select a period date sequence.
- On the ribbon, click Account | Trial Balance.
- In the Trial Balance, click the Foreign Exchange tab.
- In the Current Rate column, enter the appropriate foreign exchange rates for each period of the period date sequence.
- Repeat the process for additional columns (Prior Rates, Budget Rates, Forecast Rates, etc.).
The foreign exchange rates are set for the period. Repeat the process for different period date sequences by changing the selection in the Period Context Selector.
Notes:
- To properly view translated balances, you must select Foreign Exchange in the document's properties.
- Split-up accounts automatically use the foreign exchange rates of their parent accounts for applicable calculations and balances.
- Consolidated files are likely to have foreign exchange rounding variances. To offset this rounding variance, create a foreign exchange rounding difference account in each entity and repost all entries by selecting Tools | Repair File | Repost all Entries.
Specify a Foreign Exchange account
You can specify an account to represent the exchange differences that arise from foreign currency transactions or translations.
To specify a Foreign Exchange account:
- On the ribbon, click Account | Trial Balance.
- On the Account worksheet tab, click Settings. The Settings for Reports dialog displays.
- In the Foreign Exchange drop-down menu, select a foreign exchange rounding difference account. Click OK.
The Foreign Exchange account is specified.