--- name: intercompany-consolidation description: 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: