Banner Navigation ... 7
Quick Hints ... 10
Managing your Banner Account ... 11
Setting Up My Banner ... 11
Document History [FOIDOCH] ... 13
Budget Availability Status [FGIBAVL] ... 14
Organization Budget Status [FGIBDST] ... 15
Extracting Data from a list of records ... 16
Grant Inception to Date [FRIGITD] ... 18
Trial Balance Summary [FGITBSR] ... 19
Organization Budget Summary [FGIBSUM] ... 20
Entity Name/ID Search [FTIIDEN] ... 22
Banner Finance System Chart of Accounts
One facet of using Banner is familiarity with the chart of accounts. The diagram below illustrates Banner accounting terms.
FOAPAL (# characters)
Fund (1-6) *
Type of money
Account (1-6) *
What is being spent/receipted
Fund - Required
A Banner fund is a numeric designation for a fiscal and accounting entity with a set of accounts in which transactions are recorded and segregated to carry on specific activities or attain certain objectives in accordance with the prevailing regulations, restrictions, or limitations. Financial managers are established at this level. For grants, the financial manager is the principal investigator.
Where Money Comes From
Data Entry Range
General Funds - Departmental 1xxxxx – 2xxxxx
Trust - Departmental 331xxx
Trust - Overhead 337xxx
Capital Improvement 77xxxx
Contract & Grant 5xxxxx
Loan Funds 6xxxxx
Agency Funds 999xxx
Organization - Required
The 5-digit Organization Code represents the Division, School, and Department. It will default based on your fund. The following chart outlines the high-level breakdown of Orgs at ECSU. In general, the first digit of the organization code correlates to its related division.
Whose Money Data Entry Range
Chancellor 20xxx - 29999
Academic Affairs 30xxx - 39999
Business & Finance 40xxx - 49999
Student Affairs 50xxx - 59999
Institutional Advancement 60xxx - 69999
Account - Required
The Account Code is the numeric designation for individual asset, liability, equity, revenue, expenditure and/or transfer account classifications. The chart below outlines the basic breakdown of the Account.
What is Spent/Receipted Data Entry Range Revenues 2xxxx Expenditures 1xxxx Fund Balance 5xxxx Assets 3xxxx Liabilities 4xxxx Budget Pools 7xxxx
Program - Required
The program code is the numeric designation for group activities, operations or other units directed to attaining specific purposes or objectives. These are defined by the National Association of Colleges and University Business Officers Standards. The program code will default based on your fund. The chart below outlines a few of the program codes.
Why Money Spent/Receipted Data Entry Values Instruction 101 Summer-Term Instruction 102
Non-Credit Receipts Supported Instruction 103
Organized Research 110
Community Services 142
General Academic Support 152
Student Services 160
Activity - Optional
The Activity Code is the alphanumeric designation for special events or projects. When using the Activity field, there is no warning to the user to input this data and there is no budgetary control over this element.
Location - Optional
This section will examine various methods of navigating within Banner Finance.
Banner uses the term “form” to represent a Banner screen. A form may have multiple windows associated with it. The first element to know is how to access a form. Several navigation methods are available; the primary ones are listed and described below.
• Main Menu – An overview of Banner arranged in a top to bottom level format: system,
module, and form.
• My Banner – Build a custom menu for yourself. • Direct Access – Access a form by typing its name.
• Options Menu – From within a form you can access other forms, windows and blocks
related to the current form.
Your Personal Menu
Banner Main Menu
Double click the folder to expand and collapse the menu.
• The next component to understand is the various parts of a form. Forms contain the following parts:
§ Title Bar § Menu Bar § Toolbar
§ Blocks - Key Block and Information Block(s) § Auto Hint and Status Line
The title bar of a form shows the descriptive name, 7-character code name, version number and database name. The title bar of a window will show the name of the information area, along with the other information.
The menu bar contains pull-down menus of functions and commands that can be performed in Banner. Other areas of information can also be accessed through the menu bar. If the menu bar item is grey, the item is disabled for that particular form or condition.
The toolbar, found along the top of all Banner forms, provides a common interface across the entire Banner product. When you move your cursor to a button in a toolbar and pause, a yellow bubble appears that describes the function of the button. Functions like ‘Save’, ‘Rollback’, ‘Insert Record’, etc. can be performed by clicking various toolbar buttons.
Menu Bar Toolbar Title Bar
Auto Hint and Status Line
View of the Horizontal Toolbar
1 2 3 4 5 6 7 8 9 10 Some of the most commonly used icons are listed below.
Icon Used for…
1. Rollback – clears all information (except key information) and returns you to the first enterable field in the key block. If you enter changes and do not save them before trying to roll back, you are prompted to save.
2. Select value to return to form.
3. Previous Record – moves cursor to the previous record.
4. Next Record – moves cursor to the next record.
5. Previous Block - moves the cursor to the previous block that has at least one enterable field.
6. Next Block – moves the cursor to the next block that has at least one enterable field.
7. Enter Query - puts the form into query mode so you can enter search criteria to see what information is already in the database.
8. Execute Query – in query mode, searches the database and displays all records that match your search criteria.
9. Cancel Query – removes all data and is ready for you to enter another query. 10. Exit – if you’re in a form, exits the form and returns to the main menu. If you’re on the main menu, exits the Banner application.
The Key Block is the first block on most forms. The information in this block determines what is entered or displayed in a form. Information cannot be updated in a key block. The only way to return to the Key Block once you have moved out of it is by using the Rollback function. Information Blocks
Information blocks contain related information on a form. Usually a line separates the different blocks on a window.
Auto Hint and Status Line
The Auto Hint and Status Line will display a variety of information depending on the form and condition. Here you will find:
• Hints on the field the cursor is in. • Certain error messages
• The number of records already displayed
Banner Finance Form Naming Conventions
The forms within Banner Finance are accessible by typing their 7 character form name in Direct Access (the field on the Main Menu). These form names have the following structure:
Position 1- Identifies the primary system
owning the form, report, job, or table F Finance G General
Position 2 - Identifies the module owning the form, report, job, or table
A Accounts Payable G General Ledger O Operations P Purchasing/Procurement R Research Accounting U Utility
Position 3 - Identifies the type of form,
report, job, or table I Inquiry form A Application form
Positions 4, 5, 6, and 7 uniquely identify the form, report, job, or table.
FOIDOCH Document History
FGIBDST Organization Budget Status
FGIBAVL Budget Availability
FGITRND Detail Transaction Activity
FGITBSR Trial Balance Summary
FGIGLAC General Ledger Activity
• Banner runs with two windows open. Closing one of the windows will end the Banner
• The wildcards for Banner querying are “_” (one space) and “%” (zero or more spaces).
IN% any beginning with IN
%APR-2014% any that contains APR-2014
%CA any ending with CA
_B% any with occurrence B in 2nd character
• Use F5 on your keyboard to display the direct access field. This is useful if you want to
access another Banner form without exiting the current form.
• To check available balance:
FGIBAVL Budget Summary – Budget Pools – Fiscal Year FRIGITD Grant Inception to Date – Grant period
• To view detail transactions:
Managing your Banner Account
Set up User Preferences to enable all the features of Banner and personalize the Main Menu. • Click on File from the menu bar and choose Preferences from the drop down list. • Click inside the blank check boxes for “Display Form Name on Menu” and “Include
Header Row in Data Extract” and save your changes.
When you exit this tab, an alert box will appear to tell you that your changes will take effect after logging off and back on to Banner.
• Click on the Menu Settings tab and change the User Default to *PERSONAL and save your changes.
Setting Up My Banner
This section will explain how to organize your personal menu called “My Banner”. 1. Double click on the My Banner folder.
2. An option entitled “Empty: Select to build.” will display. Double click on the option. 3. The following form will display.
Double click to select the desired forms from the list and use the arrow buttons to move to your personal menu. Click on the save icon
to commit the changes.
4. Type the following quick keys in the object field or double click on each of the following forms (listed in alphabetical order by description). Be sure the text color turns to blue when selecting.
[FGIBAVL] Budget Availability Status (use only for funds budgeted on a fiscal year basis)
[FGIBDST] Organization Budget Status (shows detail expense and revenue accounts) [FOIDOCH] Document History (to search for documents related to the purchase order) [FGITBSR] Trial Balance Summary (to see cash or fund balance)
[FRIGITD] Grant Inception-to-Date (use this form for grants)
[FTIIDEN] Entity Name/ID Search (use this form to find vendors in Banner Finance) 5. After inserting the forms to be displayed in the My Banner menu, click the Save
6. Click the Exit icon.
Document History [FOIDOCH]
Budget Availability Status [FGIBAVL]
Before entering or approving a requisition in Viking Shoppes you must check the budget to ensure that funds are available. Use this form to view the overall year-to-date activity in a fund by budget pool. This form requires the account in the key block. To see all accounts, enter “731110” as the account code, then, click on the next block icon. Budget pool accounts are listed numerically.
• Budgets for most funds are in budget pools rather than in the individual expense account. • You will not be able to Use “Options” from the menu bar to drill down for more detail on
Organization Budget Status [FGIBDST]
Use this form to view the overall year-to-date activity for each account used in a fund during the fiscal year. Accounts are listed numerically starting with expense accounts (1####) and ending with budget pools (7#####). Uncheck “Include Revenue Accounts” in the key block to see the total of all expense accounts.
Use “Options” from the menu bar to drill down for more detail on an account (from Options, choose “Transaction Detail Information”).
Extracting Data from a list of records
Banner will allow you to extract data on some forms to Excel. This feature may be available on forms where Extract Data is an option under the Help Menu. If the option is grayed out, the extract functionality is not available.
a. Select Help from the menu bar and choose Extract Data No Key.
b. The following window will display. Click Open.
Excel will open in a new Internet Explorer window and the transaction information will display. Save the file changing the type to an Excel workbook.
Grant Inception to Date [FRIGITD]
Use this form to view the budget, activity, commitments and available balance for a grant. Enter the fund in the key block and perform a next block function. The activity represented is not limited to fiscal year-to-date.
Trial Balance Summary [FGITBSR]
Organization Budget Summary [FGIBSUM]
Use the Organization Budget Summary Form to view summarized budget information by user-defined account type for a selected organization/fund combination. Access this form from the General Budget Query Forms Menu (*FINGBUDQ) or by selecting Budget Summary
Information from the options list on the Organization Budget Status Form (FGIBDST).