Accounting: Configuration: Multi-Currencies

Purpose

This document will walk you through the uses and processes associated with using foreign currencies in Odoo 13 and how it affects your accounting.

Processes

To get started, navigate to the Accounting app.

Odoo CMS - a big picture

Configuring the Use of Multi-Currencies

To enable the use of multi-currencies, go to Configuration > Settings

Scroll down to the Currencies section and check the box next to Multi-Currencies. Once this has been selected, several more options will become available.


Multi-Currencies

  •   Activate Other Currencies: This link allows you to enable and modify preconfigured currencies in Odoo, or create a new one. Don't click this yet, we'll cover it in the next section.

  • Exchange Gain or Loss Journal: Select the journal that will track gains and losses due to currency rate fluctuation.

Automatic Currency Rates: Enable this for easy upkeep of currency rates. There are 4 additional fields when this is selected.

  • Service: Select the data provider that you want the current currency exchange rates to be retrieved from. 

  • Interval: Select the frequency the currency rates will be retrieved and updated.  

    • Manually: If this is selected, then the currency rates will not be updated until the  button beside Next Run is clicked. 

    • Daily: If this is selected, Odoo will schedule a task and fetch the currency rates once each day.

    • Weekly: If this is selected, Odoo will schedule a task and fetch the currency rates once each week.

    • Monthly: If this is selected, Odoo will schedule a task and fetch the currency rates once each month.

  • Next Run: Date field which can be used to manually choose the next date to retrieve the currency rates. 

Once you've made your selections, click Save

Activating Additional Currencies

To select the currencies that you want to begin using, navigate to  Configuration > AccountingCurrencies

You will see a list of all Active currencies. To activate an additional currency, you'll first need to remove the Active filter from the search bar by clicking the  on the Active tab.


Now, all active currencies will display in black and all inactive currencies will display in gray.


Once the filter is cleared, type in the three-character currency code for the currency that you want to start using (e.g. USD, CAD, AUD, JPY).

Click to open the currency from the results.

Odoo CMS - a big picture

Within the record, click Edit, then tick the checkbox next to Active, then click Save.  


Manually Altering Currency Rates

To manually set a currency rate, navigate to  CONFIGURATION > AccountingCURRENCIES, then click the currency from the list that you want to modify.

If the currency isn't active, be sure to tick the box next to Active, then Save.

Next, click the  Rates smart button in the top-right of the currency details page. 


This will take you to a list view of all rates entered for this currency. To add a rate, click Create.

Odoo CMS - a big picture

Enter the date of the currency rate and the rate itself. When ready, click Save.

Odoo CMS - a big picture

Additionally, you can import rates from a CSV or Excel file by clicking the Import button.

Invoicing with Multi-Currencies

In the top menu select Customers > Invoices, then click Create to start a new invoice.

First, select a Customer, then select a Currency from the drop-down before you add any products.

Important!

If you have products on the invoice before changing the currency, you'll need to remove and re-add those products to get the appropriate exchange.


When finished, click post.


Next, click the Register Payment button. On the payment modal, you can change the currency by selecting the drop-down next to the Payment Amount field.


Once you change the currency, the payment amount will automatically update to reflect the correct amount in the new currency.


When ready, click Validate.

Multi-Currencies and their Accounting Impact

If the exchange rate changed between the time the invoice was generated and the time the invoice was paid, Odoo will record the difference in the Journal you selected when enabling Multi-Currency.

In the following example, our Sale Order was created in Canadian Dollars (CAD) on 02/18/2020. 

Odoo CMS - a big picture

Our customer then paid the open invoice on the very next day in CAD.


It just so happens that the CAD exchange rate dropped by a small amount in the interim, so let's see what this looks like in the Journal Entries.

Next, we'll navigate to Accounting > MiscellaneousJournal Entries and filter for the Exchange Difference Journal. We can see the new entry which recorded the small difference. 

We'll click that entry to see more details.


Within this entry, you can see the difference was debited to Account Receivable and it was credited to the Foreign Exchange Gain account, thereby balancing the accounts. 


Good to Know!

When entering Invoices or Journal Entries in the past, the historic currency information in your Odoo database will be used in an attempt to make the currency conversion more accurate.