How to Combine Financial Statements for Multiple Companies in QuickBooks (Desktop and Online)
↓ Get the free Excel + PDF kit for this article
If you own a restaurant and the LLC that owns its building, or a store plus a catering company, sooner or later a bank, an SBA lender or your CPA will ask for one profit and loss and one balance sheet for the whole group. QuickBooks keeps each company in its own file, and most editions have no button that adds them together. People copy numbers into a spreadsheet, the totals do not tie, and the rent one company pays the other shows up as both income and expense. This guide shows a method you can follow with nothing but QuickBooks and Excel or Google Sheets.
It is written for owners and bookkeepers who manage two to four related companies with the same owners, on the same fiscal year. If outside investors own part of a company, or one company keeps its books in another currency, read the FAQ first.
Why adding the reports together is not enough
Combined statements show the group as if it were one business. Anything that happened between your own companies did not happen with the outside world, so it must come out. The three usual items are:
- Charges between companies - rent, management fees, shared staff billed from one company to another.
- Balances between companies - one company owes another (due to / due from, intercompany loans).
- Ownership between companies - a holding company's investment in a company that is also in the group.

Step 1: Pick your method
Check what your edition can do before you build anything.
- QuickBooks Desktop Enterprise: Reports > Combine Reports from Multiple Companies. Intuit lists Balance Sheet Standard and Summary, Profit & Loss Standard and by Class, Statement of Cash Flows and Trial Balance. Accounts combine only when name, type and level match, and the result opens in Excel. Intuit's article does not describe removing intercompany amounts, so you still do Step 4 yourself.
- QuickBooks Online Advanced: Reports > Spreadsheet sync > Build multi-company reports (Balance Sheet and Profit and Loss - Multiple Period, Trial Balance). Spreadsheet Sync is for Advanced (and accountant users in an Advanced file).
- Desktop Pro, Premier, Mac and the other Online plans: no built-in combine. Intuit's own help suggests exporting each report to Excel and combining there. The rest of this guide covers that method, which works for every edition.

Step 2: Export the same two reports from every company
Use the same dates and the same basis (cash or accrual) for every company. If one company is on a different fiscal year or basis, fix that first - the totals cannot be combined honestly otherwise.
QuickBooks Desktop (Windows)
- Go to Reports > Reports Center and open Profit & Loss Standard.
- Set the dates; in Customize Report choose the report basis.
- Select Excel ▼ > Create New Worksheet. If QuickBooks says the report has too many columns, select Advanced and uncheck Space between columns.
- Repeat with Balance Sheet Standard as of the last day of the period. On a Mac, open the report and select Export.
QuickBooks Online
- Go to Reports > Standard reports, search for Profit and Loss and open it.
- Set the report period and the accounting method, then run the report.
- Select Export/Print ▼ > Export to Excel. If the file opens with empty-looking cells, select Enable Editing in Excel.
- Repeat for the Balance Sheet.
Step 3: Put every row in one list and map it
Make one sheet with four columns: Company (A, B, C...), Account, Amount and Combined line. Paste each company's report rows under each other and type a short combined line next to each account - the same line for accounts that mean the same thing (Phone and Telephone both go to Other operating expenses).
| Company | Account (as exported) | Amount | Combined line |
|---|---|---|---|
| A | Checking - Operating | $72,000 | Cash and bank |
| A | Accumulated Depreciation | ($70,000) | Fixed assets (net) |
| A | Total Assets | $255,000 | SKIP (total row) |
| A | Rent - Property LLC | $96,000 | Intercompany expense |
| B | Rental Income - Restaurant LLC | $96,000 | Intercompany income |
| B | Due from Restaurant LLC | $16,000 | Due from related companies |
Example values for three made-up companies.
Three rules prevent most errors: keep each amount's sign exactly as the report shows it (accumulated depreciation and owner draws are negative), mark every heading and total row as SKIP, and map the balance sheet's Net Income row to its own line so you can check it against the P&L.
Then build the combined statement with one formula per line and company. With the list in columns A to D on a sheet named Data, company code in C1 and the line name in A5:
=SUMIFS(Data!$C:$C, Data!$A:$A, C$1, Data!$D:$D, $A5)
Copy it across for each company and down for each line. A total column is a plain =SUM() of the company columns. The formula works the same in Google Sheets.
Step 4: Match, then remove intercompany amounts
Before you eliminate anything, the two sides must agree. Add up every company's due-from balance and every company's due-to balance; they must be equal. Do the same with intercompany income and intercompany expense. A difference means one company recorded something the other did not - usually a payment in transit at month end or a bill one company paid for the other. Fix it in QuickBooks and export again.
Then add an Eliminations column. Each elimination removes the same amount from two lines on opposite sides of the same statement:
| What it is | Remove from | And from | Amount |
|---|---|---|---|
| Rent: restaurant pays property LLC | Intercompany income | Intercompany expense | $96,000 |
| Management fee: catering pays restaurant | Intercompany income | Intercompany expense | $24,000 |
| Rent still owed between them | Due from related companies | Due to related companies | $16,000 |
Example values.
The elimination for a line is =-(SUMIF(Elim!$B:$B,$A5,Elim!$D:$D)+SUMIF(Elim!$C:$C,$A5,Elim!$D:$D)), and the combined column is total plus eliminations. In the example, combined income falls from $1,670,000 to $1,550,000 and total assets from $1,286,000 to $1,270,000, while net income stays $183,000.

