Finance AI Skill

Intercompany Consolidation

Manage intercompany transactions and financial consolidation including intercompany account reconciliation, elimination entries, multi-entity consolidation, foreign currency translation, and consolidated financial reporting. Use when reconciling intercompany accounts, preparing consolidated financial statements, managing intercompany eliminations, or handling multi-entity reporting. Triggers on phrases like "intercompany", "consolidation", "elimination entries", "multi-entity", "foreign currency translation", "consolidated reporting", "intercompany reconciliation", "parent company", "subsidiary", "transfer pricing", "group reporting", "consolidated balance sheet".

Intercompany & Consolidation

Manage intercompany transactions, eliminations, and multi-entity consolidation for accurate consolidated financial reporting.

Intercompany Transaction Management

IC Framework & Reconciliation

INTERCOMPANY TRANSACTION FRAMEWORK:
════════════════════════════════════

ENTITY STRUCTURE:
  Parent: [Company] Inc. (US — reporting entity)
  Subsidiaries:
    - [Company] UK Ltd. (UK — European operations)
    - [Company] Canada Inc. (Canada — Canadian operations)
    - [Company] Singapore Pte. Ltd. (Singapore — APAC operations)
    - [Company] IP Holdings LLC (US — IP holding company)
  Total entities: 5 (3 operating + 2 holding)
  
  Functional currencies:
    US entities: USD
    UK subsidiary: GBP
    Canada subsidiary: CAD
    Singapore subsidiary: SGD
  Reporting currency: USD

INTERCOMPANY TRANSACTIONS (Monthly Volume):
  ┌────────────────────────────┬──────────┬──────────┬──────────┐
  │ Transaction Type           │ Count    │ Value    │ Frequency│
  ├────────────────────────────┼──────────┼──────────┼──────────┤
  │ IP licensing fees          │ 4        │ $840K    │ Monthly  │
  │ (subsidiary → IP holding)  │          │ /month   │          │
  │ Shared services allocation │ 4        │ $120K    │ Monthly  │
  │ (HQ → subsidiaries)        │          │ /month   │          │
  │ Intercompany loans         │ 2        │ Varies   │ As needed│
  │ (HQ → international sub.)  │          │          │          │
  │ Intercompany sales         │ 6        │ $45K     │ Monthly  │
  │ (cross-border license)     │          │ /month   │          │
  │ Management fees            │ 4        │ $60K     │ Monthly  │
  │ (subsidiary → HQ)          │          │ /month   │          │
  └────────────────────────────┴──────────┴──────────┴──────────┘

  Monthly IC transaction count: ~16-20
  Monthly IC transaction value: ~$1.07M
  Annual IC volume: ~$12.8M

