Consolidate QuickBooks Online companies into one monthly report

Why don’t the numbers add up when you combine companies?

The charts of accounts differ. “Rent” in one company is “Occupancy” in another.
Account names drift. A mid-year rename breaks last month’s formulas.
Intercompany entries count twice. A management fee is income in one company and an expense in another.
The reports don’t match. One company runs on cash, another on accrual, or the date ranges differ.
Late entries change the totals. A bill entered after the pack goes out leaves the combined report behind.

How do you map the charts of accounts once?

Map by account number, which stays put when someone renames an account.

Turn on account numbers in every company. Go to Settings > Account and settings > Advanced. In Chart of accounts, select Edit, turn on Enable account numbers, and select Show account numbers. Select Save, then Done.
Fill in the numbers. Go to All apps > Accounting > Chart of accounts, select Batch edit above the Action column, type the numbers in the Number column and select Save. Intuit suggests ranges such as 10000 to 19999 for assets and 60000 to 69999 for expenses.
Export each company’s account list. Go to Reports > Standard reports, open Account List, then Export/Print > Export to Excel.
Build one map sheet. One row per account in every company: Company, Account number, Account name, Group line (the line it shows on in the combined report).
Agree the group lines with your accountant.

Example (made-up accounts):

Company	Account number	Account name	Group line
Holdings LLC	61000	Rent	Occupancy
North Store LLC	61500	Occupancy	Occupancy
South Store LLC	61000	Rent and CAM	Occupancy
Holdings LLC	47000	Management fees	Intercompany income
North Store LLC	68000	Management fee	Intercompany expense

Every new account needs a row in this map before the next pack, or its amounts drop out of the combined total.

How do you build the monthly pack in Excel?

Use the same accounting method in every company. On each report, choose Cash or Accrual under Accounting method, then Run report. To change the default, go to Settings > Account and settings > Advanced and edit the Accounting section.
Export each company’s Profit and Loss. Go to Reports > Standard reports, open Profit and Loss, set the period to the month, then Export/Print > Export to Excel. If data is missing in Excel, the file is in Protected View: select Enable Editing.
Export each company’s Balance Sheet the same way, as of the last day of the month.
Stack the exports. Paste each company’s data onto one sheet with a Company column, or put the files in one folder and use Data > Get Data > From File > From Folder, then Combine & Load. Microsoft says each file “should have the same schema with consistent column headers, data types, and number of columns.”
Add the group line. Look up each row’s company and account number in the map sheet.
Total by group line and company. A formula such as =SUMIFS(Amount, GroupLine, $A5, Company, B$4) gives one column per company. Add an Eliminations column and a Combined column.

On Advanced, Spreadsheet Sync can replace steps 2 to 4. Intuit says it can “use pre-made templates, build consolidated reports for multiple companies, and refresh your data in a single step,” and that automatic refresh “requires setup.” Check that every company appears in its Select company dropdown before you rely on it.

If the workbook breaks whenever someone adds a column, see why spreadsheet reports break when columns change.

How do you handle intercompany entries?

Give every pair of companies matching accounts, then remove both sides in the Eliminations column each month.

Management fees and recharges: income in one company, expense in the other.
Loans and advances: “Due from” an asset in one company, “Due to” a liability in the other.
Sales between companies: ask your accountant how to treat profit still sitting in the buyer’s inventory.

Example (made-up numbers, one month):

Line	Holdings LLC	North Store LLC	South Store LLC	Eliminations
Management fee income	10,000	0	0	(10,000)
Management fee expense	0	6,000	4,000	(10,000)
Due from North Store	25,000	0	0	(25,000)
Due to Holdings	0	25,000	0	(25,000)

If the two sides differ, one company is missing an entry. Fix it in that company’s books before the pack goes out.

If you post recurring intercompany entries by import, the QuickBooks Online journal entry import checker catches file problems before they reach your books.

How do you check the combined report is right?

Each company’s column equals its own report: net income and total assets match.
Each elimination pair matches: income removed equals expense removed, and each “Due from” equals its “Due to”.
Intercompany lines are zero in the Combined column.
Assets equal liabilities plus equity in the combined balance sheet.
No unmapped rows: the count of rows with no group line is zero.
Last month still matches what you sent. If it moved, someone changed a closed month.

What are your options?

Option	Good for	Watch for
Exports, a map sheet and SUMIFS in Excel	Two to five companies with a stable chart of accounts	Hours each month, and a workbook only one person understands
Spreadsheet Sync on QuickBooks Online Advanced	Companies already on Advanced who work in Excel	Setting up refresh, and keeping the map current
Intuit Enterprise Suite	Groups ready to move every company onto one platform, with “automatic eliminations linked to the source transaction”	A migration, and Intuit answers “Not at this time” on entities outside the US
A consolidation or reporting app sold by subscription	Many companies, or currencies to translate	Mapping accounts and setting elimination rules inside the app
Bring in an outside team (Reports & answers)	A combined pack rebuilt and checked against what you already send	Read access to each company and time with whoever keeps the books

If one person keeps the workbook running, read the spreadsheet only one person understands before they’re out at month-end.

FAQ

Can QuickBooks Online combine two companies into one report? Each company’s reports show only its own books. On Advanced, Intuit says Spreadsheet Sync can build consolidated reports for multiple companies; on other plans, export and combine in Excel.

Should I merge my companies into one QuickBooks Online company? Ask your CPA first. Each legal entity’s tax return and loan reporting depend on its own books.

Do all the companies need the same chart of accounts? A map sheet linking every account to a shared group line does the job, as long as each new account is added to it.

Which accounting method should the combined report use? The same one in every company. Agree it with your accountant and set it on each report before you export.