Finance AI Skill

Intercompany Reconciliation

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, se...

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)