Multi-tier consolidation lets you define a parent-child entity hierarchy within a single engagement and generate consolidated trial balances at every level automatically. Instead of creating a separate engagement for each entity and manually linking results upward, the full structure lives in one place.
Note: Multi-tier consolidation is available to Financial Audit firms but isn't turned on for every firm yet. If Create Consolidated Trial Balance doesn't open the setup on the Set Details step, multi-tier consolidation isn't on for your firm. Contact support to ask about access.
When to use it
Use multi-tier consolidation when your client's corporate structure requires financial data to roll up across more than one level (for example, subsidiaries consolidating into regional holding companies, which then roll up into a top-level parent).
Single-level consolidation (linking trial balances directly into one parent) is still available for simpler structures.
Key terms
Term | Definition |
Parent Entity | The root entity at the top of the hierarchy. Displays a consolidated TB calculated from all children. Trial balances are not uploaded here. |
Child Entity | Any entity below the parent. If it has children of its own, it displays a consolidated TB. If it has no children, it is a leaf. |
Leaf Entity | A child entity with no children. This is the only type of entity where a trial balance is uploaded. |
Consolidated Trial Balance (TB) | A trial balance calculated automatically as the sum of all children's TBs at that level, inclusive of any eliminations posted there. |
Current Period | The primary accounting period being audited. |
Prior Period | The prior year's comparative data. |
Hierarchy rule: Trial balances are uploaded only to leaf entities. Every entity above the leaf level displays a calculated rollup.
What's supported
Up to 5 levels of hierarchy (1 parent + 4 levels of children)
Up to 200 entities per engagement
Internal entities (within the engagement) and linked entities (from other engagements) in the same structure
Consolidation by account or by group
Adjustments and eliminations at any level