Internet Native Banner (INB) – Finance








Last Revised: 03/5/2014
1


T able of Contents
• Overview ……………………………………………………………………………………………………. Page 3
• Banner Forms ………………………………………………………………………………………………. Page 5
• FGIBDST: Organization Budget Status …………………………………………………………… Page 8
• FGIBSUM: Organization Budget Summary ……………………………………………………. Page 12
• FGITBSR: Trial Balance Summary ………………………………………………………………….. Page 14
• FGITRND: Detail Transaction Activity ……………………………………………………………. Page 17
• FRIGITD: Grant Inception to Date …………………………………………………………………. Page 21
• FRIGTRD: Grant Transaction Detail ……………………………………………………………….. Page 24
• Appendix A: Configuring My Banner, My Links and Preferences …………………… Page 26
• Appendix B: More About Queries …………………………………………………………………. Page 33
• Appendix C: Common Rule Codes …………………………………………………………………. Page 35
• Appendix D: Other Useful Finance Forms ………………………………………………………. Page 36
• Appendix E: Shortcuts ……………………………………………………………………………………. Page 37



2


OIntverervnet Naitiewve Ba: nner (INB) is a fully featured client for real-time access to Banner. It has excellent response times but is
somewhat cumbersome to learn for the casual user. Security constraints do not permit general campus users access to labor
detail or tuition payment detail.
INB runs in two windows:

The ‘behind the scenes’ control window in the
The one you work in.





internet browser.


-A user can have more than one INB instance open at a time.
Note: Closing this window will close
both.
3


Direct Access Field
List of Values (LOV)
Banner Products
Custom Links
Auto Hints/Error
Messages

4


Ba• nneAl Bar Fnnero forrmms hasv:e seven characters.
o Example: F G I B D S T

• Naming Convention:
o The first letter of the name identifies the primary system (product) in Banner which ‘owns’ the job, report, form
or table.
 Example: F G I B D S T
 (F = Finance)
Section
Letter
Student
S
Finance
F
Human Resources
H
Financial Aid
R
General
G
Banner Exenter Solutions
B

o The second letter of the name identifies the module in Banner that owns the job, report, form or table.
 Example: F G I B D S T
 (G = General Finance)
 For the majority of your purposes, G wil be the only module you wil use.


5


Banner Forms (continued):

o The third letter of the name identifies the type of job, report, form or table.
 Example: F G I B D S T
 (I = Inquiry)
Letter Description
A
Application
I
Inquiry Form
Q
Query Form (accessed from another form)
R
Report or Process
V
Validation Table View

o The last four letters of the name is the title of the job, report, form or table.
 Example: F G I B D S T
 (BDST = Budget Status)




6


Banner Forms (continued):
Banner forms can be accessed in two main ways:

1.) Inputting the form name in the Direct Access Field and pressing the Enter key.



2.) Double-click on a My Banner link. The My Banner links are user-defined. See Appendix A: How to configure My
Banner for setup instructions.

7





Fo rm FGIBDST: Organization Budget Status
Functional Use: The FGIBDST form provides the available balance for budget-funded ‘accounts.’ It also reports budget,
revenue, expense and transfer amounts for a given fiscal year for both budget-funded and fund balance accounts. A user can
dril to transaction-level detail.

Available Balance = Adjusted Budget – YTD Activity – Commitments




8


FGIBDST – Organization Budget Summary
Steps to run an available balance inquiry:
1.) Enter the letter ‘O’ in the Chart field.
2.) Enter a two-digit Fiscal Year.
3.) Uncheck the “Include Revenue Accounts”
checkbox.
4.) Enter query parameters: An Index or a Fund-Org
combo.
5.) Select the Next Block button
or press CTRL +
Page Down to get the results.


Note: After running a query, use the Rol back button
or press the Shift + F7 keys to return to the ‘key block’ and change the parameters.
9


FGIBDST available balance query sample output.
Select the cell and then press
the F3 key ('Fn'+F3 on Mac
computers) to drill to
expense transaction detail.
Alternatively, you can select
Options  Transaction Detail
Information from the menu
bar.
The available balance appears in the bottom right corner.
This available balance is incorrect for all ‘fund balance’

