Banner Finance Training

Banner Finance TrainingInternet Native Banner INBInternet Native Banner INB Internet Native Banner (INB) is a fully integrated suite of administrative software applicationsused by higher education to manage business operations and offer several powerful dataqueries. Go to the “Banner Finance” tab on the portal. Go to the “Banner SSO” channel usually found below the “Banner Finance Self Service”channel.Page 1 of 25

Banner Finance TrainingInternet Native Banner INB Click the drop down box to the right of “Select a Site” and choose INB, this will take you to theINB menu. The menu will list out all the possible forms and processes that are available in theFinancial System Menu [* FINANCE] area. You can double click on each file icon to view all theavailable forms. Please note that your systems access will determine the forms and processesyou may view.Page 2 of 25

Banner Finance TrainingInternet Native Banner INBINB Forms or Screens Listed below are the more commonly used forms that are available to UMFAIVNDH DESCRIPTIONRequisitionGrant Inception to DateGrant Inception to DateDetail Transaction ActivityExecutive SummaryOrganization Budget SummaryVendor Detail HistoryEXPLANATIONMust be used for purchase requisitionsDisplays grant project to date expensesDisplays grant project to date expensesDisplays detail by transactionsDisplays budget information by accountSummarizes budget by revenue and expenseDisplays vendor detail historyType in the form name you would like to access in the Go To dropdown box and press theEnter keyPage 3 of 25

Banner Finance TrainingInternet Native Banner INB INB functionality provides the user with menu options, keystrokes options and toolbar icons tonavigate within the INB form(s). The Banner forms are broken-up by sections and blocks. Thebelow table offers available navigation options. The highlighted area below represents Menu navigation options, which are listed in the belowtable Toolbar IconsPage 4 of 25

Banner Finance TrainingInternet Native Banner INBFUNCTIONMENU OPTIONSKEYSTROKE OPTIONSNext RecordRecord/NextDown ArrowPrevious RecordRecord/PreviousUp ArrowTOOLBAR ICONSRecord/Clear orRemove RecordShift F6Record/RemoveInsert RecordRecord/InsertF6Duplicate RecordRecord/DuplicateF4Next BlockBlock/NextCtrl Page DownPrevious BlockBlock/PreviousCtrl Page UpRollbackFile/RollbackShift F7Next FieldField/NextTabN/APrevious FieldField/PreviousShift TabN/ASave or CommitFile/SaveF10Enter QueryQuery/EnterF7Page 5 of 25N/A

Banner Finance TrainingInternet Native Banner INBFUNCTIONMENU OPTIONSKEYSTROKE OPTIONSExecute QueryQuery/ExecuteF8Cancel QueryQuery/CancelCtrl QExitFile/ExitCtrl QPage 6 of 25TOOLBAR ICONS

Banner Finance TrainingInternet Native Banner INBFPAREQN - Creating a requisition Go to the “Banner Finance” tab on the portal Go to the Purchasing Portal link found under the Controller Policies & Forms channel, ashighlighted belowPage 7 of 25

Banner Finance TrainingInternet Native Banner INB Select the Banner Info link as highlighted below. This link will take you to the Purchasingrequisition information documents.Please refer to the Purchasing website for additional information athttp://www.iit.edu/purchasing/vendor information.shtml.Page 8 of 25

Banner Finance TrainingInternet Native Banner INBFRIGITD – Grant Inception to Date Inquiry Type FRIGITD in the Box to the right of the Go To. and press enter This takes you into the form where you will input your grant query as listed below:o Grant field – input grant numbero Check the Fund Summary box – this will list all funds associated with the granto The Chart of accounts will always equal “1” – this is an auto populated fieldo The Date From and Date To fields are based on grant life-to-date (LTD) activity;however, you may also change these dates to view a more specific timeframe.o Click Next Block icon to execute the queryPage 9 of 25

Banner Finance TrainingInternet Native Banner INB To drilldown to the next level of account detail, highlight the Activity Column amount on thecorresponding account row Click on Options, then Grant Detail Information, which will take you to FRIGTRD – GrantTransaction Detail FormPage 10 of 25

Banner Finance TrainingInternet Native Banner INB Once you have executed the query the information can be downloaded to EXCEL To extract data into EXCEL click on “Help” then “Extract Data No Key”. To start your extractselect “Open” to retrieve the document when prompted. A CSV formatted file will be created,which can then be saved as an EXCEL file. All INB forms generally follow this format for extracting data. If the “Extract Data No Key” isgrayed out it means you are not at a level that data can be extracted. In addition, please notethat pop-up blockers may prevent the extract process from running.Page 11 of 25

Banner Finance TrainingInternet Native Banner INB Please note that you must do a one-time Banner set up to allow headers to appear as part of thedata extraction To do this, type GUAUPRF -General User Preferences Maintenance next to the Go To. and clickthe Enter key Under the “Data Extract” section located in the lower left hand corner of the Display Optionstab, check the box next to “Include Header Row in Data Extract” and then click on the Save iconin the upper left corner of the screenPage 12 of 25

