Faculty Portfolio Reports

Faculty Portfolio is a financial 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) 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
  • Displays sponsored balances and non-sponsored net position from the General Ledger
  • 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) 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

In conjunction with the transition to UCPath the Faculty Monthly Rolling Projections Report has been retired. Additional details about this change were announced in the Controller's Office Newsletter.

Faculty Portfolio Monthly Report

The Faculty Portfolio (FP) Monthly Report displays monthly financial information 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) 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/Vacation, and Total cost per month.
  • Display either by the Accounting Period (default) in which the pay was processed or by Earning 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) 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) 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

In conjunction with the transition to UCPath the Faculty Portfolio Projects tool has been retired. As of June 1, 2020, projections information is no longer available in the suite of Faculty Portfolio reports.

Additional details about this change were announced in the Controller's Office Newsletter.