How to Consolidate Financial Statements from Multiple QuickBooks Files


Two ways to consolidate are:


[1] Export all trial balances to Excel, position them on the same tab but each below the previous one, tag add a column to tag each account with the entity name, combine the DR and CR into one DR (CR) column.
[2] Create your financial statements with your desired accounts and headings
[3] On your tab with the trial balances, create a column called Balance Sheet and assign a B/S account from your B/S page by linking to it…for all line items. Add another column for Income Statement Accounts.
Be sure to skip all intercompany accounts.
[4] On your financials, use the SUMIF function to pull from the columns on the T/B tab using your mapping.

Pros: You can easy-to-update, professional-looking consolidated financials.
Con: It takes a while to set up the first time.



[1] Make sure the Charts of Accounts are identical across all 3 entities for any accounts that you wish to consolidate. Account number, spelling, parent/sub status.
[2] Also make sure that any intercompany accounts are all on the same line, i.e. if you have an asset in one and a liability in the other, change one of them to an asset before consolidating.
[3] Use the tool in the Reports menu to consolidate.

Pro: Doesn’t take a lot of time.
Cons: You have to set up those intercompany accounts each time so they get zeroed out, and you end up with consolidated financials that are in Excel and are very cheesy-looking.