Open ERP Forum
   IndexIndex   SearchSearch     RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   RSSRSS   Mailing ListMailing List   Log inLog in 

Financial Journals for multicurrency bank accounts
 
Post new topic   Reply to topic    Open Object Forum Index -> Accounting and finance
View previous topic :: View next topic  
Author Message
Marius



Joined: 29 Oct 2009
Posts: 9
Location: Lithuania

PostPosted: Fri Oct 30, 2009 9:27 am    Post subject: Financial Journals for multicurrency bank accounts Reply with quote

Please someone share your experience, how you create Financial Journals for multicurrency bank account? Is there recommended to have as many Financial Journals, as many you have currencies in your only one Bank account? I.e. one financial journal for EUR, another financial journal for USD, anoter for GBP, and etc.?
Back to top
View user's profile Send private message
hda



Joined: 03 Dec 2007
Posts: 1305
Location: Belgium

PostPosted: Fri Oct 30, 2009 2:56 pm    Post subject: Reply with quote

You can create only one journal with a default currency of your company.
And at the time of payment you can select that bank journal and make payment in any currency,

Accounting entries will be encoded in your default currency which you have defined in journal. and you can see the other currency in which payment was made in accounting entries currency and currency amount field.
_________________
OpenERP=Easier, Adaptable, Affordable, Modular
Back to top
View user's profile Send private message
Marius



Joined: 29 Oct 2009
Posts: 9
Location: Lithuania

PostPosted: Fri Oct 30, 2009 4:00 pm    Post subject: Reply with quote

But if we will have only one bank journal for many currencies, then how this will work with starting and ending balances. I.e. when we will post new bank statement for one day with EUR, USD and GBP transactions within one journal, so ending balance for whole bank account will be calculated according to exchange rates at this date for all three currencies. But next day we will post again new statement, and starting balance must be calculated according to new day’s exchange rate, and this new rate may be different than it was yesterday for ending balance. So, my question would be: is it possible to have bank balances in several currencies within one Cash Financial Journal?

Thanks.
Back to top
View user's profile Send private message
pjkersten



Joined: 17 Nov 2008
Posts: 58
Location: Netherlands

PostPosted: Mon Feb 08, 2010 9:44 pm    Post subject: Reply with quote

+1 for me.

The development of the Account Banking Framework has now touched this area too. Apparently there are multi currency bank accounts which allow amounts in different currencies to co-exist. There is no clear understanding of how OpenERP should deal with this.

In lots of places, OpenERP coerces moves in different currencies to the companies default or some defined secondary currency. This is done using one of two coercion methods: average or current. The problem is that both methods only compute once. The multiple currency scenario calls for a third option: dynamic. Every calculation should be recalculated on review using the latest exchange rates.

On top of that there are is the challenge of reporting: how do you show the real amounts in the various currencies hidden in the system?

At first sight, adapting OpenERP for this looks like domino day - every correction triggers the need for new corrections. Right now I can't oversee the full scope of this.

As multiple currency accounts seem to become the new standard, action is needed. At least 5 member states of the EU are already affected by this.
_________________
Pieter J. Kersten
EduSense BV
http://www.edusense.nl
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    Open Object Forum Index -> Accounting and finance All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum