Community mailing list archives

Re: Journals, accounts and foreign currency

Eva Pinter
- 05/13/2015 06:35:34
Hello Mohamad,

Thanks for the detailed explanations.

My remarks are

1. I may have an account in EUR, but the customer pay me in USD. I should be able to register the payment without having to create a new payment method and a new account. I should also be able to register the exchange rate at which the transaction took place. This is not possible in odoo. I have to maintain another GL account and another journal. Then, I need to create a hiearchy to be able to see the balance on this journal and see, if it matches my bank balance. Sounds to me like a lot of work. Not if you have 1 transaction every 14 days, but if you have a multicurrency company like a trader.

2. My problem with the foreign currency is that I need to be able to maintain all my transactions in the foreign currency. It’s then not logical for me, to enter the debits and credits in local currency and to add the currency (on each line first, what should not be allowed) and then to have to enter the foreign currency amount as + and -.
What I would like is to valuate my balance at the end of the month and not have exchange done on a daily basis (not even automatically), but manually.

3. If I have a foreign currency account and I cannot reconcile in foreign currency, I have non real exchange rate gains and losses daily. This is quite difficult to explain, due to the fact that I have done the exchange once and then was using the foreign currency. This is changing my results, without being real. I will check if this is GAAP compliant, but I have my doubts…If someone knows, please confirm that it’s ok to have it this way.

4. Between the currencies and the clearing accounts, I have to create 30 journals. Does this sound like a nice thing to do and manage on a daily basis? In SAP, I have 1 clearing account per GL account representing a bank. I do not need to create a journal and certainly, I do not have to select in a list of 30 journals the payment method. I just select the account and it’s done. Now, if I have a multi-company system, I have for each company another 30 journals. Is it really working? 2 companies and 60 journals only for payment and currency management?

5. See point 1. Problem is not solved.

Now, I have a very complex structure in order to manage just the payments with different payment methods and in different currencies. I would say, for me, it does not do the job properly. It’s complex and slow to use on a daily basis, if you have to deal with multicurrency.

If anyone has enhanced these very points, I would be happy to have a look into it.

Eva P.

Affordable high quality training on

On 13 May 2015, at 09:07, Mohammad Alhashash <> wrote:

On 13/05/15 00:21, Eva Pinter wrote:
<blockquote cite="" type="cite">

Hi all,

I wanted to know if I am doing something wrong with the journals, accounts and foreign currency

1. It’s not possible to pay (using the menu point pay) in a foreign currency if you do not have a journal in that currency.
Te be able to own or handle foreign currency, you need to have a bank account or cash register in this currency. Bank/Cash accounts in Odoo are represented by a journal of type "Bank and Checks" or "Cash" and the associated financial account with internal type "Liquidity". The financial account must be set as the default debit/credit account of this journal.
<blockquote cite="" type="cite">
2. If you want a journal in a foreign currency, you need to have an account in that very currency.
This is not enforced technically (I think so but I did not to verify it). Note that you use any currency with accounts without secondary currency. When you set a secondary currency on account it, enforces that any transaction must include the amount in that currency. So account secondary currency is actually a constrain.

Also, any account can be used in any journal unless it is restricted by the journal control option.

<blockquote cite="" type="cite">
3. Even with an account in foreign currency, you cannot reconcile in foreign currency. The reconciliation is always done in the local currency, creating so exchange differences on each and every single reconciliation.
Currently, manual reconciliation works on the company currency, so, it does not match amounts in foreign currency or create exchange gain/loss entries; you have to create it manually or use write-off during reconciliation..

For example, If your company currency is USD and you registered a 1000EUR supplier invoice at 1250USD equivalent. Later, you paid 1000EUR at 1100USD equivalent. If you paid using a voucher (Supplier Payment or used the "Pay" button on invoice), the exchange gain will be recorded. But, if you did not reconcile in the voucher and used the manual reconciliation later, you would see the 1250USD due amount and the 1100USD payment. You can select both lines and choose "Full reconcile with write-off" in the wizard. You should select the exchange gain account as the write-off account. Another option is to create a manual journal entry for the 150USD gain (with 0.00EUR eq.) to reconcile the 3 lines in the payable accounts (1250 Cr., 1100 Dt, and 150 Dt.)

<blockquote cite="" type="cite">
4. If you have an approval concept and use a temporary account on which you first post the payment until the bank/credit institute confirms it, you have to create a corresponding journal and account.
This is called "Clearing Accounts", you can do this. Actually, this is the standard way of handling bank accounts in most other ERP systems. For example, In SAP, usually there are 3 clearing accounts for each bank account.

<blockquote cite="" type="cite">
5. If you have multiple payment institute (typically: bank, postbank, paypal, AFEX, FOREX) and work in 3 currencies (EUR, GBP, USD), you will then have to create for each payment institute a 6 GL accounts and 6 journals. So, in my case, 30 GL accounts and journals.
Yes. Note that each bank will create a separate bank account for each currency and will issue different statements for each. Also, it may be legally required (or at least it is the standard accounting practice) to have a separate account and journal for each bank account.

You should organize your accounts in a tree structure. For example, create a view for each currency, then a view for each bank account, then under the bank view, create the bank and clearing accounts.


Mohammad Alhashash

Post to: