Configure and Import GL Account or Main GL Account Imports

The GL Account Import provides a simple way to import GL accounts using the minimum required fields to create a GL Account or Main GL Account. GL Accounts can be imported at any time and the GL Account import will always add to the existing list of GL accounts as opposed to replacing accounts.

Fields that are not required for the GL Account or Main GL Account creation, such as such as Budget Codes, Report Groups and Categories or Analysis Codes, can be added using the Edit Multiple action once the account has been imported.

In this article:

• Configuration Considerations
• File Formatting
• File Import
• Troubleshooting

Configuration Considerations

If you are unsure if you should be importing GL Accounts or Main GL Accounts you can check the organization parameter General Ledger Dimensions Enabled (GL DIM).

• If GL DIM = N, is blank, or does not exist in your list of parameters: Your organization is using the standard GL configuration and you should import GL Accounts

• If GL DIM = Y:  Your organization is using GL Dimensions, therefore you should import Main GL Accounts.

File Formatting

The file format for GL Accounts and Main GL Accounts is outlined below. Your new GL Accounts or Main GL Account information should be added to the CSV file without a header row, in the column order below.

• Column 1 = GL Account Mask code
  • This is the code affiliated with the GL Account Mask the GL account belongs to.
  • The available GL Account Mask code options can be found on the GL Account Masks page.
• Column 2 = GL Account or Main GL Account Number
  • This is the number in an unmasked format for the GL Account or Main GL Account.
  • Example: If masked format is 22-22-333, the imported GL account will be 2222333.
• Column 3 = GL Account or Main GL Account Description
  • This is the name of the GL Account being imported.
• Column 4 = GL Account Type
  • This is the code that corresponds to the type of GL account.
  • The available Account Type code options can be found on the GL Account Types page.

Once you your worksheet contains all the GL/Main GL Account information it should be saved in CSV file format. In the case that your file has a header row, it is important to delete this before saving.

File Import

To import a GL Account or Main GL Account import file:

1. Navigate to the Import GL Account window.
2. In the File Name field, click Choose files. Your computer's file selection window opens.
3. Select the file from your computer and click Open. You are returned to Enterprise.
4. Click OK. A success message will show, stating the number of GL Accounts successfully imported.

Troubleshooting

GL Account numbers can only exist once per organization within the database. If a GL account number already exists, then importing a file with the same number will cause an error message to display indicating that records already exist.