Single Journal Entry Import
You can use the Single Journal Entry Import Assistant to import a single journal entry's data from an external system into NetSuite. If you use NetSuite OneWorld, you can use a similar assistant to import data from a single intercompany journal entry.
You need the Make Journal Entry and Posting Period on Transactions permissions to import a single journal entry. You do not need the Import CSV File permission.
The Single Journal Entry Import Assistant preserves the journal entry import process available prior to Version 2010 Release 1, with a modified user interface. More complex journal entry import functions are also available. See Journal Entry Import and Intercompany Journal Entry Import and Advanced Intercompany Journal Entry Import.
The Single Journal Entry Import Assistant is available at Transactions > Financial > Make Journal Entries > Import. For intercompany journal entries, a similar assistant is available at Transactions > Financial > Make Intercompany Journal Entries > Import. For advanced intercompany journal entries, a similar assistant is available at Transactions > Financial > Make Advanced Intercompany Journal Entries > Import.
If you are using statistical accounts, the Single Journal Entry Import Assistant is available at Transactions > Financial > Make Statistical Journal Entries > Import. For information about statistical accounting, see Statistical Accounting Overview.
The Assistant includes the following steps:
-
The first page of the Single Journal Entry Import Assistant provides a link to a CSV journal entry template file that is identical to the template for the previously available journal import process.
-
Click this link to download the template file and populate it with your data.
Note that you can add columns to your CSV file for journal entry fields that are not included in the template, if you want to import data for these fields.
For more information, see Supported Values for Journal Entry Import CSV Files.
-
After you have a CSV file with data in it, click the Select button in the Import Assistant and select your file, then click Next.
-
-
The Assistant automatically maps fields in your CSV file to NetSuite journal entry fields and lets you view these mappings.
-
You can simply click Run to accept the default mappings and immediately start the import.
-
Or, you can make changes: You can move fields to change or add mappings. Also, you can click the edit icon for a field to open a popup where you can set a default value.
-
Note that if you do not map or set defaults for the Date and Entry No. fields, the import process provides defaults.
-
After you click Run and the import process completes, the newly created journal record displays. The Entry No. field shows the journal entry number for the transaction.
If errors prevent the process from completing, a status page displays instead. Note that, unlike other imports, email notification is not sent for single journal entry import.
Supported Values for Journal Entry Import CSV Files
For ease of use and compatibility with the previous journal import, the following values are supported in your CSV files:
-
For Account — If the Use Account Numbers preference is enabled, Account field values should include both numbers and names, 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.
-
For (Entity) Name — If auto-generated numbering is enabled, you should make sure that Name field values include both entity ID and name, such as A2255 ABC Company. ID-only values, such as A2255, also are supported.
-
For Account, Class, Department, Location, and Subsidiary — Most CSV imports require the use of the full hierarchical name, but journal entry import supports the use of the simplified name. For example, for location name, both California : Los Angeles and Los Angeles are supported.
For more information about supported CSV file fields, see Journal Entry and Intercompany Journal Entry Header Fields Table and Journal Entry and Intercompany Journal Entry Line-Level Fields Table.
Import is supported for journal entries with up to 10,000 lines. However, poor performance results during import and in the user interface for journal entries with over 1000 lines, and these large journal entries may not be editable in the user interface.
For more information about journal entries, see the following.
-
For step-by-step instructions for importing a single journal entry, see Importing a Journal Entry.
-
For more information about working with journal entries, see Journal Entries.
-
To import multiple journal entries, see Journal Entry Import and Intercompany Journal Entry Import.