Finance AI Skill

Accounts Consolidation Multi Entity

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

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)

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

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

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

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

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

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

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?"

Disclaimer: All rights reserved by Circulos AI. These skills are specifically designed for Claude Code, Claude Cowork, Codex, and OpenClaw. When using or referencing any skill, please provide proper attribution to Circulos AI.