PI Portfolio at CAN, 11/4 from 10:30am-12pm

Learn more about PI Portfolio at CAN on November 4
from 10:30am - 12:00pm in room 150 at University Hall

PI Portfolio provides faculty members, Principal Investigators (PIs), Research Administrators (RAs), Chief Administrative Officers (CAOs), and other finance team members with a quick yet comprehensive overview of all the financial data related to their faculty-managed funds. It allows them to view fund balances and expenses, and drill down to transactions and personnel details for specific funds for more in depth analysis. The PI Portfolio dashboard includes the ability to create and review financial projections for faculty-managed funds and sponsored awards utilizing a CF2.

Attend ​the CAN demonstration on November 4 ​to see how financial information can be easily customized, reviewed, and shared with colleagues in Cal Answers PI Portfolio. 

Overview

PI Portfolio provides a quick, comprehensive picture of faculty-managed fund balances, expenses, and budgets for faculty-managed funds and sponsored awards.

Read more about PI Portfolio.

PI Portfolio October Enhancements

  • Created a “Show balance through” filter which is now available in the Portfolio, Fund Summary, and new Chartstrings tabs, giving Actuals and balances through the end of a prior closed month, going back to July 2012.
  • Changed the By Month tab into a complete view of the month to month balance, in order to make it easier to know when funding will run out.
  • Added a Chartstrings tab, which allows users to get a balance in each chartstring used in a given PI’s Portfolio. It’s also helpful to see at a glance the chartfields being used for this PI. 
  • Improved the archive function, so that past projections can now be downloaded into an Excel file, which will be helpful for performing variance analysis against Actuals. 
  • Added a column showing the “Minimum Direct Cost Balance” in the Portfolio tab projections view, in order to show the actual amount left to spend without going into deficit, after overhead is charged.

Read the full list of enhancements.

PI Portfolio Dashboard

This dashboard displays budgets, spending and balances for all faculty-managed funds. Users of the PI Portfolio dashboard include faculty members, Principal Investigators (PIs), Research Administrators (RAs), Chief Administrative Officers (CAOs), and other finance team members. It also allows users to drill down to more detailed analysis, by clicking on any fund on the Portfolio page and then using the tabs at the top to navigate. 

When first using PI Portfolio, please confirm that all funding is appearing properly, and speak with your administrators if not.

What is Included

  • Sponsored awards where the faculty member is listed as a PI or CoPI.
  • Non-sponsored funds that are specifically attributed to the faculty member. These are transactions in the financial system that have been coded with a specific chartfield2 with the faculty member's ID.

Portfolio 
This is usually the best starting place. This page allows users to review balances for all sponsored and non-sponsored funds attributed to a faculty member, and then click on a specific fund for more information. The view selectors allow users to choose between a single line summary by fund or more detailed breakdown. Read more.

There are two ways to filter the sponsored transactions that impact awards that have allocations to investigators other than the lead PI: 

  •  “My Allocations” shows funds that have been specifically allocated to the CF2 of the faculty member.
  •  “Total Award” shows the entire sponsored award so that users can monitor overall spending.

Fund Summary 
Contains detailed information about a specific fund including a breakdown of budget and expenses by category. Read more.

Transactions 
This page provides the lowest level of detail for transactions on a specific fund within a time period. Read more.

By Month
Shows spending and expense projections by month so users can monitor trends by expense type. It defaults to the last six months but users can choose any period. Read more.

Personnel
Shows the history of who has been paid on all funds belonging to the selected faculty member. Read more.

Projections
Shows all projections, line by line, across all of the faculty member's funds. It includes a link to the APEX input form for projections across all funds managed by a PI. Read more.

Burn Rate
Displays the average monthly expense for a particular fund-dept-account combination for a specified time period. Read more.

HR Lookup
Allows those with access to search all HCM appointments for a given Employee ID, in order to help create projections for compensation expenses by person. Read more.

Oversight
Includes exception reports showing funds with a current or projected deficit, and funds with Anticipated Funding. Read more.