G/L Level Import

User has the ability to import G/L Level using an import spreadsheet provided in the software. Navigate to the menu Accounts -> G/L Account Maintenance -> G/L Level Import.

Template

Click on the button “Download Template”. The excel sheet will open and you can fill out the fields as follows:

Field Name	Example	Description	Mandatory (Yes/ No)
Level Number	2	You can only import Level Number between 2 and before the last level which exists. So if there are 3 levels you can only import level 2, and if there are 5 levels you can only import level 2, 3, 4, and so forth.	Yes
Level Code	022	The Level Code must follow the format and length as defined. So if defined in the system as 3N then it must be 3 characters and all should be numeric.	Yes
Description	Prepaid Expense Account	Alphanumeric description of the code level	Yes
Inactive	N	Y for yes and will set the field to be inactive and not visible to users. N for No will enable the level for users to see and use.	Yes

Save the spreadsheet to your desktop. Then click on “Select” on the import page and browse for the file you just saved. Select the file to be uploaded. Click on “Test Import File”. This is necessary to correct any errors in the imported spreadsheet prior to importing.

If you have errors, the system will alert you to them. Click on OK to view the error details.

The system will display the reason for the errors. Click on “Close”, and then click on “Remove” to remove the file from being imported. Reopen the template you saved to your desktop and correct the errors and save it again to the same location. Select the file to upload and repeat the test import process until you receive a success message indicating that your import is accurate.

Note that if you want to overwrite existing levels, click the corresponding button to change it from “No” to “Yes”.

Click on the button “Import”. The import will be successful. If you click the node on this screen for the level you imported, you should be able to view the newly imported level with its description.

If you’d like to create accounts based on this ID, then you can click on the last node for "Accounts” and click on “New”. (this might be level 3, 4 or 5 depending on how many segments you are using in your full G/L Code) Enter the level 1 from the drop down menu which is usually the company code. Then choose level 2 which you imported from the drop down list. Then enter the third level of account ID and enter the account description.

Click on OK. The account is now started.

Enter the remaining fields as needed and click on “Save”. The account will be ready for use in the system.

You can also import the G/L Accounts once the levels are created. See G/L Account Import.