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 imports with the Single Journal Entry Import Assistant, only the three requirements listed above apply.
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 does not 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 is repetitious.
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.
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:
-
Journal Entry and Intercompany Journal Entry Header Fields Table
-
Journal Entry and Intercompany Journal Entry Line-Level Fields Table
Related Topics
- Journal Entry Import and Intercompany Journal Entry Import
- Permissions for Importing Journal Entries with the Import Assistant
- Journal Entry Import Supported Fields
- Journal Entry and Intercompany Journal Entry Header Fields Table
- Journal Entry and Intercompany Journal Entry Line-Level Fields Table
- Using Journal Entry Import for Updates
- Custom Form Specification for Journal Entry Imports