Foreign Exchange worksheet
Use this worksheet to specify foreign exchange rates for the accounts in the Trial Balance.
To access the Foreign Exchange worksheet, on the ribbon, click Account | Trial Balance. In the Trial Balance, click the Foreign Exchange tab. To display hidden columns, right-click a column header and click Reorder Columns.
Column | Description |
---|---|
Entity | Select the entity where the account belongs. This column only displays in consolidated files. |
Account No |
Enter unique account number containing up to 40 alphanumeric characters. |
Name |
Enter an account description to display on the Trial Balance, general ledger, draft financial statements, and all working paper documents that display the account. Click ... to enter an extended account description. |
Type |
Select the type of financial statement where the account will display.
|
Rate Type |
Select the type of exchange rate to use:
|
Opening Rate | Enter the opening foreign exchange rate for the current period. |
Current Rate |
Enter the foreign exchange rate for the current year. |
Prior Year Rate 1-4 | Enter the foreign exchange rate for the selected prior year. |
Budget Rate 1-5 | Enter the foreign exchange rate for the budget year. |
Forecast Rate 1-5 | Enter the foreign exchange rate for the selected forecast year. |