Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Artificial Intelligence
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Property Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

multicompany accounting

Subscribe

Get notified when there's activity on this post

This question has been flagged
accountingmulticompanyodoo9
5 Replies
18769 Views
Avatar
samer alsarhan

Greeting All,

I am working on project for my company and multi company is part of the project after I configure all the companies now i need to generate a Consolidating financial accounting report (balance Sheet and Profit & Loss) report dose any one has an idea how to achive that.

0
Avatar
Discard
Ray Carnes

Which version? If v9, which edition?

Avatar
Best Answer

here is the method

1-you must create a chart of accounts for the parent company.

2-change the type of accounts to consolidation, a new field will appear which is consolidated children.

3-fill the new field with the child accounts (which will be consolidated in the parent account) from the child companies.

4- after saving all the work with all the accounts, you can check the parent company COA, and you will find the data consolidated into every account with values.

1
Avatar
Discard
Avatar
michel Guénard
Best Answer

The consolidated set of account is meant to report the financial statement of the group of companies as if there is one single company that makes businesses with the rest of the world

May I recommend you to study the consolidation accounting process (or be helped by an accountant); because the consolidaton is not a trivial process:

for instance

all intercompany transactions and intercompany margins need to be eliminated ( keeping only the transactions with the "outside world")

a common currency (and conversion rates) need to be decided for the consolidation of the group companies' operations; so that each company records its operations in the common group currency in addition to the local records kept in local currency. Only the operations recorded in the group currency will be elected for the consolidation

a common chart of account for all companies

you also have to take into consideration the % of capital that the parent company holds into each other companies (not to speak from capital holdings between the daughters companies themselves); 


In summary: the consolidation is not the addition of the transactions of all companies belonging to the same group

1
Avatar
Discard
Avatar
Alexander
Best Answer

Hi Michel, I fully agree …! and would like to understand the best approach to multi-company consolidation in Odoo. So I have following questions;


  • Is there a tool / process to assist and make it easy to do inter-company elimination of internal-invoices?

  • Does it make sense to create a “Consolidation Company” for consolidation entries as eliminations, PUP, etc. and “Group Reporting”.

  • Is there a way to define “consolidation accounts” which can be used to roll-up different accounts from group companies into a group reporting chart of accounts (in v10)?


Hints and pointers to best practice would be greatly appreciated!


(Note, I am not sure if you would want to use the Group Parent as the Consolidating Company, this is because the Parent must also provide it own legal reports and also because you would need to make some adjusting entries to reflect the Consolidated Accounts.)


Thanks!

Alexander

1
Avatar
Discard
Avatar
Kinner Vachhani
Best Answer

The consolidated COA, would it work for multi currency multi company? 


0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
odoo 9 Multi-company shared product account configuration Solved
accounting product multicompany odoo9
Avatar
Avatar
Avatar
2
Feb 17
5427
Multi-Company Setup with Shared Accounting in Odoo Solved
accounting multicompany
Avatar
Avatar
1
Sep 24
5258
Multiple User Signature for each Company
multicompany odoo9
Avatar
Avatar
Avatar
2
Oct 23
7361
Treatment of branches and multi-company, version 14:
accounting multicompany
Avatar
Avatar
1
Aug 22
4513
Balance Sheet Report Broken
accounting odoo9
Avatar
0
Dec 16
5390
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk Slovenščina Español (América Latina) Español Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now