The workflow

How ConsoliView works

Read-only connections to your QuickBooks entities in; consolidated statements and a workpaper package that ties out. Here is every step — and why you confirm every elimination yourself.

The workflow, step by step

Connect each QuickBooks Online entity (read-only)

Authorize a read-only OAuth connection to every company in the group. ConsoliView pulls each entity's chart of accounts, trial balance, and general ledger. Tokens are encrypted and the connection cannot modify your books — ConsoliView never writes back. Disconnect any entity at any time.

Map every entity to one consolidated chart

Different companies almost never share an identical chart of accounts. ConsoliView maps each entity's accounts to a single master chart so like accounts roll up into the same caption. You review and adjust the mapping, and ConsoliView remembers it for the next period.

Combine into the consolidation worksheet

ConsoliView combines the mapped trial balances into a worksheet with a column per entity and a combined total. This is the starting point — a simple combination, before any intercompany activity is eliminated, so you can see exactly what each entity contributes.

Review and confirm every intercompany elimination

ConsoliView detects candidate intercompany balances and transactions — due-to/due-from, intercompany sales, management fees, and the like — matches the two sides, and recommends an elimination with a plain-English rationale. You confirm or reject each one. Nothing is eliminated until you confirm it, and your decisions are recorded.

Set ownership, method, and non-controlling interest

Enter each entity's ownership percentage and consolidation method. For partially owned subsidiaries, ConsoliView computes the non-controlling interest split on equity and earnings. The consolidated statements are only as correct as these inputs, which you own and control.

Review the consolidated statements and export

See the consolidated Balance Sheet, Income Statement, and Cash Flow on screen, with drill-down from each line to its entity detail and eliminations. Export a multi-tab Excel workbook and an indexed PDF workpaper package — entity columns, an eliminations column, NCI, and a consolidated total that ties.

What ConsoliView does, by area

Each capability supports your work — detection and recommendations are aids for your review, not conclusions you should rely on without professional judgment.

Chart-of-accounts mapping

Normalizes each entity's chart to a single consolidated chart so accounts with different names and numbers across companies roll up into the same caption.

Trial-balance combination

Combines the mapped trial balances into a worksheet with one column per entity and a combined column, before eliminations, so each entity's contribution is visible.

Intercompany detection & matching

Surfaces candidate intercompany receivables, payables, revenue, and expenses, matches the two sides where it can, and flags amounts that do not tie for your attention.

Confirmed eliminations

Recommends an elimination entry for each candidate with a rationale; only the candidates you confirm are posted to the eliminations column of the worksheet.

Non-controlling interest

Computes NCI on equity and earnings from the ownership percentage and consolidation method you configure for each partially owned entity.

Consolidated statements

Produces consolidated Balance Sheet, Income Statement, and Cash Flow on screen, with drill-down from each caption to entity detail and the eliminations behind it.

Comparatives & batch runs

Adds prior-period comparative columns and runs multiple groups or periods together, so recurring consolidations are repeatable.

Excel & PDF workpaper package

Exports a multi-tab Excel workbook and an indexed PDF package documenting the mapping, combination, eliminations, NCI, and consolidated totals that tie.

Important — this is not an audit

ConsoliView produces consolidated financials as a preparation aid — not an audit, not a GAAP-conformity opinion or guarantee, and not a substitute for a CPA or auditor. Consolidation involves judgment; you own every elimination and ownership call.

Ready to try it?

Connect your entities read-only and run your first consolidation on a 14-day free trial — no credit card.

Start 14-day trial See pricing