Oracle Grants Management (GM) maintains detailed expenditures by award and Accounts Receivables (AR) maintains information on cash received by customer. The Research Foundation (RF) customized Grant Sum Report uses information from both of these modules to create a report of expended amounts and cash received over specified periods for a given award. It is used for account analysis and to provide detailed backup documentation to some sponsors. Generally, information is available following costing and/or cash application.
A summary is provided at the end of the report displaying: subtotals by expenditure type, total direct cost and indirect cost, and grand total cash and expenditures for time period selected.
This report is run as needed.
The following table describes the required and optional parameters to use to run the report:
RF Grant Sum Report (by Award) |
|
Required Parameters |
Input from List of Values (LOV) |
Award Number |
The Oracle number associated with the award
Example: 000000 |
Starting Period |
The month and the year, formatted MON-YYYY, of the data that will be reported
Example: JUL-2006 |
Ending Period |
Fills automatically with the same month as the Starting Period. To report more than one month, change this date, formatted MON-YYYY, to the last month to be reported
Example: JUN-2007 |
The following table describes the report output:
Column Heading |
Description of Column |
Expenditure Type |
The expenditure category that was charged. |
Description |
The description of the expenditure charge. For Salaries, this column displays the name of the person paid. For Other Than Personnel Services (OTPS), this column displays the vendor and/or person paid. |
Emp No |
This column displays the employee number (unique identifying number) of the person who has been paid. |
Item Date |
For Salaries, this column displays the payroll period. For OTPS, this column displays the Invoice Item Date that Accounts Payable/Purchasing (AP/PO) entered on the vendor invoice. For Fringe Benefit and F&A costs, this column displays the date burdened. |
Month Expended |
The month and year the item was charged (that is, costed) to the award and/or project. |
Check No. |
The number of the check. |
1099 Code |
An x displays if the 1099 code was checked on the OTPS item. |
Expended/Refund |
The amount of the expenditure item. A negative value displays for adjustments and category refunds. |
Cash/Trans In |
The cash received in the Cash line for that period. |
Effective Date: 3/14/2007 8:45:33 AM