2026-11-17 · Accounting

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:

Before and after table showing intercompany rent removed from combined income and expenses
Figure 2. Adding reports overstates income and expenses until intercompany rent is removed (example values).

Step 1: Pick your method

Check what your edition can do before you build anything.

Decision tree for choosing a combining method by QuickBooks edition
Figure 3. Which combining method fits your QuickBooks 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)

  1. Go to Reports > Reports Center and open Profit & Loss Standard.
  2. Set the dates; in Customize Report choose the report basis.
  3. Select Excel ▼ > Create New Worksheet. If QuickBooks says the report has too many columns, select Advanced and uncheck Space between columns.
  4. Repeat with Balance Sheet Standard as of the last day of the period. On a Mac, open the report and select Export.

QuickBooks Online

  1. Go to Reports > Standard reports, search for Profit and Loss and open it.
  2. Set the report period and the accounting method, then run the report.
  3. Select Export/Print ▼ > Export to Excel. If the file opens with empty-looking cells, select Enable Editing in Excel.
  4. 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).

CompanyAccount (as exported)AmountCombined line
AChecking - Operating$72,000Cash and bank
AAccumulated Depreciation($70,000)Fixed assets (net)
ATotal Assets$255,000SKIP (total row)
ARent - Property LLC$96,000Intercompany expense
BRental Income - Restaurant LLC$96,000Intercompany income
BDue from Restaurant LLC$16,000Due 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 isRemove fromAnd fromAmount
Rent: restaurant pays property LLCIntercompany incomeIntercompany expense$96,000
Management fee: catering pays restaurantIntercompany incomeIntercompany expense$24,000
Rent still owed between themDue from related companiesDue 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.

Flowchart of the six steps to combine financial statements of several companies
Figure 1. The monthly combining routine, start to finish.

Step 5: Check before you send it

CheckFormula ideaShould be
Each company balancesTotal assets - (total liabilities + equity)0
Net income agreesBS net income line - P&L net income0
Nothing left between companiesCombined due from + due to + intercompany income + expense0
Combined balance sheet balancesCombined assets - combined liabilities and equity0

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

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

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.

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

← All articles Privacy