GL Fund Balances

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 GL Fund Balances 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 GL Fund Balances tile 
4. Use your Active Directory credentials to sign in, if prompted. 

Here you can find various tips and tricks on navigating Cognos report functionality

• Use these parameters to filter for the data you want to view
• These filters can be used in combination or individually to produce desired results
• All Time Prompts are required. If you plan to schedule this report, select “Yes” and choose Last or Closed Accounting Period.
• Fin Unit prompts are not multi-select. Make a selection for only one of the four Fin Unit prompts: Fin Unit L2 (VC Area), Fin Unit L3 (School/Division), Fin Unit L4, or Fin Unit.
• Fund prompts are cascading. Fund L3 can be filtered by the selection made for Fund L4 and Fund Code can be filtered by the selection made for Fund L3
• This report displays financial statement signage. Positive balances represent funds available to spend. Positive resources and non-operating transfers represent an increase in funds. Positive expenses represent a decrease in funds.
• This report is not recommended for viewing Sponsored Project balances

• Results display in a table with Accounting Period, Fin Unit code and name, and name, Fund code and name, and 9 amount columns
  • Beginning Balance: July 1 Balance for the Fin Unit, Fund, Project combination
  • YTD Resources: July 1 through selected accounting period. These are transactions where the Managerial Reporting Account Hierarchy L3 Code = 'RESRCE'.
  • YTD Non-Operating Transfers: July 1 through selected accounting period. These are transactions where the Managerial Reporting Account Hierarchy L5 Code = 'OTHNOP'.
  • YTD Expenses: July 1 through selected accounting period. These are transactions where the Managerial Reporting Account Hierarchy L3 Code = ' TOTEXP' and excludes non-operating transfers.
  • YTD Capital Assets: July 1 through selected accounting period. These are transactions where the Managerial Reporting Account Hierarchy L3 Code = 'TOTCPT'.
  • Ending Balance: ending balance through selected accounting period.
  • Purchasing Commitments: Includes all PPM Commitments except for purchasing requisitions.
  • Payroll Projections thru June: Payroll projections through June of the fiscal year selected. Regardless of the accounting period selected, this amount will only include projections for open accounting periods.
  • Ending Balance Net of Commitments and Projections: Ending Balance minus PPM Commitments and Payroll Projections. Note that this projected balance will only be accurate for the latest closed month. When running the report for earlier accounting periods, focus on the Ending Balance since that is the actual Ending Balance for the accounting period selected.
• Click on Fund Code and Name to view project-level balances on the GL Project Balances report.

• The report displays a balance for each month up to and including the accounting period selected within the accounting year selected.
• Results display in a table with Fin Unit code and name, Fund code and name, and Ending Balance amounts for each accounting period displayed.
• After updating any of the three prompts, click “Finish” to refresh the report.

• The report displays a balance for the accounting month selected for each accounting year up to and including the year selected.
• Results display in a table with Fin Unit code and name, Fund code and name, and amounts for each accounting month column displayed.
• After updating any of the three prompts, click “Finish” to refresh the report.

1. How can I view a breakdown of the fund balances by project?

2. By clicking on the Fund Code and Name. This will open a new page to the GL Project Balances report.