accounts. Use the FGITBSR form to obtain the available balance
10
for fund balance accounts.


FGIBDST query sample output with revenue account codes included.
Revenues
included in this
example.
No available balance is calculated when the “Include Revenue
Accounts” checkbox is selected.

11





Fo rm FGIBSUM: Organization Budget Sum ary
Functional Use: Provides a summary of revenues, labor expense, direct expense & transfers for a Fund-Org combo.









12


FGIBSUM – Organization Budget Summary
Steps to run a FGIBSUM inquiry:
1.) Enter the letter ‘O’ in the Chart of Accounts field.
2.) Enter a two-digit Fiscal Year.
3.) Enter an Org and Fund code.
4.) Select the Next Block button
or press CTRL + Page
Down to get the results.



Note: After running a query, use the Rol back button
or press the Shift + F7 keys to return to the ‘key block’ and change the parameters.
13





Fo rm FGITBSR: Trial Balance Summary
Functional Use: Provides the available balance for Fund Balance (aka “Cash Funded”) accounts. Examples of fund balance
accounts are professional development, research development & auxiliary accounts.

Available Balance = Current Fund Balance – Encumbrances






14


FGITBSR – Trial Balance Summary
Steps to run a FGITBSR inquiry:
1.) Enter the letter ‘O’ in the COA field.
2.) Enter a two-digit Fiscal Year.
3.) Enter a Fund code.
- For fund balance ‘accounts’, the
Fund = Index (with some exceptions)
4.) Select the Next Block button
or
press CTRL + Page Down to get the results.


Note: After running a query, use the Rol back button
or press the Shift + F7 keys to return to the ‘key block’ and change the parameters.
15


FGITBSR query sample output
Current Fund Balance is displayed at the bottom right. If Debit/Credit field at bottom reads:
‘Credit’ = surplus / ‘Debit’ = deficit.
If there are any encumbrances, you must subtract the ‘Current Balance’ in account code

‘3011 -Encumbrance Control Actual’ to get the Available Balance. For this example, the
16

available balance is $142,473.75 ($143,333.75 – $860 )







Fo rm FGITRND: Detail Transaction Activity
Functional Use: Use the Detail Transaction Activity form to obtain transaction activity for a single fiscal year. The output can
be exported to .csv file and opened in MS Excel.







17


FGITRND– Detail Transaction Activity
Key Block

Steps to run a FGITRND transaction query:
1.) Enter the letter ‘O’ in the COA field.
2.) Enter a two-digit Fiscal Year.
3.) Enter the desired Index or Fund-Org combo in the Key
Block. These parameters limit the transactions returned
so keep them as broad as possible to ensure the
data returned are complete.
4.) Select the Next Block button
or press CTRL +
Page Down.
5.) Enter detail transaction query criteria.
Entering ‘YTD’ in the Field column will return only
posted expense, revenue and transfer
transactions.
6.) Execute the query by selecting the
button or
pressing the F8 key.


Note: After running a query, use the Rol back button
or press the Shift + F7 keys to return to the ‘key block’ and change the parameters.
Once a query is started, it must be cancelled
(or Ctrl + Q) before INB allows you to roll back and change the key block parameters.
18


FGITRND Sample Query
Results can be filtered by inputting a fiscal
period. Ex. July = ‘01’, Aug = ‘02’,…, Accrual =
‘14’
This query will retrieve all posted revenue transactions
greater than $10,000 for Fund: 1001 and Org: 10040 in
FY14. (Revenue account codes begin with a four)
Auto hints and error messages appear here

19


FGITRND – Extracting data to a comma separated value (.csv) file.
Data extract steps:
With data returned, navigate to Help ->Extract Data No Key or
Extract Data with Key. Including the Key wil export the header
block information also.
If you do not receive the fol owing dialog box, then you’l need to
adjust your internet browser’s pop-up blocker settings.



20






