QuickBooks Multiple Companies: Setup, Merge, Add, Switch in Desktop & Online Version

QuickBooks Multiple Companies
  • January 9, 2024

When you are satisfied with QuickBooks' performance using your accounts and expenses for business purposes, you will want to use the packaged software for various companies or funds. 

Some people have a common query about whether they can use the application for multiple companies. And the answer is absolute, yes! You have to set up various companies in your QuickBooks software both in desktop and mobile applications. 

But it would be best if you keep some factors in mind for using multiple accounts in QuickBooks. 

The prime factor is a subscription. You can use only one account with one QuickBooks subscription. 

To connect to another account, you need to subscribe again. In simple language, you need to connect every company's history with a different subscription.

QuickBooks for Multiple Companies: Why is it Important?

QuickBooks for multiple companies is important because it allows businesses to manage their finances for more than one company in a single location. This makes it easier for business owners to keep track of their financials, save time, and avoid mistakes. Without QuickBooks for multiple companies, businesses would have to manage their finances for each company separately, which could be time-consuming and inefficient.

Benefits of Using QuickBooks for Multiple Companies

Some of the benefits of using QuickBooks for multiple companies include:

  • Simplifies financial management: QuickBooks allows businesses to manage their finances for multiple companies in a single location, making it easier to keep track of income, expenses, and other financial transactions.
  • Saves time: By managing finances for multiple companies in a single location, QuickBooks can save businesses a significant amount of time that would otherwise be spent managing finances separately for each company.
  • Reduces errors: With QuickBooks, businesses can avoid errors that can occur when managing finances for multiple companies separately. This can help prevent costly mistakes and save time and money in the long run.

Features of QuickBooks for Multiple Companies

QuickBooks for multiple companies offers a range of features that can help businesses manage their finances more efficiently and effectively. Some of these features are:

  • Centralized financial management: With QuickBooks, businesses can manage finances for multiple companies in a single location, making it easier to keep track of income, expenses, and other financial transactions.
  • Customizable reporting: QuickBooks allows businesses to generate reports that are tailored to their specific needs, making it easier to analyze financial data and make informed decisions.
  • Streamlined invoicing: QuickBooks allows businesses to create and send invoices to customers quickly and easily, helping to ensure timely payments.
  • Automated payroll: QuickBooks offers a payroll feature that can automate the payroll process, making it easier to manage payroll for multiple companies.
  • Inventory management: QuickBooks can help businesses manage inventory levels and track stock movements across multiple companies.

Common Mistakes to Avoid When Using QuickBooks for Multiple Companies

Some common mistakes to avoid when using QuickBooks for multiple companies include:

  • Mixing transactions between companies: To avoid confusion, it is important to ensure that transactions are recorded in the correct company file.
  • Failing to customize the chart of accounts: Customizing the chart of accounts for each company file can help ensure that financial data is accurately reflected.
  • Not reconciling accounts: Failing to reconcile bank and credit card accounts can result in errors and inconsistencies in financial data.

In this article, we will show you the multiple functions and activities you can do with QuickBooks Multiple Companies. Let's deep down to the post.

The major component of the post

  • Add Multiple Companies in QuickBooks
  • Merge Multiple Companies in QuickBooks
  • Switch Companies in QuickBooks
  • How to Use Multiple Accounts in QuickBooks
  • Drawbacks of Using QuickBooks for Multiple Entities

How to Add Multiple Companies in QuickBooks

No matter what version of the QuickBooks accounting software is being used, more than one firm can run on a single copy. Multiple businesses can be hosted by any of the versions, including Online and Desktop. However, the process for adding entities varies across different versions of the application.

Key Information Before Starting:

Before starting the process of creating several companies in QuickBooks, keep in mind that there are two versions of the software: QuickBooks Desktop and QuickBooks Online. Depending on the version you are using, two processes will enable you to open several firms under the same subscription because there are two versions of the software.

