QuickBooksHelpIntuit

Create multi-entity reports in QuickBooks Online Accountant

by Intuit•4• Updated 1 week ago

If you work with clients who manage multiple companies, you don’t need to run reports one by one. With multi-entity reporting in QuickBooks Online Accountant, you can create a Profit and Loss or Balance Sheet across several entities at once. This lets you compare performance across companies side by side, spot trends and differences quickly, and prepare a consolidated view for groups, trusts, or multi-site businesses.

Who this is useful for

Multi-entity reporting is especially helpful for:

Franchise groups: Compare sales, wages, rent, and other costs across stores.
Family groups: Consolidate trusts and companies, and eliminate inter-entity loans or distributions.
Property developers: Track projects by entity, then compare sites and remove group charges.
Multi-site retail and hospitality: Roll up results across cafes, restaurants, pubs, salons, or gyms.
Professional services and healthcare groups: Compare revenue and expenses across clinics, practices, or firms.

How multi-entity reporting works

Multi-entity reporting brings data from several client companies into a single report. From the Clients list in QuickBooks Online Accountant, you can:

Select the client companies to include.
Select a reporting period and accounting method cash or accrual.
Merge accounts, add custom rows, and post adjustments.
Export your report to PDF or CSV.

Note: Availability may vary by region or firm. If you don’t see this option yet, your firm may not have access.

Before you begin

Make sure:

Each client has an active QuickBooks Online subscription (QuickBooks Ledger, QuickBooks Online Simple Start, QuickBooks Online Essentials, QuickBooks Online Plus, or QuickBooks Online Advanced).
You’re signed in through QuickBooks Online Accountant.
You have access to each client you want to include.
(Optional) You can align charts of accounts across entities to make merging easier.

Create a consolidated report

Go to Clients and select Client list (Take me there).
Tick the box next to each client you want to include.
Select Create multi-entity reports.
Select your report period from the Report Period ▼ dropdown.
From the Choose a report ▼ dropdown, select Profit and Loss or Balance Sheet.
From the Accounting Method ▼ dropdown, select your accounting method Cash or Accrual.
Select Create.

The report grid will appear with accounts on the left and balances for each entity on the right.

Resume a saved report

If you’ve already worked on a consolidated report for the same set of clients, you can continue where you left off:

Go to Clients and select Client list (Take me there).
Tick the box for the same client files, then select Create multi-entity reports.
Select Show saved version.
QuickBooks will reload your previous draft, including:
- Report type and period
- Accounting method
- Figures, adjustments, and notes you added

Merge accounts, add rows, and post adjustments

In the report builder, you can:

Merge accounts: Tick the box related accounts and select Merge rows to combine them.
Add rows: To insert custom lines for subtotals or manual groupings, select Add row from the Actions column ▼ dropdown.
Adjustments: Enter values in the Adjustments column for consolidation entries such as eliminating inter-company transactions. These changes affect only the consolidated report, not the client’s books.

Export your report

Select the export icon .
Select the PDF (for sharing) or CSV (for further analysis).
Select the folder where you want to save your file, then select Save.

Quick tips:

Add notes to explain consolidation or adjustment decisions for collaborators.
If balances don’t look right, double-check the entities and date range.