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
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.
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