No matter how many firms you have, the process for adding a new one when using the offline version of the application is the same. To complete the process, you simply need to use a new company interview wizard. Now that you have a file for each new company, you can open it and make it unique for the ones that open as per your choice.

How to Add a Second Company in QuickBooks Desktop

You must create a company first to add another one to QuickBooks Desktop. Once you've created a firm in the offline edition, you can add as many as you like by following the instructions below:

  1. Launch the specific QuickBooks Desktop in the first step.
  2. Next, use a local computer to log in to your specific account.
  3. Select the File tab. Choose New Company from the menu now. A new window will appear.
  4. On the new screen, select the Start Window option. Include all pertinent information, such as name, phone number, address, etc. Save the new company now in the appropriate location.
  5. Select Next to bring up a new conversation screen. The file name for New Company will be the new window.
  6. Access the specified folder where the specified file will be saved. Press Save after giving the file a name.
  7. After the new file has been produced, move on to finish the remaining interview steps by pressing Save.
  8. Complete the procedure by sharing your company account and credit information.
  9. The setup procedure is now complete. If you like, you can carry out this procedure for more businesses.

How to Add a Second Company in QuickBooks Online

The steps listed below must be followed if you need QuickBooks Online for numerous firms in one file:

  1. You must have an active service subscription to QuickBooks Online to create a new company for the QuickBooks Online version.
  2. Pick the nation you want to live in. It will be beneficial for QuickBooks Online to launch a website specifically for that subject.
  3. If you don't already have one, create a QuickBooks Online account.
  4. Decide which version of QuickBooks Online you want to use. The Sign-in page will be displayed.
  5. A user must sign in using their current account on this specific page. Additionally, the user has the option to open a brand-new account.
  6. Joining a new company in QuickBooks Online is the same as creating a new corporation.
  7. Choose the best option for your needs from Plus, Simple, Essential, or Start. You will be informed to start a free trial and buy it when it is selected.
  8. Using a registered Intuit account, you can quickly select the Add Another Company option located on the upper side of the window.

How to Merge Company Files in QuickBooks

In QuickBooks, Merging two or more company files into a single one is completed by the process of merging company files. This can be helpful for companies who want to integrate their financial data yet maintain separate company files for several branches or locations.

By merging company files, businesses can easily view and manage all their financial data in one place. This can simplify accounting tasks, save time, and reduce the risk of errors.

However, it's important to note that merging company files is not a simple process and should be done with caution. It's recommended to seek the help of a professional accountant or QuickBooks expert to ensure the process is done correctly.

Before merging company files, it's also important to back up all data and ensure that there are no duplicate entries or errors in the files being merged.

How to Merge Company Files/Two Companies in QuickBooks Desktop

Note: You can merge only two company files with the same name, type, and level in QuickBooks Desktop, before going to the procedure. You have to understand some of the data can't be merged in QBDT such as; Payroll checks, memorized transactions, bank reconciliation, budget and forecast, sales tax data files, and negative Inventory Data files.

The procedure for Merging Two Company Files in QuickBooks Desktop is as follows;

  1. First of all, Open the QuickBooks file in which you want to work.
  2. Now go to the reports menu and then select the combined report from multiple companies.
  3. Next, You have to click on add files to locate the other company file, then click on the open button.
  4. Follow the same to same steps to select the other company files, which you want to merge.
  5. In the "Select Reports for Combining" option, You just need to choose the reports to combine.
  6. Now, Enter the date range in the Form and the To fields section.
  7. Next, Choose your desired report basis.
  8. Next, click on "Combine Reports in Excel".
  9. There you go, QuickBooks will now open a "Microsoft Excel" worksheet with your combined reports.

The other way to merge or combine two company files in QuickBooks Desktop is you use a third-party application, which you can find easily on QuickBooks Desktop App Store.

How to Merge Company Files/Two Companies in QuickBooks Online

