Skip to main content

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

  1. Advance Payment

    applied on

  2. Exchange RateThis document

  3. Journal Entry

    applied on

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

Exchange Rate1 of 4
Exchange RateEntered

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

Exchange Rate2 of 4
Exchange RateApplied

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

Exchange Rate3 of 4
Exchange RateRevalued

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

Exchange Rate4 of 4
Exchange RateRealised

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.

Mistakes people make with exchange rates

Tick any that happen here.

In ERPNext, and in your system

How ERPNext models it

DocTypeWhat it does here
Currency ExchangeOne 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 SettingsWhere 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 Settingsallow_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 Invoicecurrency 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 RevaluationSubmittable. 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 EntryType 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

SystemNameNote
ERPNextCurrency ExchangeDocType Currency Exchange holds dated rates. Each document stores the rate it was posted at. Exchange Rate Revaluation restates open foreign-currency balances.
TallyRate 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 BooksCurrencies (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 OneExchange Rates and IndexesAdministration > 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.
OdooCurrency 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

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?

An exchange rate decides what a foreign sale is worth in the books, and the gap between the rate at invoicing and the rate at payment is real money. For exporters and importers it is margin that moves after the price is agreed. Whoever keeps the rate table sets the numbers that every foreign-currency report and customer statement rests on.

Reviewed 14 October 2026. All 40 documents: the ERP glossary.

Start with one conversation

One message, call or WhatsApp is enough. Every line reaches the team directly.

Team away now