Menu
This question has been flagged
3 Trả lời
6696 Lượt xem

If I have three companies, can I create a profit and loss for the overall group, with adjustments that eliminate any cross/intercompany transactions?

Ảnh đại diện
Huỷ bỏ

this apply to support enterprise edition right

Best Answer

Yes.

You can use the Consolidation App to create financial statements based on mapping accounts from different companies.  You can even import trial balances from other financial systems and consolidate Odoo and non-Odoo company information.

The App streamlines the process of accounting consolidation between different companies and supports advanced features such as:

  • multiple periods and sub-periods

  • groups and subgroups (like a standard financial report) to roll up balances

  • restating based on several currency conversion methods - closing rate, average rate and historic rate (actual rate)

  • flexible ownership / control scenarios - when less than 100% of a company's balance or income needs to be consolidated

  • quick account mapping when charts of accounts are not identical between companies

  • ability to exclude accounts and/or entire journals so intercompany transactions are pre-eliminated

  • multiple adjustment columns (not impacting the GL) to further modify the consolidated balances, add late information, etc.

  • sub consolidations for complex multi-tier, parent/child/grandchild or peer/subsidiary business unit organizational structures

  • quick re-calculation if any of the underlying ledger data is updated

  • ability to define consolidations prior to having audited underlying financials

  • exportable to Excel with a single click

For more information, see https://www.youtube.com/watch?v=mL3J87SnWGw

Ảnh đại diện
Huỷ bỏ

Hello Ray, Do you also know how to consolidate on analytical accounts. I can't seem to find how to do that.
Thanks for your reply,

Analytic Accounts are not part of the Consolidation App.

Best Answer

4 years later and the Consolidation app is still very bad! nothing is improved. The issues mentioned from other users remain. When it comes to analytic accounting (cost centers), multi-companies and consolidation, Odoo is not a good solution unfortunately. It is for small companies and not for Groups.

Ảnh đại diện
Huỷ bỏ
Best Answer

Just to add some comments here:
ODOO-consolidation is NOT eliminating IC-issues. It is "leaving them away". Sounds the same, is a big difference. Account matching is a "little desaster" due to several reasons. 
Also there is no IC-reconciliaiton-feature in front. So you just leave away IC-accounts and hope, everything was fine.
Currency-Conversion is very limited too, as it is not calculating currency-translation diffrences (shown in Other Comprehensive Income accoring to IFRS). 
Therefore, the Balance Sheet will not be balanced!!! Asset <> Equity & Liabilities!!!
Of course you can do some manual "adjsutments" which are, at least in Germany" notliked this way, as these are "one-sided" adjustments.
Conclusion: Odoo offers a nice Management Consolidation, but NO Legal Consolidation how an accountant would expect it (I can only tell how it is in Germany and most parts of EU, though)

Ảnh đại diện
Huỷ bỏ

Sorry, I have the following error "Since `False` is a non-IC entity, you have to select a non-IC account." when I want to publish an accounting entry, could you tell me what are the IC accounts?