Note: Before proceeding to the QBO Company files merge, you need to know, what data cannot be merged. Here is the list below;

  • Payroll Checks - QuickBooks never allow payroll checks to be transferred from one company to another company.
  • Bank Reconciliation - QuickBooks Doesn't support the transfer of bank reconciliations.
  • Data files with negative inventory and assembly build - Because it doesn't merge correctly due to insufficient quantity.
  • Data files with Sales Tax Items
  • Data files with group items
  • Templates
  • Attachments
  • Customer Notes and TO-DO lists
  • Custom fields in Transactions.
  • Memorized Transactions
  • Budget or Forecast from secondary files
  • Users from Secondary files.

The Procedure for Merging QBO Company Files

  • Two merge two Company Files in QuickBooks Online, You need to convert each QBO dataset to QuickBooks Desktop Version first (US versions only).
  • The Desktop files are merged and will need to be uploaded to a new QBO company file.
    Note: if your account is older than 60 days, you will need to contact Inuit to get permission to upload the merged data back to the original QuickBooks Online account. If not, you will need to create a new QBO account.

How to Switch Companies in QuickBooks

Switching companies in QuickBooks refers to the process of moving from one company file to another within the QuickBooks software. This is useful for individuals or businesses that need to manage multiple entities or accounts using QuickBooks.

Switching companies to QuickBooks can be helpful for businesses that have multiple entities or subsidiaries that require separate accounting records. It can also be useful for individuals who use QuickBooks to manage their finances and have multiple accounts or businesses to keep track.

Switching Between Businesses

The method is simple if you want to switch from one company file to another. Go to the main menu bar and select the "File" tab from the current company file. You can choose from several alternatives when you click on it. Choose "Open Previous Company" from the menu. You'll be taken to another window with a list of the businesses associated with your account immediately. Simply search for the specific firm file you want to open, click on it, and then select the "Open" button.

How Do I Switch Companies in QuickBooks Desktop?

If you have subscribed to more than one company & want to switch between companies?. You just need to follow the simple steps mentioned below.

  • First of all, Log in to Your QuickBooks Account & head to the Settings option.
  • Then, under the profile section, You will find an option named "switch company" Select it.
  • Now from the list, select the company you want to switch to & here you go.
  • Now, the company you selected will be active.

How Do I Switch Between Companies in QuickBooks Online?

If you have subscribed to more than one company & want to switch between companies?. You just need to follow the simple steps mentioned below.

  • First of all, Log in to Your QuickBooks Account & head to the Settings option.
  • Then, under the profile section, You will find an option named "switch company" Select it.
  • Now from the list, select the company you want to switch to & here you go.
  • Now, the company you selected will be active.

How to Use Multiple Accounts in QuickBooks

Can You Have Multiple Accounts in QuickBooks Desktop 

With the QuickBooks Desktop Pro version, you cannot open multiple companies in QuickBooks. 

You can use one company account with the application and then switch off and on the other tab for use. 

If you want to use different companies from a single QuickBooks account, you need to start from the 'File' option and then click on the 'Open previous company.' 

How to Change Company Name in QuickBooks?

Then you select the specific company profile that you want to use and track. Otherwise, the process is not possible for multiple company accounts.  

Steps for Using Multiple Accounts in QuickBooks

You have to follow some definite steps to download and use the QuickBooks application for using your multiple business accounts. 

So, that you can track the expenses and transactions well and measure them on a scale.

The essential steps are as follows-

  1. Go to Play Store and install the mobile phone application or download the software for your desktop. 
  2. You have to choose a version of the application or software. 
  3. Go ahead with the sign-in option on the mentioned page. 
  4. While logging in for the account, you have a subscription and follow the guidelines to set up the second company's login.
  5. Now, you can log in to your company account. You will get to see the multiple accounts and select the one you are planning to work on.
  6. You can change the company account with the 'Gear' option after logging in. You will get the opportunity from the top where the software provides the option of 'Switch the company.'
  7. A built-in option enables the user to assemble multiple company reports from their company files.
  8. You can use them one by one. You can close the first file of data and then use the second one. You can use them one by one. You can create the same report on this file, too, and then export them to a new worksheet when required.

