cancel
Showing results for 
Search instead for 
Did you mean: 
userkassandra-torres
Level 1

Consolidated Reporting

For Quickbooks Desktop, is there a way to consolidate reporting? I have seen 2 other questions, both had the answer no, but they were for QB Online and QB Enterprise. Does the standard Desktop version have this feature? I want to combine budgets and financial statements for 4 companies.

6 Comments 6
Mark_R
Moderator

Consolidated Reporting

Your issue ends here, @userkassandra-torres.

 

Combining reports is a built-in feature available only in QuickBooks Desktop (QBDT) Enterprise. Since you're using a standard version of QBDT, you have two options to consolidate your reports.

 

First, you can consider looking for a third-party application that works with QuickBooks Desktop from the Intuit Marketplace. While your other option is to manually export the reports to MS Excel and combine them from there.

 

Here's an article you can read for more details: Combine reports from multiple company files.

 

Just in case you want to upgrade your QBDT to Enterprise version for consolidating reports and more features, feel free to check this website: Upgrade to Enterprise.

 

I'm still open to your replies. If you have other concerns (account issues or product-related questions), don't hesitate to include them. Have a great day ahead!

Mark_R
Moderator

Consolidated Reporting

I want to make sure this is taken care of, @userkassandra-torres.

 

Did you find a third-party application that can consolidate reports? Or were you able to combine them by exporting to MS Excel? If you need more clarification on this, just leave a comment below. I'll be sure to get back to you.

Have a good day!

bcertain
Level 1

Consolidated Reporting

How many company files can be included in QBES consolidated reporting? I see that QBO you can have as many companies as you want. Is this true? Is it the same for Enterprise?

MichelleBh
Moderator

Consolidated Reporting

You've come to the right place for answers, @bcertain.

 

Glad to hop in and provide some insight about reports in QuickBooks Desktop. This way, I can guide you accordingly. 

 

Yes, that's true. There's no limit to combining reports from multiple company files as long as you follow Option 1 correctly in the article mentioned above. 

 

Just keep in mind that reports can be combined from multiple business records are:

 

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

 

Additionally, check out this article below on how to personalize and memorize financial reports in QuickBooks: Understand reports.

 

Stay in touch with us if you have other questions about your account. I'm always ready to work with you again. Take care, @bcertain.

wbmorrow
Level 1

Consolidated Reporting

I don't know what you are saying. 

 

Consolidation is a specific accounting term. If feels like you are using "combine" / "combining" as an equivalent. It is not. 

 

So, to ask specifically: If I have a parent organization with non-wholly-owned subsidiary entities, can QuickBooks Enterprise automate THE CONSOLIDATION process and provide CONSOLIDATED financials through its automatic reporting function? Or do I have to do multiple cross company transaction eliminations to complete this task?

DivinaMercy_N
Moderator

Consolidated Reporting

Look no further, @wbmorrow.

 

I've come to provide you with the steps on how you can consolidate reports in QuickBooks Desktop Enterprise (QBES). 

 

To combine reports, you'll have to utilize the Combine Reports from Multiple Companies feature. Here's how:

 

  1. Open your company file and click the Reports menu.
  2. From there, select Combine Reports from Multiple Companiescombine1.PNG
  3. Next, click the Add Files button, look for the other company file and choose Open. Repeat for additional files. combine2.PNG
  4. Then, under the Select reports for combining section, pick the reports you want to combine.
  5. Set the report's From and To date, then select a report basis.
  6. Select Combine Reports in Excel. A Microsoft Excel spreadsheet will open with the combined information.

 

For your reference about the process, please see this article: Combine reports from multiple company files. It also includes the other ways how you can combine reports in QBES. 

 

Also, customizing your reports is a breeze in QuickBooks. This will allow you to add or remove columns and filter the specific details you need the most. You can also save the changes you made by memorizing the report so you can apply the same customization in the future. 

 

Don't hesitate to post again here if have any other questions about consolidating your reports in QuickBooks. I'd be glad to assist you once more. Have a great day ahead. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us