The Monthly Task Summary (MTS) Report contains a summary and detail of actual current month expenditures for a task. This report, which includes six sections, provides expenditure details needed to determine the status of a task budget. It enables operating locations that own a project and task, and particularly Principal Investigators (PIs), to make decisions regarding task status and future expenditures. It is also used as backup documentation to support billings to sponsors. MTS Reports are available monthly as six individual reports (that is, sections), as described below.
MTS reports will not be produced for tasks associated with projects that have a project status of closed. Once the project status is changed to closed the MTS report will be produced for that month and the following two months.
Run this report as needed.
The following table describes the required and optional parameters to use to run the report:
Parameter |
Description |
||
Required Parameters |
|||
MTS Report Section |
Defaults to ALL, which will run all six sections of the MTS. Each section can be run individually by choosing from the list of values. |
||
Month End Date |
Defaults to the most recent available reporting month (for example, 28-FEB-01). A prior reporting period can be entered by choosing from the list of values. |
||
Location Code |
The number that identifies the operating location (e.g., 655). The users' sign-on responsibility determines what is allowed to be input. |
||
Project Number |
The number associated with the project. |
||
Optional Parameter |
|||
Task Number |
The number associated with the task. To generate reports for a specific task within a given project, type in a task number or select from the list of values. To generate reports for ALL tasks within a given project, leave this parameter field blank. |
||
The following table describes the report output:
Column Heading |
Description of Column |
MONTHLY TASK SUMMARY SECTION |
|
Category |
The Expenditure Category (that is, the resource group) |
Budget |
The Task Budget (grouped by Expenditure Category) |
Current Month Expenditures |
The Subtotals at Expenditure Category of current month's expenditures (that is, payments made) |
Cumulative Expended |
The total expended, subtotaled by Expenditure Category, from the task start date to the end of the current month |
Encumbered |
The total encumbered (that is, the outstanding commitments) by Expenditure Category, from the task start date to the end of the current month |
Committed |
The sum of the Cumulative Expended and Encumbered columns |
Uncommitted Balance |
The Budget column minus the Committed column |
Category |
The Expenditure Type (that is, the resource), subtotaled by Expenditure Category (that is, resource group). |
Budget |
Task Budget at Expenditure Type, subtotaled by Expenditure Category |
Current Month Expenditures |
The Expenditures (that is, the payments) made during the current month by Expenditure Type, subtotaled by Expenditure Category |
Cumulative Expended |
The total expended by Expenditure Type, subtotaled by Expenditure Category, from the task start date to the end of the current month |
Encumbered |
The total encumbered (that is, outstanding commitments) by Expenditure Type, subtotaled by Expenditure Category, from the task start date to the end of the current month |
Committed |
The sum of the Cumulative Expended and Encumbered columns |
Uncommitted Balance |
The budget column minus the committed column |
MONTHLY TASK TRANSACTION DETAIL SECTION |
|
Category |
By Expenditure Type, includes dates and details on transactions made during the current month, total monthly transactions, and totals by Expenditure Category |
Budget |
The task budget at the Expenditure Type, subtotaled by the Expenditure Category. Shows balance as of the end of the previous month and the balance to date |
Current Month Expenditures |
The adjustments and expenditures (that is, the payments) made during the current month |
Cumulative Expended |
The expended balance total as of the end of the previous month, the total expended (including current month expenditures) from the task start date to the end of the current month, subtotaled by Expenditure Category |
Encumbered |
The outstanding commitments total as of the end of the previous month, total monthly transactions, total encumbered by Expenditure Type, subtotaled by the Expenditure Category |
Uncommitted Balance |
The Budget column minus the sum of the Cumulative Expended and Encumbered columns by Expenditure Type, subtotaled by Expenditure Category |
MONTHLY TASK SUMMARY - OUTSTANDING SUPPLIER ENCUMBRANCES |
|
Category |
The Expenditure Type, subtotaled by the Expenditure Category |
PO Number |
The purchase order number or blanket release |
PO Date |
The date of the purchase order or blanket release |
Description |
The items on the purchase order or blanket release, as input into AP/PO |
Supplier |
The name of the vendor from the supplier file |
Encumbered |
The total encumbered by the purchase order or blanket release, totaled for all purchase orders and blanket releases entered in the current month |
Balance |
The balance of the encumbrance by the purchase order or blanket release (total encumbrance minus payments), totaled for all purchase orders and blanket releases entered in the current month |
MONTHLY TASK PAYROLL TRANSACTION DETAIL |
|
Last Name |
The last name of the employee or fellow |
First Name |
The first name of the employee or fellow |
MI |
The middle initial of the employee or fellow |
Distribution % |
The percentage of the person's total pay allocated to the task |
Emp/Fellow Pay |
The actual salary or stipend paid to the person in the pay period indicated |
Employee Fringe Benefits |
The actual fringe benefit expenditures (based on the burden schedule applied to salaries) charged to the task for the pay period |
Title |
The job title of the employee or fellow |
MONTHLY TASK SUMMARY - PAYROLL ENCUMBRANCES
|
|
Last Name |
The last name of the employee or fellow |
First Name |
The first name of the employee or fellow |
MI |
The middle initial of the employee or fellow |
Labor Schedule End Date |
The labor schedule end date associated with the salary encumbrance distribution for this specific line of information. |
Labor Schedule Percent |
The labor schedule percentage associated with the salary encumbrance distribution for this specific line of information. |
Emp/Fellow Pay |
The amount encumbered for salary or stipend payments, based on labor schedule or task termination date, whichever is earlier.
|
Employee Fringe Benefits |
The amount encumbered for fringe benefits, based on burden schedule applied to salaries. |
Pay Shortage |
The amount of salary encumbrance that could not be posted to Grants because sufficient funds were not available for this specific line of information. |
FB Shortage |
The amount of fringe benefit encumbrance that could not be posted to Grants because sufficient funds were not available for this specific line of information. |
Pay Exception |
The amount of salary encumbrance that could not be posted to Grants because of exception reason for this specific line of information. |
FB Exception |
The amount of fringe benefit encumbrance that could not be posted to Grants because of exception reason for this specific line of information. |
Title |
The job title of the employee or fellow |
The MTS report, including all of its individual sections, is available to be viewed and printed by operating locations as an RFCUST standard report in the Oracle Applications.
Effective Date: 3/14/2007 8:51:01 AM