Transcript Introduction to Banner Finance
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