Skip to Content
This question has been flagged
accountingreportingconsolidationv14
1 Reply
8949 Views
Avatar
Cédric Thiry (cth)

Hello !

Here are the steps to create your first consolidated report with the Consolidation app :

1. Define the scope in Configuration > Consolidation :

  • Target currency of the report

  • Companies to consolidate

2. Build the structure of the consolidated report :

  • Groups and sub-groups

  • Consolidated accounts. If the selected Currency Conversion Method is :

    • Average : Odoo will use the rate you manually defined for each company in the dashboard (https://tinyurl.com/y3yhlkph)

    • Closing : Odoo will use the rate you manually defined for each company in the dashboard (https://tinyurl.com/y247l3r8)

    • Historical : Odoo will use the rate found on the historical rates screen for each company. If the rates are not set during a period, Odoo will use the rate set on each journal entry (https://www.awesomescreenshot.com/video/1360991?key=0247ff01f0ddf223663556cbe15f7192)

  • Mapping between consolidated accounts and general accounts of each company

3. Create the analysis through the dashboard :

  • Period : start date and end date

  • Consolidation rate of each company (= ownership)

  • Journal to exclude from the report (inter-company transactions for example)

For further details you can check this talk : https://www.youtube.com/watch?v=zwBexsSfxt8&t=8s

Best,

CTH

Avatar
Discard
Don Chau

I am doing monthly consolidation. For the retain earning account, it is using the average rate of PL and auto transfer to the Balance Sheet. Each month it has an average exchange rate. What is your logic of the retain earning calculation? Do you capture the 12 month average rate and auto calculate the retain earning? Or I need to manually update that "historical rate" for the retain earning account every month? For the differences between PL and BS, result from the average rate and closing rate. Do you have function to auto generate an entry as exchange reserve? thank you.

Cédric Thiry (cth)
Author

Hello Don Chau,

There is no computation about the average rate. You have to manually set it in the period you defined : https://www.awesomescreenshot.com/image/5525707/66bce97a2786158e5ab8747edc7a4ed6

Best regards,
CTH

Avatar
Ishit Mehta
Best Answer

Hello Cedric,

With the Consolidation historical rate consolidation which rate I have to add the Target Currency rate or the current currency rate?

Analytical Accounts - Filter and Group By are not working with Version 17.


---- Updated Answer -----
There are Two Problems that I am facing with Consolidation.

Problem 1: Analytical Account Filter and Group by, is activated but it is not working with Version 17.0.

Problem 2: We have 17 Countries and 17 Companies with 17 Multi-Currency. We want to use a single FX Rate, for all the currency, when I do Historical Currency on consolidation account and add the exchange rate manually. It is not considering the exchange rate. There are a lot of inter-company transactions between the companies. We want to reflect Inter-company revenue on my Consolidation statement.

I am also posting a URL : https://youtu.be/1Acj18HBBJ4 for the explanation, if required I will perform the flow and can also showcase it to you using a separate video.

Avatar
Discard
Cédric Thiry (cth)
Author

Hello ! Not sure to get your point, what do you want to do ?

Related Posts Replies Views Activity
What content in Python files for report invoice document
accounting reporting
Avatar
1
Apr 25
379
How to perform automatic year-end accounting entries?
accounting reporting
Avatar
0
Mar 25
401
Custom accounting report with account tags Solved
accounting reporting
Avatar
Avatar
2
Jan 25
591
How to show popup warning message but let the python program continue on create method via try and except block?
accounting v14
Avatar
Avatar
1
Jun 24
3247
Accounting reporting: Profit and loss; missing account Solved
accounting reporting
Avatar
Avatar
2
May 24
1071