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.
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
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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.