Consolidation & Intercompany Elimination Workbook
A consolidation workbook that pulls in entity-level trial balances against a shared chart of accounts, tracks intercompany balances in a dedicated register, and posts elimination journal entries through to a consolidated income statement, balance sheet, and NCI equity bridge. FX translation is available as an optional single-currency override rather than a full multi-currency translation engine.
Ideal for group controllers running a monthly or quarterly consolidation.
Contents:
- Cover
- Setup (Entities, Ownership & Periods)
- Group Chart of Accounts
- Trial Balance Input (YTD by Quarter)
- Intercompany Register
- Elimination Journal Entries
- Consolidated Trial Balance
- Consolidated Income Statement
- Consolidated Balance Sheet
- NCI & Investment Elimination Bridge
Related Templates
Accounting13-Week Cash Flow Forecast
Forecast weekly cash inflows and outflows on a rolling 13-week basis, broken out by AR, AP, payroll, debt service, and tax.
AccountingAccounting Standards Conversion Workbook (GAAP to IFRS)
Convert a GAAP trial balance to IFRS with a full first-time-adoption difference register, journal entries, and disclosure checklist.
AccountingAudit Working Paper
Document audit procedures, evidence gathered, and conclusions reached in a structured working paper ready for reviewer sign-off.
AccountingBoard Financial Pack
Run a focused board finance session — KPIs, P&L dynamics, forecast, and decisions required.