What Are The Drawbacks of Using QuickBooks for Multiple Entities?

Using QuickBooks for multiple entities can be a convenient option for some businesses, but it also has its drawbacks. One of the biggest challenges is the potential for data mixing between different entities. This can cause confusion and errors in financial reporting, especially if there are differences in accounting methods or tax requirements. Additionally, QuickBooks may not be scalable enough to handle complex accounting needs for multiple entities, and the cost of purchasing multiple licenses can add up quickly. Finally, QuickBooks may not offer enough customization options to meet the specific needs of each entity.

  1. QuickBooks' Multi-Entity Distributions Lack Automatic Functionality - When entities pay bills on each other's behalf or transact and share inter-company loans, users must often log into different companies so that the ledger can be updated and balanced. This often leads to separate transactions for a single bill distributed to multiple entities in each company's database.
  2. Comparing Companies is Complex - QuickBooks cannot report to multiple company databases within a single file, leading users to resort to Excel for quick overviews. However, this method requires a lot of exporting, printing, cutting, and pasting, and often requires additional manipulation to produce PDFs that are easily shareable. This manual work increases the likelihood of errors and overwhelms accountants with administrative work at the end of the month.
  3. Real-Time Insights are Lacking - QuickBooks does offer dashboards, but they lack the detailed metrics necessary for the daily oversight of multiple entities. Understanding the cash balance across all companies can be tedious, and personalized real-time dashboards that can display the right data to the right people within the company are necessary.
  4. Consolidated Financial Reporting is not Available - The combination of data from reports pulled at different times means that users are not seeing the most up-to-date picture. This can occur to data integrity problems, where the data is not up to date by the time the accountant receives the report in Excel.
  5. Different Currencies Create Challenges - QuickBooks can support different currencies in each company, but it is nearly impossible to consolidate multiple companies with different home currencies. Each company must be manually converted to a common reporting currency.
  6. Shared Charts of Accounts Are Not Available - QuickBooks creates a separate chart of accounts for each company, saving users from spending unnecessary hours adding a new account to each company and keeping them in sync. A shared chart of accounts should be provided for multi-entity accounting, and it should be possible to share information on vendors, customers, and inventory across multiple businesses.
  7. Compliance is Complicated - Without an accounting software system designed for multi-entity accounting, users lose the built-in safeguards that keep entries in line with accounting rules and suitability requirements. Journal entries can easily be missed in many companies, which can lead to compliance issues.

Conclusion:

QuickBooks for multiple companies is a powerful financial management option in QuickBooks that can help businesses streamline their financial management tasks. By setting up separate company files and customizing the chart of accounts for each company, businesses can easily manage multiple entities from a single software. While there are some potential drawbacks to using QuickBooks for multiple companies, the benefits often outweigh the costs, making it a popular choice for businesses of all sizes.

Frequently Asked Questions

Can QuickBooks Be Used for Multiple Businesses?

Yes, QuickBooks is capable of handling the accounting activities for multiple businesses. You have the flexibility to set up and manage one or more companies within a single QuickBooks installation, allowing you to maintain financial control over each business. The important aspect is to create separate company records for each of your businesses within the QuickBooks installation. This enables you to effectively manage the finances of each business entity.

Can QuickBooks Online Be Used for Multiple Businesses?

Yes, Just like the desktop version of QuickBooks, you can create separate company records within a single installation of QuickBooks Online. This feature enables you to manage multiple businesses using a single login. To switch between companies, you can easily click on the "Company" tab located at the top of the screen. It's important to note that QuickBooks Online is hosted by Intuit Online. If your company requires switching between hosting providers, there might be a brief period of downtime as the data is transferred.

Absolutely! QuickBooks Online can be used to manage the accounting activities for a single business as well. If you only need to track one company, you can simply set up a "Company File" instead of a "Company Account." This allows you to avoid the hassle of navigating between multiple companies every time you access the software. By setting up a single Company File, you can streamline your workflow and focus solely on managing the accounting activities for your business.

