PI Funds Available & Project Detail Reports Session 19

1. PI Funds Available & Project Detail Reports Session 19 • To print: • Right click • Choose “Print” • Change option “Print What?” from “slides” to “note pages” • Click ok PI_Funds Available Report and PI_Project Detail Reports

2. Four reports inTwo Workbooks • PI Funds Available Report Shows how expenses are tracking to budget and the remaining funds available on the grant/contract. • PI Project Detail Reports • PI Expenditure Detail Report Shows detailed grant/contract expenses for the month. • PI Planned Expense Report Shows details of future planned expenditures for the grant/contract. • PI Labor Schedule Report Shows the % of effort of current and future personnel scheduled to be paid on the grant/contract.

3. Common Report Parameters

4. Report Header Page details reflect unique project/award combination. Project PI Name Sponsoring Agency related Information Project Period Award PI Name FiscalContact Name Award related Information

5. Reports simplified Budget categories created to facilitate rolling up budget, expenses and commitments to a level more closely aligned with the way the PI Budgets.

6. A C D = A-C E F = A-C-E B Major Sub Totals PURPOSE: This report is designed to provide the project’s funded Budget Balance Available: It shows BOTH: 1) Budget balance after expenses to-date, AND 2) Budget balance afterexpenses to-dateand scheduled future planned expenses. Column F’s ‘Grand Total’ reflects your remaining funded Budget Balance Available (including both Direct and F&A/Indirect costs). See major Sub-totals for a breakdown of available Direct and F&A costs. Denotes which budget categories are subject to F&A and which aren’t.

7. Reviewer and PI Signature Lines on PI Funds Available Report After review of the period expenditure detail report and this summary report, to the best of my knowledge all costs charged to this project are appropriate and salary and wages charged are in relation to work performed on this project. Where required, corrections have been or will be requested to be made in the Integrated System. PI Signature: ____________________Date:__________ I have reviewed current month expenditures for accuracy and sufficient source documentation in accordance with University procedure 1-4. Reviewer: __________Date:__________ Reference:Procedure 1-4A

8. PI Funds Available report output can be restricted based on award status.

9. Purpose: This report shows detailed expenditures within a budget category for PI review and approval of the appropriateness of actual costs. Fiscal administrators must still use the original FM_Expenditure Detail report to review expenses as per University finance procedure 1-4.

10. Purchase Order Line Description can be omitted if desired

11. Purpose: This report is designed to reflect known future planned expenses for the grant/contract. Future expenses are list by Budget Categories.

12. Purchase Order Line Description and Oracle Manual Encumbrances can be shown or omitted as desired.

13. Purpose: This report shows the effort percentage of present and future personnel that are scheduled to be paid by the grant/contract. Note: Hourly wage employees are not automatically encumbered and thus will not show on this report unless a manual encumbrance was created.

14. Questions