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