Campus & Department Assessment Reconciliation Report

Access the Report through the Business Analytics Hub

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 Campus & Department Assessment Reconciliation Report in the list or use the search bar at the top right and click the dashboard name  
   • If using the Card View, click the Budget & Financial Management tab and click Launch on the Campus & Department Assessment Reconciliation Report tile 
4. Use your Active Directory credentials to sign in, if prompted. 

• Enter project number, fiscal year, and accounting period to specify the project and timeframe for the report.
• Input projected deans office tax assessment and department tax assessment to obtain projected balances in the details section of the report.

• Provides an overview of general ledger balances, project assessments, and projected balances based on fiscal year data.
• Allows users to assess the organization's financial standing, evaluate project profitability, and gain insights into future financial performance.
• Offers access to more detailed project and assessment information in specific report sections, providing a comprehensive view for decision-making and analysis.

Report View

• Detail sections display taxes calculated for Differential Income (DI) and ASSA, showcasing the different tax sets that each service agreement goes through. These sections provide a breakdown of the calculated DI and ASSA amounts and show the total that should be charged by CBO (Central Billing Office).
• There is typically a one-month lag between the total amount and the actual DI+ASSA figures. This lag allows for the necessary time to reconcile and finalize the calculations accurately.
• The Detail sections also include specific assessments, such as the Dean's Office/Department Assessment Rate, which is calculated based on the assessment rate entered in the report's prompt. This rate is used to populate the corresponding row for the Dean's Office.
• Additionally, there may be Systemwide assessments or UCOP (University of California Office of the President) assessments specific to the VCHS (Vice Chancellor of Health Sciences) included in the Detail sections.
• The Detail sections provide a comprehensive view of the total balance, including both actual and projected assessments, allowing users to track and analyze the financial impact of the taxes across different categories or departments.

Report View

Revenue Page: 

• Shows transactional level detail for project revenue. 
• Provides a comprehensive view of all revenue-related transactions, offering detailed information about each transaction. 
  

Report View

Assessments Page: 

• Shows transaction level information for actual assessments. 
• Provides a comprehensive view of assessment-related transactions, offering detailed information about each assessment. 
• The SLA Line event description provides transaction number details specifically related to differential income and charges. 

Report View