QuickBooks Multi-Entity Consolidation Tool
QuickBooks Online cannot consolidate across company files, so the monthly workaround is to export each entity's report and merge it by hand. Paste those exports here: this tool matches accounts across entities, drops the subtotal rows that would otherwise double-count, and applies your intercompany eliminations. Nothing is uploaded — it all runs in your browser.
Paste at least one export above — or load the sample — to see the consolidated statement.
How to get the exports: in each company file, run Reports → Profit and Loss (or Balance Sheet), set the same period for every entity, then Export → Export to Excel/CSV. Paste the contents of each file into its own box above. Account numbers, currency symbols, and accounting negatives like (12,500) are all handled.
On eliminations: intercompany revenue and the matching expense, intercompany receivables and payables, and investment-in-subsidiary against equity all have to come out or the consolidation overstates both sides. Enter each as a negative against the account it reverses. The partial flag marks accounts that appear in some entities but not all — usually a chart-of-accounts mismatch worth fixing at the source.
This handles the mechanics. A consolidation a lender or auditor will accept also needs consistent accounting policies across entities, currency translation for foreign subsidiaries, and minority-interest treatment where ownership is partial — see the full guide to multi-entity consolidation in QuickBooks, or book a working session if you want the monthly close built once and handed over.
More tools
Fractional vs. Full-Time CFO Cost Calculator
See the loaded cost of a full-time CFO hire versus a fractional retainer — first year and three years.
Covenant Headroom Calculator
Check your DSCR and leverage against typical covenants — and how much EBITDA headroom you have before a breach.
DSCR Calculator
Enter NOI and annual debt service to get your debt service coverage ratio — and the payment your cash flow actually supports.
Leverage Ratio Calculator
Compute debt-to-equity, debt-to-assets, and net debt/EBITDA from your balance sheet in one pass.
Cash Runway Calculator
Turn cash, revenue, and burn into a runway in months, a zero-cash date, and a 13-week cash projection.
Book a working session.
A 20-minute call, a clear read on your numbers, and a straight answer on whether a fractional CFO is the right call right now.