What is NetSuite Intercompany Reconciliation?

Definition

NetSuite intercompany reconciliation is the finance review used to compare related-party balances and transactions recorded across subsidiaries in NetSuite. It confirms that intercompany receivables, payables, journals, allocations, settlements, and elimination entries are recorded consistently by each subsidiary. In practice, it is a NetSuite-focused form of Intercompany Reconciliation that supports accurate close, consolidation, cash flow visibility, and financial reporting.

How It Works

The reconciliation starts by reviewing intercompany activity by subsidiary, counterparty, account, currency, transaction reference, posting period, and approval status. Finance teams compare the charging subsidiary’s receivable or revenue entry with the receiving subsidiary’s payable or expense entry. Where transactions are routed through multiple subsidiaries, the review checks whether each side is posted to the correct account and reporting period.

For example, Subsidiary A may record a $44,000 intercompany receivable for shared service charges, while Subsidiary B records a $42,800 payable. The $1,200 difference is reviewed using invoice references, journal details, tax treatment, exchange rates, and subsidiary coding. This helps finance teams identify whether the difference is caused by timing, currency, mapping, or an incomplete counterparty posting.

Core Reconciliation Checks

A strong NetSuite intercompany reconciliation focuses on data quality, account alignment, subsidiary relationships, and close readiness. The goal is to make sure that every internal transaction can be traced from source record to clearing, settlement, or consolidation elimination.

• Subsidiary alignment: confirms that the originating and receiving subsidiaries are correctly selected.

• Account mapping: applies Chart of Accounts Mapping (Reconciliation) to align local accounts with group reporting categories.

• Currency review: validates transaction currency, base currency, exchange rate, and translated balance.

• Document matching: compares journal numbers, invoice references, allocation IDs, and clearing entries.

• Review control: confirms preparation and approval under Segregation of Duties (Reconciliation) rules.

Key Metrics and Example

A practical metric is: NetSuite Intercompany Match Rate = Matched Intercompany Items ÷ Total Intercompany Items × 100. Another useful measure is: Manual Intervention Rate = Manually Corrected or Explained Items ÷ Total Intercompany Items × 100.

Assume NetSuite shows 4,800 intercompany items for July. If 4,320 items match by subsidiary, amount, currency, account, and reference, the match rate is 4,320 ÷ 4,800 × 100 = 90%. If 360 items require correction, reclassification, or explanation, the Manual Intervention Rate (Reconciliation) is 360 ÷ 4,800 × 100 = 7.5%. A high match rate usually indicates clean subsidiary coding and strong posting discipline, while a higher manual intervention rate highlights where master data, timing, or account mapping can be improved.

Exception Handling and Monitoring

NetSuite intercompany reconciliation often uses Exception-Based Intercompany Processing to separate matched items from records that need review. Common exception categories include missing counterparty entries, unmatched intercompany journals, tax differences, FX differences, duplicate postings, late allocations, and settlement gaps.

With Continuous Monitoring (Reconciliation), finance teams can review open items before close deadlines and assign them to subsidiary controllers, shared services, tax, treasury, or consolidation owners. This supports faster issue ownership and clearer close communication, especially in groups with multiple subsidiaries, currencies, and reporting calendars.

Role in Close, Audit, and Consolidation

NetSuite intercompany reconciliation is important during month-end and quarter-end close because unresolved internal balances can affect subsidiary reporting, management accounts, and consolidated financial statements. Clean reconciliation helps ensure that intercompany receivables and payables offset correctly and that internal income and expense are eliminated during consolidation.

It also supports Reconciliation External Audit Readiness by preserving transaction references, approval evidence, matching logic, adjustment history, and supporting schedules. Where historical data is moved into NetSuite or a new subsidiary structure is created, Data Reconciliation (Migration View) helps confirm that open intercompany balances, subsidiary mappings, and transaction categories remain accurate after conversion.

Best Practices

Effective NetSuite intercompany reconciliation depends on clean subsidiary master data, consistent posting rules, and clear close ownership. Finance teams should define mandatory fields, matching tolerances, exception categories, and escalation timelines before the close begins. Data Reconciliation (System View) is also useful when comparing NetSuite records with external billing, treasury, or consolidation data.

• Require subsidiary, counterparty, account, currency, tax code, and reference details on intercompany records.

• Review open items by subsidiary pair, account, currency, aging, owner, and transaction type.

• Use a Reconciliation Governance Committee to standardize policies, thresholds, and recurring control decisions.

• Apply Reconciliation Continuous Improvement to recurring mismatches and master data issues.

• Review Intercompany Profit in Inventory where internal inventory transfers require consolidation adjustments.

Summary

NetSuite intercompany reconciliation confirms that related-party transactions across subsidiaries are complete, accurate, supported, and ready for close and consolidation. It connects subsidiary coding, account mapping, document matching, exception tracking, and audit evidence into a controlled review. When managed consistently, it improves cash flow visibility, close quality, financial reporting accuracy, and consolidation confidence.