GL> Utilities> Import/Export Account Types

Import and Export Account Types

Summary

The Account Type Import/Export process is used to update the account types associated with specified GL accounts.

Step by Step

1 Export Account Types.

Open the Export Account Type window (GL> Utilities> Export Account Type).
Select a Fiscal Year for the export file.
- Only the account types associated with this fiscal year will be included in the export file.
Click the Confirm icon to export the account types.
- The export file will be in comma-separated value (.csv) format.
- Click the Display icon to display the .csv export file layout.
  - The export file will include the Fiscal Year, Account 1-7, Description and Account Type as separate columns on the .csv spreadsheet.
  - Click here for information on import file layouts.
Once the export file has been generated, the Export Settings window will open.
- Check the Open toggle if you would like to open the exported file after it is saved locally.
- Enter the Full Path location and click the Save icon to export the data as a spreadsheet to the local path.
Once the spreadsheet has been saved, changes can be made to the Account Type column. Only changes to the Account Type column will be updated when the file is imported.
- For example, if changes are made to the Account Type field and the Description field for each entry, only the Account Type will be updated when the data is imported.

2 Import Account Types.

Open the Import Account Type window (GL> Utilities> Import Account Type).
Enter a File Name path or click the field label to browse to the import file.
- The import file must be in comma-separated value (.csv) format.
- Click the Display icon to display the expected .csv file layout.
  - The expected import will include the Fiscal Year, Account 1-7, Description and Account Type as separate columns on the .csv spreadsheet.
Click the Confirm icon to import the account types.
Only the changes made to the Account Type column will be updated.