How to setup subsidiaries in QB Enterprise 2009 for consolidation

[bstenz]

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.

 

[bstenz]

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 fromhttp://www.q2q.us/combineroverview.htm

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

 

[Karl]

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.

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 fromhttp://www.q2q.us/combineroverview.htm

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

 

[bstenz]

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