Adjust and close · step 2 of 5
Exchange Rate
An exchange rate is the number of units of the company's own currency that one unit of a foreign currency is worth on a stated date, used to convert foreign-currency amounts into the currency the books are kept in.
Why it exists: Because a business that buys or sells in other currencies still has to keep one set of books in one currency, and the price of converting between them changes every day.
Where it sits
Exchange RateThis document
Adjust and close: Advance Payment → Exchange Rate → Journal Entry → Fixed Asset → Cost Center
How an exchange rate moves through its life
Four states. Pick one to see what an exchange rate is, and what it can still become.
A dated rate for one currency pair is saved in the rate table, by hand or fetched from a service.
Then: Applied
A dated rate for one currency pair is saved in the rate table, by hand or fetched from a service.
Then: Applied
Documents posted on or after that date, until a newer rate exists, take the rate and keep it.
Then: Revalued
Documents posted on or after that date, until a newer rate exists, take the rate and keep it.
Then: Revalued
At a period end, open foreign-currency balances are restated at a new rate and the unrealised gain or loss is booked.
Then: Realised
At a period end, open foreign-currency balances are restated at a new rate and the unrealised gain or loss is booked.
Then: Realised
When the foreign amount is settled, the difference between the booking rate and the settlement rate is booked as a realised gain or loss.
Ends here
When the foreign amount is settled, the difference between the booking rate and the settlement rate is booked as a realised gain or loss.
Ends here
Rules that must hold, and what breaks them
Rules
- A foreign-currency amount is kept twice: in the currency it was agreed in, and in the company currency at the rate of its posting date. The rate stays with the document and does not change afterwards.
- A rate belongs to a date, and a document takes the latest rate on or before its own date, never a later one.
- A gain or loss from a rate change goes to its own account and is never netted into sales or purchases. ERPNext keeps one account for the difference realised when a foreign amount is settled and another for the unrealised difference that a revaluation books on balances still open.
Does this happen in your business?
Tick what you recognise. Each tick shows what it costs.
Tick any that happen here.
In ERPNext, and in your system
How ERPNext models it
| DocType | What it does here |
|---|---|
| Currency Exchange | One row for each date and currency pair: date, from_currency, to_currency, exchange_rate, and for_buying and for_selling flags. From and to cannot be the same, and the row must apply to buying or selling. |
| Currency Exchange Settings | Where ERPNext fetches a rate when the table has none: an API service, with its endpoint and the key of the result. It can be disabled. |
| Accounts Settings | allow_stale (Allow Stale Exchange Rates, on by default) lets a document use the latest saved rate however old it is. With it off, stale_days limits how old a rate can be. |
| Sales Invoice | currency and conversion_rate (labelled Exchange Rate) fix the company-currency amounts at posting. Payment Entry has a source and a target exchange rate, and each Journal Entry Account row has an exchange_rate. |
| Exchange Rate Revaluation | Submittable. For a company and posting date it lists foreign-currency accounts and parties with the current and the new rate and the gain or loss, and makes a Journal Entry of type Exchange Rate Revaluation to the company's Unrealized Exchange Gain/Loss account. The company can create it automatically, daily, weekly or monthly (off by default). |
| Journal Entry | Type Exchange Gain Or Loss is the system-made entry for a realised difference, posted to the company's Exchange Gain/Loss account. |
What other systems call it
| System | Name | Note |
|---|---|---|
| ERPNext | Currency Exchange | DocType Currency Exchange holds dated rates. Each document stores the rate it was posted at. Exchange Rate Revaluation restates open foreign-currency balances. |
| Tally | Rate of Exchange (on the Currency) | Set on the currency master by date, and alterable during entry. Forex gain or loss is recorded with a journal voucher, and shows as Unadjusted Forex Gain/Loss in the Balance Sheet until then. |
| Zoho Books | Currencies (with Base Currency Adjustment) | Settings > Currencies holds the base currency and exchange rates. Accountant > Currency Adjustments revalues open foreign-currency transactions. Multi-currency invoicing is plan-dependent. |
| SAP Business One | Exchange Rates and Indexes | Administration > Exchange Rates and Indexes. Rates are set for each currency and date, and one fixed rate can be set for a date range of up to a month. |
| Odoo | Currency rates (Multi-currency system) | Accounting > Configuration > Currencies > Rates, by hand or updated daily, weekly or monthly. Exchange differences post to a dedicated journal with gain and loss accounts. |
From each maker's own documentation, checked 13 October 2026. A dash: not confirmed.
Where an exchange rate connects
More terms it connects to
Each one opens that term.
Questions about exchange rates
The one most people ask is answered first. Type to find the rest.
What does an exchange rate mean for the business?
- A pegged currency, quoted through the currency it is pegged to. ERPNext can convert through a pegged-currency table instead of asking for a direct rate.
- Tiny residual balances. A revaluation treats a balance below a rounding allowance (0.05 by default in ERPNext) as zero, so cents left by rounding do not keep an account open.
- An advance received at one rate and invoiced at another. The difference is realised when the advance is applied, not when the invoice is raised.
- A rate that is missing for the day. By default ERPNext uses the latest saved rate however old it is, and switching Allow Stale Exchange Rates off limits that to a set number of days.
- A corrected rate saved later for an old date. Documents already posted keep the rate they were posted with, so the correction does not restate them.
Reviewed 14 October 2026. All 40 documents: the ERP glossary.