Odoo’s multi-currency system

Overview

Choosing to use the multi-currency option in Odoo will allow you to send sales invoices, quotes and purchase orders or receive bills and payments in currencies other than your own. With multi-currency, you can also set up bank accounts in other currencies and run reports on your foreign currency activities.

Configuration

Turn on multi-currency

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

../../../../../_images/works01.png

Exchange Rate Journal

The Rate Difference Journal records the differences between the payment registration and the expected amount. For example, if a payment is paid 1 month after the invoice was issued, the exchange rate has probably changed. The fluctuation implies some loss or profit that are recorded by Odoo.

You can change it in the settings:

../../../../../_images/works02.png

View or edit rate being used

You can manually configure the currency rates in Configuration ‣ Currencies. Open the currencies you want to use in Odoo and edit it. Make sure the currency is active.

../../../../../_images/works03.png

Click on View Rates to edit it and to see the history :

../../../../../_images/works04.png

Click on Create to add the rate. Fill in the date and the rate. Click on Save when you are done.

../../../../../_images/works05.png

Live Currency Rate

By default, the currencies need to be updated manually. But you can synchronize it with Yahoo or the European Central Bank. In Configuration ‣ Settings, go to the Live Currency Rate section.

Choose the interval : Manually, Daily, Weekly or Monthly. You can always force the update by clicking on Update Now. Select the provider, and you are set !

../../../../../_images/works06.png

Note

Only the active currencies are updated

Configure your charts of account

In the accounting application, go to Adviser ‣ Charts of Accounts. On each account, you can set a currency. It will force all moves for this account to have the account currency.

If you leave it empty, it means that it can handle all currencies that are Active.

../../../../../_images/works07.png

Configure your journals

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.

../../../../../_images/works08.png

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.

../../../../../_images/works09.png

How is Odoo’s multi-currency working?

Now that you are working in a multi-currency environment, all accountable items will be linked to a currency, domestic or foreign.

Sales Orders and Invoices

You are now able to set a different currency than the company one on your sale orders and on your invoices. The currency is set for the whole document.

../../../../../_images/works10.png

Purchases orders and Vendor Bills

You are now able to set a different currency than the company one on your purchase orders and on your vendor bills. The currency is set for the whole document.

../../../../../_images/works11.png

Payment Registrations

In the accounting application, go to Sales ‣ Payments. Register the payment and set the currency.

../../../../../_images/works12.png

Bank Statements

When creating or importing bank statements, the amount is in the company currency. But there are now two complementary fields, the amount that was actually paid and the currency in which it was paid.

../../../../../_images/works13.png

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.

Exchange Rate Journal

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

../../../../../_images/works14.png

Warning

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.