ANS-0825 · ONEWORLD & MULTI-SUBSIDIARY

Why Are NetSuite Intercompany Transactions Not Auto-Eliminating?

Proper configuration of intercompany accounts and transaction elimination settings is crucial for accurate financial reporting in NetSuite.

Short answer

Intercompany transactions may not auto-eliminate if accounts are incorrectly configured. Manually create and mark intercompany A/R and A/P accounts with 'Eliminate Intercompany Transaction'. Configure revenue accounts similarly, but generally *do not* mark COGS accounts for elimination in arm's length inventory transfers. Existing transactions require re-saving related invoices.

Scenario

A NetSuite user has enabled the auto-elimination feature for intercompany transactions, specifically for arm's length processes. Despite this, revenue and expense entries related to these intercompany transactions are not being automatically eliminated as expected, leading to discrepancies in financial reporting.

Solution

  1. Upon enabling auto-elimination, separate intercompany A/R and A/P accounts must be manually created and configured to ensure they are not mixed with regular A/R and A/P accounts.

  2. Following the activation of auto-elimination, it is necessary to configure relevant revenue accounts and, with specific considerations for arm's length intercompany inventory transfers, COGS accounts. Accounts to which intercompany transactions may post must be marked for auto-elimination. The checkbox to select is Eliminate Intercompany Transaction on the account records. For arm's length intercompany inventory transfers, COGS accounts should generally *not* be marked for elimination to avoid double booking. This option is selected during the manual setup of intercompany A/R and A/P accounts. These intercompany accounts can share postings from both regular and intercompany transactions.

  3. Once this configuration is complete, new transactions should fully auto-eliminate. However, existing transactions will not. To ensure existing arm's length intercompany transactions fully eliminate, the Invoice related to Interco Sales Orders must be edited and saved.

Expert NetSuite Support

Need help with this NetSuite issue?

OneWorld & Multi-Subsidiary consulting and configuration support

Talk to a consultant