Chart of Accounts Import
The Chart of Accounts import adds ledger accounts to the Account list record. Because the Chart of Accounts is the basis for all company data, you should complete this import first when you are setting up a new NetSuite account.
Please note the following before importing or updating account records with the Import Assistant:
-
This import is not available in the NetCRM product.
-
You cannot create a new account or update an existing account with an account number that already exists. You receive an error that the account number is already used.
-
To update account numbers on the import, the Use Account Numbers option must be enabled in Setup > Accounting > Accounting Preferences > General.
-
If your account is using NetSuite OneWorld, the Subsidiaries field is a required field for Chart of Accounts imports. You must map the NetSuite Subsidiaries field to a field in your CSV file, or the import will fail.
-
For information about setting up parent/child relationships for imported account records, see Referencing Child Accounts by Name and Number.
For details about fields that can be mapped in the Account record, see the SOAP Schema Browser's account reference page. You can use the field definitions here as a basis for creating your own CSV import template file. For information about working with the SOAP Schema Browser, see SOAP Schema Browser.
Account Localization Sublist
In OneWorld accounts that have multiple languages enabled, Account Localization sublist information can be included in the chart of accounts import. The Account Localization sublist does not have a key. The records in the sublist can be language, name, accounting context, and number.
Chart of Accounts Import Example
The following tables illustrate sample data in a Chart of Accounts import.
|
External Id |
Account Number |
Account Name |
Account Type |
Description |
Date |
C |
Restrict to Class |
S |
|---|---|---|---|---|---|---|---|---|
|
CA-ACCT-01 |
515652 |
Direct Labor |
Expense |
Expense account for labor |
01/ |
YEN |
Recurring Business |
Project Cost |
|
CA-ACCT-02 |
987546 |
Sales Tax Payable |
Other Current Liability |
Sales tax liability |
01/ |
USD |
Recurring Business |
Tax Liability |
Referencing Child Accounts by Name and Number
For reference types in the CSV file, data values must be written exactly as they appear in the list in the NetSuite record form.
For example, if the Income Account dropdown list has an option entitled 40500 Sales, you must specify the full name “40500 Sales” in the CSV file for the reference type to be imported correctly after it is mapped on the Import Assistant's Field Mapping page.
-
You cannot provide only the value “40500”.
-
You cannot provide only the value “Sales”.
-
The account number and name must be separated by a single space, not a colon or other separator.
For more information about reference types, see Select Reference Types.
Account references are different for budget imports; they require only names and not numbers. For more information, see Budget Template File Tips.
The Import Assistant is available at Setup > Import/Export > Import Tasks > Import CSV Records. After you select the record type for import, you choose the import character encoding. For more information, see Select a Record Type for Import and Choose Import Character Encoding.