--- name: accounts-consolidation-multi-entity description: Consolidate financial statements across multiple legal entities, subsidiaries, and business units into a single group-level financial report. Handle intercompany eliminations, foreign currency translation, equity method investments, and consolidation adjustments. Use when users need to consolidate multi-entity financials, eliminate intercompany transactions, translate foreign currency results, prepare group financial statements, manage subsidiary consolidation, or handle business combination accounting. Triggers on phrases like "financial consolidation", "intercompany elimination", "consolidate subsidiaries", "group financials", "foreign currency translation", "equity method", "multi-entity consolidation", "elimination entries", "consolidated balance sheet", "consolidated P&L", "minority interest", or related consolidation queries. --- # Multi-Entity Financial Consolidation Consolidate financial results from multiple legal entities, subsidiaries, and business units into accurate group-level financial statements that comply with GAAP/IFRS requirements. ## Workflow 1. **Map Consolidation Structure** - Document the legal entity and ownership structure: ``` CONSOLIDATION TREE TEMPLATE ════════════════════════════════════════ Parent Company (100% — reporting entity) ├── Subsidiary A (100% owned, functional currency: USD) │ ├── Sub-A1 (80% owned, functional currency: EUR) │ └── Sub-A2 (100% owned, functional currency: GBP) ├── Subsidiary B (60% owned, functional currency: JPY) │ └── JV with Partner Co (40% non-controlling interest) ├── Subsidiary C (100% owned, functional currency: USD) └── Associate D (30% owned — Equity Method, not consolidated) Consolidation approach: → Fully consolidate: All subsidiaries with >50% ownership or control → Equity method: Associates (20-50% ownership, significant influence) → Fair value / FVOCI: Passive investments (<20%) ``` - Identify functional currency and reporting currency for each entity - Document all intercompany relationships (parent-subsidiary, inter-subsidiary) 2. **Standardize Chart of Accounts (COA) Mapping** - Create COA mapping matrix: ``` COA CROSSWALK / MAPPING ════════════════════════════════════════ Group COA Account | Entity A GL | Entity B GL | Entity C GL ───────────────────┼───────────────┼───────────────┼────────────── 4000 Sales | 4000 Rev | 4100 Sales | 4000 Rev 4010 Service Rev | 4010 Serv Rev | 4100 Sales | — (merged) 5000 COGS | 5000 COGS | 5000 Cost | 5000 COGS 5100 Labor | 5010 Labor | 5010 Payroll | 5010 Labor 6000 SGA | 6000 SGA | 6000 OpEx | 6000 SGA ... | ... | ... | ... Rules: → All subsidiary accounts must map to a group account → Many-to-one mapping allowed; one-to-many NOT allowed → Revenue and expense categories aligned to segment reporting structure → Balance sheet accounts aligned to liquidity/asset classification ``` - Validate mappings quarterly when subsidiaries change chart of accounts 3. **Collect and Validate Subsidiary Financial Data** - Establish close calendar with staggered deadlines: ``` CONSOLIDATION CLOSE CALENDAR ════════════════════════════════════════ Day 1-2 (Calendar month-end + 1-2): → All entities close sub-ledgers (AP, AR, Fixed Assets, Payroll) → Run local GL trial balance Day 3-5: → Entities complete local adjustments and accruals → Submit trial balance + supporting schedules to consolidation team → Submit intercompany transaction detail report Day 4-6: → Consolidation team validates submissions: · Trial balance balances (dr = cr) · No negative balance sheet account anomalies · Balance sheet tie-out to prior period ending · Variance analysis vs. prior period / budget (>10% flagged) Day 6-8: → Foreign currency translation → Intercompany eliminations → Equity method calculations → Consolidation adjustments Day 8-10: → Consolidated financial statements generated → Management review and sign-off → Journal entries for consolidation adjustments posted ``` 4. **Perform Foreign Currency Translation** - Apply translation methodology per ASC 830 / IAS 21: ``` CURRENCY TRANSLATION RULES ════════════════════════════════════════ Income Statement accounts: → Translate at average rate for the period → Use monthly average rates (or daily if material volatility) Balance Sheet accounts: → Assets & Liabilities: Current spot rate (period-end rate) → Equity (common stock): Historical rate at transaction date → Equity (retained earnings): Plug / cumulative translation adjustment Translation adjustment (CTA): → CTA = Ending BS in functional currency - Translated BS → CTA recorded in OCI (Other Comprehensive Income) → Accumulates in cumulative translation adjustment account Rate Sources: → Central bank rates (ECB, Federal Reserve, Bank of Japan) → Bloomberg / Reuters for real-time rates → Internal rate-setting policy (consistent application) Functional Currency Change: → Assess at each reporting date → If changed: Retrospective application → Translation to new functional currency = deemed historical cost ``` 5. **Execute Intercompany Eliminations** - Build intercompany elimination schedule: ``` INTERCOMPANY ELIMINATION WORKSHEET ════════════════════════════════════════ Step 1: Identify all intercompany balances → Pull intercompany trial balance from each entity → Match Entity A's receivable to Entity B's payable → Identify and resolve unbalanced positions Step 2: Eliminate intercompany balances DR Entity B's intercompany payable $X CR Entity A's intercompany receivable $X Step 3: Eliminate intercompany revenue and expense DR Intercompany Revenue (Entity A) $Y CR Intercompany Expense (Entity B) $Y → Sales between entities must be fully eliminated Step 4: Eliminate unrealized profit in inventory → Identify intercompany sales where goods remain in inventory → Calculate unrealized profit margin DR Retained Earnings / Revenue $Z CR Inventory $Z Step 5: Eliminate unrealized profit in fixed assets → Intercompany sale of PP&E → Eliminate gain/loss on sale → Adjust depreciation going forward Step 6: Eliminate intercompany dividends → Dividends paid from subsidiary to parent DR Parent's dividend income CR Subsidiary's dividend payable UNMATCHED INTERCOMPANY RECONCILIATION ════════════════════════════════════════ → Difference threshold: Auto-flag any difference >$1 or >0.01% → Root causes: Timing differences, currency translation, missing invoices → Resolution: Adjustment entry to larger entity + investigation → Target: 100% matched before consolidation ``` 6. **Calculate Non-Controlling Interest (NCI)** - Apply NCI methodology: ``` NON-CONTROLLING INTEREST CALCULATION ════════════════════════════════════════ Balance Sheet Presentation: → NCI in equity = Subsidiary equity × NCI % → Adjust for acquisition-date fair value differences → Adjust for cumulative translation adjustments Income Statement Presentation: → NCI in net income = Subsidiary net income × NCI % → After intercompany eliminations → Shown as separate line item: "Net income attributable to NCI" Example: Subsidiary B (60% owned, NCI = 40%) Subsidiary B net income: $1,000,000 NCI share: $1,000,000 × 40% = $400,000 Consolidated Net Income: $5,000,000 Less: NCI in net income: ($400,000) Net income attributable to parent: $4,600,000 ``` - Two-method choice (IFRS): Full goodwill vs. proportionate share - Disclose NCI movements in equity roll-forward 7. **Apply Equity Method Accounting** - For associates (20-50% ownership, significant influence): ``` EQUITY METHOD ACCOUNTING ════════════════════════════════════════ Initial recognition: → Record investment at cost Subsequent measurement: → Increase by investor's share of associate's profit DR Investment in Associate $X × ownership % CR Equity Income $X × ownership % → Decrease by investor's share of associate's loss → Decrease by dividends received DR Cash $Y × ownership % CR Investment in Associate $Y × ownership % → Adjust for other comprehensive income items → Adjust for impairment (if other-than-temporary decline) Eliminate unrealized profits on upstream/downstream transactions → Upstream: Associate sells to investor (eliminate share of profit) → Downstream: Investor sells to associate (eliminate share of profit) Write-down to zero if losses exceed investment carrying value → Resume recognizing losses only when associate returns to profit ``` 8. **Generate Consolidated Financial Statements** - Prepare consolidated statements: ``` CONSOLIDATED STATEMENTS CHECKLIST ════════════════════════════════════════ Consolidated Balance Sheet: → All assets (translated + eliminated) → All liabilities (translated + eliminated) → Equity (parent + NCI) → Balance: Assets = Liabilities + Equity Consolidated Income Statement: → Revenue (after intercompany elimination) → COGS / Expenses (after intercompany elimination) → Operating income → Non-operating items → Net income before NCI → NCI share → Net income attributable to parent Consolidated Statement of Cash Flows: → Operating (indirect method: start from net income) → Investing (intercompany loan movements eliminated) → Financing (intercompany dividends eliminated) → Cash translation adjustment → Beginning cash → Ending cash Consolidated Statement of Changes in Equity: → Parent shareholders' equity movements → NCI movements → OCI components (translation adjustment, etc.) ``` - Reconcile consolidated balances to sum of individual entities - Document all consolidation adjustments with supporting schedules ## Integration Points - **Consolidation Software**: BlackLine HFM, Oracle HFM/HC, SAP BPC, OneStream, Titan, Adaptive Insights - **ERP Systems**: Each entity's local ERP (SAP, Oracle, NetSuite, Dynamics, local systems) - **General Ledger**: Entity-level GL trial balances - **Intercompany Reconciliation**: BlackLine Reconciliations, Trintech, Cadency, Servebio - **Currency Rate Providers**: Bloomberg, Reuters, ECB, Federal Reserve - **Financial Reporting**: Board reporting platforms, regulatory filing systems (SEC EDGAR) - **Close Management**: FloQast, HotDocs, Trintech Close ## Edge Cases & Handling ``` EDGE CASES ═══════════════════════════════════════ 1. Newly Acquired Subsidiary → Business combination accounting (ASC 805 / IFRS 3) → Fair value allocation of identifiable assets and liabilities → Goodwill calculation: Consideration transferred - Net identifiable assets → Consolidate from acquisition date (not full period) → Purchase price allocation (PPA) within 12 months of closing 2. Disposed / Deconsolidated Subsidiary → Derecognize assets, liabilities, and NCI → Recognize gain/loss on disposal → Reclassify cumulative translation adjustment to P&L → Present as discontinued operations if criteria met (ASC 205) 3. Cross-Holdings / Circular Ownership → Entity A owns B, B owns A (or A→B→C→A) → Use treasury stock method or algebraic method → Complex iterative elimination → Coordinate with external auditor early 4. Hyperinflationary Economy Translation → IAS 29: First restate to constant purchasing power → Then translate at current rate (BS and IS both at closing rate) → Countries: Identify per IAS 29 guidance (CPI >100% over 3 years) 5. Intra-Group Transactions with Third-Party Impact → Cost-plus transfer pricing must be arm's length → Transfer pricing documentation required (OECD guidelines) → Tax implications of elimination entries → Deferred tax on temporary differences from eliminations ``` ## Conversation Examples ### Consolidation Process Request ``` User: "We just acquired a company in Germany. How do we consolidate them?" AI: "Great — consolidating a new subsidiary involves several steps. Here's your roadmap: Phase 1: Acquisition Accounting (Months 1-3 post-close) 1. Complete Purchase Price Allocation (PPA): → Fair value all identifiable assets and liabilities → Calculate goodwill: Purchase price - Net identifiable assets → Engage valuation firm for intangible assets (customer lists, technology, brand) 2. Set up Entity in Consolidation System: → Create German entity profile → Define functional currency (EUR) → Map their chart of accounts to group COA → Set ownership percentage in consolidation tool 3. Set up Intercompany Accounts: → Create intercompany GL accounts in both entities → Establish intercompany master data → Define transfer pricing policies Phase 2: Ongoing Consolidation (Monthly) 4. EUR → USD translation (ASC 830): → Income statement: Average EUR/USD rate → Balance sheet: Period-end spot rate → Translation adjustment to OCI 5. Intercompany eliminations: → Eliminate intercompany balances (receivables/payables) → Eliminate intercompany revenue/expense → Track and resolve unmatched positions 6. NCI calculation (if not 100% acquired) Share the acquisition details and I can help you build the consolidation framework." ``` ### Intercompany Reconciliation Issue ``` User: "Our intercompany reconciliation is off by $47K between US entity and UK subsidiary. It's been unresolved for 2 months." AI: "A $47K intercompany imbalance is a consolidation blocker and audit risk. Let's resolve it: Step 1 — Isolate the difference: → Pull detailed intercompany sub-ledger from both entities → Match transaction by transaction (date, amount, reference) → Identify which specific transactions are unmatched Step 2 — Most likely root causes: → Timing difference: Invoice recorded in one entity but not the other → Currency translation: UK records in GBP, US translates at different rate → Missing invoice: One entity recorded a charge the other hasn't invoiced → Classification error: One entity coded to wrong intercompany account Step 3 — Resolution: → If timing: Document and adjust at consolidation level (with disclosure) → If missing invoice: Expedite intercompany invoicing → If currency: Accept translation difference (normal; eliminate at consolidation) → If error: Correcting journal entry in the entity with the mistake Prevention going forward: → Monthly intercompany reconciliation deadline (by close day 5) → Auto-matching tool for intercompany transactions → Escalation process: Any unmatched >$5K escalated to controller by day 7 → Quarterly intercompany audit review Want me to set up an intercompany reconciliation template?" ```