A Guide to Combine your financial reports from multiple QuickBooks desktop company files:

QuickBooks is and advanced accounting software which is highly regarded by millions of business owners in the United States, Canada and all across the world. It’s features like integrating reports make it all the more interesting and user friendly. One of the highly appreciated features of QuickBooks is that it allows the user to merge two or more QuickBooks company files. A user can easily combine financial reports from different company files. In this article, we are going to explain the ways for merging/combining the reports from multiple company data files in QuickBooks. It is highly reliable to combine the reports from Multiple companies features enable a user to create a report for combining several balance sheets which you can transfer to the Microsoft Excel spreadsheet file.

If you have any questions about this topic, feel free to send a support request from here or you can contact to our dedicated technical support team.

Read Also: How to Fix QBDBMGRN not running on this computer problem?

How to customize QuickBooks Desktop Custom Reports?

Some basic part for the simple data about reports in QuickBooks Desktop is below described:

Understanding between two or more several accounts:

One of the main tasks for performing the combine reports is completely understandable. If you are having acquainted with this or you can simply understand the several data then you can simply check the needed information for the completion of a task.

Maintain report for orientation:

After checking the whole information, the next thing is to organize the data as per it is needed.

Modify Reports:

If you are willing to make any kind of changes in the information as per the requirement then it is an imperative part.

Mark Comment:

To make your information effective as well as favorite then you can simply comment.

Built and Organize Regular Reports:

One of the most imperative things is to classify the data and it also needs to be scheduled.

Important Points

To combine the reports some of the below points are required to remember:

  • The report is required to be much simple for reading as well as in creating a profile in several company files as almost similar.
  • The reports are required to be combined if they contain appropriate data in an identical way such as name, type and alike gradable level.

Below are some valuable points which tell that accounts will not be combined if:

  • If they contain dissimilar property and assets.
  • There is some difference in alphabetic character.
  • Account mismatch.
  • If one user has a dissimilar report and the other has distinct data.
  • Reports are categorized in different types. The Details are to be selected in some order what has been done in the chosen company file within each report. If the account appends by other in sequence after that they are encounters.
  • If you chose to log in to your file and also want to switch them to various users so as to accommodate merging routine.

See also: Disable merchant services in QuickBooks desktop for Mac

Steps to Combine Two Companies into one in QuickBooks desktop

Option 1: Combine reports in QuickBooks Desktop Enterprise (Built-In)

A few main features of built-in combines reports in QuickBooks desktop enterprise:

If you are having any built-in function in any of the fields then you can simply perform several complicated tasks with utmost ease. Likewise, QuickBooks enterprise also offers a built-in feature for merging various company files.

Note that, QuickBooks enterprise allows you to combine reports from multiple company files. These include:

  • Standard of record
  • A conclusion of balance sheet
  • Financial loss amount and profit
  • Category of profit and loss
  • Comment on the cash flow
  • Check on balance

For combining the reports:

  • Initially, you need to choose combine reports from multiple companies from the reports menu.
combine reports from multiple companies - Image
  • Moreover, choose add files, and locate the other company file and choose open. Repeat the same process for additional files.
Steps to combine reports from multiple companies - Image 1
  • Now, under select reports for combining, choose the reports you wish to combine.
  • Heading forward, pick the report from and to date range and also go for a report basis.
  • You now have to choose combine reports in excel. A Microsoft excel spreadsheet will open with the combined information.

Option 2: Use a third-party software

If you agree to us third party software then you can simply pinpoint on various programs that work with QuickBooks. Some of these programs offer important information to make the additional data from various corporate files.

Option 3: Manually export reports from each file and combine using Microsoft Excel

You can simply transfer the reports by following some of the given steps and merge reports through Microsoft Excel:

  • You need to initially open the first company file.
  • Now, on the select report, you are supposed to export to an Excel worksheet and save the workbook.
  • You are then required to open the second company file.
  • Furthermore, create the same report and then export to an excel worksheet in the same workbook and also choose save tab.
  • You now have to open the Microsoft excel and open the workbook.
  • Later on, combine the two reports into a third worksheet manually.
  • End the process by saving the workbook.

Read Also: How to Set up the QuickBooks database server manager


We hope that this article helps you to integrate QuickBooks reports. In case the issue persists or you need assistance with any other QB related issue, you can speak to our 24×7 QuickBooks support team.


Some other helpful articles:

How to Install the QuickBooks desktop?

How to set up QuickBooks Desktop to work from home?