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.

  • Balance Sheet (B): The map number is a Balance Sheet item.
  • Income Statement (I): The map number is an Income Statement item.
  • Statement of Cash Flow (S): The map number is a Statement of Cash Flow item.
  • Performance (P): Use the account to calculate Performance Measures.
Rate Type

Select the type of exchange rate to use:

  • Current: Apply the foreign exchange rate of the current active period to the year-to-date balance. Previous rates are ignored. Current is the default foreign exchange rate for Balance Sheet and Performance accounts.
  • Historical: Apply the foreign exchange rate of each period to each period balance, then total all twelve periods. Historical is the default foreign exchange rate for Income Statement accounts.
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.