Consolidation

Combine two QuickBooks companies in one workbook.

Choose a period, accounting basis, and companies. Review the statements and checks, then download the Excel workbook.

Ready for review
Sample data. The companies and balances on this page are not from QuickBooks. Live access has not been connected.

Settings

Select reports to consolidate

Mapping version 1.0
Accounting basis
2 of 2 companies included

Sample data refreshed at 8:43 AM

Consolidated revenue$800,500July 2026 · 2 companies
Net income$182,72522.8% net margin
Checks passed4/4$0.00 difference
Companies included2/2Accrual basis

Workbook preview

July 2026 statements

Account groupNorthstarHarborConsolidated
Income
Service revenue$346,000$191,500$537,500
Product revenue$136,000$127,000$263,000
Total revenue$482,000$318,500$800,500
Cost of goods sold$178,340$98,735$277,075
Gross profit$303,660$219,765$523,425
Operating expenses
Payroll and contractors$112,600$81,100$193,700
Occupancy$28,400$22,300$50,700
Marketing$21,800$17,400$39,200
Other operating expenses$35,600$21,500$57,100
Total operating expenses$198,400$142,300$340,700
Net income$105,260$77,465$182,725

Checks

Reconciliation

✓ 4 of 4 passed
Revenue mapped to workbookSource $800,500 · Workbook $800,500
$0
Net income mapped to workbookSource $182,725 · Workbook $182,725
$0
Total assets mapped to workbookSource $1,006,800 · Workbook $1,006,800
$0
Balance sheet balancesSource $1,006,800 · Workbook $1,006,800
$0