Appearance
Exchange rates
Also known as
- exchange rate
- FX rate
- currency rate
- spot rate
- closing rate
- average rate
- daily rates
- rate table
- conversion
- سعر الصرف
The rate table holds the exchange rates used to convert documents and journal lines into base currency, to revalue open balances and to translate entities in consolidation. Each rate is for a pair of currencies, a type and a date.
Add a rate
- Go to FinanceSettingsExchange rates.
- Select New (needs Permission:
finance.settings.manage). - Fill in the drawer and select Save. A second rate for the same pair, type and date replaces the first.
| Field | Required | What to enter |
|---|---|---|
| From | Yes | The foreign currency, for example EUR. |
| To | Yes | The other currency, usually your base currency, for example USD. |
| Rate type | Yes | Spot (documents, payments), Average (P&L translation), Closing (revaluation, balance-sheet translation). |
| Date | Yes | The day the rate applies from. |
| Rate | Yes | "1 unit of From = rate units of To", up to 10 decimals. |
How rates are found
For a date, the latest rate on or before that date is used. A missing direct pair is derived from the inverse or through the default entity's base currency; Average and Closing fall back to Spot. With no rate at all, posting stops with "No EUR→USD exchange rate on or before …; add one in Finance settings → Exchange rates".
Filter the list by From and Rate type; delete a wrong rate with the bin icon. Load many rates with Import and export (the Exchange rates data).
