You are here: Help Topics > Engagements > Mapping and grouping > Groupings database

Groupings database

Use this database to create and customize your leadsheet and grouping schedule documents. You can create leadsheet numbers prior to creating these documents as they are independent of the document numbers.

To access the Groupings database, on the ribbon, click Engagement | Groupings. To display hidden columns, right-click a column header and click Reorder Columns.

Column Description
Number Enter a unique number for the leadsheet or group containing up to 40 alphanumeric characters.
Name

Enter a name for the leadsheet or group number. Click ... to enter an extended description.
Title Select to use the leadsheet or group number as a title in reports. You cannot assign accounts to title group numbers. Changing an existing group number to a title will unassign any assigned accounts.
Sign Select a normal sign for the leadsheet or group number, either Credit or Debit.
Type

Select the type of statement where the leadsheet or group number is applicable.

  • Balance Sheet (B)
  • Income Statement (I)
  • Statement of Cash Flow (S)
  • Performance (P)

Adjusting journal entries made directly to an Income Statement type leadsheet or group number will be included in the Net Income on all automatic documents in the group. If the leadsheet or group number type is changed to or from Income Statement, then a full repost is completed to update the Net Income adjusting entry.
Behavior

Select the grouping behavior:

  • Normal: Accounts can be assigned to the leadsheet or group number.
  • Calculated: Perform a calculation for accounts that have a calculated behavior in their leadsheet or group number. Individual accounts cannot be assigned to a calculated group number.
  • Unassignable: Accounts cannot be assigned to the leadsheet or group number.
Class Select the ratio class to use for calculating financial ratios, conducting analytical review, and preparing the Summary of Uncorrected Misstatements document. For more information, see Ratio classes.
L/S (Flip) Select the applicable leadsheet to use if an account is flipped.
Group 2-10 (Flip) Select the applicable group to use if an account is flipped.
Flip Type

Select a display method for the flip number.

For more information, see Set up flips.
Calculation

Enter a calculation to assign multiple accounts or a range of accounts to the leadsheet/group number.
Tags Displays the grouping tags applied to the leadsheet or group number. Click + to add a new tag.

Visit us: www.caseware.com | Follow us: LinkedIn Facebook Twitter YouTube

© 2020 CaseWare International Inc. | Privacy | Terms of Use | Trademarks