Chart of Accounts import

• Number – Mandatory field, up to 60 alphanumeric characters
• Name – Mandatory field, up to 60 alphanumeric characters
• Type – Mandatory list field, select the appropriate type for each account
• Currency – The NetSuite currency field in chart of accounts is mandatory only when account Type = Bank
• Subaccount of – It refers to the Parent account, if it exists. Only needed for child accounts import.
• Subsidiaries – Mandatory field, dictates which subsidiary(ies) can post transactions to it. Note there are certain account types such as “Bank” and “Credit Card” that are restricted to a single subsidiary given the nature of those accounts.
• External ID – Although not mandatory it is still recommended to assign an external ID value to each account since accounts’ internal ID’s may not match due to timing of creation. Keep the External ID values consistent with a common prefix followed by a sequential number.
• Eliminate Intercompany Transactions – Checking this box makes the account eligible for elimination on consolidation.
• Summary – Checking this box means users cannot post transactions to this account and instead it is used for grouping similar accounts under a single parent account.

Note: The “Summary” check box cannot be populated via CSV import as the field is not exposed. Checking this box in the UI also triggers the “Inactive” check box to be checked. This ensures users cannot post transactions to Summary accounts.

Points to be noted while import:

• The parent accounts must be imported first. Then only the child accounts should be imported
• Standard accounts can be reused

Import Process:

• Navigate: Setup – Import/Export – Import CSV Records
• Import Type = Accounting
• Record Type = Chart of Accounts
• When you get to Field Mapping, it is preferable to use internal ID for subsidiary and subaccount. For this click on the pencil icon and set the appropriate value.

Once the import is successful, validate the data by navigating to the NetSuite chart of accounts.

Navigate: Setup – Accounting – Chart of Accounts