Journal Entry CSV Files

Be aware of the following requirements for journal entry CSV files:

Each imported journal entry must include at least 2 lines, and have balancing debits and credits.
Each imported intercompany journal entry must include at 4 lines, with one debit and credit each for the originating and receiving subsidiary.
If you use NetSuite OneWorld, data for journal entries and intercompany journal entries must be imported from separate files in separate jobs, because journal entry import and intercompany journal entry import are separate record types in the Import Assistant.

For general information about creating CSV import template files, see Guidelines for CSV Import Files.

Note:

For imports with the Single Journal Entry Import Assistant, only the three requirements listed above apply.

Tip:

Avoid a potential usage of incorrect entity type due to duplicate names. For more information, see Preventing Duplicate Entity Type Occurrences.

Your journal entry CSV files should include both header and line-level data.
You can import data in a single CSV file, or in multiple files-for example, with header data in one file and line-level data in other files. Each journal entry transaction can be uniquely identified by its value for one of the following fields: Entry No., External ID, or (updates only) Internal ID. This value should be included in every row of the CSV files.

Note:
When creating new records, if the CSV file doesn't include the entry number or external ID as a unique identifier, then a single import is performed.
If you include both header-level and line-level data in one file, each row of the CSV file represents a transaction line, and header-level field values must be included in each row, even if it's repetitive.

Note:
In 2021.2 the names of the sublists Journal Entry Line and Intercompany Journal Entry Line have changed to Journal Entry - Line and Intercompany Journal Entry - Line. You must use the new names in the headers of your CSV file for the automatic mapping to work properly.

Example Journal Entry CSV File

The following is a sample CSV file containing data for one journal entry transaction with two lines. The first two columns contain header-level data, whereas the other columns contain line-level data.

External ID	Department	Journal Entry -Line: Account	Journal Entry -Line: Debit	Journal Entry -Line: Credit	Journal Entry -Line: Memo
10008	Marketing	1000 Checking	100	-	Place money in petty cash
10008	Marketing	1006 Petty Cash	-	100	Place money in petty cash

Example Intercompany Journal Entry CSV File

The following is a sample CSV file containing data for one intercompany journal entry transaction with four lines. The first three columns contain header-level data, whereas the other columns contain line-level data.

Note:

The Subsidiary column indicates the subsidiary the transaction originates from, while the To Subsidiary column indicates the receiving subsidiary.

External ID	Subsidiary	To Subsidiary	Intercompany Journal Entry -Line: Subsidiary	Intercompany Journal Entry -Line: Account	Intercompany Journal Entry -Line: Debit	Intercompany Journal Entry -Line: Credit
12345	Parent Company : AU Subsid	Parent Company : CAN Subsid	Parent Company : AU Subsid	LCT Paid	100	-
12345	Parent Company : AU Subsid	Parent Company : CAN Subsid	Parent Company : AU Subsid	WET Paid	-	100
12345	Parent Company : AU Subsid	Parent Company : CAN Subsid	Parent Company : CAN Subsid	LCT Paid	100	-
12345	Parent Company : AU Subsid	Parent Company : CAN Subsid	Parent Company : CAN Subsid	VAT on Purchases	-	100

For extensive details about the fields for which data can be included in journal entry and intercompany journal entry CSV files, see:

Example Journal Entry CSV File

Example Intercompany Journal Entry CSV File

Related Topics