Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Combine reports from two or more company data files

QuickBooks Desktop Enterprise has a built in feature that allows you to combine reports from multiple company files. If you need this feature and you are using QuickBooks Desktop Pro or Premier, use option 1 or 2. For QuickBooks for Mac, use option 2 only.

Before you combine reports, be reminded of the following:

  • To make combined reports easier to read, make your Chart of Accounts in the several company files as nearly identical as you can.
  • Accounts will be combined if they have the same name, same type and are at the same hierarchical level in each report. (Account names are not case sensitive.)
  • Accounts that will not be combined:
    • Accounts at different levels (For example, "Telephone" account is not combined with "Telephone" sub-account.).
    • Spelling differences (For example, 'telephone' is not combined with 'phone.')
    • Different account numbers.
    • One with an account number and one without an account number.
  •  
  • Accounts are listed by type. Within each type, accounts are listed in the order of what has been done in the first selected company file. Subsequent accounts from the other company files are appended in the order they are encountered.
  • You may be asked to log in to your files and switch them to multi-user mode to accommodate the combination routine.
Detailed instructions

Built-in combined reports feature in QuickBooks Desktop Enterprise

QuickBooks Desktop Enterprise has a built-in feature that allows you to combine reports from multiple company files. Using this feature, you can combine the following reports:

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

To combine reports:

  1. From the QuickBooks Reports menu, select Combine Reports from Multiple Companies.
  2. Click Add Files..., locate the other company file, and click Open. Repeat for additional files.
  3. In the Select reports for combining section, select the reports for which you want to see combined information.
  4. Complete the From and To date range fields to set the report date range.
  5. Select a report basis.
  6. Click Combine Reports in Excel. A Microsoft Excel spreadsheet will open with the combined information.
 

If you need other report combinations or if you are using QuickBooks Desktop Pro or Premier, you can use the following two options. For QuickBooks for Mac, use Option 2 (applies to US only).

KB ID# HOW13293
4/29/2017 10:10:32 PM
QYPPRDQBKSWS09 9138 Pro 2017 025077