Can you have 2 companies in QuickBooks Online?

It is possible to have multiple companies within a single QuickBooks Online account. Each company file requires its own paid subscription, but you can access all of them using the same sign-in information. This convenient feature allows you to swiftly switch between different companies, enabling you to manage all of them more efficiently from a single account.

How to use Microsoft Excel to Manually Export reports from each file and merge them?

To manually export reports from each file and merge them using Microsoft Excel, all you need to follow these simple steps:

  1. Open the first file for the company.
  2. Export the chosen report to an Excel worksheet, then store the workbook.
  3. A second company file should be opened.
  4. The identical report should be created, exported to a new worksheet within the same workbook, and saved.
  5. Open the workbook with Microsoft Excel.
  6. Create the third worksheet manually by fusing the two reports.
  7. Keep the workbook safe.

How Many Companies Can You Have in QuickBooks Desktop or Can You Have Multiple Companies in QuickBooks Desktop?

The number of companies you can have in QuickBooks Desktop depends on the version of QuickBooks you are using and the type of license you have. QuickBooks Desktop Pro and Premier allow you to create up to 3 company files. QuickBooks Desktop Enterprise, on the other hand, allows you to create up to 30 company files.

Can QuickBooks Online Consolidate Multiple Companies?

Yes, QuickBooks Online can consolidate financial data from multiple companies. This feature is called "Consolidated Reports" and it allows you to combine the financial data from multiple QuickBooks Online companies into a single report.

How to Access this feature?

To access this feature, you need to have multiple QuickBooks Online companies that you want to consolidate. You can then follow these steps:

  1. Log in to QuickBooks Online and go to the Reports tab.
  2. Select the "All Reports" option.
  3. In the search bar, type "consolidated" and select "Consolidated Reports".
  4. Follow the prompts to select the companies you want to include in the report and the date range you want to cover.
  5. Customize the report as needed and then generate it.

How to run several businesses in QuickBooks or Can I Use QuickBooks for Multiple Businesses?

This is how you can learn to run several businesses, Even though you can swiftly move between different companies you've established, they remain distinct. You may manage all the data in your corporate files by doing the following actions.

  1. Users - Users that you create for one business do not automatically gain access to it. You can invite them if you want to grant them access.
  2. Banking online - A bank or credit card account that is linked to one business is not added to or made available by a different one. For each business, you must connect it separately.
  3. Lists - You don't have to start from zero if you move your lists (vendors, customers, inventory, and chart of accounts) to your new business.

How to combine reports in QuickBooks Desktop Enterprise?

In QuickBooks Desktop Enterprise, You can combine reports from many company files. Which are:

  1. Financial Statement Format
  2. Balance Sheet Overview
  3. Loss & Profit Standard
  4. Gains and Losses by Class
  5. Cash Flow Statement
  6. Test of Balance

Steps for Combining Reports

  1. Choose Combine Reports from Multiple Companies from the QuickBooks Reports menu.
  2. Locate the other company file by choosing Add Files, then select Open. Continue with further files.
  3. Choose the reports you want to combine from the list under Select Reports for combining.
  4. Choose a reported basis after choosing the reports From and To dates.
  5. Select Excel Report Combination. The combined information will appear in an Excel spreadsheet.
Blog Post

Related Articles

Perform QuickBooks Export Transactions to Another Company File in No Time

October 5, 2020
When it comes to managing your own business, your approach should be smart and sensible. You might wish to take your...

How to Convert QuickBooks Online to QuickBooks Enterprise?

August 16, 2022
So you want to move your accounting data from QuickBooks Online to QuickBooks Enterprise. Even though the process is...

Easy Migration of QuickBooks Enterprise to QuickBooks Online

July 7, 2022
QuickBooks Enterprise and QuickBooks Online are both used by organizations for handling their day-to-day accounting,...
Call Now+1-800-961-4963