Fo rm FRIGTD: Grant Inception to Date
Functional Use: Use the Grant Inception to Date form to obtain the available balance for sponsored research projects
(4xxxxx). A user can dril to inception-to-date transaction detail.
Note: The FRIGITD form works best for users with Master Fund and Master Org security access. Users without this access are
encouraged to use the Budget Status by Account query from Self-Service Banner Finance (accessed through Trailhead) or the
Budget Balance Checkbook Detail e~Print report.

Available Balance = Adjusted Budget – Inception to Date Activity – Commitments



21


FRIGITD – Grant Inception to Date
Steps to run a FRIGITD available balance inquiry:
1.) Enter the letter ‘O’ in the Chart of Accounts field.
2.) Enter a Grant or Grant-Fund combo.
Users without Master Fund security access will
not be able to leave the Fund field blank. Some
grants are assigned multiple funds.
3.) Select the Next Block button
or press CTRL +
Page Down.


Note: After running a query, use the Rol back button
or press the Shift + F7 keys to return to the ‘key block’ and change the parameters.
22


FRIGITD sample query output.
The Fund
Summary
option can
be helpful
when
grants have
multiple
funds.
Custom date
range available
Select the cell and then
press the F4 key ('Fn'+F4
on Mac computers) to
drill to transaction detail.
The available balance appears in the bottom right corner.
NOTE: This form is somewhat awkward in that the available

balance updates as you scrol down. Ensure you’ve scrolled to
the bottom to get an accurate available balance.
23









FoFunrctim:ona Fl UseR: IUsGTRe this foD rm– to viGewr aandnt qu Teryr aa dnsetailaed licstt oif oin Dnceptione-tto-adailte transactions. The output can be exported
to .csv file and opened in MS Excel.








24


FRIGTRD – Grant Transaction Detail
Key
Block

To exclude
Steps to run a FRIGTRD transaction query:
revenue.
1.) Enter the letter ‘O’ in the COA field.
2.) Enter a Grant or Grant-Fund combo.
3.) Change the Date From and/or Date To values to the desired range
(Optional)
4.) Select the Next Block button
or press CTRL + Page Down keys.
5.) Enter detail transaction query criteria.
Entering ‘YTD’ in the Field column will return only posted
expense and transfer transactions.
6.) Execute the query by selecting the
button or pressing the F8 key.


Note: After running a query, use the Rol back button
or press the Shift + F7 keys to return to the ‘key block’ and change the parameters.
Once a query is started, it must be cancelled
(or Ctrl + Q) before INB allows you to rol back and change the key block parameters.
25


Appendix A: Configuring My Banner, My Links and Preferences:
Configuring My Banner:
The My Banner section allows a user to define a list of commonly used forms in a single location for ease of access.
After logging into Internet Native Banner (INB), double-click the My Banner folder icon and then double-click “Empty: Select to build [GUAPMNU}.”

26


With the My Banner Maintenance form open, enter the desired form names in the Object column on the right side. The descriptions will fill in
automatically. After entering the first form, you can arrow down or use your mouse to select the next cell.
This section lists al the objects
(which includes the Banner
forms). You can run a query on
the Object or Description
columns to find the Banner
form(s) you want.
Enter the form names in this
column.

Once your list is complete, you need to save your updates. File  Save or select the save button
. Banner will display a message on the
bottom left that reads: “FRM-40400: Transaction complete: [# of items ] records applied and saved”
27


A user can run a query to find Banner forms and then subsequently add them to the list.
Query Steps:
1.) Make the left-oriented Object or Description column active by selecting the data cells in either column.
2.) Start a query:
Query  Enter, press ‘F7’ key or select the
button.




3.) Enter the query criteria. ‘%’ is the Banner wildcard character. See Appendix B for a more detailed explanation on how to use it.
This example will return all Banner forms with ‘Budget’ anywhere in the description. The queries are case-sensitive.


28


4.) Execute the query.
Query  Execute, press the ‘F8’ key or click the
button



Example results:

29


To add a form from the query results, double-click either the object column or description (the text wil change to blue), and then select the Insert
arrow. Alternatively, you can manually enter the form name in the right-oriented Object column in an open cel .

Any time the list is updated, save the updates. File  Save or select the save button
.



