What is Intercompany Reconciliation Prep?
Definition
Intercompany Reconciliation Prep is the preparation work completed before finance teams formally reconcile balances between related entities. It involves gathering data, validating account mappings, confirming counterparties, checking supporting documents, reviewing open transactions, and identifying early exceptions. Strong prep helps Intercompany Reconciliation run faster because receivables, payables, revenues, expenses, loans, settlements, and eliminations are organized before the close deadline.
How Intercompany Reconciliation Prep Works
The process starts by extracting intercompany balances from ledgers, subledgers, invoices, journals, payment files, and consolidation systems. Finance teams then group balances by entity pair, account, currency, transaction type, and reporting period. This creates a clean starting point for matching one entity’s receivable with the counterparty’s payable.
Prep also includes checking whether both entities used the correct counterparty codes, transaction references, account combinations, and posting dates. If one entity records an intercompany payable in the wrong account, Chart of Accounts Mapping (Reconciliation) helps identify the mapping issue before formal reconciliation begins.
Core Preparation Activities
A strong preparation routine reduces avoidable mismatches during month-end close. The goal is to make sure the reconciliation team starts with complete, structured, and validated data.
Data collection: Gather trial balances, subledger reports, invoices, journals, payment records, and open-item listings.
Counterparty review: Confirm legal entity pairs, intercompany codes, account ownership, and transaction references.
Balance grouping: Organize items by entity pair, account, currency, transaction type, and aging bucket.
Support check: Confirm that invoices, agreements, approvals, and calculation files are available.
Exception pre-screening: Flag missing postings, timing gaps, currency differences, and unsupported balances.
Prep Metric and Example
A useful metric is: Reconciliation Prep Completion Rate = Prepared Account Pairs ÷ Total Required Account Pairs × 100. For example, if a finance team must prepare 240 intercompany account pairs and completes preparation for 216 before close day 2, the prep completion rate is 216 ÷ 240 × 100 = 90%.
A high completion rate usually means data is ready, owners are assigned, and supporting evidence is available before reconciliation begins. A low completion rate may indicate missing reports, incomplete support, delayed postings, or unclear account ownership. Tracking this metric helps finance teams improve close readiness and financial reporting quality.
Data Validation and Controls
Intercompany reconciliation prep depends on accurate source data. Data Reconciliation (System View) helps compare balances across ERP, subledger, treasury, and consolidation systems. If the organization recently changed systems or migrated data, Data Reconciliation (Migration View) helps confirm that opening balances, account mappings, and entity codes were transferred correctly.
Controls should define who prepares the file, who reviews it, and who approves it for reconciliation. Segregation of Duties (Reconciliation) helps separate preparation, review, approval, and correction responsibilities so the process remains controlled and reviewable.
Exception Identification
Prep is also the stage where finance teams identify early warning items. These may include unmatched invoices, missing counterparties, unposted journals, incorrect exchange rates, unresolved settlements, or balances posted to suspense accounts. Exception-Based Intercompany Processing helps teams prioritize high-value, aged, or close-critical items before the reconciliation deadline.
For inventory-related intercompany activity, prep may include checking Intercompany Profit in Inventory so unrealized internal profit can be reviewed before consolidation. This is important when goods move between entities but remain inside the group at period end.
Governance and Audit Readiness
Clear governance helps ensure reconciliation prep is consistent across entities and periods. A Reconciliation Governance Committee may define timelines, materiality thresholds, ownership rules, escalation paths, and reporting standards. This is especially useful for large groups with many subsidiaries, currencies, and shared service teams.
Prep files also support Reconciliation External Audit Readiness because auditors often review support for intercompany balances, eliminations, aged items, and management sign-offs. Organized prep documentation makes it easier to trace balances from source systems to reconciliation schedules and consolidation entries.
Best Practices
Effective intercompany reconciliation prep should begin before formal close activities start. Finance teams should refresh data early, validate account mappings, assign owners, and track open items daily during close. Continuous Monitoring (Reconciliation) helps teams detect mismatches throughout the period instead of waiting until month end.
Prepare balances by entity pair, account, currency, and transaction type.
Validate counterparty coding and chart of accounts mappings before matching begins.
Attach invoices, journals, agreements, and approvals to material balances.
Track prep completion rate, unresolved value, aging, and exception count.
Use findings for Reconciliation Continuous Improvement after each close cycle.
Summary
Intercompany Reconciliation Prep gives finance teams a structured way to prepare data, support, ownership, and exception lists before formal reconciliation begins. It supports faster close, stronger controls, better cash flow visibility, audit readiness, and reliable consolidated reporting. When preparation is timely, complete, and well governed, intercompany reconciliation becomes more accurate, transparent, and scalable.
