MyReports Report Descriptions by Tab

Reports in MyReports are grouped by tab or report category. This page describes each report and is organized by tab. 

Consolidated Reports

Consolidated Financial Report
Consolidated Statement of Revenues, Expenses, and Changes in Net Position, including all Adjustment Period entries, as of a selected fiscal quarter for all Control Points (Dept ID Level 1) or for selected Control Point Dept IDs. Report can be expanded to show Accounting Period entries and Adjustment Period entries by quarter and by month. Control Point reports can be expanded to display the next level down the Dept ID tree. Report defaults to Level B of the Account tree, but can also be viewed at Levels C, D, E, and F.

Transactional Reports

Accounts Payable/Purchase Order Inquiry Report
Displays detailed line level information associated with a single Voucher, Vendor Invoice Number, or Purchase Order.

Asset Management Report
Used by Custodians, this 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.

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.

Distribution of Payroll Expense Report (DPE)
Displays detailed payroll information for all transactions processed through the Payroll System at a level of detail not available in the GL Payroll Journal.

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.

Transaction Detail Report
Displays detailed transaction information including Payroll, Accounts Payable, Purchase Orders, Financial Journals, and Budget Journals. Facilitates research and reconciliation. Used for Step 1 in the paper-based GL Verification procedure and to review general ledger detail for a set of criteria.

Operational Reports

Actual vs. Plan Comparison Report
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.

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.

Gift and Endowment Income Report
Displays transfer activity for Restricted Gifts, Unrestricted Gifts, and Endowment income between the Foundation and the Regents across all Business Units.

Monthly Report
Two formats:

  1. Displays monthly Actuals, compares Actuals/Forecast to Plan, and displays variance to Plan.
  2. Displays monthly Actuals on a fiscal year basis, and calculates a YTD monthly average amount for each Actual account category. Report defaults to Level C of the account tree, but can also be viewed at Account Levels B through F.

Net Position Report
Displays the actual Equity/Net Position of a Dept ID, Fund, or Award/Project -- including current year Revenues, Expenses, and Other Changes -- for a selected date range.

Payroll Funding Report
Provides a fiscal year view of employee payroll by compensation types X, Y, Z, and benefits. Displays monthly Actuals for closed periods and PSS distributions for future periods.

Project Comparison Report
Displays Revenues, Expenses, Other Changes, and Net Position by Project in side-by-side columns. Options include comparing Actuals against Plan or Forecast with calculated variance; output can be viewed at levels B through E of the Account tree. The report is best used to view a small set of non-sponsored Projects.

Sponsored Projects Balances Report
Enables departments to monitor Awards/Projects at any point in time, and at any level of the Dept ID tree. The report shows Budget, Actual Expenses, and Other Changes, and indicates whether each project has a positive or deficit balance.

Management Reports

Fund Group Report
Displays 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 B-E) to see data at various levels.

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.

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 Level B, D, & E.

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.

Faculty Portfolio Reports

MyPortfolio Report
Displays summary level General Ledger (GL) and projections data for a Faculty and/or Principal Investigator’s (PI) entire portfolio of funds, including project details such as sponsored balances and non-sponsored net position.

Award/Parent Summary Report
Provides a comprehensive view of sponsored or non-sponsored project activity with summary level General Ledger and Projections data for Project Award/Parent IDs.

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 include Personnel Expenses broken down by individual employee.

Faculty Portfolio Monthly Report
Displays monthly Actual and Projected financial information for the fiscal year by Project-Activity Period-Dept ID. Sponsored Projects include Budget, Actuals, and Projections. Non-Sponsored Projects include Revenues, Actuals, Expenses, Projections, and Net Position. Options include a choice of faculty or analyst report view, and the ability to include future employees distribution percentages from PPS.

Payroll Detail by Month Report
Displays General Ledger (GL) and projection data 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, and VLA, but the output can also be filtered to display single elements.

Program Portfolio Report
Displays summary level General Ledger (GL) and projections data for programs with projects from multiple PIs and/or multiple Dept IDs. Report filters provide flexibility to define report data and date parameters and include the option to display direct costs only.

Project Summary Report
Displays summary level General Ledger (GL) and projection data for the Project chartfield. The report can be run for a single or multiple Projects.

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.

Portfolio Projections

Standard Projections
Worksheet 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.
MyReports

Extended Projections
Worksheet provides the same functionality as standard projections with a rolling 60-month projection period.

Non-Sponsored Projections
Enables users to project up to 24-months 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
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
Enables users to enter or updated comments that are not specific to a particular chartstring. Published comments will appear in the MyPortfolio report found on the Faculty Portfolio tab.

Control Point Reports

SOM Financial Reports
Financial Reports developed and maintained by SOM. Access to the reports is administered by SOM and limited to their authorized users.

FAS Financial Reports
Financial Reports developed and maintained by FAS. Access to the reports is administered by FAS and limited to their authorized users.

UCSF Health Reports - Labor Productivity

Labor Productivity Summary Report
Provides a visual display of budget, flex, actuals, and variances in FTE and dollar amounts. Graphs display labor data by pay period, Dept ID, job code, and pay category. Users can drill through to other Labor Productivity reports to view more detailed data. The report can be run by Functional Owner and for any level of the Dept ID tree.

Labor Productivity Trend Report
Displays labor budget, flex, actuals, and variances in FTE and dollar amounts for a selected pay period and up to 26 prior pay periods. Also includes calculations for a 6-pay-period average and YTD averages/amounts as of the selected pay period. Users can drill through to other Labor Productivity reports to view more detailed data. The report can be run by Functional Owner and for any level of the Dept ID tree.