INTERCOMPANY ACCOUNTING POLICY:
  1. Transfer pricing: Arm's length basis (OECD guidelines)
     - IP licensing: 5% of subsidiary revenue (cost-plus method)
     - Shared services: Cost allocation (headcount/usage-based)
     - Management fees: Flat fee (budgeted annually)
  
  2. Intercompany pricing:
     - Goods/services: Market-based pricing
     - Loans: SOFR + margin (arm's length)
     - IP licensing: Comparable uncontrolled price (CUP)
  
  3. Settlement terms: Net 30 (standard)
     - Monthly invoice issuance (by 5th of following month)
     - Payment due by 35th day
     - Open item tracking (aging report monthly)
  
  4. Documentation:
     - Transfer pricing study: Annual (external advisor)
     - Master file + Local files: Maintained per jurisdiction
     - Intercompany agreements: Executed (all entity pairs)
     - Invoices: Issued monthly (detailed, compliant)

INTERCOMPANY RECONCILIATION PROCESS:
  Monthly close timeline:
    Day 1-3: Entity-level IC transaction posting
    Day 3-5: IC reconciliation (match invoices to payments)
    Day 5-7: Dispute resolution (differences investigation)
    Day 7-8: Adjustment entries (timing differences, FX)
    Day 8-10: Reconciliation sign-off (Controller + IC manager)
    Day 10-15: Consolidation entries (elimination)
  
  Reconciliation tools:
    Primary: BlackLine IC Reconciliation (automated matching)
    Backup: Excel (small subsidiaries, manual process)
    Frequency: Monthly (all IC balances)
    Target: 100% reconciled by Day 8 of close

RECONCILIATION RESULTS (Q4 2024):
  December:
    IC transactions posted: 18
    Auto-matched: 14 (78%)
    Manual matched: 3 (17%)
    Disputed/adjustment: 1 (5%) — FX timing difference
    Resolution time: 2 days
    Sign-off: Day 6 (ahead of Day 8 target) ✓
  
  November:
    IC transactions posted: 16
    Auto-matched: 13 (81%)
    Manual matched: 2 (13%)
    Disputed/adjustment: 1 (6%) — invoice amount difference
    Resolution time: 3 days
    Sign-off: Day 7 ✓
  
  October:
    IC transactions posted: 17
    Auto-matched: 12 (71%)
    Manual matched: 4 (24%)
    Disputed/adjustment: 1 (6%) — payment timing difference
    Resolution time: 2 days
    Sign-off: Day 8 ✓ (on target)

Consolidation Process

Consolidated Financial Statements

CONSOLIDATION PROCESS:
══════════════════════

CONSOLIDATION METHODOLOGY:
  1. Gather: Entity-level trial balances (all 5 entities)
  2. Translate: Foreign currency translation (subsidiaries → USD)
  3. Eliminate: Intercompany transactions (revenue, expenses, balances)
  4. Adjust: Fair value adjustments, acquisition accounting
  5. Consolidate: Sum all entity balances (adjusted)
  6. Review: Consolidated trial balance review (Controller + CFO)
  7. Report: Consolidated financial statements (GAAP)

FOREIGN CURRENCY TRANSLATION:
  Method: Current rate method (ASC 830)
  Translation:
    Assets/Liabilities: Current exchange rate (balance sheet date)
    Revenue/Expenses: Average exchange rate (period)
    Equity: Historical exchange rate
  
  Exchange rates (December 2024):
    ┌─────────────────┬──────────┬──────────┬──────────┐
    │ Currency        │ Period   │ Avg Rate │ Spot Rate│
    │                 │ End Rate │          │          │
    ├─────────────────┼──────────┼──────────┼──────────┤
    │ GBP (UK)        │ 1.270    │ 1.265    │ 1.272    │
    │ CAD (Canada)    │ 0.715    │ 0.718    │ 0.714    │
    │ SGD (Singapore) │ 0.742    │ 0.745    │ 0.741    │
    └─────────────────┴──────────┴──────────┴──────────┘
  
  Translation adjustments (Cumulative Translation Adjustment — CTA):
    UK subsidiary: $42,000 (unrealized gain in AOCI)
    Canada subsidiary: ($18,000) (unrealized loss in AOCI)
    Singapore subsidiary: $12,500 (unrealized gain in AOCI)
    ════════════════════════════════════
    NET CTA: $36,500 (unrealized gain — in AOCI, not recycled)

INTERCOMPANY ELIMINATION ENTRIES (December 2024):
  ┌──────────────────────────────────┬────────────┬────────────┐
  │ Elimination Entry                │ Debit      │ Credit     │
  ├──────────────────────────────────┼────────────┼────────────┤
  │ IC Revenue (HQ recognized)       │ $840,000   │            │
  │  vs IC Expense (subsidiary)      │            │ $840,000   │
  │  (IP licensing fees)             │            │            │
  ├──────────────────────────────────┼────────────┼────────────┤
  │ IC Receivable (subsidiary)       │ $320,000   │            │
  │  vs IC Payable (HQ)              │            │ $320,000   │
  │  (open IC invoices)              │            │            │
  ├──────────────────────────────────┼────────────┼────────────┤
  │ IC Revenue (subsidiary)          │ $180,000   │            │
  │  vs IC Expense (HQ)              │            │ $180,000   │
  │  (management fees)               │            │            │
  ├──────────────────────────────────┼────────────┼────────────┤
  │ IC Receivable (HQ)               │ $85,000    │            │
  │  vs IC Payable (subsidiary)      │            │ $85,000    │
  │  (open management fee invoices)  │            │            │
  ├──────────────────────────────────┼────────────┼────────────┤
  │ IC Loan Interest (HQ)            │ $15,200    │            │
  │  vs IC Interest Expense (sub.)   │            │ $15,200    │
  │  (intercompany loan interest)    │            │            │
  ├──────────────────────────────────┼────────────┼────────────┤
  │ IC Loan Balance (HQ)             │ $2,800,000 │            │
  │  vs IC Loan Payable (sub.)       │            │ $2,800,000 │
  │  (outstanding loan principal)    │            │            │
  └──────────────────────────────────┴────────────┴────────────┘

  Total elimination entries: 6 (standard monthly set)
  Total elimination value: $4.44M (balance sheet) + $1.04M (P&L)
  Verification: Post-elimination IC balances = $0 ✓

CONSOLIDATED FINANCIAL STATEMENTS:
  Consolidated balance sheet (December 2024):
    Total assets: $2,485,000,000
    Total liabilities: $455,000,000
    Total equity: $2,030,000,000
    Cash (consolidated): $17,500,000
    Debt (consolidated): $20,000,000
  
  Consolidated income statement (FY2024):
    Revenue: $168,000,000
    COGS: ($42,000,000)
    Gross profit: $126,000,000
    Operating expenses: ($84,000,000)
    Operating income: $42,000,000
    Net income: $31,500,000
  
  Non-controlling interest: $0 (100% owned subsidiaries)
  Goodwill: $125,000,000 (from prior acquisitions — tested annually)
  Impairment test: Passed (Q4 2024 — no impairment)

CONSOLIDATION TOOLS:
  Primary: BlackLine Consolidation (automated workflow)
  Backup: Excel consolidation model (manual backup)
  Frequency: Monthly (management reporting) + Quarterly (external audit)
  Timeline: Day 1-10 (consolidation) + Day 10-20 (review + reporting)
  Accuracy: 100% (zero restatements, zero material adjustments)

Transfer Pricing

Compliance & Documentation

TRANSFER PRICING COMPLIANCE:
═════════════════════════════

TRANSFER PRICING POLICY:
  Methodology: Arm's length principle (OECD Guidelines)
  Documentation: Master file + Local files + Country-by-country report
  
  IP Licensing:
    Method: Comparable uncontrolled price (CUP)
    Rate: 5% of subsidiary revenue (benchmark: 4-6%)
    Benchmarking: Annual (external advisor)
    Last review: October 2024 — within range ✓
    Risk: LOW (well-documented, within benchmark)
  
  Shared Services:
    Method: Cost-plus (5% markup)
    Allocation base: Headcount (60%) + usage metrics (40%)
    Markup: 5% (benchmark: 3-7%)
    Last review: October 2024 — within range ✓
    Risk: LOW (cost allocation well-documented)
  
  Intercompany Loans:
    Method: Comparable yields (bond market data)
    Rate: SOFR + 1.0-1.5% (based on credit profile)
    Current rate: 4.8% (SOFR 3.8% + 1.0%)
    Last review: October 2024 — within range ✓
    Risk: LOW (arm's length rate applied)

DOCUMENTATION STATUS:
  Master file: ✓ Updated (October 2024)
  Local files (per jurisdiction):
    UK: ✓ Updated (November 2024)
    Canada: ✓ Updated (November 2024)
    Singapore: ✓ Updated (November 2024)
  Country-by-country report: ✓ Filed (December 2024)
  Benchmarking study: ✓ Current (valid through Oct 2025)
  
  Tax authority inquiries: 0 (FY2024)
  Transfer pricing audit: 0 (FY2024)
  Advance pricing agreement: N/A (not pursued — low risk)

TRANSFER PRICING RISK ASSESSMENT:
  Overall risk: LOW (well-documented, within benchmarks)
  Jurisdiction-specific risk:
    US: LOW (strong documentation, no recent changes)
    UK: LOW (compliant with DAC6 reporting)
    Canada: LOW (CRS filing complete, documentation strong)
    Singapore: LOW (transfer pricing documentation filed)
  
  Key risks monitored:
    1. Benchmarking data currency (annual refresh)
    2. Economic changes (methodology appropriateness)
    3. Regulatory changes (BEPS 2.0, Pillar Two)
    4. Audit activity (increased global scrutiny)
  
  BEPS Pillar Two considerations:
    Global effective tax rate: 26.5% (above 15% minimum)
    Top-up tax exposure: $0 (above threshold)
    Monitoring: Quarterly review of effective tax rate

Output

Consolidation Dashboard

CONSOLIDATION DASHBOARD — Jan 2025
══════════════════════════════════

Entity Structure:
  Entities: 5 (3 operating + 2 holding)
  Functional currencies: 4 (USD, GBP, CAD, SGD)
  Reporting currency: USD
  NCI: 0% (100% owned)

Intercompany Reconciliation:
  Monthly volume: 16-20 transactions
  Auto-match rate: 71-81% (target: >80%)
  Resolution time: 2-3 days (target: <5 days)
  Sign-off: Day 6-8 (target: <Day 8)
  Status: ✓ All reconciled

Consolidation:
  Consolidation timeline: Day 1-10
  Elimination entries: 6 standard (all verified)
  Post-elimination IC balance: $0 ✓
  Translation adjustment (CTA): $36.5K gain
  Goodwill: $125M (tested — no impairment)

Transfer Pricing:
  Documentation: ✓ Current (all jurisdictions)
  Benchmarking: ✓ Valid (through Oct 2025)
  Tax rate: 26.5% (above 15% Pillar Two minimum)
  Audit exposure: 0 (FY2024)
  Overall risk: LOW

Financial Statements:
  Revenue: $168.0M (FY2024)
  Net income: $31.5M (FY2024)
  Total assets: $2,485.0M
  Total equity: $2,030.0M
  Net margin: 18.8%
  ROE: 15.5%

Actions:
  1. Q1 consolidation (Day 1-10)
  2. Exchange rate update (monthly)
  3. Benchmarking refresh (Oct 2025)
  4. Goodwill impairment test (Q4)
  5. CbCR filing (annual)

Integration Points

ERP/GL (NetSuite, SAP): Entity-level financial data, intercompany postings
Consolidation platforms (BlackLine, OneStream): Automated consolidation, elimination
FX rate feeds: Exchange rate data, translation rates
Transfer pricing tools (Thomson Reuters, Bvlgaria): Benchmarking, documentation
Tax platforms (Vertex, Thomson Reuters ONESource): Tax calculation, compliance
BI platforms: Consolidated dashboards, entity-level reporting
Document management: Transfer pricing documentation, agreements
Audit management platforms: Audit trail, working papers
Banking platforms: Multi-entity cash management, intercompany transfers
Regulatory filing platforms: Country-by-country reporting, local filings

Edge Cases

Acquisition of new entity: Integration into consolidation; historical restatement; goodwill calculation
Entity dissolution: Deregistration; asset transfer; final consolidation; tax clearance
Significant FX volatility: Material translation adjustment; hedging impact; disclosure
Transfer pricing dispute: Tax authority challenge; audit defense; APA application; reserve assessment
Intercompany imbalance: Persistent IC receivable/payable mismatch; reserve; adjustment timing
Cross-border restructuring: Entity rationalization; transfer pricing impact; tax optimization
Goodwill impairment: Trigger event identification; testing methodology; write-down; communication
BEPS Pillar Two: Top-up tax calculation; effective tax rate monitoring; jurisdictional compliance
Related-party disclosure: SEC filing requirements; threshold analysis; footnote preparation
Consolidation boundary changes: VIE assessment; control evaluation; consolidation method change

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.