Group statements from entity trial balances
Group Consolidation combines mapped entity trial balances into group financial statements and applies intercompany eliminations, with an audit trail from each group line back to the entity accounts. Consolidate Files and Consolidate Sheets pull scattered workbooks together first.
Multi-entity targets mean multiple trial balances, charts of accounts and currencies. Consolidating them by hand, and redoing it when a TB changes, is days of error-prone work.
- Consolidated group flatfile
- Intercompany elimination schedule
- Group financial statements with entity drill-down
How it works
- Import and map each entity trial balance.
- Translate non-English TBs in-table if needed.
- Run Group Consolidation and review intercompany eliminations.
- Build group P&L, balance sheet and cash flow from the consolidated flatfile.
Questions about group consolidation
Does it handle foreign-language trial balances?
Yes. Translate TB converts Swedish, German, Spanish, French, Dutch, Italian and Portuguese account names to English before mapping.
Related
- Trial balance mapping — Import any TB, translate it, and let AI suggest the mapping to your hierarchy.
- Build financial statements — From mapped TB to P&L, balance sheet, NWC, net debt and cash flow schedules.
- 38 free Excel tools & model audit — Formula consistency, hardcodes, broken refs, plus 38 free formatting, navigation and cleaning tools.
- Trial balance mapping template — template
- ZAF Tools vs Daloopa
See it on your own trial balance
Book a 30-minute live demo on your own trial balance, or request a trial for your team.