Faculty Portfolio Reports and Projections

Faculty Portfolio is a financial projection and reporting tool designed to aid in the management of a faculty member’s contract, grants, gifts, start-up, retention, and other discretionary funding.

The set of Faculty Portfolio Reports include:

MyPortfolio Report

The MyPortfolio Report is designed to support faculty in reviewing their projects.  See the Quick Reference Guide for Faculty for a brief orientation to the MyPortfolio Report. This report displays summary level General Ledger (GL) and projections data for a single Faculty or Principal Investigator’s (PI) portfolio of Projects. Using the MyPortfolio Report (job aid) you can:

  • View an entire portfolio for a single faculty member in one report
    • Combines GL data and projections entered in faculty portfolio projections
    • Displays sponsored balances and non-sponsored net position
  • View percent spent vs. percent time elapsed-to-date in a graphic
  • View Project details such as Nickname and Activity Period begin and end dates
  • Limit data by PI Type (Award/Parent PI, Project PI, and/or Lab Owner)
  • Include or exclude a burn rate graphic, inactive Project-Activity Periods, pending Project-Activity Periods, and PI Details

Award/Parent Summary Report

The Award/Parent Summary Report displays summary level General Ledger (GL) and projections data for Project Award/Parent IDs. Using the Award/Parent Summary Report (job aid) you can:

  • View an Award including all children under an Award/Parent ID
  • View Sponsored Balances with Budget, Expenses, and Other Changes
  • View Non-Sponsored Current Net Position with Beginning Net Position, Revenues, Expenses, and Other Changes
  • View multiple Award/Parent IDs in one report, however Sponsored and Non-Sponsored Award/Parent IDs cannot be run in the same report

Faculty Monthly Rolling Projections Report

The Faculty Monthly Rolling Projections Report displays 12, 18, or 24 months of projected Budget, Revenue, Expense, and Other Changes on a month-by-month basis for selected Sponsored and Non-Sponsored Projects. Projections for Personnel Expenses are displayed by individual employee. Using the Faculty Monthly Rolling Projections Report (job aid) you can:

  • View Projected Revenue/Budget by Project
  • Review Projected Expenses/Other Changes for:
    • Personnel Expenses (salary & benefits) by employee name/title
    • Other Personnel Expenses: personnel items not directly related to an individual employee
    • Non-Personnel Expense and Other Changes at the summary level ("total" from Faculty Portfolio Projections)
      • Review a calculated monthly Running Balance
      • Includes options to view Liens and Projected Adjustments

Faculty Portfolio Monthly Report

The Faculty Portfolio (FP) Monthly Report displays monthly actual and projected financial information for a fiscal year by Project-Activity Period-Dept ID. Using the Faculty Portfolio Monthly Report (job aid) you can

  • Search for Projects by Award/Parent ID, Project, posting level Dept ID, and/or PI/Manager
  • View Sponsored Balances by month with Budget, Expenses and Other Changes
  • View Non-Sponsored Current Net Position with Beginning Net Position, Revenues, Expenses, and Other Changes
  • Choose from a more summarized Faculty view or more detailed Analyst view

Payroll Detail by Month Report

The Faculty Portfolio Payroll Detail by Month Report displays General Ledger (GL) and projection data for payroll expenses by month for either 6 or 12 months. The report runs by Project-Activity Period-Dept ID. Using the Payroll Detail by Month Report (job aid) you can

  • Display monthly payroll detail by employee for the duration selected. Details include Gross Pay, %DPE/Hours, Benefits, VLA, and Total cost per month.
  • Display either by the Accounting Period (default) in which the pay was processed or by Pay Period, the month of the effort
  • Data can be grouped by Award PI, Project PI, Award ID, Fund, Dept ID, Project, Project-Activity Period, Project-Activity Period-Fund-Dept ID, and/or Employee with Sponsored and Non-Sponsored activity in one report

Program Portfolio Report

The Program Portfolio Report provides summary General Ledger (GL) and projections data for multiple Project-Activity Period-Dept IDs and includes enhanced report filters that allow increased flexibility in defining dates and data parameters. These features allow reporting on an entire program of Projects that span multiple Principal Investigators (PIs) and/or multiple Dept IDs. Using the Program Portfolio Report (job aid) you can: 

  • Search for projects to build “programs” by any combination of one or more Award/Parent IDs, Projects, Dept IDs, or PI/Managers
  • Filter the report to:
    • Include only Sponsored, Non-Sponsored, or All Projects
    • Include or exclude Inactive or Pending Project-Activity Periods
    • View Direct and Indirect Costs, or Direct Costs only

Project Summary Report

The Faculty Portfolio Project Summary Report displays summary level General Ledger (GL) and projections data for the Project chartfield. The report can be run for a single Project or for multiple Projects. Using the Project Summary Report (job aid) you can:

  • Get a Project-based view
  • View Sponsored Balances with Budget, Expenses and Other Changes
  • View Non-Sponsored Current Net Position with Beginning Net Position, Revenues, Expenses, and Other Changes
  • View multiple Projects in one report, however Sponsored and Non-Sponsored Projects cannot be run in the same report

The Sponsored Awards Summary Report displays Research Administration System (RAS) billing and payment information as well as Budget Balance and Net Position Balance. Using the Sponsored Awards Summary Report (job aid) you can:

  • Displays RAS billing and payments
  • Displays the Budget Balance and Net Position Balance
  • Displays totals by Award-Project-Activity Period and can be run by Activity Through Date (from inception through the date selected)
  • Can only be run for Sponsored Awards
  • You can search for Awards by Award/Parent ID, Project, Dept ID, and/or PI/Manager

Portfolio Projections

The Faculty Portfolio Projections (job aid) tool enables users who have been granted the MyReports Projections Role to project budget/revenue, expenses, and other changes for sponsored projects and other faculty controlled funding for a Fund/Dept ID/Project/Activity Period. Published projections are displayed in Faculty Portfolio reports, along with actual expenditures to date to provide a projected balance.

Projections entry sheets:

Standard Projections

Standard Projections enables users to project up to 24 months of budget, expenses, and other changes for Sponsored projects. Projections, once published, are consolidated into reports with the actual expenditures to provide a projected balance.

Extended Projections

Extended Projections are the same as standard projections but provide a rolling 60-month projection period.

Non-Sponsored Projections

Non-Sponsored Projections enables users to project up to 5 fiscal years of revenue, expenses, and other changes for Non-Sponsored projects. Projections, once published, are consolidated into reports with the actual revenue, expenses, and other changes to provide a projected balance.

Personnel Projections by Employee

Personnel Projections by Employee enables users to project personnel expenses across multiple funding sources, including both Sponsored and Non-Sponsored projects, for a single employee over a rolling 60-month period. Saved Projections are visible in the Standard, Extended, and Non-Sponsored Projections sheets. Projections, once published, are consolidated into reports with the actual expenditures to provide a projected balance.

Comments for Faculty

Comments for Faculty enables users to enter or update comments that are not specific to a particular chartstring. Published comments will appear in the MyPortfolio Report found on the Faculty Portfolio tab.