Rollup Report

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.

Subtotaling account codes

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.

Detail elements & levels

Selections in these fields determine the amount of detail provided for the subtotals that appear on the report.

The report contains the following information:

Fields included on the report are: Actuals for the selected range, adopted budget, current budget, YTD actuals, YTD encumbrances, available, and % of budget.

Report filters are:

• 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