What is Intercompany Aging Analysis?

Q: What is Intercompany Aging Analysis?

Intercompany Aging Analysis is the review of open intercompany balances by days outstanding to prioritize settlement, reconciliation, dispute review, and close actions.

Definition

Intercompany Aging Analysis is the review of how long intercompany balances have remained open between related legal entities. It classifies due-to, due-from, receivable, payable, loan, settlement, recharge, and clearing balances into aging buckets such as current, 1-30 days, 31-60 days, 61-90 days, and over 90 days. The purpose is to identify old balances, delayed settlements, unresolved exceptions, and entity pairs that need follow-up before close, consolidation, or treasury settlement.

In practice, Intercompany Aging supports Aging Analysis, intercompany reconciliation, close management, treasury planning, and financial reporting accuracy. It helps finance teams understand not only the amount outstanding, but also how long the balance has been open and whether it needs settlement, correction, dispute review, or elimination support.

How Intercompany Aging Analysis Works

The process starts by extracting open intercompany balances from ERP systems, subledgers, consolidation reports, treasury files, and reconciliation schedules. Each balance is grouped by entity pair, counterparty, account, currency, invoice date, due date, posting period, and transaction type. Finance teams then assign each item to an aging bucket based on the number of days outstanding.

For example, if Entity A has an intercompany receivable from Entity B that was posted 75 days ago and remains unpaid or unmatched, it falls into the 61-90 day bucket. That item may require follow-up with the counterparty entity, review of supporting documents, or Intercompany Difference Analysis if the two entities do not agree on the balance.

Core Components

Entity-pair view: Shows outstanding balances between specific related legal entities.
Aging buckets: Groups balances by days outstanding, such as current, 1-30, 31-60, 61-90, and over 90 days.
Balance type: Separates receivables, payables, loans, service charges, tax recharges, and clearing accounts.
Owner assignment: Links aged items to entity controllers, shared services, treasury, tax, or group finance.
Resolution status: Tracks whether each item is pending settlement, correction, support, approval, or close sign-off.

Key Metrics and Calculation

A useful metric is weighted average intercompany age. The formula is: weighted average intercompany age = sum of balance value × age in days / total intercompany balance. This shows the average age of open balances after considering the size of each item.

For example, assume $500,000 is 10 days old, $300,000 is 45 days old, and $200,000 is 90 days old. Weighted average intercompany age = (($500,000 × 10) + ($300,000 × 45) + ($200,000 × 90)) / $1,000,000 = 36.5 days. A lower average age usually indicates timely settlement, strong ownership, and clean reconciliation routines. A higher average age suggests finance teams should review dispute status, settlement timing, missing support, or entity response delays.

Interpretation and Business Impact

Low aging values usually mean intercompany balances are being cleared promptly through settlement, matching, or approved elimination entries. This supports cash flow visibility, close efficiency, and cleaner consolidated reporting. High aging values often point to items that need attention because old balances can affect entity-level working capital, internal funding views, and management reporting.

Treasury teams may use Cash Flow Analysis (Management View) to understand which aged balances should be settled and which currencies need funding coordination. Finance leaders may also connect aging results with Financial Planning & Analysis (FP&A) to understand how unresolved internal balances affect entity performance, liquidity planning, and forecast reliability.

Root Cause and Exception Review

Aging analysis becomes more useful when finance teams investigate why balances remain open. Root Cause Analysis (Performance View) can help identify whether aged balances come from recurring billing delays, tax coding issues, missing approvals, unmatched invoices, foreign exchange differences, or unclear ownership.

For large or sensitive balances, teams may use Sensitivity Analysis (Management View) to understand the reporting effect of settlement timing, exchange rate movement, or correction entries. Contribution Analysis (Benchmark View) can also show which entities, accounts, or transaction types contribute most to aged intercompany balances.

Best Practices

Effective Intercompany Aging Analysis depends on accurate invoice dates, due dates, counterparty codes, account mappings, and settlement status. Finance teams should review aged balances by materiality, assign owners early, maintain reason codes, and separate timing differences from true disputes or accounting errors.

Best practices include reviewing over-90-day balances before close, linking aged items to reconciliation dashboards, escalating material balances with clear due dates, and documenting each resolution step. Teams can also compare aging patterns with Return on Investment (ROI) Analysis for process improvements or use Break-Even Analysis (Management View) when evaluating settlement policy changes, shared service capacity, or working capital actions.

Summary

Intercompany Aging Analysis shows how long internal balances between related entities have remained open. It helps finance teams prioritize aged receivables, payables, loans, recharges, disputes, and clearing balances. When used well, it improves cash flow visibility, close discipline, treasury planning, and financial reporting accuracy across the corporate group.