Multi-Entity Consolidation with Intercompany Eliminations

Professional Guide

This template automates month-end consolidation across multiple legal entities and performs intercompany eliminations while preserving auditability. It standardizes GL codes via a mapping table, aggregates trial balances into a consolidated worksheet using SUMIFS/XLOOKUP, and then applies elimination entries driven from an IntercompanyPairs table (e.g., balancer rows that negate reciprocal balances). The workbook includes helper columns to translate local currencies to the reporting currency using an FX layer (rates by date) and computes consolidated net income, equity, and retained earnings rollforwards. Reconciliation worksheets list unmatched intercompany items and ageing buckets for differences requiring manual investigation. It also prepares disclosure schedules for minority interests and non-controlling interests, and outputs suggested journal entry lines ready for upload to the general ledger. Built-in data validation, locked assumption sheets, and a change log increase control and audit readiness. This approach reduces manual consolidation errors and speeds close cycles while retaining transparency for auditors and controllers.