This question has been flagged
2 Replies
6033 Views
bankstatementcurrencyratesV12internal-transferEE
Avatar
Lars Aam

How to register a transfer from one bank account in NOK to another in EUR, when the bank uses a different currency exchange rate than in Odoo.  Company currency is NOK.

The bank will always use a currency exchange rate less favourable for us, than the official rate used in Odoo. (Odoo automatic update from ECB).  

I can register correctly with a direct Journal entry.  Then I can see the what Odoo calculate as exchange rate and post the difference directly. The problem is that this entry will not come up in Bank statement reconciliation. Then I cannot close my bank statements

If I use the function for Payment -> Internal transfer, I cannot modify the value in the receiving account.  I am stuck with this issue.


Avatar
Discard
Avatar
Roger Brugger
Best Answer

I have the same issue. Any updates? 

Avatar
Discard
Avatar
Chris TRINGHAM
Best Answer

There seem to be several apps that allow the exchange rate to be changed for payment.  Would any of them be useful?

https://apps.odoo.com/apps/modules/browse?search=exchange+rate+on+payment 

https://apps.odoo.com/apps/modules/11.0/bi_manual_currency_exchange_rate_invoice_payment/

Avatar
Discard
Lars Aam
Author

Thank you for your input, Chris. These are 3rd party apps and as we are running on Odoo.com we cannot use these.

And - the issue is only related to transfer between two bank account with different currencies. And now I found that this also is an issue in bank reconciliation during import of bank statements.

For purchase and sales in different currencies as well as payments to and from partners, we don't have any problems. Also if customer pay in a different currency, it is easy to manage. The only you need to do is at year end, you should check the balance account and make a year end posting so that your balance sheet show the correct value in company currency according to exchange rates at year end.