Internet Native Banner (INB)

Topics

• • • • • • •

Navigation Budget Status

– – –

Operating Ledger (Budget/Actual) General Ledger (Cash Balances) Grant Ledger Document History/Retrieval Encumbrance/PO Balances Vendor/Check History Downloading Data to Excel Submitting Reports Online through INB

2

www.tnstate.edu/banner

3

Banner Logon

4

INB Finance Menu

1 2 5

Finance Menu

6

Banner Navigation

• Mouse vs. keystroke • Multiple part forms • Banner Navigation Reference Next Block Ctrl + Page Down Previous Block Ctrl + Page Up Rollback/Clear Form Shift + F7 Enter Query Mode Execute Query Cancel Query Print Exit F7 F8 Ctrl + Q Shift + F8 Ctrl + X 7

Budget Status

• Operating Ledger – FGIBDSR: Executive Summary • High Level Organizational View of Budget Status • Dynamic, Real-time Balances • Shows Budget versus YTD Actual versus Encumbrances with an Available Balances for Revenues and Expenses 8

FGIBDSR

9

Budget Status

• Operating Ledger – FGIBDST: Organization Budget Status • Dynamic, Real-time Balances • Specific Fund Detail • Shows Budget/Actual/Encumbrances/Available Balances for Revenues and Expenses • Refine search by using queries • Drill-down capabilities to document level • Download to excel capabilities 10

FGIBDST

11

Budget Status

• General Ledger – FGITBSR: Trial Balance Summary • Search by Fund Code or high level Fund Type. • Shows current cash balance • Most useful for Foundation or Agency Funds • Capability to drill down by Account Code through the Options Menu 12

FGITBSR

13

Budget Status

• General Ledger – FGITBAL: General Ledger Trial Balance • Search by specific fund code only • Shows current cash balance • Shows fund is in balance • Most useful for Foundation and Agency Funds • Capability to drill down by Account Code through the Options Menu 14

FGITBAL

15

Banner Forms

• Grant Ledger – FRIGITD: Grant Inception to Date • Uses Grant Code • Shows revenues/expenses from beginning of project • Can restrict to specific periods • Can drill down by Account code 16

FRIGITD

1 17

Document History/Retrieval

• Document Query – FOIDOCH: Document History • Follows document from requisition to check • Allows searches on Requisition, PO, Invoice, or Check Number • Drill down capabilities by document from Options Menu 18

FOIDOCH

1 2 19

Document History/Retrieval

• Document Query – FGIDOCR: Document Retrieval Inquiry • Detail transactions associated with a document • Allows search capabilities on FOAPAL or amount 20

FGIDOCR

21

Document History/Retrieval

• Document Query – FGIENCD: Detail Encumbrance Activity • Shows outstanding balance on Encumbrance/PO • Shows FOAPAL being charged on Encumbrance/PO • Shows invoices paid against Encumbrance/PO • Shows change orders against an Encumbrance/PO 22

FGIENCD

23

Vendor/Check History

• FAIVNDH: Vendor History – Allows vendor lookup of Banner ‘T’ number – Displays vendor history by fiscal year – Provides capability to view detail check history – Can see if an invoice has been paid and obtain the check number 24

FAIVNDH

1 2 25

Extracting Data to Excel

• Banner provides the capability to download certain data to excel • This is helpful when desiring a special sort or to provide special reports for budget heads.

• Most common forms to extract from are FGIBDST and FGITBAL.

26

Extracting Data to Excel

• Select Options/Query Transaction by Source to view the details.

27

Extracting Data to Excel

• Select Help/Extract Data No Key 28

Extracting Data to Excel

• Data is displayed in an excel workbook.

• Reformat all cells and add titles as needed.

• Data can now be sorted/saved/printed, etc.

29