Financial Deficit Report - Operating Funds

Access has been provisioned to anyone with the Oracle BI Consumer JR role.  Staff who do not have access should request the Oracle role. Access failure appears as error "Unable to load requested view. Displaying home view instead."

1. Navigate to bah.ucsd.edu. 

2. Select Budget & Finance. 

3. If using the List View, look for Financial Deficit Report - Operating Funds in the list or use the search bar at the top right and click the dashboard name  

   • If using the Card View, click the Financial Resource Management Dashboard tab and click Launch on the Financial Deficit Report - Operating Funds tile 

4. Use your Active Directory credentials to sign in, if prompted.

Use these parameters to filter for the data you want to see.

These filters can be used in comination or individually to produce the desired results.

• Accounting Period is a required prompt.
• Select Yes to only display deficits over $25K; if no selection, all deficits will display.
• Financial Unit Level 2 is the VC.
• Level 3 is the School.
• Level 4 is Department.
  
• Selection Values include both code and description.  
• The FinU Levels and FinU filters are used individually to produce desired results.
  

• The Financial Deficit Report - Operating Funds gives users the choice of viewing deficits of any dollar amount or only those deficit balances greater than $25,000.
• 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?

Results display in 4 tabs:

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

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

• For the Core, Unrestricted and Restricted tables, the query displays 10 column labels representing the fin unit level, fin unit and fund.
  
• Six 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.