Restricted Purpose Fund Balance Report
Last Updated on April 23, 2025
Report Summary
Purpose: This report provides summary and details about activity in restricted funds. This report is powered by PowerBI, provides fund balances from Oracle, and bypasses cost center security, which means you will see the current balance in the fund. Funds details are by fiscal year, which runs July – June.
Restrictions: This report is only available to authorized fund managers, and only for the funds that they manage. The report does not include endowed funds or capital projects. When viewing this report, you will only have access to those funds that you manage. If you believe you are missing funds that you should have access to, please email finance@davidson.edu.
Accessing the Report
1. Go to the Davidson Reports tab in Oracle Cloud.
2. Click on the Power BI Reports tile.
3. Click Finance Reports.
4. Click on Fund Balance Report to access the report.
Selecting a Report to View
1. You’ll see a list of funds available to you in the right-hand side of the screen under the title Your funds at a glance.
2. If you’d like to search for a report inside this list, use the Search for Funds feature on the left. Simply type the fund code or fund title and then click the magnifying glass to search. You can also browse the fund hierarchy by clicking on any fund type listed in the white box on the bottom left. Clicking on any fund type will open up a list of funds available in that section.
3. To view details for a fund, click on the fund name in the Your funds at a glance section. Selected fund will highlight in grey. Then, click on the red button that says Click to view details for fund [####] on the left-hand side of the screen.
Viewing Fund Detail in the Report
1. Once you select a fund and click to view details you’ll be taken the to Fund Detail screen.
2. The detail screen has several sections. See below for specifics what what you’ll find in each section.
Fund Balances by Month
Located in the top left of the screen, this section displays a balance sheet with summaries of balances, additions (activity in revenue accounts), deductions (activity in expense accounts), transfers (activity in transfer accounts; accounts starting with 9) and funds available by month, by fiscal year. Click on any year heading in this section to filter data on the rest of the screen to only show data from the fiscal year you select.
Account Activity – All fiscal periods
This section is in the bottom left of the screen and shows a summary of all additions, deductions and transfers for specific account activity within the specified fund. Click on any account to filter data on other parts of the screen to show only activity associated with that account.
Yearly Summary
Located in the top right of the screen, this section provides a quick summary overview for an entire year or year-to-date. Click on any year column to filter data on the rest of the report to show only that year.
Funds Available by Month Chart
This section shows a visual representation of available funds and is located in the middle of the ride hand side of the screen.
Cost Center Activity – All fiscal periods
See a summary of specific cost center activity for the full fund. This section bypasses the usual cost center permissions in Oracle allowing you to see summaries across multiple cost centers. This section is located in the lower right hand side of the screen.
Note: At this time, the report does not include endowed funds or capital projects. When viewing this report, you will only have access to those funds that you manage. If you believe you are missing funds that you should have access to, please email finance@davidson.edu.