Import Upload Journal Entries/ Upload budget from excel

Owned by ej dalde
Last updated: Dec 22, 2015 by Anonymous

 

Attached are all the necessary items needed for Journal Entries and Upload of Budget from excel File:

 

A. Import Multiple Lines in Journal Entry

SuiteAnswers Article > 9986 – Journal Entry Import and Intercompany Journal Entry Import
SuiteAnswers Article > 7742 – Importing a Journal Entry

User can import multiple journal entries from another system into NetSuite. 

Once 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 Tasks > Import CSV Records (Administrator), selecting an Import Type of Transactions and a Record Type of Journal Entry, and completing other Import Assistant pages.

NOTE:  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.

Permission:

-          Make Journal Entry (Edit or Full)

-          Posting Period on Transactions (Full)

-          Import CSV File

To set journal entries to approved during import, a user also needs - Journal Approval (Full)

NOTE:  Users who have the Make Journal Entry and Posting Period on Transactions permissions, but not the Import CSV File permission, can use the Single Journal Entry Import.

 

B. Budget Import

Budget Import allows you to import your external budget data as NetSuite budget records.

Permission Needed:   Setup Budgets Permission

SuiteAnswers Article > 9956 – Budget Import
SuiteAnswers Article > 7688 – Importing a Budget

Budget Template File Tips

Review the following tips for populating a budget CSV file from the template:

1)      The year entered on the budget must match the name of the year at Setup > Accounting > Manage Accounting Periods.

2)      Note that the CSV file field mapped to the required Account field should contain account names, not account numbers.

3)      Be sure to only use the name that appears in the Name field on the Account record. If you are entering a line item for a subaccount, the Account field must include the parent account name and subaccount name separated by a colon, for example, Checking : Purchases. Use this format for the Account field even if the Use Account Numbers preference is enabled.

4)      If you have multiple accounts with the same name and different numbers, so that mapping by name does not work, a workaround is to map a CSV file field containing internal ID values to the Account field.

5)      If you use the Multiple Budgets feature, Category is a required field. You can create new categories at Setup > Accounting > Accounting Lists > New, by clicking the Budget Category link and entering a budget category name.

NOTE:  If the Budget Category field is not mapped during the import, its value defaults to the first budget category on the list. This list is ordered alphabetically.