Automate intercompany elimination entries for multi-entity consolidation

Steps

1. Maintain an intercompany transaction register that records each intercompany payable, receivable, revenue, and expense with fields for originating entity, counterpart entity, account code, and period.
2. At period-end, query the register to identify matched pairs (e.g., Entity A receivable offset by Entity B payable for the same transaction) and flag unmatched items for investigation before elimination.
3. Generate elimination journal entries: debit the intercompany revenue or receivable account and credit the intercompany expense or payable account in the consolidating entity, ensuring the entry nets to zero at the consolidated level.
4. Apply currency translation to intercompany balances denominated in non-reporting currencies before elimination, using the appropriate rate type (current for balance sheet, average for income statement) per ASC 830.
5. Post elimination entries to the consolidation journal — most ERPs support a dedicated elimination entity or book — and re-run the consolidated trial balance to verify intercompany accounts net to zero.
6. Log each elimination batch with a run ID, period, eliminating entity pair, and entry amounts to support audit trail and period-close sign-off requirements.