I've heard that QB Enterprise 2009 can perform consolidations, however, the Help Menu provides no guidance. How is this best done? I'm tempted to just create unique GL accounts (P&L and BS) and be done with it (i.e. book quarterly entries based on the financial statements (prepared separately by various acct firms) of our subsidiaries). Thanks, Bob.
How to setup subsidiaries in QB Enterprise 2009 for consolidation
Jan 22, 2009
4 Replies
Since you are entering only summary data, you could set up each company as class in one QB file and journal in the entries from the various acct firms. You can do this with Pro/PRemier and ES. Run the QB PL report by class to see PL by "company".
ES can create consoliating financial statements from multiple QuickBooks file. You just tell ES which files to use and it grabs the data from each file.
You can do the same thing with Pro and Premier by using a third party progam like our Report Combiner from
formatting link
Thanks, I'm not a fan of class since the results come out at the field level (verses record level...I export my trial balances into excel for reporting and record level data pivots much more effectively) and I believe class only works for the P&L. What is "ES"? Thanks again. Bob
ES is Enterprise Solutions.
Since you are journaling in the amounts, you can add a class to all JE lines and run as BS by class. To create the report.
Create a Custom Summary Report. 1.. Change "Display columns by" to Class. 2.. Change "Display rows by" to Balance Sheet. 3.. Change the Account filter to All accounts. 4.. Change the Report Title to Balance Sheet or Consolidating Balance Sheet. 5.. Memorize the report for future use.
Thanks, I'm not a fan of class since the results come out at the field level (verses record level...I export my trial balances into excel for reporting and record level data pivots much more effectively) and I believe class only works for the P&L. What is "ES"? Thanks again. Bob
Thanks...yes...I can see that the custom summary reports could work. However, I'm not looking for a report that puts the sub's in a seperate column. Instead, I'm looking for a way that the subsidiary information is defined at the record (row) level. I'm still curious though on what is meant by "ES can create consoliating financial statements from multiple QuickBooks file". How would this be done? Regards, Bob
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required