Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
U
userkassandra-torres
December 9, 2020
Question

Consolidated Reporting

  • December 9, 2020
  • 6 replies
  • 48 views

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 replies

M
Mark_RModerator
Moderator
December 9, 2020

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!

B
bcertain
October 25, 2021

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?

DivinaMercy_N
DivinaMercy_NModerator
Moderator
May 5, 2022

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?


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 Companies. 
  3. Next, click the Add Files button, look for the other company file and choose Open. Repeat for additional files. 
  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. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement