Adding new exchange rate tables
Typically, you add a new exchange rate table for every fiscal period. The quickest method for adding an exchange rate table is to copy an existing table and select a new effective fiscal period.
To add a new exchange rate table
- In the Administration navigation pane, select Financial Settings > Exchange Rate Tables.
- In the Exchange Rate Tables pane, click Copy in the row of the latest exchange rate table, or click New.
The Copy Exchange Rate Table or New Exchange Rate Table pane appears, similar to the following figure:

The values in an exchange rate table are the multipliers to convert the currency in that column to the book currency for costs that have accrued during the fiscal period represented by the row. Any cell that contains <default> inherits its value from the cell above it. The first row of any exchange rate table must contain numerical values, because there are no preceding cells from which to inherit the values. - From the Effective Fiscal Period lists, select the fiscal period and year.
These selections become the name that identifies this table. - Enter the current conversion rates.
Click Save and Refresh Cache to save your entries.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*