Before you combine reports, take note of the following:
To make combined reports easier to read, make your chart of accounts in the company files as 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. Note: Account names are not case sensitive.
Accounts that will not be combined are:
Accounts at different levels. For example, telephone account is not combined with telephone subaccount.
Spelling differences. For example, telephone is not combined with phone.
Different account numbers.
Accounts with and without account number.
Accounts are listed by type. Within each type, the accounts are listed in the order of changes on the first company file. Then, accounts from other company files are added in the order they are encountered.
You may need to log in to your files and switch them to multi-user mode.
Note: If you are using QuickBooks Desktop Pro or Premier, you can use option 2 and 3.
Option 1: Combine reports in QuickBooks Desktop Enterprise
In QuickBooks Desktop Enterprise, you can combine reports from multiple company files. These are:
Balance Sheet Standard
Balance Sheet Summary
Profit & Loss Standard
Profit & Loss by Class
Statement of Cash Flows
To combine reports:
From the QuickBooks Reports menu, select Combine Reportsfrom Multiple Companies.
Select Add Files, locate the other company file, then choose Open. Repeat for additional files.
Under Select reports for combining, select the reports you want to combine.
Select the report From and To date range, then select a report basis.
Select Combine Reports in Excel. A Microsoft Excel spreadsheet will open with the combined information.
Option 2: Use a third-party software
The Intuit Marketplace offers applications that work with QuickBooks Desktop. Some of these produce combined reports from multiple company files.
Option 3: Manually export reports from each file and combine using Microsoft Excel
Open your first company file.
On the selected report, export to an Excel worksheet and save the workbook.
Open the second company file.
Create the same report, then export to a new worksheet in the same workbook and Save.