Skip to main content

System Status: 

  1. Home
  2. Finance
  3. BI & Financial Reporting
  4. Exceptions and Reconciliation

Exceptions and Reconciliation

Last Updated: April 12, 2024 12:42:42 PM PDT
Give feedback

Find out about business scenarios, data selection, report view options, and data definitions for Department Exceptions and Reconciliation reports, available under Budget & Finance in the Business Analytics Hub (bah.ucsd.edu).

Panoramas and Dashboards in this section include:

Panorama/Dashboard Description
Assessment Reconciliation Report The Assessment Reconciliation Report helps users reconcile assessments like Differential Income and ASSA that are charged on certain revenues. The report calculates the assessments that should be charged and compares them to actual assessments. A GL Balance Summary includes uncharged assessments to provide a projected balance.
Closed Projects with GL Balance PPM allows for projects to be closed regardless of the balance of any chart string on the GL. This report displays projects that have been closed in PPM but still have a balance on one or more general ledger accounts.
Cost Share Reconciliation This dashboard helps departments identify issues related to cost share that should be resolved.
Department Exceptions Panorama This panorama is designed to highlight the transaction discrepancies and errors in the Oracle financial system.
GL-PPM Reconciliation This report displays differences between amounts in General Ledger and amounts in PPM.
Graduate Student Funding Report

This report allows users to:

  1. Verify funding sources for payroll, tuition, fees, and stipends across multiple terms/years by graduate student, department, fin unit, and project.
  2. Discern how a student is funded over their tenure as a graduate student.
  3. View data as individual transactions, summary for each student by accounting period, or both.
Project Setup to GL Match Errors

This report looks at the Project Owning Organization (Financial Unit) that is assigned upon Project setup in PPM with General Ledger transactions for the same Project. It will detect any GL transactions with a Financial Unit that does not match the Project Owning Organization in PPM.
Transactions on No Project

Use this report to identify UCPath, Concur, or Oracle transactions that were recorded without a project segment in the General Ledger. If these transactions belong on a project, it is important to identify and correct them in a timely manner.

Resources

  • View the Report Index for more specific guidance on which report or dashboard to run based on your case.