more-arw search

Q&A Forum

Quickbooks Multiple Entity Management

Can I Have Multiple Companies In QuickbooksI currently manage two company files within Quickbooks Pro 2012 which cannot be open simultaneously. This makes for a frustrating and time consuming user experience. We are now in the process of setting up another entity, and I know more headaches await me should I try and manage three company files in this manner. Any suggestions for a better way to manage multiple entities in a Quickbooks environment?

Editor's Discussion Summary:
  • QuickBooks Enterprise is a common choice for multiple entity management.
  • QB Accountant or QB Professional Bookkeeper versions allow 2 entities to be open at the same time.
  • Consideratins before upgrading to higher levels of QuickBooks
  • If consolidations are required, investigate further before upgrading
  • Some have added a two digit entity code to the account numbers as a work-around
  • Some favor NetSuite, other higher versions of QuickBooks
  • Plus much more below!

Read a little more below and then take a look at this discussion comparing QuickBooks Pro:vs Premier https://www.proformative.com/questions/quickbooks-pro-vs-premier

Answers

Wray Rives
Title: CPA CGMA
Company: Rives CPA PLLC
(CPA CGMA, Rives CPA PLLC) |

Robert, Typically for multiple entities, QuickBooks Enterprise is the choice, but in your case, just needing to open two companies, you might consider the accountant's version of QuickBooks which will allow you to work in two different companies at the same time.

Sarah Jackson
Title: Associate Editor
Company: Proformative
(Associate Editor, Proformative) |

Robert, take a look at this free report here on Proformative:

"When Is The Right Time To Graduate From QuickBooks?:"
https://www.proformative.com/whitepapers/when-right-time-graduate-quickbooks

Enjoy.... Sarah

John Harmon
Title: Owner
Company: John Harmon CPA
(Owner, John Harmon CPA) |

Hello Robert,
You would need either QB Enterprise, QB Accountant or QB Professional Bookkeeper versions to have 2 entities open at the same time. Enterprise is very similar to the regular QB versions, but can accommodate more transaction volume and has an included fixed assets module. If your accountant is a ProAdvisor, he can get you a 20-30% discount on most of these products.
I hope this helps.

Topic Expert
Jaime Campbell
Title: Chief Financial Officer
Company: Tier One Services, LLC
(Chief Financial Officer, Tier One Services, LLC) |

Robert,

I am delighted to share with you that in the Premier Accountant Edition, Professional Bookkeeper Edition, and Enterprise Edition, two files may in fact be open at once.

Obviously this necessitates an upgrade, but the headaches would be minimized.

I also experienced this with clients who manage multiple entities, and I myself manage multiple entities.

Other thoughts:
(1) Before you upgrade, check online for the restrictions placed upon a secondary file. For example, payroll functions can only be used in the primary file, not the file that you happened to open second, i.e. the secondary file.

(2) Since you have three companies and not two, consider an upgrade in which two of your files are moved up to QuickBooks 2013 Premier Accountant Edition and one file is retained in QuickBooks Pro 2012. This will enable you to have all three open at once.

(3) If your office environment includes a terminal server, you can have one file open on the terminal server and two files open locally, or vice versa.

All of the above techniques have been effective for me in managing three QB files simultaneously.

Please do not hesitate to contact me with any follow-up questions, concerns, or great ideas.

Regards,
Jaime

Anonymous
(IT Director) |

Hi Jaimie,
Do you know if QB 2014 Premier Non-Profit supports opening two files or only Premier Accountant version?

Many thanks,
Jeannine

Michael Kaplan
Title: CFO | Corporate Financial Consulting
Company: Veralytix
(CFO | Corporate Financial Consulting, Veralytix) |

You don't state whether your situation involves consolidations.

I recently had an experience with a QB client needing to set up multiple entities under a single parent. While only QB Enterprise supports consolidation, I was able to do a workaround using classes. This was made rather straightforward as the subsidiaries were simple, uncomplicated affairs. Most of the complicated accounting was done at the parent level.

