Manage Rollups

You can create multiple rollup sets of data in the Manage Rollups screen of the System folder in the Administration area.

 

There are three types of rollup sets:

 

•The Effective Rate rollup determines how data is rolled up and presented on the Effective Tax Rate report.
•The Deferred rollup determines how data is rolled up and presented on the Deferred Balances report.
•The Trial Balance rollup determines how data is rolled up and presented on the Tax Basis Balance Sheet report.

 

Under each rollup set are rollup buckets that define how data should be tiered on reports. On reports, the rollups are sorted alphanumerically based on rollup bucket codes.

 

To import rollup information, complete the appropriate fields on the #CRU# Component Rollup Sets sheet in the Import Categories template.

 

Note: For more information on importing, refer to the Importing Templates documentation.

 

Screen Entry Fields

Component Rollup Sets

•Name each rollup set. Keep in mind that the name displays in the upper right hand corner of reports.
•The code must start with R and can be any code from R10-R99 that is not being used to identify another rollup set.
•For the rollup set, select whether this rollup is a 1: Deferred Rollup (DEF on the Import template), 2: Effective Rate Rollup (EFF on the Import template), or 3: Trial Balance Rollup (TB on the Import template).
•On the Import template use the code CRS when creating a new component rollup set.

 

Rollups

•Name each rollup bucket. The name can be edited after it is created. The rollup name displays on reports.
•The code is user-defined and can be any combination of alpha and numeric characters, including spaces, up to 60 characters.
•The rollup name and code displays on reports.
•On the Import template, use the code CR when creating a new rollup bucket.

 

Associations

•Each component that is in the categories displays in the Component column. Component types for Deferred Balances, Effective Tax Rates, and Trial Balance differ.
•To associate a component, select the item in the Association list. Available rollups that have been created for the rollup set displays in the drop-down list.
•If a component is not associated with a rollup, it displays as part of an unassigned rollup on the reports. When new components are added in the system, they default to unassigned in all rollups.
•On the Import template, use the code CRR when creating a new rollup association.