Banner Finance. Banner Navigation Quick Hints Managing your Banner Account Setting Up My Banner... 11

22  Download (0)

Full text


Banner Finance

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)


Chart (1)


Fund (1-6) *

Type of money


Organization (1-6)

Whose 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

Auxiliary 335xxx

Capital Improvement 77xxxx

Contract & Grant 5xxxxx

Endowment 6xxxxx

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

Libraries 151

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


Banner Navigation

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.

Direct Access

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

  Title Bar

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.

Menu Bar

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

Key Block

Information Block

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.

Key Blocks

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

Quick Hints

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

For example,

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


Entity Name/ID Search [FTIIDEN]




Related subjects :