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.
What do you want to do next?
- Design a financial statement
- Display a financial statement on the screen
- Filter a report, form, or financial statement
- Print a report or financial statement
- Copy a financial statement format from one company to another
- Set up a rounding account for financial statements
- Perform other report or form tasks
- Learn more about the Financial Statement Design window and object tools