Skip to main content

System Status: 

Fund Summary Report

The Fund Summary report displays balances, now named Resources Available, at the various financial unit levels, fund, project level.

The Fund Summary report is available from the Business Analytics Hub under the Financial Resource Management Dashboard. Standard Oracle roles are required to access the report.

Business Scenarios

  • The Fund Summary displays balances, now named Resources Available, at the various financial unit levels, fund, project level.
  • The report also displays Beginning Net Position at July 1, Total Resources, Total Expenses, Ending Net Position, Capital Asset purchases and Resources Available.
  • At the beginning of a new fiscal year, July 1 20XX, carryforward balances, also known as Beginning Net Position, post to the Fund Balance Account 300000 at the Oracle segment entity only. The carryforward balances do not post in Oracle at the financial unit or project segments. The distribution of carryforward balances to financial units and projects is a separate journal entry that is processed by ICA in October, after UCOP has approved final close.
  • The report can be run for different Fund types: Contracts and Grants, Core Funds, Other Unrestricted Funds, Restricted Funds. The report can be run for a single, multiple, or all Fund types by using the prompt for Fund Level 3.

This report answers the following questions:

  • What is the Ending Net Position for my Vice Chancellor? For my Division? For my Financial Unit? For a specific Fund? For a specific Project?
  • What are the YTD Resources and Expenses for my Vice Chancellor? For my Division? For my Financial Unit? For a specific Fund? For a specific Project?
  • What have I spent on Capital Assets?
  • What are my Available Resources to spend?
  • Does my financial unit show a positive net position in total, but negative net position within individual funds or projects, indicating I should transfer resources between funds or projects?

Data Selection and View Options

Use these parameters to filter for the data you want to see.
  • Accounting Period is a required prompt.
  • FinU Level 2 is the VC and Level 3 is the School.
  • The FinU Level and FinU Code filters are used independently to produce desired results.
  • The report can be run for different Fund types at Fund Level 3: Contracts and Grants, Core Funds, Other Unrestricted Funds, Restricted Funds.
  • Fund and Project are also user prompts.
  • Selection Values include both Code and Description.

fund summary prompt

Report Views

  • Results display in a table format with subtotals for Project, Fund, Financial Unit, Financial Unit Level 3, and a grand total for Financial Unit Level 2 (Vice Chancellor).
  • Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules.
  • There is an Export link at the bottom of the query to export the report to Excel.
fund summary output