Journal Entry Import

Owned by Ces Esparagoza
Jun 27, 2014

Step-by-step guide

  1. Create a CSV File that has the following Columns:
  • External ID
  • Account
  • Debit
  • Credit
  • Date
  • Posting Period

 

Notes:

-          External ID is a unique ID that you have to assign to every transaction. This does not require any format. You can use any combination as long as it is unique and will only be used once.

-          For Account, you can just use the Internal ID of the Account instead of the Account Name. To get the Internal ID of the Account, navigate to Lists > Accounting > Accounts > Internal ID column).

Sample CSV file I have used for the import:

                       

-          This will import one Journal Entry. You can add multiple lines on the same CSV File provided that line on the same transaction will have the same External ID. You also need to make sure that Debit Amount and Credit Amount is in Balance.

 

  1. Once CSV file is created, in NetSuite navigate to Setup > Import/Export > Import CSV Records.
  2. Set Import Type = Transactions and Record Type to Journal Entry.
  3. Select the CSV File then click Next.
  4. Set Data Handling to Add.
  5. Field Mapping below:

 

  1. Click the Account line.
  2. Click the Pencil Icon and set Reference Type to Internal ID.
  3. Click Next.
  4. Provide Import Map Name.
  5. Click Save & Run.