Record exchange rates at payments


Any company doing international trade faces the case where the payments are in a different currency.

After receiving their payments, you have the option to convert the amount into your company currency. Multi currency payment implies rates fluctuations. The rate differences are automatically recorded by Odoo.


Enable multi-currencies

In the accounting module, Go to Configuration ‣ Settings and flag Allow multi currencies, then click on apply.


Configure the currency rates in Configuration ‣ Currencies. Write down the rate and make sure the currency is active.


In this document, the base currency is Euro and we will record payments in Dollars.



You can automatically fetch the currency rates from the European Central Bank or from Yahoo. Please read the document : Odoo’s multi-currency system.

Configure your journal

In order to register payments in other currencies, you have to remove the currency constraint on the journal. Go to the accounting application, Click on More on the journal and Settings.


Check if the Currency field is empty or in the foreign currency in which you will register the payments. If a currency is filled in, it means that you can register payments only in this currency.


Record a payment in a different currency

In the Accounting application, go to Sales ‣ Payments. Register the payment and indicate that it was done in the foreign currency. Then click on confirm.


The journal entry has been posted but not allocated.

Go back to your invoice (Sales ‣ Customer Invoices) and click on Add to allocate the payment.


Record a bank statement in a different currency

Create or import the bank statement of your payment. The Amount is in the company currency. There are two complementary fields, the Amount currency, which is the amount that was actually paid and the Currency in which it was paid.


When reconciling it, Odoo will directly match the payment with the right Invoice. You will get the invoice price in the invoice currency and the amount in your company currency.


Check the exchange rate differences

Go to Adviser ‣ Journal Entries and look for the Exchange difference journal entries. All the exchange rates differences are recorded in it.



The Exchange difference journal can be changed in your accounting settings.


In order for an exchange difference entry to be created automatically, the corresponding invoices and payments need to be fully reconciled. This means the invoices are fully paid and the payments are fully spent on invoices. If you partially pay 3 invoices from 2 payments, and the last invoice still has an amount due, there will be no exchange difference entry for any of them until that final amount is paid.