Skip to content

Merge Quickbooks Company Files

QuickBooks business managements software is well designed to manage the complex accounting of the small and medium sized industries. The software has advanced features and tools that helps running the business hassle-free. Out of the numerous features the combining the reports from two or more company files is one of them.

In case you need to merge two or more company files with data stored in separate QuickBooks files. Certain QuickBooks versions have a built-in feature designed fro carrying out the specific task of merging the files. With merging the reports from multiple companies feature you are authorized to create reports including the balance sheets, profit and loss, statements of cash flows and more. Further the data combination is exported as a Microsoft Excel spreadsheet file.

Merge QB Company Files


Here are the Steps to Merge Company Data Files Into one.

Combining reports from two different company files allows you to merge different financial statements into a single file that you can later export in the form of an excel worksheet. Currently, combining reports is only available in the Enterprise version of QuickBooks Desktop. If you are using some other version like Pro or Premier, you can take advantage of third-party applications that integrate with QuickBooks to combine reports. You can find such applications on the QuickBooks Desktop App Store.

IMPORTANT: You can use QuickBooks Data Transfer Utility and AccuPOS point of sale to transfer data from two companies.

Steps to Combine QuickBooks Company Files

  • Go to QuickBooks application.
  • Launch & open a QuickBooks company file that you need to merge.
  • Click on Reports by going to the main menu.
  • Choose Combine Reports from Multiple Companies.
  • Click on Add Files option -> Locate the second company file -> Select it -> Click the Open option.
  • Select the correct reports for which you want to see combined information.
  • The saved reports are listed in the Select Reports for Combining section.
  • Mention the specific date range you needs to be used in the forms to fields, respectively.
  • Click the report that are needed.
  • Click Combine Reports in Excel to showcase the merged reports from the two companies in a spreadsheet.

Also Read: How to Merge Customers in QuickBooks

Sending transaction to a different company file in QuickBooks Point of Sale

  • Open QuickBooks Point of Sale, from the left side menu, click on Financial Center.
  • Ensure that your data is recoverable and then select the Retrieve Data option.
  • Press continue and select the correct date range.
  • Type Yes in the popup box and hit Continue.
  • The company’s financial transactions will be sent to an archive.

QuickBooks Desktop Pro & Premier can combine reports submitted by different companies into one.

  • Access and manipulate different reports in QuickBooks.
  • From the Export toolbar, select Excel Worksheet.
  • Save the report on your desktop as an Excel file.
  • Follow these steps to export the report of your second company.
  • Here’s information on how to convert Quickbooks files to CSV formats.
  • Merge Excel’s essential features into Microsoft Excel.

Also Read: Import an IIf file into QuickBooks Desktop

Steps to Combine Reports in QuickBooks Desktop Enterprise

  • Click the Reports tab, and then click Combine reports from multiple companies.
  • Click Add Files, browse the first company file, and click Open.
  • Follow the same process to select the files you want to merge.
  • The Select Reports for combining option allows you to choose the reports that you want to join.
  • Choose the date range and then select a report basis.
  • Click Combine Reports in Excel.
  • QuickBooks will open Microsoft Excel with a combined report.

Get a Free User Guide “Why to Upgrade to QuickBooks 2022”

Headache Huh, Looking to Upgrade from Your Current Version of QuickBooks?. But frustrated which version will be best suited according to your need. Don’t worry, Get a comprehensive list of reasons, why you should upgrade to the QuickBooks 2022 version.

Get these 20 tips on why to Upgrade to QuickBooks 2022.

    Support Help for QuickBooks Company File Merging

    The above steps allow you to Merge two QuickBooks company files. In case you fail to combine the company files or have related to the same connect to QuickBooks support Phone number. You can contact them through the toll free phone number, email support or live chat option.

    Alternatively you can call to other QuickBooks agencies that hire a proficient QuickBooks experts who assure quick and feasible support for all QuickBooks errors and queries that are reported by the users. They assure quick support and error resolution in a very short time. Call to the toll free phone support number +1-516-494-3146 and garner immediate solutions.

    Frequently Asked Questions

    1. Is there a way to merge company files in QuickBooks?

      When merging two different company files into one in QuickBooks, there is currently no way to merge the data. You can manually input the data into the company you want to keep.

    2. How do I merge two customers in QuickBooks desktop?

      Yes, you can merge two different customers in QuickBooks Desktop.
      Here’s how:
      1. Click the customer’s name of you would like to add or edit their information.
      2. Replace the customer name with the one you took note of or copied, then select OK.
      3. You will need to enter your credentials to proceed with the merge.

    1 thought on “Merge Quickbooks Company Files”

    1. do you provide the service to combine two company files in QuickBooks or only provide the software?, we have one company file in QB Pro and another company file in QB Enterprize, Ultimately, we need to use Enterprize I am the business owner. My accountant is not with me

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    three × 1 =

    Disclaimer : MyOnePro assemble the showcase the information of accounting software as accurate as possible , aim to provide user can resolve issue and get technical aspects of downloading, installing , update , upgrade accounting software. Intimating the MyOnePro visitor the information shown here for only information purposes. We have no direct or indirect association with any brand or any accounting software manufacturing company. QuickBooks Desktop and related versions are manufactured, promoted and distributed by Intuit®, Inc which is a USA based company. Other software like G-Suite, Gmail, Fiber owned by Google® USA, Excel, DOC, Word, Windows OS, Windows Server have under the copyright trademark of Microsoft® USA. MyOnePro is a team of certified ProAdvisor helps the user for managing accounting software like QuickBooks Pro, Premier, enterprise, POS, Non Profit, Accountant, Retail, Professional services Etc. All the images and content are under copyright of MyOnePro. The more information you can check the full disclaimer. Also for any dispute you need to first intimate our legal team to get full details, any action against web property and other resources of MyOnePro may be liable to penalties and a million dollar claim. Beware of fraudsters!