SECTIONSRate Tables Overview
A rate table defines the conversion rates between different planning units across dimension values. For example, you can use a rate table to store the exchange rate for different currencies against the nominated base currency over consecutive periods. The rate table has the required operating currencies on separate rows and then the relevant periods as columns. For each currency and dimension value combination, the entered rate determines the amount that can be exchanged for one unit of base currency. For example, if the exchange rate for EUR/USD is 1.13, this means that one euro can be exchanged for 1.13 US dollars.
You can create rate tables from scratch, selecting the desired planning units and dimension values, before entering the conversion rates in each cell. For this creation method, you have the ability to import external rate table data from a spreadsheet during initial setup and for subsequent updates. Alternatively, you can generate rate tables using a data source linked to Analytics. You can also clone an existing rate table. The new copy retains all associated attributes, which you can then edit.
The following example shows a rate table with two planning unit currencies stored on separate rows. The applicable exchange rates appear under the corresponding dimension values, which represent the accounting periods within a financial year.
| Financial Year | 2025 | |||||
|---|---|---|---|---|---|---|
| Period | 01 | 02 | 03 | 04 | 05 | 06 |
| Unit | Rate | Rate | Rate | Rate | Rate | Rate |
| EUR | 1.13 | 1.12 | 1.14 | 1.17 | 1.16 | 1.17 |
| GBP | 1.29 | 1.33 | 1.35 | 1.36 | 1.34 | 1.35 |