ANS-1803 · CSV IMPORT & DATA MIGRATION

How to Update ‘Eliminate Intercompany Transactions’ on GL Accounts in NetSuite?

This guide addresses the challenge of bulk updating the 'Eliminate Intercompany Transactions' checkbox on NetSuite GL Accounts when direct CSV import is not an option.

AreaCSV Import & Data MigrationAudienceFinance/accounting teamDifficultyIntermediate

Short answer

The 'Eliminate Intercompany Transactions' checkbox on NetSuite GL Accounts cannot be directly updated via CSV import. Manual updates are required. To manage many accounts, create a custom checkbox field, populate it via CSV, then use a saved search to identify and manually edit accounts. Alternatively, use a naming convention for filtering.

Scenario

NetSuite users attempting to update the 'Eliminate Intercompany Transactions' checkbox on General Ledger (GL) Accounts via CSV import will find that this field cannot be directly modified through this method. This limitation necessitates an alternative approach, particularly when a large number of accounts require this specific setting.

Solution

The 'Eliminate Intercompany Transactions' checkbox on GL Accounts must be set manually within NetSuite, as direct modification via CSV import is not supported. For organizations with a substantial number of accounts requiring this update, consider the following strategies to streamline the process:

  1. Utilize a Custom Checkbox Field and Saved Search:

  2. Create a custom checkbox field on the GL Account record to identify all accounts for which 'Eliminate Intercompany Transaction' has to be checked.

  3. Set the value in this custom field through CSV import for the relevant accounts.

  4. Run a saved search that returns only results where the 'Eliminate Intercompany Transaction' checkbox is unchecked AND the custom field is checked.

  5. Manually edit the accounts within the search results to enable the 'Eliminate Intercompany Transaction' checkbox.

  6. When complete, the search should not display any results.

  7. Implement a Naming Convention:

  8. Establish a naming convention in the account name, for example, having 'Intercompany' in the account name.

  9. Filter saved search results using that parameter to identify accounts for manual updates.

Originally answered August 21, 2017Verified July 5, 2026

Expert NetSuite Support

Need help with this NetSuite issue?

CSV Import & Data Migration consulting and configuration support

Talk to a consultant

Keep exploring

Related answers