Use the Rollup Report to generate data for financial statements, such as monthly or quarterly reports, income statements, etc. You specify the element to subtotal, the element rollup level for the subtotal, and the amount of detail to include with the subtotal amounts.
The report is accessed from 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: Actuals for the selected range, adopted budget, current budget, YTD actuals, YTD encumbrances, available, and % of budget.
Cycle
Begin & end dates
Account code expression filter — all or selected
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
Subtotal on account type — no or yes
Include encumbrances — no or yes
Return to General Ledger Reports Overview