Skip to main content

System Status: 

  1. Home
  2. Finance
  3. BI & Financial Reporting
  4. Budget and Financial Management
  5. Financial Resource Management Dashboard
  6. Net Operating Results and Fund Balances

Net Operating Results and Fund Balances

Last Updated: March 24, 2023 3:02:30 PM PDT
Give feedback

The Net Operating Results (NOR) and Fund Balances report provides YTD overall net financial surplus or loss by major Fund categories in a profit and loss statement format.

The Net Operating Results (NOR) and Fund Balances report is available from the Business Analytics Hub under the Financial Resource Management Dashboard. Standard Oracle roles are required to access the report.

Critical Concepts

  • All prompt fields must be populated for the report to run.
  • There are two ways to populate a prompt field:
    • Entering the desired value directly into the relevant prompt box, if known.
    • Locating the desired value by navigating through a field’s hierarchy by clicking on the Member Selection icon budget-vs-actual-1.PNG
  • Report rows use the Managerial Reporting Account Hierarchy, not the Standard Financial Account Hierarchy
  • Report columns use the Managerial Reporting Fund Hierarchy, not the Standard Fund Hierarchy
  • Report data is YTD for the selected Accounting Period
  • The report can be run for any of these attributes:
    • Accounting Period
    • Financial Unit or any level in the Financial Unit hierarchy
    • Project
  • Total Resources (account 4xxxxx and some 7xxxxx) and Total Expenses (account 5xxxxx and some 7xxxxx) are YTD amounts based on the accounting period selected in the user prompt.
    Change in Net Position = Net of Total Resources and Total Expenses
    Beginning Net Position = Fund balances from the October distribution of prior year Net Activity to account 300000 at the financial unit and project level
    Ending Net Position = Change in Net Position plus Beginning Net Position
    Capital Assets = amounts posted to level 16000B in the Chart of Accounts
    Resources Available = Ending Net Position minus Capital Assets. This represents the amount available to spend but does not include encumbrances or commitments.
  • Capital Asset Purchases are not accounted for as expenses in the income statement and therefore are not included in the calculation of Change in Net Position or Ending Net Position
    • To assist with deriving a unit's remaining Resources Available, capital asset purchases are reflected after Ending Position as a reduction of fund balance
  • FD_13042: Internal Loan, is excluded from this report as it is not included in the Managerial Reporting Fund Hierarchy

How to Run

  1. Go to bah.ucsd.edu.
  2. Locate the Budget & Finance tab, click on the Financial Resource Management Dashboard
  3. Click Launch, and log into Oracle via UCSD Single Sign-On
  4. Under Oracle BI Managerial Reports, select Net Operating Results and Fund Balance, and select Click on this link to run Net Operating Results and Fund Balance report in blue hyperlink
  5. A new page will open with a pop-up box containing the prompt fields that must be populated

    nor prompt

  6. In Enter Accounting Period
    1. Enter the Accounting Period directly in the prompt field using the format Mmm-YY, e.g. Sep-21, if entering the Accounting Period directly in the field, it must exactly match the value, e.g. Oct-20, Nov-20, Dec-20, Jan-21, etc.
    2. To search for a specific Accounting Period, click the search icon to the right of Accounting Period field
    3. Open the Accounting Period folder
    4. Expand each folder and select the desired Fiscal Year, Quarter, and Month
    5. To move the selected period, click the > icon to the Name Column, if there is an Accounting Period in the Name column that is not desired, select it and use < icon to remove it
    6. Click OK at the bottom of the screen when desired Accounting Period(s) are entered

      nor prompt accounting period

  7. In Enter Financial Unit, there are two options for entering the Financial Unit:
    Option 1 – Enter the 7 digit Financial Unit number directly into the prompt field, recommended method, then click OK
    Option 2 – Search for the Financial Unit or the Financial Unit level using the hierarchy, you can select up to three Financial Units to be included in the report
    1. In Rows Per Page, select 50
    2. To the right of the Enter Financial Unit field, click the search icon
    3. Expand FINANCIAL UNIT folder
    4. Expand UCSD_FIN_UNIT_T-UCSD_FIN_UNIT_T_V1 folder

      nor prompt finunit 1

    5. Expand 160000A-UC San Diego, this is the top level of the Financial Unit hierarchy
    6. Drill down to the Financial Unit level hierarchy or desired Fin Unit by expanding each level, select the desired level/Fin Unit box e.g. VC CFO unit

      nor prompt finunit 2

    7. Click the > icon in the middle of the screen to move this selection to the Name column
    8. Select the All FINANCIAL UNIT Values on the right side of the screen and click the < icon in the middle of the screen to remove the selection
    9. The Name column should only have the values chosen after this step, when selections are completed, click OK at the bottom of the screen

      nor prompt finunit 3

  8. In the Enter Project field, there are two options for entering the Project Number:
    Option 1 – Enter the 7 digit Project Number directly into the prompt field, recommended method, then click OK
    Option 2 – Search for the Project Number using the name

    1. To the right of the Enter Project field, click the search icon
    2. Expand PROJECT folder, you can select up to three Projects to be included in the report
    3. Expand All PROJECT Values folder
    4. In the Find field, select Default
    5. In the Search field, enter a key word between 2 Asterisks and click the search icon
    6. Select the desired Project(s) by clicking in the box, click the > icon in the middle of the screen to move this selection to the Name Column
    7. Select the All Projects Values box on the right side of the screen and click the < icon in the middle of the screen to remove the selection, the Name column should only have the desired Projects Number(s)
    8. Click OK at the bottom of the screen when done

  9.  Once all prompt selections are complete, click OK to generate the report, the report output defaults to HTML preview
    1. To drill into the account groupings that make up the Total Resources and Total Expenses, click the arrows to the left of the row name
    2. Keep clicking the arrows to drill into the accounts that make up the account groupings
    3. To see the report in PDF or Export to Excel, under HTML Preview, select the desired format

 

Report Views

  • Results display in a formatted report with 1 label/description column and 7 amount columns
  • The report rows represent level 4 of the Managerial Reporting Account hierarchy
  • The rows are individually expandable and allow drill through the account hierarchy down to the account detail by clicking on the arrow to the left of the report rows
  • The column amounts represent actual financial data grouped by major Fund categories
  • Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

    nor output