If you have the Make Journal Entry and Posting Period on Transactions permissions, you can import a single journal entry from an external system into NetSuite.
If you use NetSuite OneWorld, you can also import a single intercompany journal entry.
Import is supported for journal entries with up to 10,000 lines. You may notice a performance impact during import and in the user interface for journal entries with over 1000 lines. In addition, these large journal entries may not be editable in the user interface.
Journal entry and intercompany journal entry records include a Memo body field and a Journal Entry – Line : Memo field. When mapping:
If you include only a Line Memo or Memo field in your CSV file, it is mapped to the Journal Entry – Line : Memo field.
If you include both a Line Memo and Memo field in your CSV file, Line Memo is mapped to Journal Entry – Line : Memo and Memo is mapped to the Memo body field.
Auto-mapping works differently if you are using the CSV Import Assistant. For details on that method, see Journal Entry Import and Intercompany Journal Entry Import.
To import a journal entry:
Go to Transactions > Financial > Make Journal Entries > Import.
(To import an intercompany journal entry, go to Transactions > Financial > Make Intercompany Journal Entries > Import.)
On the Import Assistant's Scan & Upload CSV File page, select the type of character encoding for imported data.
For information about available options, see Choose Import Character Encoding.
For more information about the Import Assistant, see Single Journal Entry Import.
Click the Single Journal Entry Template File link to download a CSV template file.
Save the file to your system and then populate the saved file with your journal entry data. Note the following conditions:
Each imported journal entry must include at least two lines and have balancing debits and credits.
Each imported intercompany journal entry must include at four lines with one debit and credit for both the originating and receiving subsidiary.
You can add columns to the file to import data for additional journal entry fields.
For more information about supported CSV file values, see Supported Values for Journal Entry Import CSV Files.
Click Select, choose the CSV file you have populated and then click Open.
On the View Mapping / Start Import page, review the automappings of CSV file fields to NetSuite fields.
Accept the default mappings and start the import, or make changes by dragging and dropping fields. You can also click the pencil icon to open a popup and set default values.
If you do not map or set defaults for the Date and Entry No. fields, the import process provides default values.Note:
If you want to know what the defaulted number is going to be for an imported statistical journal, you can check this value prior to the import by going to Setup > Company > Auto-Generated Numbers > Document Numbers subtab > Journal field > Current Number column. For details about field mapping, see CSV Field Mapping Tasks and General CSV Field Mapping Tips.
Click Run to immediately start the import.
When the import process successfully completes, the record created by the journal entry import displays. This page enables you to immediately review import results.
If an import does not successfully complete, a Job Status page appears. Click the CSV Response link to view a results.csv file that contains your CSV file data and the error message.
Correct the error in your CSV file and then retry the import. For information about import errors, see Journal Entry Import Errors.
Users who have the Import CSV File permission can import multiple journal entries at one time and take advantage of additional import options. For details about this more complex capability, see Journal Entry Import and Intercompany Journal Entry Import. For details about importing advanced intercompany journal entries, see Advanced Intercompany Journal Entry Import.
- Journal Entries
- Journal Entries Overview
- Journal Entry Preferences
- Making Journal Entries
- Journal Entry Approval Overview
- Reversing Journal Entries
- Viewing Journal Entries
- Printing Journal Entries
- Importing a Journal Entry
- Bad Debt Overview
- Writing Off Customer Overpayments
- Expense Allocation Overview
- Period End Journal Entries
- Balancing Segments and Journals