Labor Productivity by Dept ID Report
Displays labor budget, flex, actuals, and variances in FTE and dollar amounts, and units of service by Dept ID for a selected pay period. Data can be rolled up or down the Dept ID tree hierarchy to display labor productivity across organizational levels. Users can drill through to other Labor Productivity reports to view more detailed data. The report can be run by Functional Owner and for any level of the Dept ID tree.

Labor Productivity by Job Code Report
Two report components display labor productivity data at the job code level and employee level. A Job Code Summary section displays labor budget, flex, actuals, and variances in hours, FTEs, dollars, and skill mix for a selected pay period. A Job Code Detail section displays actual amounts in hours, FTEs, and dollars. Users can drill down to the employee level to view the HBS pay code classifications recorded for the pay period and can further drill through to the employee’s HR distribution details.

Distribution of Payroll Expense (DPE) Report
Displays detailed payroll information for all transactions processed through the Payroll/Personnel System (PPS). Use this report to prepare a Payroll Expense Transfer Uploader (PETU) to correct payroll recorded to an incorrect chartstring.

UCSF Health Reports - Monthly Variance

Monthly Variance Summary Report
Provides a dashboard overview of financial performance as of a selected month and fiscal year-to-date (YTD). The report displays actuals, fixed budget and flex budget, and corresponding variances for Statistics, Revenue, Expense, Non-Operating Income/Expense, and Other Changes in Net Position. Users can drill through to other Monthly Variance reports to view more detailed data. The report can be run by Functional Owner and for any level of the Dept ID tree. Variance Analysis Tool (VAT) Alerts and Comments are available for easy reference.

Monthly Variance by Alt Account Report
Displays actuals, budget and flex, and corresponding variances for Statistics, Revenue, and Expenses as of a selected month and fiscal year-to-date. Users can drill through to other Monthly Variance reports to view more detailed data. The report can be run by Functional Owner and for any level of the Dept ID tree.

Monthly Variance Trend Report
Displays monthly actuals on a fiscal year basis and calculates monthly and year-to-date variances to budget and flex for Statistics, Revenue, Expenses, and Other Changes in Net Position. Users can drill through to other Monthly Variance reports to view more detailed data. The report can be run by Functional Owner and for any level of the Dept ID tree.

Monthly Variance by Dept ID Report
Displays actuals, budget and flex, and corresponding variances for Statistics, Revenue, and Expenses, and Other Changes in Net Position as of a selected month and fiscal year-to-date. Data can be rolled up or down the Dept ID tree hierarchy to display data across organizational levels. Users can drill through to other Monthly Variance reports to view more detailed data. The report can be run by Functional Owner and for any level of the Dept ID tree.

Alt Account Detail Report
Displays detailed transaction information by Alt Account, including Payroll, Accounts Payable, BearBuy Purchase Orders, and Financial Journals. Facilitates research and reconciliation. Used to review general ledger transaction detail for a set of criteria.

McKesson AP Detail Report
Displays detailed information for vouchers created in McKesson and posted to PeopleSoft within a specific Accounting Period, including vendor, PO, invoice, voucher and item detail. The report can also be used for basic inquiry by voucher or vendor details.

UCSF Health Reports - Health Financial

Alt Account Detail Report
Displays detailed transaction information by Alt Account, including Payroll, Accounts Payable, BearBuy Purchase Orders, and Financial Journals. Facilitates research and reconciliation. Used to review general ledger transaction detail for a set of criteria.

Balance Sheet Report – UCSF Health
Displays Asset, Liability, and Net Position Alt Account balances as of selected period. The report can be displayed at a summary and detail level.

Income Statement Report
Displays Revenue, Expense, Non-Operating Income/Expense, Other Changes, and Net Position balances by Business Unit as of a selected month and fiscal year-to-date. Also displays Fixed Budget for selected month and fiscal YTD. The report can be displayed at a summary and detail level.

Income Statement Variance Report
Displays Revenue, Expense, Non-Operating Income/Expense, Other Changes, and Net Position actuals as of a selected month and fiscal year-to-date. Also displays monthly and YTD Fixed Budget, Flex Budget, and Prior Year Actual amounts. The report can be displayed at a summary and detail level.

Key Operating Trends
Displays monthly Revenue, Expense, Non-Operating Income/Expense, Other Changes, and Net Position on a fiscal year basis. Includes monthly trend calculation of Operating Marin and Operating EBIDA. The monthly actuals can be displayed at a summary and detail level.

McKesson AP Detail Report
Displays detailed information for vouchers created in McKesson and posted to PeopleSoft within a specific Accounting Period, including vendor, PO, invoice, voucher and item detail. The report can also be used for basic inquiry by voucher or vendor details.

HR Data Reports

Employee Appointment Report
Displays HR appointment details in a list format by Employee, Appointment Number, and Appointment Begin and End Date.

Employee Distribution Report
Displays HR distribution details in a list by Employee, Distribution No., Distribution %, Distribution Chartstring, and Distribution Begin and End Dates.

Employee Lookup Report
Displays all HR appointment and distribution line information for a single employee, or multiple employees.

HR Event Report
Displays HR Events such as Appointments and Separations with the ability to drill-through to Event details. Data available from July 2013 forward.

HR Monthly Review Report
Combines several report subgroups into a single review report with the ability to display 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%.

Inquiries

Inquiry Reports (Controller’s Office Website)
Links directly to the Inquiries page of the Controller’s Office Website where users may inquire on any chartfield, combo edits, and many other commonly used codes and values.