Financial Deficit Report - Operating Funds
Last Updated: March 8, 2023 1:32:59 PM PST
Give feedback
The Financial Deficit - Operating Funds Report in the Business Analytics Hub displays deficit balances by accounting period for all campus funds, except Contracts & Grants.
The Financial Deficit Report - Operating Funds 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 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?
Data Selection and View Options
Use these parameters to filter for the data you want to see.
- 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.
Report Views
Results display in 4 tabs:
- 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 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.