Consolidation software for QuickBooks Online: six ways to combine several company files

Consolidation software for QuickBooks at a glance

For QuickBooks Online companies, consolidation software either reports across the files from outside, as Joiin, Spotlight Reporting and Fathom, the financial reporting app (fathomhq.com), do; books the group into a new QuickBooks company, as JustConsolidate does; or sits inside Intuit's own products, QuickBooks Online Advanced and Intuit Enterprise Suite.

Intuit says each QuickBooks Online company is its own paid subscription and keeps its data separate even under one sign-in, so every route below starts from separate files.

Pick Joiin for 5 to 10 QuickBooks Online companies that need group reports without rebuilding them in Excel; Core is $122 a month for 10 companies, billed monthly. Pick JustConsolidate when the consolidated books should live in a QuickBooks company. Pick Intuit Enterprise Suite for a US-only group moving into one Intuit system.

Joiin: reports across QuickBooks Online files

Joiin works alongside your QuickBooks Online files and builds the group reports in its own app. Each company's Admin user connects it, and the data refreshes every 24 hours. By default Joiin pulls the previous 3 and next 2 fiscal years.

An elimination, which takes an intercompany item out of the group figures so it is not counted twice, can run by account, by contact or by transaction for QuickBooks companies. Only account and transaction eliminations change the financial statements. Joiin QuickBooks covers the connection step by step.

JustConsolidate: a consolidation company in QuickBooks

JustConsolidate keeps the group inside QuickBooks. You create a new QuickBooks company, a consolidation company, with a chart of accounts you design, and JustConsolidate posts each company's trial balance into it as a journal entry. Group reports then run from that company. JustConsolidate says it only reads your existing companies and needs admin rights to connect each one. Its $65 a month for 5 companies leaves out the QuickBooks subscription for the new company. See Joiin vs JustConsolidate.

Fathom and Spotlight Reporting

Fathom lists QuickBooks Online and Desktop among its integrations and prices by company count: $295 a month for 5 companies, billed monthly. It says it is a management reporting tool for internal reporting, not a statutory reporting tool. Spotlight Reporting imports QuickBooks data and prices by organization: $175 a month for 5 companies by its per-organization prices. Both keep the group numbers in their own app, not in QuickBooks.

Intuit's own routes: Spreadsheet Sync and Enterprise Suite

Spreadsheet Sync is Intuit's add-in that sends QuickBooks reports into Excel and can group companies. On QuickBooks Online Advanced it combines three reports in a spreadsheet: Balance Sheet (Multiple Period), Profit and Loss (Multiple Period) and Trial Balance. A cash flow statement is not on that list. Accounts combine only when name, type and level match; see can QuickBooks Online consolidate multiple companies.

Intuit Enterprise Suite is a separate product from QuickBooks Online, priced by quote, and intercompany entries and elimination accounts are managed from its parent company. Intuit says it does not support entities outside the US at this time. For the plan-by-plan view, read Intuit Enterprise Suite vs QuickBooks Online Advanced.

Joiin connects QuickBooks Online companies inside a 14-day trial on Max that asks for no card.