Balances By Category Report

The Balances By Category Report offers detailed Fixed Assets information summed up by categories defined by the district. The report can be set to run by Fiscal Year and can also be filtered by specific Facilities, Categories, and/or Disposition Codes. Once generated, the report lists data by each Category (and associated Capitalized Code).

The Balances By Category Report

1. From the Fixed Assets menu, click Balances By Category Report.

The Balances By Category Report screen displays with several options to generate the report.

2. Start by selecting the Fiscal Year from which you’d like to pull data. The Fiscal Year will default to the current year.

3. Select a Facility if you want your report to be restricted to one or specific facilities.

Notice that the pull-downs allow you to choose one, multiple, all, or none. You can also utilize the Check all visible and Clear selected links. For a quick search, use the Filter text box to begin typing the name or number of the facility. Note: These features are available on most pull-downs.

Balances By Category Report

4. Select the categories to be displayed in the report from the Category pull-down.

Balances By Category Report

5. Select the applicable Disposition Code(s) from the pull-down, such as Active, Sold, Stolen, etc.

Balances By Category Report

6. Select a general ledger account from the GL Account pull-down assigned to any category via the Debit Account or Credit Account pull-down setup via Fixed Assets > Categories.

Balances By Category Report

7. Enter the corresponding codes to run the report based on account elements, such as a specific Fund, Function, Object, etc.

Balances By Category Report

All of the fields shown on this screen are optional except the Fiscal Year. Depending on what information you need to see in the report, you can run the report with all fields blank. Note: Running the report blank may take longer due to the amount of data being pulled.

8. When all selections have been made, click Run Report.

The report lists the Category, Capitalized Code, Noncapitalized Code, and the Beginning Balance As Of 07/01/20XX for filtered fixed asset information first.

The next four columns list the Additions (Including new assets), Additions (Only new assets), Dispositions, and Depreciation of Disposed Assets for filtered fixed asset information.

The last three columns list the Ending Balance As Of 06/30/20XX, Current Year Depreciation, and Accumulated Depreciation As Of [current year], Accumulated Depreciation As Of [previous year].

Click Toggle Columns to customize the reports and determine which columns should be displayed. To hide a column from the report, clear the selected check box. To include the column, select the check box.

Balances By Category Report

At the bottom of the page, the Current Page Totals is listed. The totals here will change as you sift through pages. In the image shown, the Current Page Totals is just for page 1. Note: The Grand Totals will remain the same regardless of what page is displayed; this is showing the Grand Totals for all data generated.

The amounts shown are totals for the Beginning Balance As Of 07/01/20XX column. The $15,562,018.58 represents the Current Page Totals for the Beginning Balance As Of 07/01/20XX. The $24,734,292.54 below represents the Grand Totals for the Beginning Balance As Of 07/01/20XX.

If you use any of the filters to change the data, the Current Page Totals and Grand Totals will change. See Additional Features for more information on how to use filters.

Additional Features

You have the ability to save your report before or after running the report.

a. Click the floppy disk Save icon to name and save your report.

b. You can also 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 Balances By Category Report screen, select the saved report from the pull-down; your report will generate automatically.

To navigate through the listed pages, click the Prev and Next buttons. To jump to a specific numbered page, type the number in the page text box and press Enter.

Click the Excel icon in the Export section allows you to export the report to an Excel spreadsheet. Click the icon to download the file.

Click the Printer icon in the Export section as shown in the image above. Depending on browser settings, this will generate a print preview where you will have the ability to change the layout, print two-sided, etc.

Click Filters to further breakdown your report without having to change the report criteria and rerun the report.

a. To add more than one filter to a column, click the green plus sign.

b. To delete an additional filter, click the red minus sign.

c. For additional filtering options, click the gray arrow for a filter pull-down.

See Filters for more information.