Fund Balance Report

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.

The Fund Balance Report

1. From the Budgeting/General Ledger menu, click Fund Balance Report.

Fund Balance Report

2. The Report tab is selected by default. If on another tab, click the Report tab.

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.

Fund Balance Report

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.

Fund Balance Report Setup

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.

Fund Balance Report

2. Click the Setup tab.

Fund Balance Report

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 key to save the line of data.

When saved, the line turns blue and the delet button (red minus sign) displays.

Additional Features

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.

Fund Balance 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.

Fund Balance Report

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.

Fund Balance Report

Click the Check all visible link to select all options in the pull-down. Click Clear selected to remove any selections made in the pull-down.

Fund Balance Report

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.

Fund Balance Report

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 on how to use the Filters feature, see the Filters document.

You can also sort data by clicking on any of the headers. Click once for ascending results; click twice for descending results.