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, NetSuite recommends that values 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, NetSuite recommends that Name field values 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.

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. NetSuite recommends that the column to be mapped to the line-level Subsidiary field 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

Journal Entry Import and Intercompany Journal Entry Import
Permissions for Importing Journal Entries with the Import Assistant
Journal Entry CSV Files
Journal Entry Import Supported Fields
Journal Entry and Intercompany Journal Entry Header Fields Table
Using Journal Entry Import for Updates
Custom Form Specification for Journal Entry Imports

General Notices