Financial Deficit Report - Sponsored Projects

• The Financial Deficit Report - Sponsored Projects 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.
• The report is run for a single Accounting Period for an individual Financial Unit (corresponding to the Project Owning Org in PPM) or for any level of the Financial Unit Hierarchy.
• The report also allows for searching by PI/PM/TM, Fund Manager, and Fiscal Manager.
• The PPM subledger data presented in the report is divided into three sections:
  • Open = includes all projects where Project Finish Date is greater than today's date
  • Ended = includes all projects where Project Finish Date is less than or equal to today's date
  • All = includes all projects where Project Finish Date is less than or equal to or greater than today's date

NOTE: PPM Budget column does not include Unbudgeted Amounts – please contact your SPF Award Accountant if budget displays as $1. Costs do not include Commitments. PPM Budget Balance calculation includes amounts for Internal Cost Sharing.

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?
• Which sponsored projects are currently in deficit within my Financial Unit?
• Which sponsored projects within my Financial Unit have ended and need deficit cleanup for project closeout?
• Which awards are managed by a specific Project Manager? By a specific Fund Manager? By a specific Fiscal Manager?

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

• Accounting Period is a required prompt.
• 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.
• Select from Project Personnel prompts such as PI/PM/TM, Fund Manager, or Fiscal Manager.
• 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 3 tabs:

• Sponsored Projects: Ended Projects
• Sponsored Projects: Open Projects
• Sponsored Projects: All Projects

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.

Drill-Throughs:

• Users can drill-through on ‘Project Code and Name’ to launch the Expanded Project Summary Report for more details.
• Users can drill-through on ‘Award Number and Title’ to launch the Project Management Dashboard 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.