The Budget Status Report v2.x allows you to customize your view of the data in several ways. Not only can you select preconfigured reports, such as the Budget Status by Department, Fund, and Account, but you can also use filters to add or remove the data seen in the view. You also have the ability to drill into the displayed money values to view transaction data.
In this article, you willl learn the steps to set the parameters for running the Budget Status Report and to customize the data view.
This article uses the Budget Status by Department, Fund, and Account view.
First, log into the Budget Management System
The Summary by Department, Fund, and Account tab is the first tab that you see after accessing the Budget Status Report.
From this page, you can set your filter parameters for the rest of the report.
To set the Department filter, click the Department dropdown list.
The list of departments is displayed. Select the appropriate department(s).
Example shown here: Department " 14023456 ".
If you wish to exclude the existing department filter(s) for running the report, deselect the existing department filter(s).
Example shown here: deselect " 14012345 ".
Click the Department filter dropdown button again to close the menu.
Continue to modify the existing filters.
To set the Budget Reference filter, click the Budget Ref Descr dropdown list.
Select the appropriate Budget Reference from the list.
Example shown here: " 2019 ".
To set the Fiscal Year filter, click the Fiscal Yr dropdown list.
Select the appropriate fiscal year from the list.
Note : The Bud Ref and the Fiscal Year should be the same.
The data view on the left has been updated to match the filters that you have set.
You can right click on the various pieces of data to bring up a pop-up window with additional information.
Example shown here: Personal Services Expense row
A floating window shows options for viewing the data. You can keep the selected line only or exclude the selected line. In addition, you can navigate to the detail tab or go to the transaction list for the selected row.
To go to the detail tab with your selected information, click the Go to Detail link.
Detailed information about the selected row is displayed.
To expand the account tree to show the Level03 account codes, hover over the UGAACCTTREE Level02 header and click the Expand [+] button.
Continue to expand out to the lower level account codes.
To expand out to the Level04 account codes, hover over the UGAACCTTREE Level03 header and click the Expand [+] button.
If you wish to view additional details about a money value, hover over the cell. A floating window will show detailed information associated with the value, such as Fund and Account codes.
Example shown here: " $9,215.18 " on the 522100 - Salaries-Staff line was selected. You can review detailed information in the window.
You can also view the transaction list for the selected money value.
Click the Go to Transaction List link.
The Transaction List associated with the selected money value is displayed. On this page, you can sort the data by selecting different filters.
Example shown here: Sort button on the Estimated Revenue column.
Click the title of the selected column for sorting the data.
Example shown here: Estimated Revenue column title.
The selected column is a light blue color. In addition, a pop-up window is displayed. You can keep only the selected column or exclude the selected column.
Example shown here: Exclude option.
The selected column has been removed from the data view.
Continue to select columns and apply either the Keep Only or Exclude option.
Example shown here: Recognized Revenue column title.
The selected column is a light blue color. From the pop-up window, you can choose to keep only the selected column or exclude the selected column.
Scroll to the bottom to see the Grand Total line.