QuickBooks consolidated financial statements

Every practical way to produce group statements from QuickBooks, with steps, checks and costs.

By the ConsoHQ editorial team. Updated 4 November 2026.

Key takeaways

• Standard QuickBooks Online plans can't consolidate; Intuit Enterprise Suite can.
• Consolidation means adding companies, mapping accounts, translating currencies and eliminating intercompany items.
• Excel works for two simple companies; apps are faster and safer beyond that.
• Always check: the balance sheet balances, eliminations net to zero and nothing is unmapped.
• Consolidate monthly so problems surface early.

What "consolidated" means

A consolidated financial statement shows a parent company and its subsidiaries as if they were one business. It's not just adding up: you remove everything that happened between group companies, translate foreign subsidiaries into one currency, and show any part of a subsidiary owned by outsiders. Our worked example shows a three-company group line by line.

Your five methods compared

Method 1: Manual consolidation in Excel

1. Close every company to the same date. Reconcile banks and post month-end journals in each.
2. Run and export the trial balance for each company at the period end.
3. Create a mapping table that sends every account in every company to a group line.
4. Sum each company's balances by group line using SUMIF or a pivot table.
5. Translate foreign companies: P&L at average rate, balance sheet at closing rate, difference to a translation reserve.
6. Add eliminations for intercompany loans, sales, fees and the parent's investment. See intercompany transactions in QuickBooks.
7. Produce the group P&L, balance sheet and cash flow, with each company alongside.
8. Check that the balance sheet balances, eliminations net to zero and there are no unmapped balances.

Method 2: Spreadsheet Sync on QuickBooks Online Advanced

If you're on Advanced, Spreadsheet Sync can pull reports from several companies into Excel, so you skip the export and paste. Build the mapping and elimination logic once in the workbook, then refresh each month. It's a good middle ground for Excel-confident teams, but the consolidation logic is still yours to maintain.

Method 3: A spreadsheet connector

Tools such as LiveFlow keep QuickBooks data live in Google Sheets or Excel. The workflow is the same as Method 2 but works in Google Sheets as well as Excel. Pricing is quote-only.

Try Joiin free for 14 days

Method 4: A consolidation app

With Joiin, you connect each QuickBooks company (read-only), create a group, map accounts that differ, and mark intercompany accounts for elimination. Consolidated P&L, balance sheet, cash flow and trial balance are then available immediately, with each company as a column, and they update as QuickBooks updates. You can include companies on Xero, Sage and other ledgers in the same group, set ownership percentages for part-owned subsidiaries, and, on the Pro plan, translate foreign subsidiaries automatically. Reports can be packaged into branded board packs.

Method 5: Intuit Enterprise Suite

Intuit's multi-entity product includes consolidated financial statements and multi-entity eliminations and journal entries. It's the native route, but it's a different product from QuickBooks Online with a higher price, and moving to it is a migration project. It makes sense for businesses that need more operational capability across entities, not just reporting. Compare it with other options in our multi-entity accounting software guide.

Which method should you choose?

• Two companies, same chart, one currency: Excel is fine. Use our template with its built-in checks.
• Three or more companies, or regular intercompany activity: a consolidation app.
• Foreign subsidiaries: an app with multi-currency.
• Heavy custom modelling in Sheets: a spreadsheet connector.
• Outgrowing QuickBooks Online operationally: evaluate Intuit Enterprise Suite or another ERP.

Mistakes that break QuickBooks consolidations

• Unmapped new accounts silently dropping out of the group total.
• Intercompany balances that don't agree, so eliminations leave a difference.
• Forgetting the investment elimination, which overstates group net assets.
• Different period ends across companies.
• Hard-coded numbers in elimination rows that aren't updated next month.

Consolidation checklist

• All companies closed to the same date
• Every account mapped; unmapped total is zero
• Intercompany balances reconciled
• Eliminations net to zero
• Foreign subsidiaries translated at documented rates
• Group balance sheet balances
• Each company shown alongside the group

A worked example in dollars

Coastline Group has three QuickBooks Online companies. Coastline Coffee (the parent) sold $60,000 of roasted beans to Coastline Retail, which sold them all by year end, and lent Coastline Retail $150,000.

The $60,000 intercompany sale comes out of revenue and cost of sales. Group profit is unchanged at $305,000. The $150,000 loan appears as an asset in one company and a liability in the other, and both are eliminated. If Coastline Properties charges the cafés rent, that rent is also intercompany and would be eliminated from both revenue and overheads.

Part-owned subsidiaries

If the parent owns less than 100% of a subsidiary, the group still consolidates 100% of its revenue, costs, assets and liabilities, then shows the share belonging to outside owners separately as a non-controlling interest, in both profit and equity. For example, if the parent owns 80% of a subsidiary that makes $50,000 profit, $10,000 of group profit is attributed to the non-controlling interest. In Excel you calculate this yourself. In Joiin, you set an ownership percentage for each entity. Confirm the presentation with your accountant.

The group cash flow statement

A consolidated cash flow statement isn't just the companies' cash flows added together. Intercompany loans and repayments must be removed, because cash moving between group companies isn't a group cash flow. The simplest approach for management reporting is to derive the group cash flow from the consolidated P&L and the movements in the consolidated balance sheet, after eliminations. A consolidation app does this automatically.

What lenders and auditors expect

If your consolidated figures go to a bank, investor or auditor, expect them to ask how you got there. Keep the trail: the trial balances used, the mapping, the elimination entries with support, and the exchange rates. Whether you use Excel or an app, the ability to show your workings is what makes consolidated numbers credible.

Group structures and sub-groups

Not every group is a parent with a row of subsidiaries. You might have a UK holding company that owns a US sub-group, which itself owns two companies; or a property company owned jointly with a partner. Consolidate from the bottom up: first the sub-group, then the sub-group into the wider group. Each level eliminates its own intercompany items. In Excel that means a workbook per level; in a consolidation app such as Joiin, you build nested groups and the app handles each level. Map the structure on paper before you start, with ownership percentages on every line.

Moving from Excel to an app

If you've been consolidating in Excel and want to move to an app, the transition is straightforward because your QuickBooks data doesn't move. Start a trial, connect each company, and rebuild your most recent month. Use your existing mapping table as the guide for mapping in the app, and your existing elimination entries as the guide for eliminations. Compare the app's group totals with your spreadsheet. When they agree, run the next month in both, then retire the spreadsheet. Keep the old workbooks for comparatives and audit trail.

How often should you consolidate?

Monthly is the right rhythm for most groups. Quarterly consolidation means problems, such as unmatched intercompany balances or miscoded transactions, build up for three months before anyone sees them, and they're harder to fix by then. Annual consolidation for statutory accounts alone leaves the board running the group without a group view. If monthly consolidation feels like too much work, that's a sign the process needs automating, not a reason to do it less often. With an app, a monthly consolidation of a small group is a short review rather than a day's work.

Frequently asked questions