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.
• 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.