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, NetSuite recommends that you 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

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 Line-Level Fields Table
Using Journal Entry Import for Updates
Custom Form Specification for Journal Entry Imports
Advanced Intercompany Journal Entry Import

General Notices