30


Adding Header Rows to Data Extracts:
After logging into INB, go to File  Preferences to open the General User Preferences Maintenance form (GUAUPRF.)
Check the ‘Include Header Row in Data Extract’ checkbox.

Save your changes. File  Save or select the save button
.
31


Creating Personal Links:
After logging into INB, go to File  Preferences to open the General User Preferences Maintenance form (GUAUPRF.)
Select the My Links tab. The sections work in pairs, with one section for the description and another for URL.
Enter the description for the 1st
personal link.
Enter the URL for the 1st personal
link.
Save your changes. File  Save or select the save button

The Hyperlink changes will take effect after exiting and logging back
into INB.


32


Appendix B: More About Queries
• To query:
o Press the F7 key or click on
to begin a query.
o Enter information you wish to query on (using optional wildcards)
o Execute the query to retrieve data by selecting the F8 key or selecting the
button
• Wildcards are special characters used in queries to represent one or more unspecified characters. Wildcards can also help with getting data
based on a specified pattern match. For example, finding every document code that begins with “DAC.”
o The percent character (%) represents any number of unspecified characters.
o The underscore character (_) represents one occurrence of an unspecified character.
To get these results
Enter these criteria
Note: Queries are case sensitive!
All values that contain “a”
%a%
All values that begin with “An”
An%

All values that have “n” as the second character
_n%

Example: The FTVFUND – Fund Code Validation form contains information about funds such as the title and termination date. There can be
multiple records for a single fund with different effective dates. If a title has been updated, there wil be a record showing the old title and a newer
record showing the revised title.

33


Scenario: You need the CCAC – Research Development index/fund number but don’t have it in your records. After navigating to the FTVFUND form,
begin a query by pressing the F7 key or click on the
button. To find al fund titles that contain “CCAC” anywhere in the text value, you would
enter the fol owing criteria and then execute the query by pressing F8 or selecting the
button.

If the abbreviation is not used in the title and the center name is explicitly spel ed out, this query wil not return the desired information. Multiple
searches may be necessary and thought should be given to different possible configurations. Also keep in mind that there are different effective
date records and you may only be interested in the current title.








34


Ap pendix C: Com on Rule Codes

Rule Code
Description
Rule Code
Description

BD__
Budget Entries
DNEC
Check - C/M w encumbrance

BR__
Budget Rol forward Entry
DNEI
Check - Invoice w encumbrance
CA__ , CB__
Student Charges
DNNI
Check - Invoice w/o encumb

CAEC
Cancel Check C/M Addl w/Encumb
E0__, E100
Encumbrance Entry
CAEI
Cancel check invoice addl w/encumb

F400
ES Feed - Chemicals
CDEI
Cancel Check Invoice disc w/encumb
F500
PCard Feed - EXTERNAL

CNEC
Cancel Check - C/M w encumbrance
F600
TelComFeed - CHARGES
CNEI
Cancel Check - Invoice w encumbranc
FZ__
Journal Entry

CNNI
Cancel Check - Invoice w/o encumb
GRIC
Indir Cost Charge

CO__
Change Order
H___
Payroll Entries
CR05
Cash Receipt Entry
IN__
Invoice

DIEI
Discount on Invoice w/ Encumb
PORD
Purch Ordr - Establish
DISC
Discount on Credit Memo
REQP
Requisition - Reservation

DISI
Discount on Invoice








35


Ap• FenPIPdix URR – DPur:c Ohasteher Orde Ur Inseful F
quiry
inance Forms
FAIVNDH – Vendor History
FOIDOCH – Document cross reference
FPIOPOF – Open PO’s by FOAP
FPIOPOV – Open PO’s by Vendor
FGIOENC – Open Encumbrances by FOAP
GUAUPRF – Set user screen preferences
FGIENCD – Encumbrance Detail Activity
FAIINVE – Invoice/Credit Memo Query
Fund-Org-Account Code-Program (FOAP) Queries
o FTVFUND
o FTVORGN
o FTVACCT
o FTVPROG




36


App endix E: Shortcuts



37


Document Outline