The Fund Balance Report allows users to run the report for information about the balances of specific funds and the accounts linked to said funds identified by the district via the Setup tab.
1. From the Budgeting/General Ledger menu, click Fund Balance Report.
The Report tab is selected by default.
3. To run the report, select the applicable Fund from the pull-down.
4. Select the Fiscal Year from the pull-down.
5. Select the Month for which you'd like to run the report from the corresponding pull-down.
6. Click Run Report.
The Fund Balance Report displays the Balance of the Fund selected according to the report criteria identified.
The report also displays the Revenue section, which displays the Revenue account, Description, applicable YTD Revenue amount, % (percentage), applicable date Budgeted YTD, Projected amount, and Variance
The report displays the Expense section, which displays the Object code, Description of the object, the applicable date YTD Expense, the % (percentage), the applicable date Budgeted YTD, the applicable date Encumbered YTD, the Projected amount, and the Variance.
7. The last two columns of the Revenue and Expense section in the report allow the CFO to enter CFO's Projected Revenue/Expenditures and CFO's Variance. To enter an amount here, click the applicable text field and enter the number. When a number is entered, the data saves automatically.
The page Totals and Grand Totals are displayed at the bottom of each section, depending on the number of results. If there is only one page of results, only the Grand Totals display.
The Setup tab to the report allows users to identify the funds and corresponding accounts that should populate the report.
1. From the Budgeting/General Ledger menu, click Fund Balance Report.
2. Click the Setup tab.
3. In the Fund Map section, enter the applicable Fund using the provided text field.
The Fund text field allows wildcards, such as 01**.
4. Select the applicable Account(s) that should populate the report when the linked Fund is selected. Select as many accounts as needed from the pull-down.
5. Once all information has been identified, press the Enter/Return key to save the line of data.
When saved, the line turns blue and the delet button (red minus sign) displays.
You have the ability to save your report before or after running the report. Click the floppy disk save icon to name and save the report.
a. Name and Save the report.
b. Click the Trash Can icon to delete saved reports.
c. To edit a Report Name after saving, select the report, then click the Blue Arrow next to the Trash Can.
d. In order to generate a saved report, from the Fund Balance Report screen, select the saved report from the pull-down; your report will generate automatically.
Use the Filter text box located in select pull-downs to quickly find a selection. Begin typing the name or number of the data in question to pull it to the beginning of the list.
Click Check all to select all options in the pull-down. Click Clear to remove any selections made in the pull-down.
Select the Exact filter check box to filter results based on text entered exactly.
If there are multiple pages of data, click the Prev and Next buttons to sift through pages. You can also enter a number in the Page text box to jump to a page.
Click the Excel icon in the Export section to export the table of data to an Excel spreadsheet, which can then be saved to your computer.
Click the Printer icon to print the table of data.
Click the Filters button to filter data and apply filter rules.
a. To add more than one filter to a column, click on the green plus sign.
b. To delete an added filter, click on the red minus sign.
c. Select the gray arrow for additional filtering rules.
For more information, see Filters.
You can also sort data by clicking on any of the headers. Click once for ascending results; click twice for descending results.