If you don't need to consolidate entities, I agree with the previous comments. Upgrading to QB Premier/Accountant 2013 should get the job done.

Topic Expert
Bob Stenz
Title: Controller
Company: Silicon Valley start-up
(Controller, Silicon Valley start-up) |

I successfully managed 6 entities within a single parent company in QB Enterprise (QB Pro would have been just fine) by adding a two digit entity code to the account numbers. This was much easier than having 6 different QB instances. See more at: https://www.proformative.com/questions/consolidating-foreign-entities-using-quickbooks.

Tim Kim
Title: IT
Company: IT
(IT, IT) |

Hi, did you add two digits at the end or at the beginning of the account numbers? Is there any site/resource to explains how this works? I am planning to have three entities under a single parent company. Thank you.

Lynne Holloman
Title: Accounting Manager
Company: Woodside Equine Clinic
(Accounting Manager, Woodside Equine Clinic) |

Question to all - would upgrading to QB's Cloud version help in a multiple company environment? I manage 3 entities in QB's Premier 2011 and also have occasional issues with more than 1 user trying to access one of the companies and then having the other user get blocked out when they try to switch companies. QB's in the cloud seems to have some real benefits but it's clearly more expensive than just housing it on our server. Would going to the cloud also make a multiple company environment more easily managed? I'm just trying to gather up the pro's and con's for moving to the cloud...
Thank you in advance for any advice you all may provide...

Topic Expert
Bob Stenz
Title: Controller
Company: Silicon Valley start-up
(Controller, Silicon Valley start-up) |

We just migrated from QB Online to NetSuite. I was hired at the time of the migration, but my limited experience with QB Online led me to conclude that I would not use QB Online for anything but a small mom/pop or consulting company given limited features, reporting, and performance. Going to the cloud would solve the problem of multi-user access, however, I'm would test (or review the features) QB Online before making a commitment.

Elle Dee
Title: Manager
Company: Elle
(Manager, Elle) |

Hi, I just saw this old post and wonder if your opinion has changed since then.

Also, I am confused because in this post you seem to conclude that QB is not a good solution but in your prior post you relate being successful at managing several entities by using the 2-digit entity trick.
Could you clarify?

Binita Thakker
Title: Sr Manager
Company: SOAProjects
(Sr Manager, SOAProjects) |

I have successfully used QB Enterprise to manage over 80 different entities with various levels of consolidation.
Depending upon the specific needs of the entities, it can be done two different ways. One is to use classes for entities under a parent so that you have the simplicity of a single GL.
The other way is to maintain separate GLs for each entity. Each entity is set it up using a uniform chart of accounts. For eliminating entries, I created a separate QB file for the eliminating balances. I use the 'Combine reports from multiple entities' feature in QB Enterprise to get a consolidated set of financials at the touch of a button.

Dave Newkirk
Title: Vice President, Strategic Sales & Relati..
Company: Fidelity Investments
(Vice President, Strategic Sales & Relationship Management, Fidelity Investments) |

for managing six entities, I understand adding a two-digit entity code to the account numbers. How were you able to get good management reports including P&L by entity?

Vaibhav Devaansh
Title: Director
Company: Hitechfpo.com
(Director, Hitechfpo.com) |

Hi Robert,

You should use either Quickbooks Enterprise or Quickbooks accountant or Quickbooks professional, as everyone said enterprise is very similar to the regular QB versions, you can hire any expert of Quickbooks who can manage multiple files at the same time.

Sophia Jacob
Title: QuickBooks Hosting
Company: Techarex Networks
(QuickBooks Hosting, Techarex Networks) |

If you have multiple entities in one set of QuickBook you can still get separate reports for each using class, same as if you had a set of books for each. I think the argument for one over the other centers on convenience not good or bad. I have several QuickBooks files I work with during the day, closing-opening-closing-opening ... is a pain. If QuickBooks would allow you to load up multiple files and flip back and forth like tabs in a browser then I could see having separate books.

137782 views
Topics
Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.

QuickBooks Quicker - 24 Courses Available