The Research Foundation (RF) developed the customized Grant Expenditure Export report to provide a version of the Grant Sum that could be exported easily to Excel to meet the reporting needs of various sponsors by giving the capability to manipulate the data to meet the sponsor's needs. The RF Grant Expenditure Export Report does not contain header information and only displays the following required columns for sponsor reporting: Expenditure Type, Employee/Supplier Name, Expenditure Item Date, AP Invoice Number, AP Invoice Item Description/Employee Title, Purchase Order Number, Purchase Order Line Description, Check Number, Check Paid Date, and Expended/Refund Amount. It is used to provide the detailed backup documentation required by sponsors for financial and/or invoicing reports.
Run this report as needed.
People with the following responsibilities are able to generate this report:
The following table describes the required and optional parameters to use to run the report:
Parameters |
Description |
||
Required Parameters |
|||
Project Number |
The Oracle project number (Required for Project and Task level Reports) |
||
Award Number |
The Oracle award number (Required for Award and Task Level Reports. Optional for Project Level Report) |
||
Task Number |
The Oracle task number (Required for Task Level Report) |
||
Starting Period (MON-YYYY) |
The month and the year of the data that will be reported from
Example: MAY-2002 |
||
Ending Period |
The month and the year of the data that will be report to. (e.g. May-2002) To report more than one month, change this date to the last month to be reported (e.g., JUN-2002) |
Step |
Action |
1 |
From the applicable responsibility in the Navigator window, select Processes and Reports > Submit Processes and Requests to go to the Submit a New Request form. |
2 |
Select Single Request. |
3 |
Click OK to go to the Submit Request form. |
4 |
Complete the following field: Name (Title of the report to be run. Select from the List of Values.) |
5 |
The Parameters form will be displayed if you select a request that requires parameter values. As required, enter the parameters. |
6 |
Click OK to return to the Submit Request form. |
7 |
Click Completion Options to return the Upon Completion Options form. Change the Format to Excel (Select from the List of Values). |
8 |
Click OK to go to the Submit Request form. |
9 |
Click Submit to go to the Requests form. Submitted requests are queued and run in the order in which they are received. Your current request may appear in a list of all of your requests in the Requests form. |
10 |
Click Refresh Data until the Phase field displays Completed.
|
11 |
Click View Output. You will then be prompted to either save or open the report in excel. |
12 |
You have successfully exported the data into Excel. To remove the blank lines select the whole spreadsheet and from the menu bar select Data > Sort and select the column to sort by and the blank lines will be gone. You can now adjust and manipulate the data. Some column widths may need to be increased for the data to be fully displayed. Select File > Save As to name the file and save it with the spreadsheet extension. |
The following table describes the report output:
Column Heading |
Description of Column |
Award Number |
This displays only on the Project level as column 1. |
Project Number |
This displays only on the Award level as column 1. |
Task Number |
This displays as column 2 on the Award Level and on the Project Level. |
Expenditure Type |
Expenditure Category that was charged. |
Employee and/or Supplier Name |
Expenditure description of the charge. For Salaries, this column displays the name of the person paid. For Other Than Personal Services (OTPS), this column displays the vendor and/or person paid. |
Expenditure Item Date |
For OTPS, this column displays the date the Accounts Payable invoice was entered. |
AP Invoice Number |
Oracle Accounts Payable invoice number assigned to item for OTPS. |
AP Invoice Date |
Oracle Accounts Payable invoice date from the header of the AP invoice. |
AP Invoice Description and/or Employee Title |
For Salaries, this column displays the title of the person paid. For OTPS, this column displays the accounts payable invoice description field from the AP invoice header. |
Purchase Order Number |
Oracle Purchase Order number assigned to the item. |
Purchase Order Line Description |
The description of the item assigned in the Oracle Purchase Order Line Description field. |
Check Number |
Individual check numbers for each OTPS item. |
Check Paid Date |
For Salaries, this column displays the payroll period. For OTPS, this column displays the Individual check dates for each item. |
Expended/Refund Amount |
Amount of the expenditure item. A negative value displays for adjustments and category refunds. |
Effective Date: 2/5/2009 10:39:40 AM