Overview
The UCSD Net Operating Results and Fund Balance report provides financial officers and financial managers the overall net financial surplus/(loss) by major fund groups for a particular Vice Chancellor unit, a Division, School, Department or Project. The report is presented in a standard profit and loss statement format and includes the prior year’s carryforward as a beginning balance to provide the user a financial position at any given point in time.
Essential Information
- User roles required to run report are: General Ledger Inquiry and Reporting JR and BI Consumer JR.
- Net Surplus (Loss) calculation: Total Resources – Total Expenses
- Beginning Balance: July 1 carryforward balance
- Ending Balance calculation: Net Surplus (Loss) + Carryforward Balance.
- Report rows use the managerial view of the Account Hierarchy known as the Managerial Reporting Account Hierarchy, not the Standard Financial Account Hierarchy.
- Report columns use the Managerial Reporting Fund Hierarchy, not the Standard Fund Hierarchy.
- Report data is YTD for the selected Accounting Period.
- The report can be run for any of these attributes:
- Current year Accounting Period
- Financial Unit or any level in the Financial Unit hierarchy.
- Project
Next Steps
How to Access and Review the UCSD Net Operating Results and Fund Balance Report
1. Go to BAH
2. Navigate to the Budget & Finance tab, click on the Financial Resource Management Dashboard, and log into Oracle via UCSD Single Sign-On.
3. Under Oracle BI Managerial Reports, select Net Operating Results and Fund Balance, and select Click here to run the Net Operating Results and Fund Balance report in blue hyperlink.
4. In Enter Accounting Period:
a. Enter the Accounting Period directly in the prompt field using the format Mmm-YY, e.g. Sep-21, if entering the Accounting Period directly in the field, it must exactly match the value, e.g. Oct-20, Nov-20, Dec-20, Jan-21, etc.
b. To search for a specific Accounting Period, click the search icon to the right of Accounting Period field.
c. Open the Accounting Period folder.
d. Expand each folder and select the desired Fiscal Year, Quarter, and Month.
e. To move the selected period, click the > icon to the Name Column, if there is an Accounting Period in the Name column that is not desired, select it and use < icon to remove it.
f. Click OK at the bottom of the screen when desired Accounting Period(s) are entered.
5. In Enter Financial Unit, there are two options for entering the Financial Unit:
Option 1 – Enter the 7 digit Financial Unit number directly into the prompt field, recommended method, then click OK.
Option 2 – Search for the Financial Unit or the Financial Unit level using the hierarchy, you can select up to three Financial Units to be included in the report.
a. In Rows Per Page, select 50
b. To the right of the Enter Financial Unit field, click the search icon.
c. Expand FINANCIAL UNIT folder.
d. Expand UCSD_FIN_UNIT_T-UCSD_FIN_UNIT_T_V1 folder
e. Expand 160000A-UC San Diego, this is the top level of the Financial Unit hierarchy.
f. Drill down to the Financial Unit level hierarchy or desired Fin Unit by expanding each level, select the desired level/Fin Unit box e.g. VC CFO unit.
g. Click the > icon in the middle of the screen to move this selection to the Name column.
h. Select the All FINANCIAL UNIT Values on the right side of the screen and click the < icon in the middle of the screen to remove the selection.
i. The Name column should only have the values chosen after this step, when selections are completed, click OK at the bottom of the screen.
6. In the Enter Project field, there are two options for entering the Project Number:
Option 1 – Enter the 7 digit Project Number directly into the prompt field, recommended method, then click OK.
Option 2 – Search for the Project Number using the name.
a. To the right of the Enter Project field, click the search icon.
b. Expand PROJECT folder, you can select up to three Projects to be included in the report.
c. Expand All PROJECT Values folder.
d. In the Find field, select Default.
e. In the Search field, enter a key word between 2 Asterisks and click the search icon.
f. Select the desired Project(s) by clicking in the box, click the > icon in the middle of the screen to move this selection to the Name Column.
g. Select the All Projects Values box on the right side of the screen and click the < icon in the middle of the screen to remove the selection, the Name column should only have the desired Projects Number(s).
h. Click OK at the bottom of the screen when done.
7. Once all prompt selections are complete, click OK to generate the report, the report output defaults to HTML preview.
a. To drill into the account groupings that make up the Total Resources and Total Expenses, click the arrows to the left of the row name.
b. Keep clicking the arrows to drill into the accounts that make up the account groupings.
c. To see the report in PDF or Export to Excel, under HTML Preview, select the desired format.