Financial Deficit Report - Operating Funds

• The Financial Deficit Report - Operating Funds report gives users the choice of viewing deficits of any dollar amount or only those deficit balances greater than $25,000, $100,000, or $250,000.
• Capital Asset expenditures are included in the calculation for Resources Available.
• The report is run for a single Accounting Period for an individual Financial Unit or for any level of the Financial Unit Hierarchy.
• The report can be run by Project Department Reporting Category.
• 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 report.
• Most Funds display deficits at the Financial Unit/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 $100,000 and must be addressed with a resolution plan according to UC San Diego's deficit policy?
• What are the financial deficit balances that exceed $25,000 or $250,000?
• What are my financial deficit balances YTD? What were my financial deficit balances as of a prior “Closed” Accounting Period?
• What are all the financial deficits balances at the VC, Division, Department, or Financial Unit level?

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

• Accounting Period is a required prompt.
• Display Prompts - Choose One Only:
  • Select $25K if only deficits exceeding $25,000 are to be displayed.
  • Select $100K if only deficits exceeding $100,000 are to be displayed.
  • Select $250K if only deficits exceeding $250,000 are to be displayed.
  • If no selection is made, all deficits regardless of amount will display.
• Financial Unit Level 2 is the VC Area.
• Financial Unit Level 3 is the School.
• Financial Unit Level 4 is the Department.
• Selection Values include both Code and Name.
• The Financial Unit Levels and Financial Unit prompts are used individually to produce desired results.
• Project Department Reporting Category is an optional prompt.
• Use the Last Closed Accounting Period prompt to schedule this report for monthly delivery. More information on how to schedule Cognos reports can be found here.

Results display in 4 tabs:

• Core Funds
• Other Unrestricted Funds
• Recharge Funds
• 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 Financial Unit Levels, Financial Unit, and Fund.
• One amount column displays the Resources Available.
• For the Recharge Funds table, the Project Code and Name and Project Recharge License Numbers columns are added.

Drill-Throughs:

• Users can drill-through on ‘Resources Available’ to launch the GL Balances Report for more details.

Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules.