Journal Entry and Intercompany Journal Entry Header Fields Table

The following table lists NetSuite standard header fields commonly available for journal entry and intercompany journal entry import mapping. The fields you can map vary according to the fields available on either your preferred journal entry form, or the custom form specified for import.

Note:

The Accounting Book and Is Book Specific are available only if the Multi-Book Accounting feature has been enabled. For details about Multi-Book Accounting, see Multi-Book Accounting Overview and Using Multi-Book Accounting.

Column Header	Field Size	Notes
Accounting Book	—	Only used in Multi-Book Accounting to specify the accounting book for a book specific Journal Entry or a book specific Intercompany Journal Entry. The `Accounting Book` field works in conjunction with the `Is Book Specific` field to accomplish this goal. The list below outlines various combinations that can be specified in the CSV import file for Journal Entries. The same combinations are used for Intercompany Journal Entries. If `Is Book Specific` is set to True, a book specific journal entry is created. If an `Accounting Book` is not specified, the book specific journal entry is entered in the primary accounting book. If `Is Book Specific` is set to False, a journal entry is created. If `Is Book Specific` is not set, and an `Accounting Book` is specified, a book specific journal entry is created. If `Is Book Specific` is not set, and no `Accounting Book` is specified, a journal entry is created. If you have questions about Multi-Book Accounting, see these help topics: Multi-Book Accounting Overview and Using Multi-Book Accounting.
Accounting Book Detail	—	The Accounting Book Detail sublist is available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. This sublist is selectively updateable based on the Accounting Book key field.
Approved	Boolean	Users need the Journal Approval permission to set this value to True.
Class	—	Must match the name of an existing class at Setup > Company > Classes. If the Always Allow Per-line Classifications on Journals preference is enabled at Setup > Accounting > Accounting Preferences, the Class field is at line-level rather than header-level.
Currency	—	Available for accounts with the Multiple Currencies feature enabled. See Currency Management. Must match the name of an existing currency at Lists > Accounting > Currencies. In accounts that are not OneWorld, defaults to company base currency when CSV file row does not specify a value. In OneWorld accounts, defaults to root parent subsidiary base currency when CSV file row does not specify a value. Click the edit icon to set a different default value for all imported rows. Important: If you set a default 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.
Date	—	Required for new records. For Single Journal Entry Import, default value provided if necessary.
Defer Entry	Boolean	—
Department	—	Must match the name of an existing department at Setup > Company > Departments. If the Always Allow Per-line Classifications on Journals preference is enabled at Setup > Accounting > Accounting Preferences, the Department field is at the line-level rather than header-level.
Entry No.	45	For new records, you should map the external ID field from your CSV files to this field, which serves as a transaction ID for Journal Entry records. For Single Journal Entry Import, default provided if necessary. Note that if you provide a value that is already in use, this value is blank for the newly created journal entry.
Exchange Rate	—	Available for accounts with the Multiple Currencies feature enabled. Defaults to 1.00 when CSV file row does not specify a value.
External ID	—	Unique journal entry identifier in an external system.
Internal ID	—	Available for updates. You can create a transaction saved search to obtain Internal ID values.
Is Book Specific	Boolean	Only used in Multi-Book Accounting. The main function of the book specific journal entry or the book specific Intercompany journal entry is to make accounting adjustments for a specific accounting book. The `Is Book Specific` field works in conjunction with the `Accounting Book` field to accomplish this goal. For simplicity, the list below outlines various combinations that can be specified in the CSV import file for Journal Entries. The same combinations are used for Intercompany Journal Entries. If `Is Book Specific` is set to True, a book specific journal entry is created. If an `Accounting Book` is not specified, the book specific journal entry is entered in the primary accounting book. If `Is Book Specific` is set to False, a journal entry is created. If `Is Book Specific` is not set, and an `Accounting Book` is specified, a book specific journal entry is created. If `Is Book Specific` is not set, and no `Accounting Book` is specified, a journal entry is created. If you have questions about Multi-Book Accounting, see these help topics: Multi-Book Accounting Overview and Using Multi-Book Accounting.
Memo	999	—
Posting Period	—	An error is returned if a closed period is specified.
Reversal Date	—	—
Subsidiary	—	Required for OneWorld accounts. Must match the name of an existing subsidiary at Setup > Company > Subsidiaries. For intercompany journal entries, this field is the “from”, or originating, subsidiary.
To Subsidiary	—	Required for intercompany journal entries. This field is the “to”, or receiving, subsidiary.

Related Topics