Skip to main content

System Status: 

Financial Deficit Report - Operating Funds

The Financial Deficit Report - Operating Funds report highlights YTD deficit balances exceeding $25,000 under Resources Available.

The Financial Deficit Report - Operating Funds report is available from the Business Analytics Hub under the Budget & Financial Management Reports Panorama. Standard Oracle roles are required to access the report.

Business Scenarios

  • The Financial Deficit Report - Operating Funds highlights YTD deficit balances exceeding $25,000 in red cells in the Resources Available column . Any other financial deficit balances display in red font in the Resources Available column.
  • Capital Asset expenditures are included in the calculation for Resources Available.
  • The report is run for a single Accounting period for an individual FinUnit or for any level of the FinUnit Hierarchy.
  • The report groups data by Fund categories based on the Managerial Reporting Fund Hierarchy with the exception of Contracts & Grants/Sponsored Projects which are available on the Financial Deficit Report - Sponsored Projects.
  • Most Funds display deficits at the FinUnit/Fund level only, while Recharge Operating Funds include Project to allow identification of unique recharge activities.
  • Internal Loan Funds 13042 are excluded from this report.

This report answers the following questions:

  • What are the financial deficit balances that exceed $25,000 and must be addressed with a resolution plan according to UC San Diego's deficit policy?
  • What are all the financial deficits balances at the VC, Division, Department or FinUnit level?

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,
  • Level 3 is the Division.
  • Level 4 is Department.  
  • Selection Values include both code and description.  
  • The FinU Levels and FinU filters are used individually to produce desired results. 

    Blink_0915.png

Report Views

Results display in 4 tables:

  • Core Funds
  • Other Unrestricted Funds
  • Recharge Operating Fund 12100
  • Restricted Funds

These fund groupings are based on the Managerial Reporting Fund Hierarchy.

  • For the Core, Unrestricted and Restricted tables, the query displays 11 column labels representing the fin unit level, fin unit and fund.  
  • Five amount columns display the Beginning Net Position, Total YTD Resources, Total YTD Expenses, Ending Net Position, Capital Assets purchased since July 1, 2020, and Resources Available.  
  • For the Recharge Operating Fund 12100 table, the project code and project description columns are added.
  • Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules


    FinDefRpt_01.png

    FinDefRpt_02.png

    FinDefRpt_03.png

    FinDefRpt_04.png