Step 5: Check before you send it
| Check | Formula idea | Should be |
|---|---|---|
| Each company balances | Total assets - (total liabilities + equity) | 0 |
| Net income agrees | BS net income line - P&L net income | 0 |
| Nothing left between companies | Combined due from + due to + intercompany income + expense | 0 |
| Combined balance sheet balances | Combined assets - combined liabilities and equity | 0 |
If a company does not balance, a real account was marked SKIP or a total was mapped. If net income disagrees, the P&L and balance sheet were run for different dates.
Common mistakes
- Mapping a total row as well as its accounts, which counts it twice.
- Flipping signs so everything is positive - negative depreciation and draws must stay negative.
- Mixing cash and accrual reports, or different fiscal years.
- Putting an owner's personal loan in due from related companies; it is not between group companies and must not be eliminated.
- Eliminating amounts that do not match on both sides, which hides a bookkeeping error instead of fixing it.
- Calling the result an audited or GAAP consolidation. It is a management and lender summary unless an accountant prepares it as more.
FAQ
Can QuickBooks Online combine companies without Advanced?
Not with a built-in report. Intuit's community answer points to exporting each company's reports to Excel or using a third-party reporting app.
Do I need the same chart of accounts in every company?
No. The combined line column does the matching. Matching account names only matters for the Desktop Enterprise combine feature.
What if outside investors own part of one company?
Then the combined statements need a minority (noncontrolling) interest. This method does not cover that - ask your CPA.
One company keeps its books in Korean won. Can I include it?
Convert its reports to US dollars first using a documented rate, then paste them. Currency translation rules are beyond this guide.
How often should I do this?
Monthly if a lender watches covenants; otherwise quarterly and at year end. Exporting the same report settings each time keeps the rows in the same order.
Checklist
- Bank and card accounts reconciled in every company
- Same dates and basis for every report
- Every row mapped; heading and total rows skipped
- Due from = due to, intercompany income = intercompany expense
- Eliminations entered; all four checks are 0
- Combined P&L and balance sheet saved as PDF with the period on top
You can download the ready-made Multi-Company Combined Financial Statements Builder 2026 for free in the Free kit download box below (Excel + PDF guide, no sign-up).
This article is for education only and is not tax, legal or accounting advice. Example companies and numbers are made up. Menu names were checked against Intuit help articles in November 2026 and may change. QuickBooks is a registered trademark of Intuit Inc.; not affiliated with or endorsed by Intuit.
Free kit download
Tools to follow this article step by step. No sign-up needed.
- Excel workbook (.xlsx)Multi_Company_Combined_Financials_2026_EN.xlsx · 44 KB
- Step-by-step guide (PDF)Combined_Financials_Guide_Checklist_2026_EN.pdf · 100 KB
Free to use for yourself and your own business; please do not resell or redistribute. General information, not tax, legal or accounting advice; check every figure against your own records. QuickBooks is a trademark of Intuit Inc.; BIZLEX is not affiliated with Intuit.
Sources
- Intuit: Combine reports from multiple company files in QuickBooks Desktop Enterprise
- Intuit: Combine reports from multiple companies using Spreadsheet Sync (QuickBooks Online Advanced)
- Intuit: Create and edit reports in Spreadsheet Sync (Advanced or Accountant)
- Intuit: Export reports to Excel (QuickBooks Online)
- Intuit: Export reports as Excel workbooks in QuickBooks Desktop
- QuickBooks Community: How do I get consolidated reports for multiple companies?
- QuickBooks Community: QBO combined financial reporting from multiple companies