July 28, 2020

How to Merge QuickBooks Company Files?

The customers can merge two QuickBooks information with the assistance of Combine Reports function to be had in QuickBooks Desktop. This will can help you come with stability sheets, benefit, and loss, reproduction transactions and generate reviews and extra. In this weblog, you are going to discover ways to merge QuickBooks information, other issues to keep in mind sooner than appearing the stairs and form of information you can not merge.

Points to Remember while you Merge QuickBooks Files

  • The blended reviews must be really easy to learn, create Chart of Accounts equivalent in numerous corporate information.
  • Accounts can best be merged if they’ve identical title, kind and identical gradable degree.
  • Accounts might not be merged if:
    1. They are at other ranges (as an example: “Telephone” account can’t be blended with “Telephone” sub-account).
    2. They have other spelling. (‘phone’ can’t be merged with ‘telephone’).
    3. They have other account numbers.
  • You may need to log in in your information and switch them to multi-user mode to create space for the combo regimen.

You Cannot Merge Following Data

  1. Payroll exams are blended within the type of common exams due to this fact, they gained’t be displayed in payroll reviews.
  2. Memorized Transactions don’t seem to be transferred from the secondary information.
  3. QuickBooks does no longer fortify merging of Bank Reconciliations.
  4. Data information having damaging stock and meeting builds are arduous to merge.
  5. Data information containing gross sales tax pieces and teams, as they get changed in the end.
  6. Customer Notes and To-Do Lists can’t be merged.
  7. Customer fields from transactions are inconceivable to merge.

You May Also Read: How To Resolve Basic QuickBooks Company File Issues?

Steps to Merge Two QuickBooks Company Files

Method 1: Use integrated blended reviews function

QuickBooks Desktop Enterprise incorporates integrated function that is helping you merge reviews from other corporate information. With the assistance of this option, you’ll merge following reviews:

  • Balance Sheet Standard
  • Balance Sheet Summary
  • Profit & Loss Standard
  • Profit & Loss through Class
  • Statement of Cash Flows
  • Trial Balance

Follow the stairs discussed underneath to mix reviews in QuickBooks Enterprise:

  1. Firstly, pass to QuickBooks Reports menu after which make a choice Combine Reports from Multiple Companies.
  2. Choose Add Files >> navigate to some other corporate document >> Open.
  3. Repeat the similar for added information.
  4. From the “choose reviews for combining”, make a choice the reviews you need to merge.
  5. Fill the From and To date vary fields.
  6. Now make a choice a record foundation.
  7. Choose Combine Reports in Excel. An excel sheet will seem with blended data.

Method 2: Use a third-party device for QuickBooks Pro or Premier

The Intuit Marketplace gives more than a few products and services supported through QuickBooks Desktop. There are a number of methods which allow you to mix reviews from a couple of corporate information.

Method 3: Export reviews manually

  1. Open the primary information document and create a record for this document.
  2. Export the record in Excel worksheet and reserve it.
  3. Now open the second one information document and create the similar record.
  4. Export the report back to new Excel sheet and reserve it.
  5. Open Microsoft Excel and workbook.
  6. You need to manually merge two reviews in some other worksheet.
  7. Lastly, save the workbook.

About the author 


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}