ANS-1681 · CSV IMPORT & DATA MIGRATION
How to Import Trial Balance History for NetSuite OneWorld Elimination Accounts
NetSuite users can manage trial balance imports for OneWorld elimination accounts by leveraging specific intercompany account types and subsequent reclassification.
Short answer
To import historical trial balance data for NetSuite OneWorld elimination accounts, create non-A/R or A/P intercompany accounts for the initial import. Subsequently, reclassify balances from these temporary accounts to the actual intercompany A/R and A/P accounts using intercompany journals. This ensures proper handling of intercompany balances during data migration.
Scenario
When importing historical trial balance data into NetSuite OneWorld, organizations often face challenges with elimination accounts, especially those involving intercompany transactions. Standard A/R and A/P account types may not be suitable for the initial import of historical intercompany balances, necessitating an alternative approach for accurate data migration.
Solution
To effectively import historical trial balance data for NetSuite OneWorld elimination accounts, follow these steps:
Create intercompany accounts that are not designated as A/R (Accounts Receivable) or A/P (Accounts Payable) types. These accounts will serve as temporary holding accounts for the historical data.
Import the historical trial balance data into these newly created non-A/R and non-A/P intercompany accounts.
Reclassify the balances from these temporary accounts to the actual intercompany A/R and A/P accounts using intercompany journals. This final step ensures that the intercompany balances are correctly reflected in the appropriate account types.
Expert NetSuite Support
Need help with this NetSuite issue?
CSV Import & Data Migration consulting and configuration support