# Combining & Consolidating Multiple Business Accounts

**URL:** <https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072>\
**Category:** Uncategorized\
**Created:** [June 15, 2016, 8:36pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072 "2016-06-15T20:36:26Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Majik](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@Majik](https://forum.manager.io/u/Majik)\
**Post date:** [June 15, 2016, 8:36pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/1 "2016-06-15T20:36:26Z")

</div>

We are a startup with offices in a number of countries.

We want an accounting system that is nevertheless compartmentalised per country, such that only global officers see the accounts across all our markets/operating-countries (i.e. with the option to combine or consolidated accounts for different countries by the global officers), whilst staff in each country only see the accounts of the specific country they have been assigned.

In essence, we want a multi-user, multi-country, account. Is Manager the right option?

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [June 15, 2016, 9:46pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/2 "2016-06-15T21:46:02Z")

</div>

Currently Manager does have multi-user (server & cloud editions) and multi-business capabilities.  
If your organisation is a single legal entity then Manager has tracking codes function where divisions (countries) can be reported individually or collectively. If your organisation is a multiple of separate legal entities then Manager can cater for them individually, but doesn’t have consolidation of entities currently but it a planned enhancement in the future.

---

<div class="post-metadata">

**Author:** ![Majik](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@Majik](https://forum.manager.io/u/Majik)\
**Post date:** [June 15, 2016, 10:03pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/3 "2016-06-15T22:03:39Z")

</div>

Hi, thanks. The country operating entities are separate legal bodies but with common shareholding. So they all report to group of ‘global officers’. What is needed is the ability of the ‘global group’ to compute income and other results across the country entities thus obtaining a snap shot of the organisation as a whole.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [June 15, 2016, 10:17pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/4 "2016-06-15T22:17:56Z")

</div>

Consolidations aren’t a current feature of Manager but it’s planned in the future. Your only option with Manager would be to export the data and combine within a spreadsheet program.

---

<div class="post-metadata">

**Author:** ![Majik](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@Majik](https://forum.manager.io/u/Majik)\
**Post date:** [June 15, 2016, 10:29pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/5 "2016-06-15T22:29:46Z")

</div>

Might you have a timeline of when this feature might be available as over time data growth will make manual consolidation unbearable.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [June 15, 2016, 10:35pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/6 "2016-06-15T22:35:02Z")

</div>

The Developer needs to answer that question - I’m just a user.

---

<div class="post-metadata">

**Author:** ![Majik](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@Majik](https://forum.manager.io/u/Majik)\
**Post date:** [June 15, 2016, 10:46pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/7 "2016-06-15T22:46:01Z")

</div>

Oh Ok. Thanks.

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [June 16, 2016, 9:00am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/8 "2016-06-16T09:00:55Z")

</div>

Consolidation will probably come the next year. It’s quite complicated feature and it’s not something that is generally supported in other accounting packages anyway. Most companies do consolidation manually.

---

<div class="post-metadata">

**Author:** ![Majik](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@Majik](https://forum.manager.io/u/Majik)\
**Post date:** [June 17, 2016, 12:39am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/9 "2016-06-17T00:39:55Z")

</div>

Hi, in the meantime do you provide API access for something like: [How Qvinci Works – Qvinci Software](http://www.qvinci.com/how-qvinci-works/) ?

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [June 24, 2016, 12:13am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/10 "2016-06-24T00:13:05Z")

</div>

A couple of work a rounds

1. Set up in a spreadsheet a Master BS & P&L which caters for all the chart of account variations and then transpose the data from the respective reports into the columns for each business. This would also allow for a column to enter any intercompany elimination entries - that’s if you are going to worry about that level of detail. (This could be a good practise exercise before considering (2)

2. As with (1) but set up the Master BS & P&L inside a Manager business called Consolidation, “not” the parent business. This business would “only” have the default tabs activated - Summary, Journal, Reports & Settings so there is no complications with Control Accounts. Then via Journal entry transpose the respective reports, possibly utilising the tracking codes feature. The Journals could either be monthly results (via cloning) or cumulative results (via overwriting)

These options would only suit month end reporting - not day to day reporting.

---

<div class="post-metadata">

**Author:** ![adilmallick](https://avatars.discourse-cdn.com/v4/letter/a/3ab097/32.png) [@adilmallick](https://forum.manager.io/u/adilmallick)\
**Post date:** [January 12, 2017, 11:49am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/11 "2017-01-12T11:49:07Z")

</div>

I am trying the Server Edition to setup all my businesses. I have 3 different companies at three different locations, but each of these companies deal with the other 2 - as suppliers and customers. So, I was trying to setup 3 different business, but after creating these companies, the other companies are not visible for me to set them up as supplier and/or customer. Can this be done? Or is there a workaround?

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [January 12, 2017, 12:17pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/12 "2017-01-12T12:17:23Z")

</div>

Each company is a separate data file. When you have one of the company’s open you can add the other companies as Customers or Suppliers via the Customers or Suppliers tab as you would add any other external Customer or Supplier for that business.

---

<div class="post-metadata">

**Author:** ![Condell](https://avatars.discourse-cdn.com/v4/letter/c/edb3f5/32.png) [@Condell](https://forum.manager.io/u/Condell)\
**Post date:** [February 6, 2017, 11:56pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/13 "2017-02-06T23:56:59Z")

</div>

I’m a sole trader/sole proprietor.

I run different businesses all under the same government registration number (so I only submit one income tax return).

But each business has a different name, one has inventory, another is consulting etc etc.

I need to report various activities into a tax return, but not the breakdown by business. If ever I get audited by the tax office, I would then need to show details of each business.

A consolidation feature would be most helpful, especially if it was into a separate consolidated business account?

Quickbooks Enterprise has done this for over 10 years.

I really like your design and simple approach to the program.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [February 7, 2017, 12:35am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/14 "2017-02-07T00:35:50Z")

</div>

Currently your best option in Manager is to create a new master business and then Journal the required balances of each individual business into the master business. You could use the tracking codes in the master business so that you can produce a P&L with both aggregate and each business side by side totals

---

<div class="post-metadata">

**Author:** ![rbt](https://avatars.discourse-cdn.com/v4/letter/r/df705f/32.png) [@rbt](https://forum.manager.io/u/rbt)\
**Post date:** [September 14, 2017, 2:37am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/15 "2017-09-14T02:37:50Z")

</div>

Hi,

If we create a single business and use tracking codes for the branches, is there a way to restrict users to their specific tracking codes/branches?

thanks.

---

<div class="post-metadata">

**Author:** ![ShaneAU](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shaneau/32/10122_2.png) [@ShaneAU](https://forum.manager.io/u/ShaneAU)\
**Post date:** [September 14, 2017, 6:29am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/16 "2017-09-14T06:29:33Z")

</div>

> [@rbt](#):
>
> If we create a single business and use tracking codes for the branches, is there a way to restrict users to their specific tracking codes/branches?

The level of control we have over user permissions is quite powerful, but alas it doesn’t have a distinction between different tracking codes.

Restrictions for users (Cloud/Server Edition) are currently at a number of levels:

- **Business Level** - You can completely hide an entire business from a user.
- **CRUD Level** - You can give someone read-only access, allow them to create but not edit later, or give complete access.
- **Tab/Module Level** - You can completely hide tabs from a user (e.g. only show ‘Reports’, or just ‘Bank Accounts’ and ‘Sales Invoices’).
- **Cash/Bank Account Level** - You can limit certain bank accounts / cash accounts to particular users.

This comment from @Brucanna (above) is probably relevant to you:

> [@Brucanna](#):
>
> If your organisation is a single legal entity then Manager has tracking codes function where divisions (countries) can be reported individually or collectively. If your organisation is a multiple of separate legal entities then Manager can cater for them individually

If your separate parts of the business are separate legal entities, then create them as separate businesses. That way, you’ll also be able to give users access to only specific businesses.

---

<div class="post-metadata">

**Author:** ![Previsam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/previsam/32/18169_2.png) [@Previsam](https://forum.manager.io/u/Previsam)\
**Post date:** [March 25, 2019, 10:00am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/17 "2019-03-25T10:00:37Z")

</div>

how exactly do implement this consolidation stuff using a consolidation business in manager. Please through mo light, a step by step guide would be very helpful. Thanks.

---

<div class="post-metadata">

**Author:** ![Previsam](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/previsam/32/18169_2.png) [@Previsam](https://forum.manager.io/u/Previsam)\
**Post date:** [March 25, 2019, 10:01am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/18 "2019-03-25T10:01:54Z")

</div>

is consolidation available now or how much longer is needed

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [March 25, 2019, 11:57pm UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/19 "2019-03-25T23:57:17Z")

</div>

I’m not planning to implement consolidation of multiple business files. It would be impossible to do it correctly.

What I’m planning to do is improve divisional accounting so you can set for each asset and liability account what division it belongs to so you can get divisional balance sheet where loan accounts between divisions are automatically managed and of course consolidated balance sheet where loan accounts between divisions are filtered out.

In other words, if you have 5 related entities which you want to consolidate, you will set them up as single business is Manager and those 5 entities will be created as divisions within single business file.

---

<div class="post-metadata">

**Author:** ![abdulbari](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/abdulbari/32/20703_2.png) [@abdulbari](https://forum.manager.io/u/abdulbari)\
**Post date:** [March 26, 2019, 5:44am UTC](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072/20 "2019-03-26T05:44:41Z")

</div>

I just would like to know weather there will a possibility to link the tracking codes to division. or it would be like group tracking same as what was discussed in the below subject

> [@Grouping of Tracking Codes](https://forum.manager.io/t/grouping-of-tracking-codes/18818):
>
> I work in a company in which tracking codes can be a real benefit for the company. They have heavy equipment, and the want to use tracking codes to track expenses and revenue for each equipment. The only missing problem here is that they want to view the overall performance of each group of tracking codes. for example some tracking codes need to be grouped under excavators, other group of tracking codes need to be grouped under dump trucks, and others under wheel loaders, and so on. I found th…

[Next page](https://forum.manager.io/t/combining-consolidating-multiple-business-accounts/6072.md?page=2)
