Imperial Valley College - Grand Valley State University
Contents
1. File Edit Options Block Item Record Query Tools Window Help Boh i x9 8 mp m9 PPE TH General Ledger Activity FGIGLAC 7 0 FINT PPri Chart s 7 Periad C Fiscal Year os 7 Index Jv Fund fzosaoz 7 Account 165 7 2 m Account Transaction Date Type Description Amount H invoice FE PO PO Cd O Cd PO O OA Lo Loo SOS Loo OAS Loo O Do O O Loo S LEAT TOM TTT Total 5 650 00 Add INB Grant Module forms to your Personal Menu Quick Tip for ease of future access Grants User Manual 121008 4 23 2010 Page 18 of 22 User Manual Banner Grants Module Creating a Personal Menu This feature allows you to create your own menu of commonly used forms for quick and easy access Add the INB Grants module forms most likely to be used most as follows amp Oracle Developer Forms Runtime Web Bee File Edit Options Block Item Record Query Tools Window Help B E R 5 m gE I XI d ENT ee Rick BSI ix i z9 General Menu GUAGV Next Record M Thursday June 09 2005 L FX Go To LY Welcome LINDBERB Products 4 Menu Site Map Help Center 8 QUE ee ea Hbi Sei si My Links B Account Hierarchy Query FTIACTH Bl Account Detail TFADETL Change Banner Password Bl Chart of Account Code Maintenance FTMCOAS B Organize My Banner GUAPMNU lt JSCT Banner Check Banner Message Personal Link 1 C Student STUDENT Personal Link 2 Q Financial FINANCE _J2. Activity Account 208402 DOI USGS Map Musk Quadrangles J J O Organization Location 0 j L C Fund Summary C Hierarchy By Sponsor Account Date From MM J Y Y Date To MM Y Y C Include Revenue Accounts Sponsor Account Code DIRECT FRINGES INDIRECT SUPPLIES sumPoRT TRAVEL 0 0 Adjusted Budget 30 000 00 11 000 00 18 400 00 2 000 00 s 000 00 1 000 00 0 0 Activity 6 000 00 2 400 00 250 00 0 00 Available Balance 24 000 00 11 000 00 16 000 00 1 750 00 5 000 00 1 000 00 Co o Commitments 58 750 00 Press Key Dup Record for Grant Detail Transactions Record 1 6 Novell GroupWi fam 2 windows Ex v C Grants User Ma Internet Exp 7 woa Oy S Grants User Manual 121008 4 23 2010 Page 11 of 22 User Manual Banner Grants Module Note that the grant information is now displayed using the Sponsor s account code format The example below illustrates the grant code translation functionality provided by Banner Any number of Sponsor code structures can be converted using this utility Grant Total Salaries and Wages 6002 Academic 15 000 15 000 6102 EAP 10 000 10 000 6202 COT 5 000
3. Click desired data column titles headers to display Each item checked will create a column of data KR UC N HL select the Operating Ledger Data columns to display on the report V Adopted Budget Year to Date V Budget Adjustment iv Encumbrances M Adjusted Budget M Reservations Quick Tip The Finance Self Service Manual Temporary Budget Commitments is a great reference Accounted Budget Available Balance Save Query as Shared 5 Click Continue button 6 Supply the following information Fiscal year Fiscal period Comparison Fiscal year Comparison Fiscal period Commitment Type M Chart of u NEN E Accounts __ __ Grant Code m C Include Revenue Accounts C Shared 7 Click Submit Query button Grants User Manual 121008 4 23 2010 Page 21 of 22 User Manual Banner Grants Module 8 View results Select a link in the Query Results list to retrieve detail information for the specific item chosen Select one of the Download options to download Budget Query data to a Microsoft Excel spreadsheet Calculate user defined columns for the query by making selections from the Compute Additional Columns pull down lists Report Parameters Grant Inception to Date Report By Account Period Ending Jun 30 2005 As of Jun 28 2005 Chart of Accounts G Grand valley State University Commitment Type All Fund All Program All Organization All Activity All Account All Locatio
4. Grants User Manual 121008 4 23 2010 Page 7 of 22 User Manual Banner Grants Module Grant Queries INB Forms FRIGITD is the Grant Inception to Date Report form f Oracle Developer Forms Runtime Web File Edit Options Black Item Record Query Tools Window T Chart of Accounts Grant Grant Year Index Fund Fm Organization Fund Summary Program Activity Location Hierarchy C3 i z Quick Tip Account Type 7j Account 0 Account Summary By Sponsor Account Date From MM Y Date To MM Y Y Include Revenue Accounts This form can also be opened via the Direct Access menu Activity by typing FRIGITD and pressing the Enter key on the keyboard a TABEEEEEEEETER LAB J THT JU JU TU 30 JD JD JU JU JU 0 CJL TU CJL Tl Enter the Grant Code to view LIST is available CQUERY for Grant Title Search Form Record 1H l 08 2 Q I fers T fm L Banner Finan ij Grants User Ma 2 Internet Exp Grants User Manual 121008 4 23 2010 Page 8 of 22 User Manual FRIGITD Grant Inception to Date Report Banner Grants Module 1 To check a Grant account balance type the Grant code in the Grant code field in the Key Information Block To perform a Code Look up simply click on the Search box and select the List of Grant Codes option 2 Oracle Developer Forms Runtime Web Fille Edit Options Block
5. Fund zo8402 7 Organization OU Activity C Y so Account 31 Date To MM YY Grant Year CO Fund Summary Chart of Accounts Grant Index Program Location Hierarchy Account Summary By Sponsor Account C Include Revenue Accounts NOTE Zero balance lines generally et Account Type Adjusted Budget Activity Commitments Available Balance E Supplies Student Wages Regular ag Supplies Bool amp Periodicals Brochu E Food servie E Licenses Permits F es a Services ContractuA Services ea 621 38 56 50 48 00 an 361 38 56 50 48 00 200 00 have detail transactions don t forget to look E Travel In State E Miscellaneous Expense a Indirect Costs 585 88 0 00 0 00 LUTE IEE Novell GroupWis fim 2 Windows Ex Ly 2MicosoftOf S 7 4 Sw RY ee Intenet Exp 7 Rollback to the previous block to perform this query with another option 8 Select the By Sponsor Account option and then Next Block to view the grant information using the Sponsor s account codes m Oracle Developer Forms Runtime Web File Edit Options Block Item Record Query Tools Window Help A Bm TI a tril o1 Za Grant Inception to Date FRIGITD 7 0 Test am Chart of Accounts Grant Grant Year C Index Program Account Type Fund
6. A E Press Key Dup Item for Document Query Forms Count Query for Encumbrance Detail Record 1 2 08C Internetex v E LY 5 start 12 r L Banner Fina aj Grants User Ma Quick Tip 5 Novell GroupWi Banner Grants Module Quick Tip See Commonly Encountered Rule Codes for definitions For additional detail select the options menu or follow the prompts in the Auto Hint Status Line for other navigation messages Note that indirect costs will continue to be posted at month end based on the grant budget parameters established in the grant set up process by the Grant Accountant When you receive an award notice for a new grant what are your next steps Let s review the New Grant Setup process next Grants User Manual 121008 4 23 2010 Page 14 of 22 User Manual Banner Grants Module NEW GRANT POST AWARD PROCESS To acquire a Fund Code for a new Grant the Director of Grants Development amp Administration will assist with the initiation of the Request A New Fund RANF process She will work with the PI and Office Assistant in completing the RANF and gathering the required documentation The RANF must be submitted with The Official award notice Final grant budget Final grant agreement Grant proposal The RANF with the accompanying documents next need to be signed by the Dean and Provost The Provost office sends the packet to Chris DeMull Controller s Assistant for proc
7. General Menu GUAGMNU 7 0 FINT Monday June 06 2005 mx Welcome MCCONOCH Products Menu Site Map Help Center EE Direct My Banner Access SCT Banner My Links Student Object Search Change Banner Password Financial Check Banner Message Personal Link 1 Human Resources Financial Aid General Personal Link 2 Banner XtenderSolutions Personal Link 3 Personal Link 4 Hierarchical Tree Bree inks Menu Structure Barsnnsi nied My Institution Banner Broadcast Messages ZI 4 Auto Hint Enter the object name press CQUERY for messages LIST for listing Status Line Record 1 1 2s lt oSC a Start E O 4 Novell GroupWi fm 2 Windows Ex 42 MicosoftWord 2InternetExp Sole mb vo 1 41PM Main Menu Sections Offers a variety of selections for navigating within SCT Banner Allows direct access to forms jobs menus Object Search Access a form or job if you know part of its name description or type Toolbar oet of icons that represent shortcuts for performing common functions Hierarchical Tree When accessing Forms from the Main Menu they are displayed as a hierarchy Steps Menu which expand and collapse content by clicking on the plus and minus signs Structure Auto Hint Status Line Briefly describes the field where the cursor is located explains the purpose of the field what can be done next or how to move to another window or form
8. Human Resources HRS Procedures _J Financial Aid RESOURCE C General GENERAL C Banner XtenderSolutions BXS L Click Folder My Banner 2 Click Organize My Banner Procedures Cont There are different ways to load information into the right hand column which becomes your My Banner menu Choices are e Type form name directly into the Object Box e Locate the form name on the left hand side You can perform a query to do this Then click large yellow arrow to select one by one or the double arrows to select all queried items Oracle Developer Forms Runtime Web PEE File Edit Options Block Item Record Query Tools Window Help ES w E rox 9 m XE EESGIG IG Ix xpI r1 Ix Za My Banner Maintenance GUAPMNU 7 0 FINT 1777 ad od ad ad rir Ur he od ut cd Ld Mud ad ad add dod ded ed ud ded Ud d ud ere Wee ar e rd ud eR od dd ud ad Re E ie ki at ce LINDBERB s Personal Menu Type FORM S Object Description FriacTH aeceuntHierarchy Query TFADETL Account Detail FTmcoas Chart of Account Code Maintenance Object Description rsaioss 1098 7 Tax Information J Frerrve 1099 Income Type Code Maintenance FAa1099 1099 Reporting Foaiogs 1099 misc Magnetic Tape Transmitter D pxaio99 1099 R 2 Prv1os9 1099 R Distribution Code validation Se RNAOVOL 2000 2001 Applicant Override 5 RNRGLOL 2000 2001 INAS Global Policy Options Ru RNIMSO1 2000 2001 Misc
9. ctor Vos xus ore Seed O FRIGTRD Grant Detail Information ccc cee vec vue can can cue cee eee eee cus emm hn cen nen ne nen nee ne enn en es seed PGITBAL General Ledger Trial DOlGHOR unions veeintesn hatt rte 6M Sera EE aU ESR AY Abos A Eius atoxaced O FGIGLAC Genera Ledgeer CUVID ieeesee ute wupreu tabuar a a sp ad ei 6D i a a A CREATING A PERSONAL MENU i550 eee eo SEES ea a Eo Sra eS RAP EORRENVENTERRVS SE STERNE QRA P ERU A ERUN S PUO UE SEX URS ESPERE RO tad PE ai 18 GRANT QUERIES SELF SERVICE iie bos soya ae EP EY ER MER EMNE aE EREEFCE CK KERSA E PREREE SE PEMIP E AGERE ME 19 Grants User Manual 121008 4 23 2010 Page 2 of 22 User Manual Banner Grants Module Objectives This guide is designed for Grand Valley State University employees that work frequently with grants to enable them to access and navigate within the Internet Native Banner system and learn the basic query and reporting functions for grants Upon completion employees will be able to obtain information regarding budgets revenues expenditures commitments and available balances within their grants and other areas of fiscal responsibility What is Banner Banner is a web based software application developed specifically for higher education institutions by a company called SunGard SCT Banner provides an online environment that will allow GVSU to perform computing functions in a highly efficient manner as all data will now be totally integrated
10. 00 00 Employee Fringe Benefits 11 000 00 Student Wages Regular 5 000 00 supplies Department Defined 2 000 00 Travel In State 1 000 00 Indirect Casts 15 600 00 Indirect Costs Waived 2 800 00 0 00 0 00 oo 250 00 0 00 0 00 0 00 5 000 00 11 000 00 5 000 00 1 750 00 1 000 00 2 800 00 9 800 00 determine whether download capabilities apply to the form fr Mandatory Transfer In 9 800 00 bos e102 TE Tm pozo Frost Fert s72 foo oo 0 00 0 00 a0 aT ood 0 00 ooo 0 00 Press Key Dup Record for Grant Detail Transactions Record 1 10 Grants User Manual 6 15 05 doc Microsoft Word Novell Group Wi aw L Banner Fina E Grants User Ma InternetEx E B2 0 Activity reflects the inception to date balances based on the period of time entered in the Key Bock Date From Date To This is the only form in Banner INB that displays inception to date activity Additional details are provided through the Options Menu as shown below im Oracle Developer Forms Runtime Web File edic feae Block Item Record Query Tools Window Help Grant Detail Information FRIGTRD e t I Format Display Prefer
11. 5 000 6803 Student Wages 5 000 5 000 6610 Fringe Benefits 9 000 2 000 11 000 Total Personnel Costs 39 000 7 000 46 000 7010 Supplies 2 000 2 000 7081 Travel 1 000 1 000 7571 72 Indirect Cost 40 of S W amp F 15 600 2 800 18 400 Total 57 600 9 800 67 400 DIRECT Acad EAP amp Stdt wages 30 000 FRINGES 11 000 INDIRECT 18 400 SUPPLIES 2 000 SUPPORT COT wages 5 000 TRAVEL 1 000 Total 67 400 NOTE Selection of Banner account codes is very important to a successful display Only those Banner account codes that are mapped to sponsorship codes should be utilized to record financial activity Grants User Manual 121008 4 23 2010 Page 12 of 22 User Manual Banner Grants Module 9 Rollback to the previous block to perform the query without any option boxes selected 10 Click on Next block to view the Grant Inception to Date summary information below amp Oracle Developer Forms Runtime Web File Edit Options Block Item Record Query Tools Window Help Xem mI I amp II I a Grant Inception to Date FRIGITD 7 0 Test A777777 Chart of Accounts Grant Index 7 Fund IC Organization Location Account Account Summary Levels Date To MM YY 06 os Quick Tip Check the drop down Help menu to Program J Activity Adjusted Budget Activity EAP Other 10 000 00 Available Balance 10 000 00 Commitments 0 00 cot Full time Technical 5 0
12. Cumulative Amount Status Date Project End Date 4 Enter a query press F8 to execute Ctrl to cancel Record 1 1 Enter Qu osc a Novell GroupWi C Grants User Ma Grants User Manual 121008 4 23 2010 Quick Tip To narrow a query type the part of the code or the part of the title you remember in the appropriate field and then use the wildcard search functions REMEMBER search fields are case sensitive Page 9 of 22 User Manual Banner Grants Module 4 Find the grant code for DOI USGS Map Musk Quadrangles and double click on the grant code This will populate the grant code field on FRIGITD Oracle Developer Forms Runtime Web EDA File Edit Options Block Item Record Query Tools Window Help oO 7 BABB IE 11 IL 1169 i Quick Tip a Grant Inception To Date Form FRIGITD 7 0 FINT rr rrr r ree r eee e e eere e e eese e eee eee e Tm Chart of Accounts am Grant 208402 DOI USGS Map Musk Quadrangles Grant Year A num ber Index Fane eo OXN roanization O V Fund Summary of GSP Program Activity f C Locatjon Hierarchy Account Type Account Account Summary All Levels M By Sponsor Account options are Date From MM YY 07 00 Date Mf MM Y Y 06 05 Include Revenue Accounts available j with this Account Type Adjusted Budget Activity Commitnieqts Available Bala
13. Item Record Query Tools Window Help ea Grant Inception To Date Form FRIGITO 7 0 FIMT Chart of Accounts Grant Index Fund a ta Organization Program Activity a IJ Location Account Type Account ba Account Summary All La Date From PP wr Date To MM wy EHI aptioan Lis List of Grant Codes FRIGRNT Account Type Grant Title Search Form FRIKGHANT 2 Tab to the second field of the first line We will search for all grants from the Department of Interior DOI Remember that wildcards work here so type DOI and click on the Execute Query icon 3 All grant codes with DOI in the name will be displayed Oracle Developer Forms Runtime Web File Edit Options Block Item Record Query Tools Window Help QOD o8 i Ss d Xp DE GI GO Gh gs DO 3d wc za Grant Code Inquiry Form FRIGRNT 7 0 FINT Grant Principal Investigator ID Agency Cumulative Amount Maximum Amount Status Date Project End Date Current Amount Status Project Start Date Responsible Organization Sponsor ID Grant Principal Investigator ID Agency Cumulative Amount Maximum Amount Status Date Project End Date Current Amount Status Project Start Date Responsible Organization Sponsor ID Grant Principal Investigator ID Agency Current Amount Status Project Start Date Responsible Organization KH
14. Service Description Enter the URL or Banner object for the My Personal Link 1 link Default Value Your first personal link URL After making the selections you must Save Commit the changes F10 The changes do not appear until you log out amp log back into Banner User Value http banner app2 gvsu edu 9971 PROD twbkwbis P GenMenu name homepadge Description Enter the description for the My Personal Link 2 link Default Value Your second personal link description User Value GroupWWise Email Description Enter the URL or Banner object for the My Personal Link 2 link Default Value vour second personal link URL User Value 4 ELE SP ene acp Pape ale 4 ee epee VF EUR TFI MM A funr Enter user specific settings Record 5 13 ts Start Internet amp Grants Lu 4 Microsoft Novell Group W 2 WOH Iv osc Grants User Manual 121008 4 23 2010 Page 20 of 22 User Manual Banner Grants Module Grant Queries Self Service Budget Status by Account Query Budget Status by Account Query is another option to look up financial activity for a grant To complete a budget status by account query Click Budget Queries on the Finance Main Menu Choose Budget Status by Account from drop down menu Click Create Query button
15. User Manual Banner Grants Module GRANDVAILEY STATE UNIVERSITY WWW gvsu edu Grand Valley State University Banner Finance Grants Module This guide is designed to be used in conjunction with attendance in training classes provided by the Banner Finance Training Team Grants User Manual 121008 4 23 2010 Page 1 of 22 User Manual Banner Grants Module Table of Contents 71 3 3064 MH RT US NRI ee nee eee 3 WHAT IS BANNER ccscccsescssssssescssssssscssssssssssvscssecssssssvsessesssssssvecssesssssssvsssvesssssssveessesssssssvsessesssssssvsessesssesssvsessesssssssveceseessessveessecsseessees 3 WHAT IS INB GRANTS gn OC See ve ooo tttrrrreeeees 3 010 80708 10 2 1 or nn rT es ne PDO le ETR OE 4 LOGGING INTO FINANCE TNB visasinsesviocccseiainsvetien aiaia Aa aE beans a 6 INTERNET NATIVE BANNER MAIN MIEN sisiarsincvacndenscuscrcucncseasascenseneessnctdiseeiuieonnavarbarwvesddauneseesdeuebeanteneaes one 7 GRANT OUERIES INB FORMS siiccsicccicssecciurcsasenneonmnsseeioncdteadnrsarsesooneomssoeansecesstaewisoeqerenecseeunsansceeetemscsceeecads 8 FRIPSTG Grant Personnel Inquiry Form cccccccccsseccccccceeeeeeeee een eeeeee cece eens cece ee nnne essa annt essen annees ananas S FRIGITD Grant Inception to Date Report ccc cae cae can can can can cancun can cae can can can can can e sentences nen nen ene ened FRIGKNT Grant Code InqulEy FOV sais ssc cais cieinwniars eheu Raoul wes ke wb aise Mo xe Gaines aed Bun uan ast
16. and shared among different departments across the University Banner comes in two distinct options Internet Native Banner INB and Self Service Self Service is a more user friendly interface that allows a specific set of processes to be completed It is more intuitive and less intensive than that of INB however not all Banner processes can be completed with Self Service Either option can be used to review grant financial activity What is INB Grants The Research Accounting module of INB provides for tracking grants This module contains all of the accounting reporting and billing functions necessary for post award management Research Accounting module includes maintenance and tracking tools primarily used by researchers and research administrators These components provide for information tracking on key personnel funding agency contact and funding agency address This module also provides for creation of grant budgets indirect cost allocations F amp A and cost share calculations An electronic Grant Billing feature is also available that enables users to track grant expenditures billed and unbilled and payments received from sponsoring agencies This process will be implemented in latter 2006 Another feature to be implemented after Go Live is Event Tracking where electronic notification of reporting due dates will be provided Stay tuned Grants User Manual 121008 4 23 2010 Page 3 of 22 User Manual Banner Grants Modu
17. displayed below File Edit Options Block Item Record Query Tools Window Help a a rrr Chart fee Account Type Fund 28402 7 DOLUSGS Map Musk Quadrangles Fiscal Year fos Account Beginning Current Account Description Balance Balance c m m x 1010 3011 3013 Budgeted Revenue Contral 3021 3023 3051 Budgeted Expenditure Control Budgeted Change to Fund Balance D C PL t185 Grant Receivable other 00000 Pl gu b et eL PL 0o DL Lool DL 1 ie se am SJ am 0o ie Llom DL EE MEMM DE denotes amount is opposite of Normal Balance Total ALL ACCOUNTS B 0 mDoyoxxxxxxemrrmmms O OAOA Note that if more specialized query criteria are warranted enter a specific General Ledger account code such as accounts receivable and then proceed to the Next Block Quick Tip INB Form FGITBAL equates to the old FRS screen 18 Grants User Manual 121008 4 23 2010 Page 17 of 22 User Manual Banner Grants Module Additional details are provided through the options menu as shown below Black Item Record Query Tools wi A File Edit Slanina H Query General Ledger Activity Info FGIGLAC EH General EUH Display Preferences A x cE 421 IX By keeping the cursor in the Grant Receivable field and selecting Query General Ledger Activity Info FGIGLAC all transaction detail for the line selected will be displayed as shown below
18. ellaneous Results Inquiry RNANAGI 2000 2001 Need Analysis RNAVROL 2000 2001 Need Analysis Document Weri RMAPRO1 2000 2001 Need Analysis Processing RNASLOI 2000 2001 Student Loan Data After making the selections you must Save Commit amp V lal ly the changes F10 The changes do not appear until you log out amp log back into Banner RNasuor 2000 2001 Supplemental Need Analysis RNAOVO2 2001 2002 Applicant Override RNRGLOZ 2001 2002 INAS Global Policy Options Re RNIMsOz 2001 2002 Miscellaneous Results Inquiry RNANADZ 2001 2002 Meed Analysis RNAvROZ 2001 2002 Need Analysis Document Verr RNAPROZ 2001 2002 Need Analysis Processing READ102 2001 2002 Pell Disbursement Acknowled These arrows add delete by entire J group Enter Object Name List to Search Record 1 3 Items listed in this column become your My Banner options Grants User Manual 121008 4 23 2010 Page 19 of 22 User Manual Banner Grants Module Creating a Personal Link This feature allows you to create your own links on the main page Oracle Developer Forms Runtime Web PEE File Edit Options Block Item Record Query Tools Window Help BAGAMA AHI dig EIN MI I5iQG x z9 General Menu eld Next Record Wale Thursday June 09 2005 fatio Go To Welcome LINDBERB Products Menu Site Map Help Cen
19. ences F r P r F P F F P r F r F r P r F Chart of Accounts am Grant 207000 207000 Index mn Fund 207000 Program lo Activity nie Account Type Account Assume that transaction details are needed for the Indirect Cost account 7571 The row for that account must be highlighted now select the Transaction Detail Information line from the Options drop down menu The results are shown below Grants User Manual 121008 4 23 2010 Page 13 of 22 User Manual 5 Oracle Developer Forms Runtime Web File Edit Options Block Item Record Query Tools Window Help AADAM Billi L1 1G ta Grant Transaction Detail Forn FRIGTRD 7 0 Test e OA iei Index i l l gt a a o c 2 o o c N c c o uU o a c 3 gt z lt gt lt 2 I t j lt uc 2 o a c 3 D 2 Description na ae e BD 1 J 000017 208402 ORIG Grem amp aLudget Fund Organization Account Program Activity Location Commit Year Period Date From Amount 15 600 00 I TTA TTA TETERTHETTTELTT TUTTI TUUU A TAHE UUU VEA 18 000 00 Date To m O COCO D O O fuco foz Increase or Decrease f CX X XC X X X X XC 3X X X 3X AC X c 88 a q Aa E or ee ATE
20. essing a new Fund Code and creating the Grant file Once a Grant file is created and the Controller issues a notification memo the file then comes to the appropriate Grants Fund Accountant for further action and PI contact See the Award Notification flowchart below Quick Tip Follow this link to view and print the new RANF form http www qvsu edu busfin Click on Forms under the Popular Pages reference box and go to Miscellaneous Forms Grants User Manual 121008 4 23 2010 Page 15 of 22 User Manual Banner Grants Module Director of Grants Development amp Administration Starts RANF process Christine Chamberlain PI and or Ass t complete RANF sent to Dean for Additions Corrections signature Grant Award Letter Final Approved Grant Proposal Final Approved Grant Budget Grant Agreement Sent to Provost for Signature Sent to Controller s Office Chris DeMull for FOAP processing New FOAP assigned Award Memo iS prepared and distributed New Grant File Given to Grants Fund Accountant for PI Contact Grants User Manual 121008 4 23 2010 Page 16 of 22 User Manual Banner Grants Module FGITBAL General Ledger Trial Balance This form provides a statement of financial position for the grant and is useful for monitoring outstanding receivable activity 1 In the Key Block enter Fiscal Year amp Fund Code 2 Click on the Next Block icon to perform the query The results are
21. ic Fund by entering the Grant Code and then the specific Fund Code to view only that Fund s activity Again neither Organization Code nor Program Code is required to perform a grant query Budget Quick Query Query set up follows the same procedures as a Budget Status by Account Query including Inception to Date balances However the display provides no additional features such as drill down or Excel download capabilities Grants User Manual 121008 4 23 2010 Page 22 of 22
22. le Quick Review Chart of Accounts The Chart of Accounts is the numbering system used by Banner to capture financial transactions and facilitate retrieval of information and financial reporting The Chart of Accounts structure in Banner is composed of four elements FOA P Fund Organization Account Program FOAP Fund A fund is a six character code that identifies the source from which money is being drawn Each grant is assigned a unique fund number The first two digits reference the type of funding the third digit references the specific funding source and the remaining three digits are unique to each grant project Refer to the FOAP em Crosswalk A new naming convention has also been established All grant fund names begin with Tool Job Aid the original funding source then identify the pass through funder if applicable and for a quick then the unique grant reference For example a federal grant received from Michigan reference tool Department of Education would be named USDOED MDOE Grant project name Organization A five character code that identifies a unit of budgetary responsibility and or departments within an institution It is normally used to define WHO spends the money Examples of Organizations 40625 AWRI Annis Water Resources 57105 Accounting Office Grants User Manual 121008 4 23 2010 Page 4 of 22 User Manual Banner Grants Module Account Code A four character code that identifie
23. n All Grant 208402 DOI USGS Map Musk Quadrangles Query Results Account Account Title GYO5 PDO02 Adjusted Budget GYO5 PDO2 Year to Date GYO5 PDO2 Commitments GY05 PD02 Available Balance 6002 Faculty Tenure Track 15 000 00 6 000 00 0 00 9 000 00 6102 EAP Other 10 000 00 0 00 0 00 10 000 00 6202 COT Full time Technical 5 000 00 0 00 0 00 5 000 00 6610 Employee Fringe Benefits 11 000 00 0 00 0 00 11 000 00 6803 Student Wages Regular 5 000 00 0 00 0 00 5 000 00 7010 Supplies Department Defined 2 000 00 250 00 0 00 1 750 00 7081 Travel In State 1 000 00 0 00 0 00 1 000 00 7571 Indirect Costs 18 400 00 2 400 00 0 00 16 000 00 8101 Mandatory Transfer In 9 800 00 0 00 0 00 9 800 00 Report Total of all records 57 600 00 8 650 00 0 00 48 950 00 Download All Ledger Columns Download Selected Ledger Columns an am rt In this query only Grant Code 208402 was selected and resulting display is a financial consolidation of all funds associated with this grant code To look at the activity of a single fund component enter both the grant code and associated fund code for the query Neither Organization Code or Program Code is required to perform a grant query Other e Query function is available for look up of Grant Codes and Fund Codes e The Year to Date column will reflect Inception to Date balances e The Sponsor Account display feature is not available in Self Service For Multiple Funds in a Grant Code you can query a specif
24. nce form OL 1 LE C 5 Type in the Fund number in the Fund field 6 Click on the Next Block button to view the Fund summary Grant information Please Note User Security has been established such that most Users when proceeding to the next inquiry step on this Form will receive a reminder message as displayed below amp Oracle Developer Forms Runtime Web Seles File Edit Options Block Item Record Query Tools Window Help BY LI AFAR PT Bee EN ED x D eR RIO IX g Grant Inception to Date FRIGITD 7 0 FINT yi Chart of Accounts G f Grant Y DOl UsGs Map Musk Quadrangles Grant Tear Index ly Fund X Organization Fund Summary Program Activity Location b Hierarchy Account Type X Account X Account Summary All Levels j LIBy Sponsor Account Date From MM YY 07 00 Date To MM YY 07 05 Include Revenue Accounts Account Type Adjusted Budget Activity Commitments Available Balance FRM 40208 Form running in query anly mode Cannot change database fields Click OK in the message box to proceed with the query Grants User Manual 121008 4 23 2010 Page 10 of 22 User Manual Banner Grants Module amp Oracle Developer Forms Runtime Web Open FRIGITD File Edit Options Block Item Record Query Tools Help b y E BERR PTI ERR d B3 al E e xL D ET SS De LO TX a Grart Inception to Date FRIGITD 7 2 PROD 208402 7 DOI USGS Map Musk QuadrInactivt
25. s general ledger assets liabilities control fund balances and operating ledger accounts income expenditures transfers Revenue account codes identify the type of revenue received such as tuition or auxiliary sales revenue Expenditure account codes identify the type of expenditure such as salaries or supplies Examples of Accounts 1000 ASSETS 6000 SALARIES WAGES amp FRINGES 2000 LIABILITIES 7000 CSSM amp EQUIPMENT EXPENSES 5000 REVENUES 8000 MANDATORY NON MANDATORY XFR Program This is a three character code that identifies a function and enables the institution to establish a method of classifying transactions across an organization Program codes were designed to correlate to the Higher Education Institutional Data Inventory HEIDI reporting scheme Examples of Program Codes 100 Instruction 200 Research 300 Public Service 400 Academic Support 500 Student Services 600 Institutional Support 700 Operation and Maintenance of Physical Plant 800 Scholarships and Fellowships 900 Auxiliary Enterprises Grant Code Grant codes are used to combine all related Fund codes to one reference code If one fund code is established for a grant then the grant code will be the same as the fund code However some grants require more than one fund to manage the financial activity Some examples of grants requiring multiple fund codes are when r cash match or multiple budget periods are involved In the
26. se instances the Grant code is assigned the same code as the lead fund code number In summary multiple fund codes can be used for a single grant award but only one grant code can be assigned Grants User Manual 121008 4 23 2010 Page 5 of 22 User Manual Banner Grants Module Logging into Finance INB Finance Internet Native Banner INB is a web based program To use it open an Internet Browser and log into Finance INB Browsers include Microsoft Internet Explorer Netscape Navigator etc Open Internet Explorer Type http banner gvsu edu press enter Locate Internet Native Banner Click Internet Native Banner INB pop IT Quick Tip Banner INB logins are case sensitive The login screens may vary based on system access 5 Type User ID 6 Type Password leave Database field blank 7 Click Connect button 2 Oracle Developer Forms Runtime Web Username Password Database Novell GroupWi i MINA aa d aae AM Lu 2 Microsoft Word 2 Internet Exp 7 Grants User Manual 121008 4 23 2010 Page 6 of 22 User Manual Banner Grants Module Internet Native Banner Main Menu The Main Menu provides an overview of the menus forms and jobs in SCT Banner You can use the Main Menu to navigate through SCT Banner f Oracle Developer Forms Runtime Web SEE Menu Bar x File Edit Options Block Item Record Query Tools Window Help 1 3 NN BMENIBENEE Toolbar a
27. ter NN rn BG MM m p did Macau My Links Bl Account Hierarchy Query FTIACTH B Account Detail TFADETL Change Banner Password Bl Chart of Account Code Maintenance FTMCOAS Bl Organize My Banner GUAPMNU XSCT Banner C Student STUDENT Personal Link 2 _J Financial FINANCE C Human Resources HRS Procedures for Banner Self Service C Financial Aid RESOURCE Oe C General GENERAL C Banner XtenderSolutions BXS 1 Click on File 2 Click on Preference Check Banner Message Personal Link 1 Procedures Cont 3 Click on My Links 4 Under the first User Value type in the Title that will appear to the right of the screen 5 Under the 2 User Value type in the following URL http banner app2 gvsu edu 9971 PROD twbkwbis P GenMenu name homepage 6 Click F10 to save amp Oracle Developer Forms Runtime Web Open GUAUPRF File Edit Options Block ltem Record Query Tools Help BMA BARRIS IEEE ESIER IERI IIS IO X ra General User Preferences Maintenance GUAUPRF 7 2 PROD Display Options Directory Options My Links Menu Settings Description Enter the URL for the My Institution link Default Value http Awww sungardsct com User Value CN Description Enter the description for the My Personal Link 1 link Default Value Your first personal link description User Value Banner Self
Download Pdf Manuals
Related Search