Journal Entry Import and Intercompany Journal Entry Import

A journal entry records debits and credits to be posted to ledger accounts, adjusting the value of accounts. In NetSuite OneWorld, an intercompany journal entry records the impact of transactions between two subsidiaries. Intercompany journal entries identify both a “from”, or originating, subsidiary and a “to”, or receiving, subsidiary.

You can import multiple journal entries and, for NetSuite OneWorld, multiple intercompany journal entries, from another system into NetSuite. Each import job can include data for any combination of classes, department, locations, and for NetSuite OneWorld, subsidiaries. Journal entry import and intercompany journal entry import are two separate tasks in the Import Assistant. For information about importing advanced intercompany journal entries, see Advanced Intercompany Journal Entry Import.

Note:

The Journal Entry and Intercompany Journal Entry record types have been enhanced with two fields: Accounting Book and Is Book Specific. You use these fields only in accounts that have the Multi-Book Accounting feature enabled to create book specific journal entries and book specific intercompany journal entries. If you have questions about Multi-Book Accounting, see Multi-Book Accounting Overview and Using Multi-Book Accounting.

After journal entry data is in a CSV file, users with required permissions can start a journal entry import by going to Setup > Import/Export > Import CSV Records, selecting an Import Type of Transactions and a Record Type of Journal Entry (or Intercompany Journal Entry), and completing other Import Assistant pages.

Important:

To import a single journal entry, you can use a simpler import process available at Transactions > Financial > Make Journal Entries > Import. If you use NetSuite OneWorld, you can go to Transactions > Financial > Make Intercompany Journal Entries > Import to import a single intercompany journal entry. See Single Journal Entry Import.

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.

See the following for more information about using the Import Assistant to import journal entries or intercompany journal entries.

Related Topics