MyReports

  • The Purchase Order Lien Balance Report displays purchase orders with open balances for the specified search criteria, as of the close of the previous business day.
  • 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.
  • Sign up for the MyReports listserv to receive communications about MyReports including notification of new reports, enhancements, and system downtime.
  • In conjunction with the transition to UCPath this report has been retired. Additional details about this change were announced in the Controller's Office Newsletter.
  • In conjunction with the transition to UCPath this report has been retired. Additional details about this change were announced in the Controller's Office Newsletter.
  • In conjunction with the transition to UCPath this report has been retired. Additional details about this change were announced in the Controller's Office Newsletter.
  • The HR Event Report displays HR Events such as Appointments or Separations with the ability to drill-through to the HR Event Detail Report for more information. Data is available from July, 2013 and the report is static as of June 1, 2020.
  • The HR Monthly Review Report combines several report subgroups into a single review report with the ability to display the following data: New Hires, Separations, Appointments near end, Distributions near end, Probation period near end, Work permit end date, Limited employee hours, and Distributions greater than 100%.
  • The MyPortfolio Report displays summary level General Ledger (GL) data for a single Faculty or Principal Investigator’s (PI) portfolio of Projects.
  • The Award/Parent Summary Report displays summary level General Ledger (GL) and projection data for Project Award/Parent IDs. The report runs for Award/Parent ID(s).
  • The Faculty Portfolio (FP) Monthly Report displays monthly actual financial information by Project-Activity Period-Dept ID.
  • The Payroll Detail by Month Report displays General Ledger (GL) for Payroll expenses by month. The report is run for Project-Activity Period or by Employee. By default, the report displays all payroll elements, such as Gross Pay, Benefits, Accruals, and VLA/Vacation Accrual, but the output can also be filtered to display single or multiple elements.
  • 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.
  • The Project Summary Report displays summary level General Ledger (GL) and projection data for the Project chartfield. The report can be run for single or multiple Projects.
  • The Sponsored Awards Summary Report displays Research Administration System (RAS) billing and payment information as well as Budget Balance and current fiscal year Net Position by Award-Project-Activity Period.
  • MyReports Accounts Payable/Purchase Order (AP/PO) Inquiry Report Job Aid
  • The Balance Sheet report displays Asset and Liability account activity and balances for a selected date range. The report can be displayed at a summary Account level, or at a detail level including Fund, Dept ID, and Project.
  • The Distribution of Payroll Expense (DPE) Report displays detailed payroll information for all transactions processed through the Payroll/Personnel System (PPS) and UCPath.
  • The Transaction Detail Report displays detailed transaction information including Payroll, Accounts Payable, Purchase Orders, Financial Journals, and Budget Journals. This report facilitates research and reconciliation, and is used for Step 1 in GL Verification and to review general ledger detail for a set of criteria.
  • The Asset Management Report lists detailed information about capitalized assets to enable departments to perform their physical inventory. The report can also be used for basic inquiry, including the status of an asset.
  • This guide outlines how to understand PPS Payroll Transactions on the Transaction Detail Report (TDR) and the Distribution of Payroll Expense (DPE) by Account and Alt Account Reports.
  • Compares YTD Actuals to YTD Plan and calculates variance. Also compares Actuals/Forecast to Fiscal Year Plan and calculates variance. Report defaults to Level C of the account tree, but can also be viewed at Account Level B through F.
  • The Monthly Report contains two formats: Displays monthly Actuals, compares Actuals/Forecast to Plan, and displays variance to Plan. Displays monthly Actuals on a Fiscal year basis, and calculates a YTD monthly average amount for each Actual account category.  The report defaults to Level C of the account tree, but can also be viewed at Account Levels B through F.
  • The Net Position Report allows you to view beginning and ending net position calculations by Dept ID, Fund, Project, and Parent/Award ID. The term Net Position was previously known as “Equity”, “Fund Balance”, “Unexpended Balance”, and “Net Assets”.
  • The Sponsored Projects Balances Report is a valuable tool for departments to monitor Awards/Projects at any point in time and at any level of the Dept ID tree.
  • The report allows you to view Restricted Gifts, Unrestricted Gifts, and Endowment income across Business Units. The report displays transfer activity between the Foundation and the Regents by leveraging Pair logic. Pair Logic identifies when the same Project is used in recording activity across all Business Units (BU).
  • The Current Year vs. Prior Year Actuals Comparison Report provides a side-by-side comparison of the current fiscal year’s actual transactions through the last closed month and the previous fiscal year’s actual transactions through the same month. Report defaults to Level C of the account tree, but can also be viewed at Account Level B through F.
  • The Project Comparison Report displays Revenues, Expenses, Other Changes, and Net Position by Project in side-by-side columns. The report is best used to compare a small set of non-sponsored Projects.
  • The Organization Report compares YTD Actuals against YTD Plan or YTD Forecast and calculates the variance by Department(s) or Department Nodes. Report can be expanded and collapsed up and down the Dept ID tree to see data at all department levels. Report defaults to Level C of the account tree, but can also be viewed at Account Levels B through F.
  • The Mission Based Report displays Actual Revenues, Expenses, Other Changes, and Net Position by Mission (Function Code). Report defaults to Level C of the account tree, but can also be viewed at Account Level B, D, & E.
  • The Fund Group Report enables users to review Actual Revenues, Expenses, Other Changes and Net Position by Fund Group (source of funds). Report can be expanded and collapsed up and down the Fund tree (Levels C-E) and the Account tree (Levels BE) to see data at various levels.
  • The Project Use Report displays Actual Revenues, Expenses, Other Changes, and Net Position by Project Use, an attribute of the Project chartfield, which indicates a specified activity or purpose of the project. Report defaults to Level C of the Account tree, but can also be viewed at Account Level B, D, & E.
  • MyFavorites functionality allows MyReports users to save and retrieve commonly used filter criteria. A selection of MyFavorites can then be used to schedule reports with MySchedules. Scheduled reports send email with the attached report(s) to identified recipients. This job aid explains how to create and manage MyFavorites and how to use MyFavorites to create and maintain MySchedules.
  • The Income Statement Report displays Revenue, Expense, and NonOperating Income actuals by Business Unit as of a selected month and fiscal year-to-date (YTD). It also displays Fixed Budget for a selected month and fiscal YTD. The report can be displayed at a summary or a detail level.
  • The Alt Account Detail Report (ADR) displays detail transaction information for all financial transactions and journal entries posted to the PeopleSoft general ledger. Provides accurate and timely information for researching transactions Facilitates reconciliation to source documents and/or source systems Displays when drilling through for more detail from other reports
  • Campus Reports Name Control Point Department Email Anil Vora IGHS IGHS Central Admin [email protected] Ellyn Woo IGHS IGHS Central Admin [email protected] Cecilia Chang SON Dean's Office [email protected] Tiffany Nguyen SON Dean's Office
  • The MyReports Team works with the campus and UCSF Health to continually improve MyReports. The MyReports Advisory Group supports the continuous improvement of MyReports and ensures that the entire campus community has a voice in submitting, evaluating, and prioritizing new report development and enhancement ideas.  Group members are appointed by the Control Points and actively gather input from their constituents. The Advisory Group will review all submissions and make prioritized recommendations for MyReports improvements.
  • Download this job aid for more details on how Net Position is calculated and displayed in MyReports.
  • The Income Statement Variance Report displays Revenue, Expense, NonOperating Income/Expense, Other Changes, and Net Position actuals as of a selected month and fiscal year-to-date (YTD). Monthly and YTD Fixed Budgets are also displayed, with options to include or exclude Flex Budget and Prior Year Actuals amounts. The report can be displayed at a summary or a detail level by selecting the desired Alt Account level.
  • The Key Operating Trends report displays monthly Revenue, Expense, Non Operating Income/Expense, Other Changes, and Net Position on a fiscal year basis. The report includes monthly trend calculations of Operating Margin and Operating Earnings before Non-Operating Income, Interest, Depreciation, and Amortization (EBIDA). The monthly actuals can be displayed at a summary or a detail level by selecting the desired Alt Account level.
  • MyReports is UCSF's campus-wide reporting solution that provides financial and human resources data to meet the needs of users at all levels within our organization. The HR Data Reports in MyReports include:
  • 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:
  • UCSF Health Reports are designed specifically for the Health Business Units. Campus Business Units are not available in these reports and PeopleSoft Alt Accounts are used in lieu of Account codes.
  • 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.
  • Users needing access to financial information to fulfill their job requirements should have been granted access to MyReports.
  • Reports in MyReports are grouped by tab or report category. This page describes each report and is organized by tab. 
  • The matrix in this Quick Reference Guide displays the recommended reports for various financial activities by role. The information is provided to help you choose the report(s) to use in your day-to-day business.
  • Each report has a unique filter page; most reports have very similar filter pages to help you more easily enter your report criteria. Most filter pages have four major sections: Report Date Filters Chartstring Filters Report Specific Filters Report Output Selection.
  • Most MyReports filter pages have a Report Specific Filters section. Report specific filters are usually optional and provide you with additional ways to limit the data returned in the report. In some cases, the report specific filters have been preset. To change the preset filter, follow the instructions in this Job Aid.
  • Data in the Plan and Forecast columns of the MyReports Operational and Management reports come from UPlan, UCSF’s planning system. The following will help you to correctly interpret the data in these columns.How is Plan and Forecast Data Brought Into and Displayed in MyReports? Data in the Plan and Forecast columns of the MyReports Operational and Management reports comes from UPlan, UCSF’s planning system:
  • This is a detailed list of MyReports enhancements from October 2016 to current. For previous enhancements, see MyReports Enhancements Prior to October 2016.
  • In conjunction with the transition to UCPath this report has been retired. Additional details about this change were announced in the Controller's Office Newsletter.
  • MyReports is UCSF’s campus-wide reporting solution that provides financial and human resources data to meet the needs of users at all levels within our organization. At a glance MyReports enables users to view data to answer questions including:
  • Accessing the Chart of Accounts Alt Account Tree via the Controller's Office website now requires a connection from the UCSF network or VPN. If you are already connected to the UCSF network or VPN you may proceed. If you are connecting remotely, please connect to the UCSF VPN before accessing this resource. Review these Frequently Asked Questions (opens in new window) for more information about the UCSF VPN.
  • This document contains job aids for the entire Labor Productivity suite of reports. 
  • The McKesson AP (Accounts Payable) Detail Report displays detailed transaction information for vouchers created in McKesson and posted to PeopleSoft, including PO, Invoice, Vendor, Voucher, Functional Owner, and Item Description.
  • The Access Management application is used to process and track access requests made by Access Administrators and Security Administrators for the following Financial Systems supported by the Controller’s Office: PeopleSoft Financials, RAS, MyReports, GL Verification (GLV) Tool, and Effort Reporting System (ERS). This document provides instructions on how to request and modify access to MyReports using the Access Management application.
  • The Employee and Position Roster Report displays Employee and Position details with default department funding in a list by HR Department, Position Department, Employee, Reports To, Position, and/or specific chartstring.
  • The Employee and Position Distribution Report displays current and future funding entries, including additional pay, in a list by HR Department, Position Department, Employee, Reports To, Position, and/or specific chartstring.
  • This guide outlines how to understand UCPath Payroll Transactions on the Transaction Detail Report (TDR) and the Distribution of Payroll Expense (DPE) by Account and Alt Account Reports.  
  • The Distribution of Payroll Expense by Alt Account Report displays detailed payroll information for all transactions processed through the UC Payroll System (UCPath) and the Payroll/Personnel System (PPS) by UCSF Health Alt Account.
  • Watch this webinar to learn more about recent changes in MyReports in conjunction with UCPath. This presentation will focus on changes to the Distribution of Payroll Expense (DPE) Report and HR Reports.
  • Access Employees who need access to financial information to fulfill their job requirements should be granted access to MyReports. If you have financial reporting needs and find you do not have access to MyReports, contact your Manager/Supervisor or departmental Access Administrator. Follow the Accessing MyReports job aid to login to MyReports using MyAccess.
  • This quick reference provides the list of DOS Codes and Descriptions that roll up into the Base Salary (X), Negotiated Salary (Y), Other Compensation (Z), Over the Cap of X (OTC-X), and Over the Cap of Y (OTC-Y) Compensation Types displayed in the MyReports Payroll Funding Report.
  • MyReports is UCSF’s campus-wide reporting solution that provides financial and human resources data to meet the needs of users at all levels within our organization. Financial Reports in MyReports are displayed in three tabs (sets of reports):
  • The Payroll Funding Report  provides a fiscal year view of employee pay information by Compensation Types Base Salary (X), Negotiated Salary (Y), Other Compensation (Z), Over-the-Cap (OTC), and Benefits. Displays monthly Actuals for closed periods and Future Distributions based on position funding entry in UCPath. Report display options include a choice of Summary or Detail View.
  • MyReports encourages continuous improvement and welcomes new report and enhancement ideas from the entire UCSF community. If you have an idea or suggestion to improve MyReports: Complete the form Email the completed form to one of your Control Point’s MyReports Advisory Group members. The Advisory Group meets on a regular basis to evaluate and prioritize new report development and enhancement ideas.
  • Based on input from the MyReports Campus Advisory Group, two new columns have been added to the Employee and Position Roster Report to help in the timely processing of reappointments: Visa Permit Type Work Authorization End Date In addition, Work Permit End Date has been renamed Visa End Date to better align with the UCPath label. Users should clear their web browser cache to take advantage of the new columns.
  • A UCPath defect (opens in new window) that has resulted in incorrect hours, pay percentages, and effort percentages on the Distribution of Payroll Expense (DPE) reports since October 2021 will be resolved this month. The defect is observed on leave earnings distribution lines and the corresponding “Reg-like” offsetting lines where the lines do not have equal and opposite hours and effort percent. When running the DPE by earnings end date, the effort percent and hours will be slightly off. Paycheck amounts were not impacted.
  • Based on input from the MyReports Campus Advisory Group, the Sponsored Awards Summary Report has been updated with the following enhancements.
  • The Faculty Portfolio Monthly Report has been redesigned to include more detailed budget information for sponsored activity: Budget activity is displayed for each month, instead of in a single aggregated column. Budget activity is separated into direct and indirect costs to better align with actuals. An updated job aid is available in the MyReports section of the Controller’s Office website.
  • As the amount of data in MyReports continues to grow, MyReports is partitioning some reports into current and archive versions. This change is expected to reduce the duration of the nightly data refresh for MyReports. Current reports will: contain data from the three most recent fiscal years continue to be accessed in the same way as they are today continue to be refreshed nightly Archive reports will:
  • The MyReports Advisory Group supports the continuous improvement of MyReports and ensures that the entire campus community has a voice in submitting, evaluating, and prioritizing new report development and enhancement ideas. Advisory Group members are nominated by the Control Points and actively gather and prioritize input from their constituents. The MyReports Advisory Group will meet again at the end of February.
  • Based on input from the MyReports Campus Advisory Group, two new columns have been added to the Transaction Detail Report (TDR) to provide additional details about accounts payable transactions:  Invoice Number  Voucher Line Description (for vouchers entered since July 2021) Use the Display Columns filter to include the new columns and tailor the report output as desired. Users will need to clear their web browser cache in order to take advantage of the enhancements. 
  • The McKesson AP Detail Report was recently enhanced with the following new data fields and improved functionality.  Filter Enhancements  A new Display Codes and Descriptions filter allows for tailoring of the display of chartfield information, available on both the filter page and the On Screen HTML report output.  Report Sort 1 and Report Sort 2 filters previously only available on the On Screen HTML report output have been added to the filter page. 
  • The Employee and Position Roster Report now includes details about each UCPath position’s effective status. Two new columns available in all report outputs indicate whether a position is active or inactive: Position Status, with values “A” and “I” Position Status Descr, with values “Active” and “Inactive” Users should clear their web browser cache to take advantage of the new columns. Contact the Controller's Office Solution Center if you have any questions about MyReports or to report a potential issue.
  • The Payroll Funding Report's Employee search filter "typeahead" functionality has recently been enhanced.  Typing into the filter field now returns values that match any part of an employee’s name, UCSF Employee ID, or UCPath Employee ID. Users may need to clear their web browser cache to take advantage of the enhancements. Contact the Controller's Office Solution Center if you have any questions about MyReports or to report a potential issue.
  • Based on input from the MyReports Campus Advisory Group, the Transaction Detail Report (TDR) and Alt Account Detail Report (ADR) have been enhanced to include the following chartfield tree values in the Unformatted Data report output:
  • Based on input from the MyReports Campus Advisory Group and feedback from our users, the Employee and Position Distribution Report has been enhanced with additional columns and functionality. Highlights of report changes include:
  • On November 1, the MyReports team released a new version of the Employee and Position Roster Report, adding the following fields: CBR% – displays the composite benefit rate for the employee’s job CBR Group – indicates the employee’s assigned benefit group based on job code and benefits eligibility FLSA Status – indicates Exempt and Non-Exempt appointments UCPath Bus Unit – displays the Business Unit of the employee’s job Users may need to clear their web browser cache to take advantage of the enhancements.
  • Based on input from the MyReports Campus Advisory Group and feedback from our users, the Distribution of Payroll Expense (DPE) reports by Account and Alt Account have been enhanced with additional filters and data columns. Highlights of report changes include:
  • The MyFavorites functionality of MyReports allows users to save and easily retrieve commonly used filter criteria. Users can schedule the email delivery of MyFavorites reports using MySchedules. An effort is underway to remove unused and expired schedules created using the MySchedules feature. In December, MyReports will delete existing schedules that meet any of the following criteria:
  • In October, UCSF will upgrade to the current release of Oracle Database. The Oracle Database platform is used by several applications and information systems at UCSF. The following financial systems will be unavailable during the maintenance periods specified. Please plan accordingly.
  • The Transaction Detail Report (TDR) and Alt Account Detail Report (ADR) were recently enhanced to provide improved display and sort options. Highlights of report changes include:
  • Later this month, the Distribution of Payroll Expense (DPE) reports by Account and Alt Account will be enhanced to increase the accuracy of Composite Benefit Rates (CBR) for employees with multiple positions, and those whose primary job is at a different UC. When the CBR cannot be determined based on the rules provided by UCPath, the CBR % will display as “N/A”. An additional announcement will be made via the MyReports listserv when the enhancement is available.
  • Later this month, the Employee & Position Distribution Report will be enhanced based on input from the MyReports Campus Advisory Group. The following report changes are intended to provide more accurate funding entry data:
  • Later this month, a new version of the Employee and Position Roster Report will be available with the following enhancements:
  • The MyReports Advisory Group supports the continuous improvement of MyReports and ensures that the entire campus community has a voice in submitting, evaluating, and prioritizing new report development and enhancement ideas. Advisory Group members are nominated by the Control Points and actively gather and prioritize input from their constituents. The MyReports Advisory Group will meet again at the end of August 2021.
  • UPlan will be down for year-end/open activities beginning Monday, August 9th through Monday, September 6th. During this period, the weekly transfer of forecast data from UPlan to MyReports will be turned off. Scheduled jobs will resume on September 10.
  • Beginning in August, MyReports will suspend the nightly data refresh on the third Saturday of every month to avoid any overlaps during UCSF’s standard monthly maintenance of the infrastructure. MyReports will continue to be accessible during the monthly maintenance window but will not contain any of Saturday’s entries and postings. Data refreshes will resume the following Sunday evening.
  • Based on input from the MyReports Campus Advisory Group, the Payroll Funding Report has been enhanced to allow the report to be run by earning period, in addition to the default functionality of running it by accounting period. Users will find the new Run by Earning Period filter in the Report Specific Filters section.
  • Based on input from the MyReports Campus Advisory Group, the Payroll Detail by Month Report has been updated with the following enhancements.
  • Based on input from the MyReports Campus Advisory Group, the Faculty Portfolio Monthly Report has been enhanced. Highlights of report changes include:
  • Throughout the month of July, and until final close in August, more than one accounting period will be open in PeopleSoft. When two accounting periods are open at one time, Report Date Filters in MyReports default to either the last closed month or the open month depending on the report purpose and design. MyReports users will see the following default Report Date Filter values during the fiscal year-end closing process: