If I have three companies, can I create a profit and loss for the overall group, with adjustments that eliminate any cross/intercompany transactions?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
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
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.
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.
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)
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?
this apply to support enterprise edition right