Skip to Content
This question has been flagged
multicurrencyaccountsmulticompany
1 Reply
6689 Views
Avatar
Chris TRINGHAM

My understanding is that the standard solution for consolidation in v11 is to select multiple companies in the Financial Reports (e.g. P&L).

This works well if they are all in the same base currency, but if not then the current exchange rate is used to convert to the base currency of the company (could be the parent but doesn't have to be).

This does not seem to be correct.  I believe that it should either use the actual rate at the time of the transaction or some other fixed rate (e.g. average rate for the period).

Does anyone have experience of doing consolidation in a multi-company environment with different base currencies?  Any good ideas?

Avatar
Discard
Avatar
Ray Carnes
Best Answer

The rate used is the rate on the day that the conversion takes place.  This means you are seeing unrealized gains or losses on your reports, always using the latest daily exchange rate.

If it used the rate of the date of the transaction, you would not see the potential value of assets as if you sold them "today".  If you want to see how much of the other currency you hold in your bank, switch to that company's currency.

Avatar
Discard
Related Posts Replies Views Activity
No Account Currency field in Chart of Accounts
multicurrency accounts
Avatar
Avatar
1
Jul 17
5814
Setting Default Currency and Invoice Currency in Odoo: EURO for Company, RON for Invoices
multicurrency invoice multicompany
Avatar
Avatar
Avatar
2
Mar 24
2509
Multi Currency Bank Accounts Opening Balances
multicurrency accounts bank
Avatar
0
Sep 21
3603
Timesheet entries with Multi company
multicurrency timesheet multicompany
Avatar
Avatar
1
Aug 21
4306
Multi Company Websites- Currency error
multicurrency multicompany multiwebsite
Avatar
Avatar
2
Apr 20
4057