Banner Finance TrainingInternet Native Banner INBFGITBSR – Trial Balance Summary Type FGITBSR in the Box to the right of the Go To. and press enter This takes you to the form which is broken into two sections, the top section for accountingquery information and the next section for query resultsCOA field will always be “1”Fiscal Year field – will automatically default to current fiscal yearFund Field – enter fund number you would like to viewYou have the option once the fund is selected to choose a specific account or to leave this fieldblank. If the account is left blank, once the query is executed Banner will display all accountsassociated with the selected fund.Click Next Block icon to execute the query Page 13 of 25

Banner Finance TrainingInternet Native Banner INB This form is useful for tracking net assets for 2XXXXX - Restricted funds and 15XXXX –Unrestricted funds.This form displays the general ledger accounts, which summarize operating account information(i.e., 5XXX - Revenue, 6XXX – Salary and Benefits, 7XXX – Other Expenses and 8XXX - Transfers).All 5xxx accounts are summarized within account 3011 – Revenue Control, and all 6xxx, 7xxx and8xxx accounts are summarized within account 3021 – Expenditure Control.The 4XXX - Net Asset series represents the beginning fund balance (i.e., prior year endingbalance).The Current Fund Balance field should always be a credit balance. If this field is a debit balance,the fund is currently overspent.Highlighting an account row and selecting “Options” and then “Query General Ledger Activity”allows you to drilldown to the account detailOnce you have executed the query the information can be downloaded to EXCELTo extract data into EXCEL click on “Help” then “Extract Data No Key”. To start your extractselect “Open” to retrieve the document when prompted. A CSV formatted file will be created,which can then be saved as an EXCEL file.Page 14 of 25

Banner Finance TrainingInternet Native Banner INB All INB forms generally follow this format for extracting data. If the “Extract Data No Key” isgrayed out it means you are not at a level that data can be extracted. In addition, please notethat pop-up blockers may prevent the extract process from running.Page 15 of 25

Banner Finance TrainingInternet Native Banner INBFGITRND – Detail Transaction Activity Type FGITRND in the Box to the right of the Go To. and press enter This takes you to the form which is broken into two sections, the top section for accountingquery information and the next section for query resultsFOAP fields – Can be left blank or entered to view a specific queryAccount FieldClick Next Block icon, which takes you to the next section of the formClick the Execute Query icon to retrieve query results Page 16 of 25

Banner Finance TrainingInternet Native Banner INBFGITRND – Wildcard (%) Query The top section may be left blank with the exception of the COA and fiscal yearCOA field will always be “1”Fiscal Year field – will automatically default to current fiscal yearClick Next Block icon, which takes you to the next section of the formSelect query items using the wildcard (the % sign) to query all of the items you have Banneraccess to. For example, if you would like to see the detail transactions for all 7XXX accountsenter “7%” in the account column. Please noteClick the Execute Query icon to retrieve query resultsPlease note that this is a rather large extract because it will include all the budget, reserves,encumbrance and actual transactions. To view year-to-date (YTD) actual transactions only,enter YTD in the Field column and “7%” in the account column. The fields, documents and typesare further explained on the “Banner Finance Guides and Charts of Accounts” section found onthe Controller’s Office Website.This information can also be downloaded to EXCEL the same way as discussed at the beginningof the INB section.Once you have executed the query the information can be downloaded to EXCELTo extract data into EXCEL click on “Help” then “Extract Data No Key”. To start your extractselect “Open” to retrieve the document when prompted. A CSV formatted file will be created,which can then be saved as an EXCEL file.All INB forms generally follow this format for extracting data. If the “Extract Data No Key” isgrayed out it means you are not at a level that data can be extracted. In addition, please notethat pop-up blockers may prevent the extract process from running.Page 17 of 25

Banner Finance TrainingInternet Native Banner INBFAIVNDH – Vendor Detail HistoryType FAIVNDH in the Box to the right of the Go To.and press enter This takes you to the form which is broken into two sections, the top section for accountingquery information and the next section for query resultsThis form is used to determine if a vendor has been paid and provides relevant informationregarding the payments.Page 18 of 25

Banner Finance TrainingInternet Native Banner INB Vendor field – enter vendor A number. Please note, a query is available to find the vendors “A”number.To start the query click on the dropdown box to the right of the Vendor field, select EntityName/ID Search by clicking on it. In the Last Name column type in the Vendors name or part ofthe name and use the wildcard (the % sign). Please note that this form is case sensitive.Execute your query by clicking the Execute Query icon. Double click on the desired vendor rowto return the correct vendor.Tab through the vendor line and then click the Next Block icon to execute the queryThis allows you to see the vendor invoice, the IIT generated invoice document, amount, duedate, check date and check numberGUTPMNU - Personal Menu Maintenance Menu and Copy Type GUTPMNU in the Box to the right of the Go To. and press enter. This will take you tothe Personal Menu Maintenance Menu and Copy screen. The following forms are used to create, change and copy My BannerFormPersonal Menu MaintenancePersonal Menu MaintenanceMenu and CopyCodePurposeGUAPMNUCreate and change your personalmenuGUTPMNUCopy your personal menu to orfrom another userPage 19 of 25

Banner Finance TrainingInternet Native Banner INB To copy another user’s “My Banner” form listing go to the User field and select that userfrom the dropdown box. This will populate the right side of the screen with that user’s “MyBanner” form listing.Page 20 of 25

Banner Finance TrainingInternet Native Banner INB To display users click on the Display User icon circled below. This will populate the left sideof the screen with that user’s “My Banner” form listing.Page 21 of 25