Elizabeth City State University Banner Finance Course Objectives

Elizabeth City State University Banner Finance

Course Objectives • Understand ECSU Chart of Accounts Structure • Managing your Banner System Account – How to set up user preferences – How to manage your personal menu • Finance Forms – Understand naming conventions and form structure – Perform basic Banner navigation functions • Search for items in a database • Extract data to Excel – How to find financial data

ECSU Chart of Accounts Structure

Fund vs. Account What is Spent/Receipted Data Entry Range Revenues 2 xxxx Expenditures 1 xxxx Fund Balance 5 xxxx Assets 3 xxxx Liabilities 4 xxxx Budget Pools 7 xxxx

Internet Native Banner Logon

Make “My Banner” your default

Set up your Personal Menu

Form Naming Conventions • All forms names have seven characters also known as a Quick Key Modules Finance Position 1 - System Module Position 2 Student Position 2 Module A Accounts Payable A Admissions B Budget Development C Catalog C Cost Accounting E Support Services E Electronic Data Interchange F Registration/Fee Assessment F Fixed Assets G General Student G General Ledger H Grades/Academic History I Investment Management I Faculty Load N Endowment Management L Location Management O Operations M CAPP P Purchasing and Procurement O Overall R Research Accounting P Person S Stores Inventory R Recruiting T Validation Form/Table S Schedule U Utility T Validation Form/Table U Utility Position 2 - Module Position 3 – Type

Parts of a form • Title Bar • Blocks – Key Block – Information Block

Menu Bar Toolbar Title Bar Key Block Information Block Auto Hint and Status Line

When working on a form, where do you start? A. Next block B. Information block C. Start block D. Key block

Horizontal Toolbar 1 2 3 4 5 6 7 8 9 10

Querying • Wildcards - you can use the Oracle wildcards % and _ in the search criteria: – The character % represents any number of unspecified characters. – The character _ represents one occurrence of an unspecified character. – The date format in Banner is DD-MMM-YYYY. To query all transactions for the month of December 2013 use %DEC-2013 as the search criteria.

Quick Hints • Options Menu – From within a form you can access other forms, windows and blocks related to the current form. – You can also use the right mouse button to access a list of options (just be sure your pointer is not over a field). • Use F 5 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. • Click on File from the menu bar to see the last 10 forms accessed since your last logon.

Type in the search criteria

Execute the query

Drill down for more information

Drilling down Ø Field in key block is populated automatically from the previous form Ø Perform a ‘next block’ function to see information Ø As long as Options is not grayed out in menu bar, you can continue to drill down for more information

Check Available Balance

To see detail accounts

To see detail transactions in operating ledger

Perform a search 1. Enter the query mode 2. Type in the search criteria 3. Execute the search

Extract records to Excel

To see general ledger balances on self supporting or other trust funds

Use “Options” to drill down for more detail Menu Bar or Right click

Grant funds

To look up vendors in Banner

If you want to see the names of the last 10 forms accessed in the current session, which menu bar choice would you select? A. File B. Edit C. Record D. Help