The Budget Monitoring Report compares the budget numbers for the selected cycle with the previous and following cycles. It can be run for expenditure, revenue, or fund balance accounts, as a summary or with detail, with or without sub-totals, and with or without encumbrances. The Excel file can be produced with each fund on a separate tab.
The report is reached by selecting Reports > Budget and can be created as a CSV, Excel, or PDF file.
The subtotal elements tell the report which type of element to sum up. For example, if you select Fund as the 1st subtotal element, every time the fund changes on the report, it's subtotaled. The names of the elements that make up your current account structure are available to select.
The subtotal rollup levels allow you to specify on which level in the hierarchy to subtotal. For example, if the hierarchy in Element Value Maintenance shows Object codes from 1100 to 1109 with 1109 being the lowest in the hierarchy, you could select Lowest to ensure 1109 and 1101 will be subtotaled on the report. If you wanted to include 1109 and 1101 in the subtotal for 1100, you would select Highest.
Selections in these fields determine the amount of detail provided for the subtotals that appear on the report.
Fields included on the report are: Element ID & description, previous year, selected year, & next year amounts, sub-totals, and grand total.
Cycle
Account code expression filter — all or selected
Account type — expenditure, revenue, or fund balance
1st - 5th subtotal element — none or selected
1st - 5th subtotal rollup level — none, highest, lower, middle, detailed, or lowest
1st - 5th detail element — none or selected
1st - 5th detail level — none, highest, lower, middle, detailed, or lowest
Include encumbrances — no or yes
Next year budget — current or proposed
Fund to separate tab — no or yes
Sample report for expenditure accounts with sub-totals on fund & function and detail for function & object
Return to Budget Reports Overview