Rollup Mask vs. Department Mask (Financial Statement Design)

Sometimes you may want to show balances by department. Other times, you may want to summarize department totals for the main or primary account. The Financial Statement Design window lets you do both.

First, you have to set up your chart of accounts for departments or locations as in the simplified example below.

Account ID

Account Description

40000-11

Sales: Hardware

40000-12

Sales: Software

50000-11

Purchases: Hardware

50000-12

Purchases: Software

Using the above numbers, if you wanted a departmentalized income statement, you could set up a column definition with a department mask of *****-11, to show only totals for the Hardware department, and *****-12 to show the Software department totals.

But, if you wanted to combine totals for both departments into a single Sales and Purchase amount, you could use a Line Description with a Rollup Mask like 40000-** for Sales and 50000-** for Purchases.

If you are using Account Segments in Sage 50 Premium Accounting or higher, the rollup masking feature would work the same way. Masking for the department would be a matter of selecting the appropriate segment from the drop-down list.