Supported Values for Journal Entry Import CSV Files in NetSuite

The Single Journal Entry Import Assistant allows users to import a single journal entry's data from an external system into NetSuite. Access this assistant via Transactions > Financial > Make Journal Entries > Import. Additionally, for users of NetSuite OneWorld, a similar assistant is available for importing intercompany journal entries.

Permissions Required

To utilize the Single Journal Entry Import, users must have the following permissions:

• Make Journal Entry
• Posting Period on Transactions Note that the Import CSV File permission is not required.

Assistant Workflow

1. Download the Template: The first page of the import assistant provides a link to download a CSV journal entry template identical to the former journal import structure. Users should populate this template with their data.

   • Users can extend the CSV file by adding columns for any journal entry fields absent from the template.

2. File Selection: After preparing the CSV file, users click the select button within the Import Assistant to choose their file and proceed to the next step.

3. Field Mapping: The Assistant automatically maps CSV fields to corresponding NetSuite journal entry fields, allowing users to review and adjust these mappings as needed:

   • Users can click Run to accept the defaults or adjust mappings by moving fields and setting default values for anything not explicitly mapped, such as the Date and Entry No. fields which will be assigned defaults if left unmapped.

4. Processing and Error Handling: Upon clicking Run, the journal entry will be created if there are no errors; otherwise, a status page will display the errors. Notably, there is no email notification for issues stemming from the single journal entry import process.

Supported Values for CSV File

The following guidelines are in place for compatible CSV values:

• Account: If the Use Account Numbers preference is enabled, both account numbers and names (e.g., 11000 Accounts Payable) are accepted. If the preference is disabled, only name-only values are valid.
• Entity Name: When auto-generated numbering is enabled, values should include entity ID and name (e.g., A2255 ABC Company). ID-only values are acceptable as well.
• Other Fields: For fields like Account, Class, Department, Location, and Subsidiary, both simplified names and full hierarchical names are supported. For instance, California : Los Angeles and Los Angeles are both valid for location names.

Important Considerations

• Users can import journal entries with up to 10,000 lines; however, performance may degrade during import and upon managing large entries (particularly those exceeding 1,000 lines).

For further assistance with journal entries, consult the following documents:

• Importing a Journal Entry
• Journal Entries Overview
• Multiple Journal Entries Import

Source: This article is based on Oracle's official NetSuite documentation.