How to create a rollup financial statement

For hands-on instruction on designing financial statements, see Designing financial statements training.

1. Select Reports, Financial Statements. Highlight the Income Statement and click the Design button.
2. Locate the Line Description button that corresponds to the section of your Income Statement that you want to rollup (in our example we are going to modify the Income section).
3. Right-click the Line Description button you have selected.
4. Select Properties.
5. In the lower right, select Rollup from the Print field drop-down list.
   Note: If you do not see Rollup in the drop-down list, use the down arrow on your keyboard to find it.
6. In the Rollup Mask field, type the leading digit(s) that represent the account group you are rolling up (income accounts for example) and type zeros for the rest of the digits (as place holders) until you get to the department code. Then type asterisks for the department code. For example: You are interested in rolling up income accounts for all departments. Your income accounts begin with the number 4 and there are a total of 5 digits in each regular General Ledger account number. The department code consists of a dash and one character as the last digit. If you create a Rollup Mask using this criteria the rollup mask would be 40000**.

Note: if you want to change the name of the rollup instead of it just saying the first account ID, change it from ROLLUP in line 5 to "summary" and change the text. It will now roll up with the new text.