--- name: intercompany-reconciliation description: Reconcile intercompany transactions and balances between affiliated entities to ensure accurate consolidation and eliminate intercompany profits. Use when performing month-end/quarter-end intercompany reconciliations, investigating IC balance mismatches, setting up IC reconciliation processes, managing IC eliminations, resolving FX-related IC variances, or preparing IC reconciliation reports for auditors. Triggers on phrases like "intercompany reconciliation", "IC reconciliation", "IC balances", "intercompany elimination", "intercompany mismatch", "IC variance", "intercompany payable receivable", "consolidation elimination", "IC matching". --- # Intercompany Reconciliation Systematically match and reconcile intercompany transactions and balances across entities to enable clean consolidation and eliminate intercompany profits and balances. ## Workflow ### 1. Intercompany Transaction Registry ``` INTERCOMPANY TRANSACTION TYPES ═══════════════════════════════════════ Track all IC transaction types: 1. GOODS & SERVICES → Transfer pricing (manufacturer sells to distributor) → Intercompany service charges (shared services, IT, legal) → Management fees (holding company to operating entity) → Royalty/license fees (IP holder to operating entity) 2. FINANCIAL → Intercompany loans (principal + interest) → Dividend distributions → Capital contributions → Intercompany guarantees 3. OPERATIONAL → Inventory transfers → Cost allocations (shared facilities, utilities) → Reimbursements → Cost-sharing arrangements 4. ELIMINATIONS (consolidation) → Intercompany revenue/expense elimination → Intercompany profit in inventory elimination → Intercompany dividend elimination → Unrealized gain/loss on IC transactions ``` ### 2. Reconciliation Process ``` MONTHLY INTERCOMPANY RECONCILIATION PROCESS ═══════════════════════════════════════ TIMELINE: Day 1-2: Entity controllers extract IC sub-ledger balances Day 3: Central IC team runs auto-matching Day 4: Investigate and resolve mismatches Day 5: Final reconciliation sign-off Day 6: Generate elimination entries Day 7: Post eliminations to consolidation ledger STEP 1: Extract IC Balances from Each Entity ═══════════════════════════════════════ Entity A (Parent — USD): IC Receivable — Entity B: $1,250,000 IC Receivable — Entity C: $450,000 IC Payable — Entity D: $320,000 IC Payable — Entity E: $180,000 Entity B (EU Sub — EUR): IC Payable — Entity A: €1,150,000 IC Receivable — Entity C: €200,000 Entity C (UK Sub — GBP): IC Payable — Entity A: £380,000 IC Payable — Entity B: £170,000 STEP 2: FX Translation (to Common Currency) ═══════════════════════════════════════ Using month-end exchange rate: EUR/USD: 1.0850 GBP/USD: 1.2650 Entity B IC Payable — Entity A: €1,150,000 × 1.0850 = $1,247,750 Entity A shows: $1,250,000 Variance: $2,250 → FX translation difference Entity C IC Payable — Entity A: £380,000 × 1.2650 = $480,700 Entity A shows: $450,000 Variance: $30,700 → ⚠ SIGNIFICANT — requires investigation STEP 3: Auto-Matching & Exception Reporting ═══════════════════════════════════════ MATCH RESULTS: ═══════════════════════════════════════ Pair Entity A Entity B/Other Variance Status ───────────────────────────────────────────────────────────────────────────── A ↔ B (Trade) $1,250,000 $1,247,750 $2,250 ⚠ FX diff A ↔ C (Trade) $450,000 $480,700 ($30,700) 🚩 MISMATCH A ↔ D (Loan) $320,000 $320,000 $0 ✓ MATCHED A ↔ E (Services) $180,000 $180,000 $0 ✓ MATCHED B ↔ C (Services) $0 $183,900 ($183,900) 🚩 ONE-SIDED SUMMARY: Total pairs: 5 Matched: 2 (40%) FX variance only: 1 (20%) — within tolerance ($2,250 < $5,000 threshold) Investigate: 2 (40%) — require resolution before close TOLERANCE POLICY: → <$5,000: Accept as FX variance; document in reconciliation → $5,000 – $50,000: Investigate; explain variance; Controller sign-off → >$50,000: Material; must resolve or create adjusting entry ``` ### 3. Common Causes of Mismatches & Resolution ``` MISMATCH INVESTIGATION & RESOLUTION ═══════════════════════════════════════ COMMON CAUSES: 1. TIMING DIFFERENCES (most common) → Entity A recorded sale on Dec 28; Entity B recorded purchase Jan 3 → Resolution: Determine correct recording date per revenue recognition → Adjusting entry in later entity to match earlier entity's period → Document in cutoff analysis 2. FOREIGN EXCHANGE DIFFERENCES → Each entity records in local currency; translation rates differ → Resolution: Use consistent translation rate (month-end spot rate) → FX difference flows to consolidation as unrealized FX gain/loss → Document rate used and source 3. TRANSPORTATION/INSURANCE COSTS → Buyer and seller allocate shipping costs differently → Resolution: Establish policy — FOB shipping point vs destination → Adjust to agreed allocation method 4. DUPLICATE RECORDING → Transaction recorded twice in one entity → Resolution: Identify duplicate entry; reverse; document 5. WRONG ENTITY → Transaction posted to wrong intercompany entity → Resolution: Re-code to correct entity; document 6. ONE-SIDED ENTRIES → One entity recorded but counterparty hasn't → Resolution: Contact counterparty controller; confirm transaction → If valid: create entry at counterparty → If invalid: reverse at originating entity 7. TRANSFER PRICING DIFFERENCES → Pricing differs from agreed transfer pricing policy → Resolution: Adjust to TP policy rate; document TP methodology → Tax team review for TP documentation requirements INVESTIGATION WORKFLOW: ═══════════════════════════════════════ 1. Identify mismatch pair and amount 2. Pull detailed transaction listing from both entities 3. Match individual transactions (line-level, not just balance) 4. Identify unmatched items: → Items at Entity A not at Entity B (and vice versa) → Same invoice number but different amounts → Same amount but different GL periods 5. Root cause analysis for each unmatched item 6. Determine correct treatment (adjust A, adjust B, or document) 7. Create adjusting entries (if needed) 8. Document reconciliation with explanations 9. Controller sign-off 10. Update IC reconciliation workbook ``` ### 4. Elimination Entries ``` CONSOLIDATION ELIMINATION ENTRIES ═══════════════════════════════════════ After reconciliation complete, generate elimination entries: 1. INTERCOMPANY REVENUE/EXPENSE ELIMINATION Dr Intercompany Revenue $1,500,000 Cr Intercompany Expense $1,500,000 (Eliminate IC sales between A and B) 2. INTERCOMPANY RECEIVABLE/PAYABLE ELIMINATION Dr IC Payable — Entity A $1,250,000 Cr IC Receivable — Entity B $1,250,000 (Eliminate IC trade balances) 3. UNREALIZED PROFIT IN INVENTORY → Entity A sold goods to Entity B at $500K (cost $400K, profit $100K) → Entity B still holds $200K of goods at year-end → Unrealized profit = $200K × ($100K/$500K) = $40K Dr Retained Earnings / COGS $40,000 Cr Inventory — Entity B $40,000 (Eliminate unrealized profit in ending inventory) 4. INTERCOMPANY LOAN ELIMINATION Dr IC Loan Receivable — Entity D $320,000 Cr IC Loan Payable — Entity A $320,000 (Eliminate IC loan principal) Dr IC Interest Payable — Entity D $12,000 Cr IC Interest Receivable — Entity A $12,000 (Eliminate IC accrued interest) 5. INTERCOMPANY DIVIDEND ELIMINATION Dr Dividend Income — Entity A $250,000 Cr Dividend Declared — Entity C $250,000 (Eliminate IC dividends) ELIMINATION SUMMARY: ═══════════════════════════════════════ Elimination Type Amount Impact ─────────────────────────────────────────────────────────── Revenue/Expense elimination ($1,500,000) Reduces consolidated revenue Receivable/Payable elimination $0 Offsets (no P&L impact) Unrealized profit elimination ($40,000) Reduces consolidated inventory Loan principal elimination $0 Offsets Interest elimination $0 Offsets Dividend elimination ($250,000) Reduces consolidated income Net impact on consolidated income: ($1,790,000) ``` ### 5. IC Reconciliation Reporting ``` INTERCOMPANY RECONCILIATION REPORT ═══════════════════════════════════════ Period: March 2024 Prepared by: [Name] Date: April 3, 2024 RECONCILIATION SUMMARY: ═══════════════════════════════════════ Total IC balance pairs: 12 Matched within tolerance: 8 (67%) Resolved variances: 3 (25%) Outstanding variances: 1 (8%) ⚠ OUTSTANDING ITEM: Pair: Entity A ↔ Entity C (Trade) Variance: $30,700 (Entity A: $450K; Entity C translated: $480.7K) Root cause: Entity C recorded 3 additional invoices not in Entity A Status: Entity A accounting researching — 2 invoices identified as January delivery (should be in March per shipping terms) Resolution: Entity A posting 2 invoices in March; $2,100 FX variance accepted Sign-off: Pending AGING OF RECONCILING ITEMS: ═══════════════════════════════════════ Age Range | Count | Total Amount | Action ───────────────────┼─────────┼────────────────┼────────── Current (0-30 days)| 1 | $30,700 | Investigating 31-60 days | 0 | $0 | — 61-90 days | 0 | $0 | — >90 days | 0 | $0 | ✓ No aged items RECONCILIATION METRICS: ═══════════════════════════════════════ Match rate: 75% (8/12 matched + 3 resolved) Avg resolution time: 2.3 days Aged items (>90 days): 0 FX variance accepted: $2,250 (1 pair) ``` ## Edge Cases - **High FX volatility**: Large FX translation differences; consider more frequent reconciliation or hedging IC exposures - **Complex supply chains**: Multiple entities in transaction chain; trace each transfer step; document chain - **Transfer pricing disputes**: Tax authority challenges TP methodology; coordinate with tax team; maintain documentation - **New entity addition**: Onboard to IC reconciliation process immediately; establish IC accounts in local GL - **Entity dissolution**: Wind down IC balances; settle outstanding amounts; document final reconciliation - **Shared services**: Allocate costs using consistent methodology; document allocation basis and rates ## Integration Points - **ERP systems**: IC transaction data from each entity's GL - **Consolidation tools**: BlackLine, OneStream, HFM (auto-matching, elimination) - **Transfer pricing**: Tax rate databases, TP policy documents - **FX systems**: Bloomberg, Reuters (exchange rates) - **Workflow tools**: Approval routing, exception management - **Audit platforms**: Workiva (documentation and audit trail) ## Output ### IC Reconciliation Package ``` INTERCOMPANY RECONCILIATION PACKAGE — March 2024 ═══════════════════════════════════════ Contents: 1. IC Balance Summary by Entity Pair (all pairs, all balances) 2. Match/Exception Report (auto-generated, detail level) 3. Variance Investigation Log (root cause, resolution, sign-off) 4. FX Rate Documentation (rates used, source, date) 5. Elimination Entries (for consolidation posting) 6. Aging Report of Reconciling Items 7. Controller Sign-Off Certificate Status: READY FOR CONSOLIDATION (1 minor item documented, $2,100 FX) ```