General Accounting - Procedure 63011

Banner Transaction Download

Contacts and revision dates:

Procedure: 

1. In Banner, enter the desired form name in the Search box. Examples include FGITRND, FRIGTRD, and FGIGLAC. 
2. Once on the form, enter the six-digit banner fund number. A specific account code can also be entered to restrict the transaction to a specific account code. Select the Go button.
3. To further restrict the transactions, additional criteria can be entered. The user selects Go to display the data.
4. Once the desired transactions are on the form, select “Export” from the Tools menu. The file will automatically download in Excel format and be saved in your “Downloads” folder.
   1. Note that the file is .csv and when it is opened it will prompt the user to convert the file so that leading zeros on account codes, organization codes, and program codes are removed. The user should select Don’t Convert to maintain this information. For example, organization code 044000 would appear as 44000 if the file is converted.
   2. The account code, organization code, and program code columns will need to be maintained as Text to prevent leading zeros from being lost.

Please Note: The data in the Banner columns is included in the download file. The first row will contain the selection criteria. The titles of the columns from the online screen are not included in the download file.  

This is a controlled document when viewed online. Printed copies are considered uncontrolled and may not reflect the most current version.