Income Statement Report (UCSF Health) Job Aid

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. This step-by-step guide explains how to filter and run the report.

What Can I Learn from the Income Statement Report?

  • Monthly and YTD actuals and fixed budgets for Revenue, Expense, Non-Operating Income, Other Changes, and Net Position for selected UCSF Health Business Units
  • Reports can be displayed at Alt Account Level B to F (posting accounts) and defaults to Alt Account Level D
  • Click on hyperlinked numbers to display transaction detail in the Alt Account Detail Report for the selected month

Report Date Filter

The Income Statement Report defaults to the current open month. Use the Report Date as of drop-down menu to select a previous closed month.

Chartstring Filters

  1. Business Unit (BU) is the only required (*) chartstring filter. The filter page defaults to select all UCSF Health BUs. You may override the default and select an individual BU or multiple BUs .
  2. The Income Statement Report displays all Revenue, Expense, Non-Operating Income/Expense, and Other Changes Alt Accounts; additional filtering by Alt Account is not available .

Additional chartfield parameters may be selected as desired.

Report Specific Filters

You can further refine your data or display additional data using the options in the Report Specific Filters section:

  1. Display Alt Account Level :
    • Select Alt Account Level
    • Default is Level D
  2. Display Codes and Descriptions :
    • Display codes and descriptions
    • Display codes only
    • Display descriptions only (default)
  3. Display Amounts :
    • Round to dollars
    • Round to thousands (default)
    • Show 2 decimal places
  4. Functional Owner  - allows you to run the report for all Dept IDs where the selected Functional Owner is assigned the Senior Executive, Executive Director, Business Officer, or Head of Unit role in PeopleSoft
    • You can only select a single Functional Owner.
    • The report will include a list of all assigned Dept IDs.
    • The Functional Owner filter should not be used in conjunction with the Dept ID filter.

Report Output

  1. In addition to the report output selections of On Screen HTML (default), PDF, and Excel , you can choose Unformatted Data
  2. The Unformatted Data output returns an Excel file that has no special formatting and a single row for column headings, making it the best source for pivot tables and other advanced spreadsheet analysis.
  3. Select your desired report output and click the Run Report button .
In both Excel outputs (standard Excel and Unformatted Data), the workbook will contain at least two tabs. The first tab/sheet always displays the entered filter criteria. The second tab/sheet displays the data and differs depending on whether you selected standard Excel or Unformatted Data.

Working in the Report View

The Income Statement Report displays a current month Total in the left-hand column for the BUs selected. The columns to the right show the fiscal YTD Total for the selected BUs. Column titles displayed with black underlines can be expanded/collapsed to show additional detail.

  • Clicking on the underlined ‘TOTAL’ in the Current Month column and/or the YTD column expands the column to display the individual selected BUs .
  • In the expanded YTD columns click on the underlined BU YTD to generate a monthly report for that individual BU .
  • Click on any blue hyperlinked number to generate an Alt Account Detail Report to display transaction details for the amount selected .

Refine or display additional report data using any of the drop-down menus in the HTML report header. These are the same report selection options that appear in the Report Specific Filters section of the filter page:

  1. Alt Account Level  – Select from Alt Account Levels B, C, D, E, or F (posting level) 
  2. Codes and Descriptions  – Display codes and descriptions; Display codes only; Display descriptions only
  3. Amounts  – Round to dollars; Round to thousands; Show 2 decimal places
  4. Click Update to re-run the report at the selected level .
     
  • Alt Account rows with black underlines can be expanded. Click on an underlined Alt Account name to expand that row to the next lower level of the Alt Account tree .
  • Right click in the white space to the right of the underlined row label and select Drill Up to return to the original Alt Acct level .
  • To expand all Alt Account rows on the report, select a lower Alt Account Level at D, E, or F (posting level) from the drop-down menu in the upper right-hand corner of the HTML report header. Click Update to re-run the report at the selected level.

Tips and Tricks

  • Two versions of the Income Statement Report exist. The current version of the report contains data from the three most recent fiscal years and is accessed directly from the Health Financial Reports landing page. The archive version of the report contains historical data older than the three most recent fiscal years and is accessed through the current report via the “Archive Periods” link located below the Run button in the top right section of the filter page.
  • The MyFavorites functionality allows you to save and retrieve frequently used filter criteria. See the Managing and Scheduling MyFavorites in MyReports job aid for instructions on saving report parameters to MyFavorites, and how to select and run a saved Favorite.
  • For the easiest navigation when using MyReports, close extra browser tabs/windows (usually the result of drilling through to another report) when you have completed reviewing and/or exporting the information.

Additional Information and Assistance

  • More information about MyReports, including how to request access and additional training, can be found in the MyReports section of the Controller’s Office website.
  • If you require help with a technical problem or have a question about a specific report, contact the Controller’s Office Solution Center at [email protected] or 415.476.2126.
  • To stay informed about MyReports news, follow the directions on the MyReports section of the Controller’s Office website to join the MyReports ListServ.

Give Us Your Feedback