University Controller's Office
Search
Banner Finance
 

Grant Reports

FACR Accumulated by Grant Fund

In this report, FACR (Facilities and Administrative Cost Recoveries) expenditures are shown for the current period (monthly) and fiscal year to date period. In Banner, these expenditures are reported in expenditure account 639997 and represent administrative overhead and other support costs associated with research grants. Other information provided in this report includes: department, sub-department, organization code, grant ID and title, G and C accountant and principal investigator. 

Parameters for the report include options for the fiscal year and fiscal period.  Hierarchy level parameters include: executive level (vice presidential level), senior management level, major budget unit, department or sub-department. Click here for sample report. pdf

 

G and C Grant Billing Drawdowns

G and C Grant Billing Drawdowns is a transaction detail report that identifies transactions that may not be allowable on certain grants.  Fiscal administrators should review the output to determine whether the charges are allowable with the terms of the grantor.  This report contains detailed information for each transaction including: document number, activity date, rule class and description, amount of transaction, G and C accountant, grant ID, fund and organization code.


Parameters for the report include options for fiscal year and a fiscal period range (starting fiscal period and ending fiscal period) by hierarchy level.  Hierarchy level includes department, sub-department or organization code.  Click here for sample report.pdf

 

Grants Budget and PTD Actual

Report shows grant budget and project-to-date actual expenses for direct and indirect cost. It shows project start and end dates, general grant information (including P.I.) and can be run for ARRA, non ARRA or all awards.

Parameters include fiscal year, fiscal period and hierarchy levels that include University executive level (vice presidential level), senior management level, major budget unit level, department or subdepartment level. Click here for sample report. pdf

 

Grant Deficit Report

Grant Deficit Report by grant ID and fund are reported by fiscal year and period (month).  By using the selected parameters, deficit balances can be shown by: fiscal administrator, principal investigator, G and C accountant, sub-department, department, major budget unit or senior management level.

Report fields provide information for G and C accountant, principal investigator, fiscal administrator, months in deficit, grant end date and sponsor.  Click here for sample report. pdf

 

Grant Expenditures Report

Grant Expenditures is a summary report for total expenditures by grant organization code. This report has selection criteria for fiscal year and fiscal period along with hierarchy selection by major budget unit, department and sub-department.

Expenditures are reported as total year to date expenditures for Stimulus and Non-Stimulus awards, total year to date direct cost and total year to date indirect cost. Direct cost does not include FACR (overhead or indirect costs). Indirect cost is the amount of FACR charged to the research grant. Other report fields include Grant ID, Grant and Grant Description. Click here for sample report. pdf

 

Grant ID Project Start and End Dates

Grant ID Project Start and End Dates offers project start and end dates by grant ID with fund balance (budget minus YTD activity for expenditures).  Parameters include: fiscal year and period, major budget unit, department, sub-department and fund status.  Report fields include: project start and end date, grant ID, principal investigator, G and C accountant, fund code, fund description, department, department description, sub-department and fund balance. Click here for sample report. pdf

 

Grants and Principal Investigators

This report identifies the principal investigator associated with a Grant ID.  Hierarchy selection includes major budget unit, department, or sub-department. The selection criteria includes results for grants that are active, inactive or both.


The report fields include: grant ID and title, G and C accountant, principal investigator, department, sub-department, fund indirect cost distribution code (distribution percentage indicator on grant fund), fund code and description. Click here for sample report. pdf

It should be noted that on this report, business users will only see fund codes for Grant IDs assigned to their department or major budget unit. They may not be able to see multi-disciplinary grants.

 

Grant ID Crosswalk

Grant ID Crosswalk provides information on what funds and organization codes are associated with each Grant ID. Parameters include: organization code, department, sub-department and grant status.
Report fields include: major budget unit, department, sub-department, grant ID and title, G and C accountant, fund type and description, fund, organization code and description. Click here for sample report. pdf

 

Indirect Cost Expense Report

The Indirect Cost Expense Report provides information on the automatic entries for indirect cost that are created in the Banner Finance System. This report provides detailed information for the associated grants and expenditures used for the calculation, as well as the organizations used to recover revenues. The report parameters include start and end dates and department or sub-department values. Please note that manual entries for indirect cost will not be reflected on this report. Click here for a sample report. pdf

 

Indirect Cost for New Grants

Indirect Cost for New Grants identifies indirect cost information associated with new grants. This report contains: grant ID, fund, G&C accountant, principal investigator, budget period end and start date. Indirect cost rate, basis, charge account code and distribute to code are included. Report parameters are budget period start date and hierarchy level options for MBU, department and subdepartment. Click here for a sample report. pdf

 

Indirect Cost Revenue Report

This report provides the revenue generated through indirect cost by grant ID. It does not include the expense detail. The report parameters include start and end dates and department or subdepartment values. Please note that manual entries for indirect cost will not be reflected on this report. Click here for a sample report. pdf

 

Responsible Organization Grant Monitoring Report with Labor

This report allows you to see the detail charges, including payroll, for all sub-accounts even if that sub-account is in another department. A sample of the report is attached. The "V" numbers and employee names have been removed from the sample, but they will display when you run the report. The report parameters are responsible org code, fiscal year, transaction start and end date and whether to display in Excel or HTML. Click here for sample report. pdf

 

Transaction Detail- Grants

This report is designed to provide detail transaction information for grants in a given fiscal period for all organizations. Transactions are presented by grant ID description, amounts, associated rule class and document information, related organization code, organization description, and account and account description. Business users may run this report at three different organization levels: department, sub-department, and organization code.

Fiscal year, fiscal period(s), preferred organization level and range for associated accounts (to see whether the transaction is associated with an expenditure, revenue or personnel costs accounts) are necessary parameters to run this report. Click here for sample report. pdf