Using SCT Banner Finance / Research Accounting / Chapter 25 / 5.0
Contents
1. FRR134B Standard 1034 Billing Form Prints a bill in the standard 1034 format To run this bill Oracle Reports must be installed on your computer This bill will not run from a web enabled form FRR269R Standard 269 Report Form Prints grant billing information in the standard 269 format To run this report Oracle Reports must be installed on your computer This report will not run from a web enabled form SCT Banner Release 5 0 February 2001 Using SCT Banner Finance Confidential February 2001 Confidential FRR270B FRR272B FRR272R FRRABUD FRRBDEX FRRBEXC FRRBUDG FRRCNSF FRRCONV FRREVNG FRREVNP FRRFEXC FRRGBFY FRRGENB Chapter 25 Research Accounting Standard 270 Billing Form Prints a bill in the standard 270 format To run this bill Oracle Reports must be installed on your computer This bill will not run from a web enabled form Standard 272 Billing Form Prints a bill in the standard 272 format To run this bill Oracle Reports must be installed on your computer This bill will not run from a web enabled form Standard 272 Report Form Prints grant billing information in the standard 272 format To run this report Oracle Reports must be installed on your computer This report will not run from a web enabled form Agency Budget Report Prints a list of budget activity for grants received from the specified sponsoring agency Billing Detail Exception Report Prints a list of all docum2. reflect the cost or debit side of the cost share calculations on the unrestricted fund SCT Banner Release 5 0 Using SCT Banner Finance 25 5 Chapter 25 Research Accounting FRASYSC Research Accounting System Control Form Enables you to create and maintain system control records that store general billing information about grants such as payee name address and other system level defaults FTMBECL Billing Exclusion Maintenance Form Enables you to create and define exclusion codes that automatically restrict billing and place non allowable accounts on hold FTMBFRM Grant Billing Format Form Enables you to define existing format codes that customize bills and reports FINRESVAL Research Accounting Table Validation Menu Provides access to all of the Research Accounting validation forms Access this menu from the Research Accounting Table Maintenance Menu FINRESMAINT FRVBASI Basis Code Validation Form Provides a list of defined basis codes for query purposes FRVCFDA Catalog of Federal Domestic Assistance Codes Form Enables you to view and define Federal Domestic Assistance Program Codes These codes are directly related to federal proposals or grants FRVEVNT Event Code Validation Form Provides a list of defined event codes for query purposes FRVINDA Indirect Cost Charge Code Validation Form Enables you to view or select Indirect Cost Charge codes This form is used for query and selection only FRVINDD Indirect Co
3. Banner Finance 25 13 Chapter 25 Research Accounting Research Accounting Processes The following processes are available in the Research Accounting module FGRGRBD Grant Rebuild Process Enables you to rebuild the grant ledger from the Transaction Detail Table FGBTRND FRRBILL Research Accounting Billing Process Enables you to generate billing amounts and post transactions to the ledgers FRRBREV Research Accounting Billing Reversal Process Enables you to reverse or undo bills that you ran in Update mode Execution Mode U in the Research Accounting Billing Process FRRBILL FRRGRNT Deferred Grant Process Enables you to define when you want Banner to perform indirect cost F amp A cost share and revenue recognition calculations FRRGRPT Research Accounting Report Process Enables you to generate data for Grant Billing reports TRRAPPL Application of Payment Process Enables you to apply payments to charges by grant TRRUNAP Unapplication of Payments Process Enables you to reverse or undo payments that have been applied to grant charges Refer to Chapter 26 Reports and Processes for descriptions parameter listings and sample output Research Accounting Reports 25 14 The following reports are available in the Research Accounting module FGRGLEX Grant Ledger Exception Report Prints a list of all transactions that exist in the Transaction Detail Table FGBTRND but not the Grant Ledger FRRGRNL
4. Banner Finance 25 15 Chapter 25 Research Accounting 25 16 FRRGENR Generic Report Form Prints grant billing information in a format customized by your institution on the Billing Report Format Maintenance Form FTMBFRM To run this report Oracle Reports must be installed on your computer This report will not run from a web enabled form FRIGITD Grant Inception to Date Report Prints grant account activity information from the General Ledger FRRINDC Grant Expenditures Report Prints the total expenditures for the specified grant s by FOAPAL FRRINVS Grant Billing Preview Report Prints a list of all grants that will be selected by the Research Accounting Billing Process FRRBILL when it s run on the specified date TRRAGES Grant Aging Analysis Report Prints information about the aging of billed receivables TRRCOLL Collections Report Prints information about collection efforts that have been entered on the Grant Billing Collections Form TRACOLL TRRRCON Grant Reconciliation Report Reconciles data between the Accounts Receivable module and the Finance module for Grant Billing transactions only TRRUNPL Unapplied Payments Listing Prints a list of all payments that have not been applied to charges and their corresponding fund codes Refer to Chapter 26 Reports and Processes for descriptions parameter listings and sample output SCT Banner Release 5 0 February 2001 Using SCT Banner Finance Confidential
5. Billing 1034 Form Enables you to view and print bills in the standard 1034 format You can also use this form to enter bills from your legacy system Standard Report 269 Form Enables you to view and print reports in the standard 269 format You can also use this form to enter reports from your legacy system Standard Billing 270 Form Enables you to view and print bills in the standard 270 format You can also use this form to enter bills from your legacy system Standard Billing 272 Form Enables you to view and print bills in the standard 272 format You can also use this form to enter bills from your legacy system Standard Report 272 Form Enables you to view and print reports in the standard 272 format You can also use this form to enter reports from your legacy system Generic Bill Form Enables you to view and print bills in a user defined format You can also use this form to enter bills from your legacy system SCT Banner Release 5 0 Using SCT Banner Finance 25 11 Chapter 25 Research Accounting 25 12 FRAGENR FRABRUN FINRESGRBILLQ Generic Report Form Enables you to view and print reports in a user defined format You can also use this form to enter reports from your legacy system Run Standard Bills and Reports Form Enables you to print bills and reports You can also use this form to enter bills and reports from your legacy system Research Accounting Grant Billing Query Menu Provides access to
6. Chapter 25 RESEARCH ACCOUNTING reet EE 25 3 Research Accounting Master Elements eege e 25 3 Menu Navigation Table issn ates tetas ecassstatastont seem sta nassau eneoeM ae reels 25 4 Res ateh Acco nting OMG ia te citiahtetcrsteres adno acta EE E andere 25 13 Research eet 25 14 Research eet Eer 25 14 25 1 Chapter 25 Research Accounting This page intentionally left blank SCT Banner Release 5 0 February 2001 25 2 Using SCT Banner Finance Confidential Introduction Chapter 25 Research Accounting The Research Accounting module enables you to track grants from the time you submit a proposal to a funding agency through the award and disbursement process This module also enables you to perform accounting reporting and billing functions after you receive a grant award SCT delivered the Research Accounting module using a three phase approach With Release 2 1 11 SCT delivered the Proposals enhancement The Grants enhancement followed in Release 3 1 Clients received the final phase Grant Billing in Release 4 0 Proposals and Grants are maintenance and tracking tools primarily used by researchers and research administrators These components enable you to set up proposals and or grants that include information such as key personnel funding agency contact and funding agency address You can also create proposal and or grant budgets and perform indirect cost F amp A and cost share calculations Grant Billing enables us
7. al February 2001 Confidential FRVEVNT FRVEGRP FRAEVPA FRAEVNP Chapter 25 Research Accounting Event Code Validation Form Enables you to view add change or delete an event Event Group Validation Form Enables you to group together defined event codes Proposal Events Assignment Form Enables you to assign defined event codes and event group codes to a proposal Proposal Event Action Form Enables you to monitor events associated with a proposal Access this menu from the Research Accounting Menu FINRESEARCH FRAGRNT FRABUDG FOAETXT FRMFUND FINGRNTQUERY FINGRNTEVENT Grant Maintenance Form Enables you to enter or update grant information This form is also used to maintain information such as key personnel agency information and cost code information for indirect cost F amp A and cost share calculations on the grant Grant Budget Form Enables you to enter and track grant budgets This form supports budget iterations which may be developed for the entire length of the project or for each year within the project period Entity Text Entry Form Enables you to view add change or delete text associated with an event Research Accounting Fund Maintenance Form Enables you to associate indirect cost codes and cost share codes to a fund Grant Inquiry Menu Provides access to the query forms which allow you to retrieve grant information Grant Events Menu Provides access to the forms w
8. e If you know the seven letter name of the form you want to access you may use Direct Access to bypass the menus To use Direct Access enter the FINRESMAINT Research Accounting Table Maintenance Menu seven letter name of a form at Provides access to the maintenance and validation forms the Direct Access prompt Instructions for accessing menus are in Chapter 2 Using Banner of this manual FINRESPROP Research Accounting Proposal Menu Access this menu from the Finance System Menu FINANCE within the Research Accounting module Provides access to the forms needed to create maintain and query proposals and proposal budgets FINRESGRANT Research Accounting Grants Menu Provides access to the forms needed to create maintain and query grants and grant budgets FINRESGRBILL Research Accounting Grant Billing Menu Provides access to the forms needed to create maintain and query bills and reports SCT Banner Release 5 0 February 2001 25 4 Using SCT Banner Finance Confidential Chapter 25 Research Accounting FINRESARGRBIL Grant Billing Accounts Receivable Menu L Provides access to the forms needed to enter payments received from sponsoring agencies and apply those payments to grants Access this menu from the Research Accounting Menu FINRESEARCH FTMBASI FTMINDR FRHINDR FTMINDA FTMINDD FTMCSTR FIMCSTA FTMCSTD February 2001 Confidential Basis Definition Code Maintenance Form Enable
9. ents that are stored in the Transaction Detail Table FGBTRND but not the Billing Detail Table FRRBDET Billing Exception Report Prints a list of all grants that have exceptions associated with them Grant Budget Report Prints budget information including indirect cost F amp A and cost share amounts for a specific grant Canadian Standard Report Form Prints grant billing information in a format customized for Canadian institutions To run this report Oracle Reports must be installed on your computer This report will not run from a web enabled form Research Accounting Conversion Report Prints indirect cost F amp A and cost share data from the Grants module to facilitate your conversion to the Research Accounting module Grant Events Report Prints a list of events associated with a grant Proposal Events Report Prints a list of events associated with a proposal Fund Exception Report Prints a list of all grant funds that do not have information stored in the Accrual Acct and Revenue Acct fields on the Fund Code Maintenance Form FTMFUND Grant Budget Status Report Prints a list of grant activity within the specified fiscal year Generic Bill Form Prints bills in a format customized by your institution on the Billing Report Format Maintenance Form FIMBFRM To run this bill Oracle Reports must be installed on your computer This bill will not run from a web enabled form SCT Banner Release 5 0 Using SCT
10. enu from the Research Accounting Proposal Menu FINRESPROP FRIASTP FRIBDSP FRIBUDP FRIBUDT FRIEVNP FRIKPRO FRIPROP FRIPRST FRIPSTP Proposal Agency Inquiry Form Enables you to monitor proposal activity by agency Proposal Budget Distribution Inquiry Form Enables you to view proposal budget distributions Proposal Budget Codes Inquiry Form Enables you to view general information about proposal budgets Proposal Budget Totals Inquiry Form Enables you to perform an online query of summarized budget data by account number sponsor account number account title or account types for each proposal budget code FRIBUDT displays cost sharing and sponsor funded amounts information Proposal Events Inquiry Form Provides a list of proposal events for query purposes Proposal Title Search Form Enables you to search for a proposal by the words and or characters in the proposal s title This form queries both the long and the short title of a proposal but it only displays the 35 character short title Proposal Codes Inquiry Form Enables you to display a list of all proposal codes Proposal Status History Inquiry Form Enables you to view proposal status history information Proposal Personnel Inquiry Form Enables you to monitor proposal activity by Personnel ID Access this menu from the Research Accounting Proposal Menu FINRESPROP SCT Banner Release 5 0 February 2001 Using SCT Banner Finance Confidenti
11. ers to track grant expenditures billed and unbilled and payments received from sponsoring agencies It also enables you to generate bills and reports for sponsoring agencies in the standard formats for example 272 as well as in formats defined by your institution In addition you can use this component to process payments received from sponsoring agencies Research Accounting Master Elements February 2001 Confidential Several codes on the Proposal Maintenance Form are created through and validated against the System Data Maintenance Table FTVSDAT The following table depicts the field on the Proposal Maintenance Form FRAPROP and its cross reference to the values defined on this table You will see SCT Banner Release 5 0 Using SCT Banner Finance 25 3 Chapter 25 Research Accounting in the Optional 1 column that certain examples were created for your use These codes may be altered used as provided or deleted at your site to suit your needs Table 1 Form Field SDAT Emi Aedes Cade Opont Short Title Usage Code FRAPROP Status Code FRBPROP Status_Code A Awarded D Declined N New O Open R Re submitted S Submitted Proposal FRBPROP Proposal_Type A Agreement Type C Contract G Grant Category FRBPROP Category F Federal N Non Federal R Other Restricted Sub Category FRBPROP Sub_Category CORP Corporation FNDT Foundation FRGN Foreign Indicator FRRPRPI ID_Indicator 001 Project Director 002 Grant Analyst Menu Navigation Tabl
12. hich allow you to create and maintain grant events Access this menu from the Research Accounting Grants Menu FINRESGRANT FRIASTG Grant Agency Inquiry Form Enables you to monitor grant activity by agency SCT Banner Release 5 0 Using SCT Banner Finance 25 9 Chapter 25 Research Accounting FRIBDSG FRIBUDG FRIBUTG FRIEVNG FRIGITD FRIGRNT FRIGRST FRIGTRD FRIKGNT FRIMEMO FRIORGH FRIPSTG Grant Budget Distribution Inquiry Form Enables you to view grant budget distributions Grant Budget Codes Inquiry Form Enables you to view general information about grant budgets Grant Budget Totals Form Enables you to perform an online query of summarized budget data by account number sponsor account number account title or account types for each grant budget code FRIBUTG displays cost sharing and sponsor funded amounts information Grant Event Inquiry Form Provides a list of grant events for query purposes Grant Inception to Date Form Enables you to view account type information including adjusted budgets inception to date actual activity encumbrance and available balance amounts Grant Code Inquiry Form Enables you to display a list of all proposal codes Grant Status History Inquiry Form Enables you to view grant status history information Grant Transaction Detail Form Provides a list of transactions from the Transaction Detail Table for query purposes Grant Title Search Form Enab
13. imbursement requirements and were received from the same sponsoring agency Billing Format Validation Form Enables you to create view and query format codes Access this menu from the Research Accounting Menu FINRESEARCH FINPROPOSAL FINPROPQUERY FINPROPEVENT Proposal Maintenance Menu Provides access to the forms which allow you to create a proposal or enter budget iterations for a proposal Proposal Query Menu Provides access to the query forms which allow you to retrieve proposal information Proposal Events Menu Provides access to the forms which allow you to create and maintain proposal events Access this menu from the Research Accounting Proposal Menu FINRESPROP FRAPROP Proposal Maintenance Form Enables you to enter or update proposal information This form is also used to maintain information such as key personnel agency information and cost code information for indirect cost F amp A and cost share calculations on the proposal February 2001 SCT Banner Release 5 0 Confidential Using SCT Banner Finance 25 7 Chapter 25 Research Accounting 25 8 FRABUDP FOAETXT Proposal Budget Form Enables you to enter and track proposal budgets This form supports budget iterations which may be developed for the entire length of the project or for each year within the project period Entity Text Entry Form Enables you to view add change or delete text associated with an event Access this m
14. les you to search for a grant by the words and or characters in the grant s title This form queries both the long and the short title of a grant but it only displays the 35 character short title Grant Memo Ledger Inquiry Form Enables you to track the amount of lost overhead Grant Organization Inquiry Form Enables you to view grants by organization Grant Personnel Inquiry Form Enables you to monitor grant activity by Personnel ID Access this menu from the Research Accounting Grants Menu FINRESGRANT FRVEVNT 25 10 Event Code Validation Form Enables you to view add change or delete an event SCT Banner Release 5 0 February 2001 Using SCT Banner Finance Confidential FRVEGRP FRAEVGA FRAEVNG Chapter 25 Research Accounting Event Group Validation Form Enables you to group together defined event codes Grant Events Assignment Form Enables you to assign defined event codes and event group codes to a grant Grant Event Action Form Enables you to monitor events associated with a grant Access this menu from the Research Accounting Menu FINRESEARCH FRABDCN FRA134B FRA269R FRA270B FRA272B FRA272R FRAGENB February 2001 Confidential Research Accounting Unbilled Status Control Form Enables you to monitor unbilled grant expenditures and the associated grant overhead This form also enables you to change the status of an item from unbilled to hold or from hold to unbilled Standard
15. pply payments that have been applied incorrectly FINRESARGRB Grant Billing Accounts Receivable Query Menu 8 H Provides access to the query forms which allow you to retrieve payment information for grants FINRESARGBVA Grant Billing Accounts Receivable Validation Menu L Provides access to the form needed to view billing collection codes Access this menu from the Grant Billing Accounts Receivable Menu FINRESARGRBILL FRIAPPL Application of Payment History Inquiry Form Enables you to view information about payments that have been applied to charges FRIGSUM Research Accounting Grant Summary Review Form Enables you to view summary information about charges and payments associated with a grant or payment management system code FRIBILL Research Accounting Billing Inquiry Form Enables you to view billing information for a grant or payment management system code Access this menu from the Grant Billing Accounts Receivable Menu FINRESARGRBILL FRVCOLL Grant Billing Collections Validation Form Enables you to create and maintain collection codes Research Accounting Forms February 2001 Confidential Descriptions of Research Accounting forms appear in Banner online help Introductory information about online help is found in Chapter 2 Using Banner of this manual Note Documentation for the Detail Code Control Form TFADETC is available in the Accounts Receivable System User Manual SCT Banner Release 5 0 Using SCT
16. s you to define and establish the base for indirect cost F amp A and cost sharing calculations The basis may be linked to a proposal for calculations within the Proposal Budget Form FRABUDP Indirect Cost Rate Code Maintenance Form Enables you to define the indirect cost F amp A rate Indirect Cost Rate History Form Enables you to query a history of changes on indirect cost F amp A rates Indirect Cost Charge Code Maintenance Form Enables you to enter the accounts and percentages for overhead charge calculations Indirect Cost Charge Accounts represent the debit side of the posting transaction for indirect costs F amp A to the grant fund Indirect Cost Distribution Maintenance Form Enables you to enter the FOAPAL distribution for the recovery of indirect charges This form creates transactions used for the credit side of indirect costs F amp A in the ledgers All of the FOAPAL elements are defined on this form Cost Share Rate Code Maintenance Form Enables you to enter Cost Share Rate Codes and their related descriptions This form is also used to record the rate or lump sum amount for cost share calculations Cost Share Credit Code Maintenance Form Enables you to enter the accounts to which cost share amounts are to be credited or to enter a fund code that can be used as an alternate fund to track cost share activity Cost Share Distribution Maintenance Form Enables you to define the FOAPAL elements used to
17. st Distribution Code Validation Form Enables you to view or select Indirect Cost Distribution Codes This form is used for query and selection only FRVINDR Indirect Cost Rate Code Validation Form Enables you to view or select Indirect Cost Rate Codes This form is used for query and selection only FRVISAC Institution Sponsor Account Maintenance Form Enables you to cross reference Institution Account Codes and Institution Account Types to Sponsor Identified Account codes By allowing this cross reference reports and queries may be enhanced to view proposal budgets from an agency s point of reference SCT Banner Release 5 0 February 2001 25 6 Using SCT Banner Finance Confidential FRVLCLA FRVSACT FRVSDAT FRVBECL FRVPMSC FRVBFRM Chapter 25 Research Accounting Grants Labor Clearing Accounts Validation Form Enables you to create clearing accounts for labor and grant transactions Sponsor Account Code Maintenance Form Enables you to define and view Sponsor Account codes Research Accounting User Codes Validation Form Enables you to create user defined literals and attributes on the Proposal Maintenance Form FRAPROP and the Grant Maintenance Form FRAGRNT Billing Exclusion Validation Form Provides a list of defined exclusion codes for query purposes Payment Management System Code Maintenance Form Enables you to create and maintain payment management system codes that link together grants that have the same re
18. the query forms which allow you to retrieve grant billing information Access this menu from the Research Accounting Grant Billing Menu FINRESGRBILL FRIBDET FRI134B FRI272B FRIGENB FRIGENR FRI270B Research Accounting Billing Detail Inquiry Form Enables you to view billed expenditures unbilled expeditures and associated grant overhead throughout the billing cycle Standard Bill Inquiry 134B Form Enables you to view bills in the standard 1034 format Standard Bill Inquiry 272B Form Enables you to view bills in the standard 272 format Generic Inquiry Bill Form Enables you to view bills in a user defined format Generic Inquiry Report Form Enables you to view reports in a user defined format Standard Bill Inquiry 270B Form Enables you to view bills in the standard 270 format Access this menu from the Research Accounting Menu FINRESEARCH TFADETC FRAAREV FRACOLL Detail Code Control Form Enables you to establish detail codes to process bills for sponsoring agencies and payments from those agencies Research Accounting Payments Entry Form Enables you to enter payments received from sponsoring agencies Grant Billing Collections Form Enables you to track collection efforts for specific bills on a grant SCT Banner Release 5 0 February 2001 Using SCT Banner Finance Confidential Chapter 25 Research Accounting FRAUNAP Research Accounting Unapplication of Payments Form Enables you to una
Download Pdf Manuals
Related Search