Period End Journal Entry Import
A Period End Journal is a transaction record that posts subsidiary consolidation and year end closing to the general ledger. Period end journals are generated automatically when you complete the Create Period End Journals task on the Period Close Checklist. For help working with this record in the user interface, see Period End Journal Entries.
You can use the Import Assistant to update the already generated Period End Journals, but not to add new records. To find the Import Assistant go to Setup > Import/Export > Import Tasks > Import CSV Records.
Permissions and Features required for Importing Period End Journal with the Import Assistant
Features
To use the Import Assistant to import Period End Journals you need to have a NetSuite OneWorld account. Also, you need to enable the Accounting Periods and the Period End Journal Entries features in Setup > Company > Setup Tasks > Enable Features, Accounting subtab.
For more information, see Setup for Period End Journal Entries
Permissions
To update period end journals, you must have the permission Period End Journals, Edit level or higher. You must also have access to both the Subsidiary to which the period end journal posts and the Source Subsidiary for the period end journal entry. To review the access level of a specific role, go to Setup > Users/Roles > User Management > Manage Roles and click on the role you want to review. In the Subsidiary Restrictions field group, you can see which subsidiaries this role can access. On the Permissions subtab, under Transactions you can see the level of the Period End Journals permission. For information about assigning permissions to roles, see Customizing or Creating NetSuite Roles
The Source Subsidiary is the child subsidiary when posting consolidation, income statement closing and balance sheet closing journals for the child subsidiary in the parent subsidiary. The child subsidiary does not need to have the Period End Journal Entries feature enabled. The Subsidiary is the same as the Source Subsidiary only when posting non-consolidated income statement closing and balance sheet closing journals for each subsidiary's year end.
Editing period end journals in the UI or with a CSV import is permitted when the period is open or when the Allow Non-G/L Changes box is checked on the period record. When Allow Non-G/L Changes is checked, users with the Setup permission Allow Non-G/L Changes can make edits that do not affect the general ledger.
Period End Journal Import Supported Fields
From standard fields on period end journals, you can update only the Memo fields on each journal line and in the header. From custom fields or segments, you can update only those that do not affect the general ledger. You can’t update any other fields and especially those affecting the general ledger. For more information about the header and journal line fields, see Period End Journal Header Fields and Period End Journal Line Fields