Journal Entry and Intercompany Journal Entry Line-Level Fields Table

The following table lists NetSuite standard line-level fields commonly available for journal entry and intercompany journal entry import mapping.

Important:

Each imported journal entry must include at least two lines, and have balancing debits and credits. Each imported intercompany journal entry must include at least four lines, one debit and one credit each for the originating and receiving subsidiary.

Column Header	Field Size	Notes
Account	—	This field is required and should match the name of an existing account at Lists > Accounting > Accounts. If the Use Account Numbers preference has been enabled at Setup > Accounting > Accounting Preferences, values should include both account number and name, such as 11000 Accounts Payable. Number-only values, such as 11000, also are supported. Name-only values, such as Accounts Payable, are not supported when this preference is enabled. If this preference is not enabled, name-only values should be used. Ensure that you exactly match the capitalization, spelling, and spacing of the names as defined in NetSuite with no leading or trailing spaces.
Debit	13	Defines the amount to be debited. Must be a number with a maximum of 10 digits before the decimal and 2 digits after the decimal.
Credit	13	Defines the amount to be credited. Must be a number with a maximum of 10 digits before the decimal and 2 digits after the decimal.
End Date	—	Available if the Revenue Recognition feature is enabled.
Gross Amt	—	Available for if the Advanced Taxes feature is enabled. This feature is required for OneWorld accounts.
Location	—	Required if the Multi-Location Inventory feature is enabled. Must match the name of an existing location at Setup > Company > Locations. Important: If you set a default value in a OneWorld account, you need to ensure that the selected default is valid for all imported subsidiary values. See Using Dependent Field Values as Defaults.
Memo	4000	Provides a detailed description displayed in the transaction detail list and other reports.
Name	—	The name of the associated entity, such as customer, vendor or employee. Should match the name of an existing entity. If auto-generated numbering is enabled, Name field values should include both entity ID and name, such as A2255 ABC Company. ID-only values, such as A2255, also are supported. If you include an invalid value that is numeric, an error is returned with the numeric value in quotes. Tip: To avoid a potential usage of incorrect entity type due to duplicate names, pick an entity from the Name field when creating journals. You can then filter the correct entity using the drop-down list (for example, customer, employee, other name, or vendor). Important: If you set a default value in a OneWorld account, you need to ensure that the selected default is valid for all imported subsidiary values. See Using Dependent Field Values as Defaults.
Residual	—	Available if the Revenue Recognition feature is enabled.
Schedule	—	Available if the Revenue Recognition feature is enabled.
Start Date	—	Available if the Revenue Recognition feature is enabled.
Subsidiary	—	Required for intercompany journal entries. Must match value for either Subsidiary or To Subsidiary. If your CSV file includes a Subsidiary column, it is automatically mapped to the header level Subsidiary field. The column to be mapped to the line-level Subsidiary field should have a different name, such as Line Subsidiary.
Tax Account	—	Available if the Advanced Taxes feature is enabled. This feature is required for OneWorld accounts.
Tax Code	—	Available if the Advanced Taxes feature is enabled. This feature is required for OneWorld accounts. Tax codes should be set up in NetSuite before the import. Important: If you set a default value in a OneWorld account, you need to ensure that the selected default is valid for all imported subsidiary values. See Using Dependent Field Values as Defaults.
VAT Amt	—	Available if the Advanced Taxes feature is enabled. This feature is required for OneWorld accounts.

Related Topics