Summary Groups Tab of the Account Tables Form

Use the Summary Groups tab to associate each summary account group with one or more detail account groups.

You can think of the summary account group as the parent to all detail account groups associated with it. The detail account groups define which accounts are included. You can also use this tab to specify how account group table information prints on general ledger reports.

The availability of some options on this tab depend upon your security access rights. See your system administrator if you have questions.

Summary Account Groups Grid

Field Description
Test Setup

Each detail account group should belong to a summary account group. This option works in conjunction with the Exclude from Report Total option.

When you click Test Setup, the following things happen:

  • Vantagepoint displays a list of all detail account groups not currently assigned to a summary account group.

    If a detail account group is assigned to a summary account group, but the summary account group is marked for exclusion from report totals, the detail account group displays in the list of "missing" detail account groups.

    Amounts for accounts associated with any detail account groups not included in a summary account group display in the Other column on the General Ledger reports. However, if the summary account group is marked for exclusion from report totals, corresponding child account amounts are not included in the Other column.

  • Vantagepoint checks for duplicates, which in this case are detail account groups assigned to more than one summary account group.

Vantagepoint considers account group assignments as duplicates only the Exclude from Report Total option is not selected for either summary account group to which the detail account group is assigned. In other words, the list does not include a detail account group assigned to two summary account groups if one of the summary account groups is included in report totals and the other summary account group is excluded from report totals.

Sort Order Enter a number that indicates the order in which account groups display on reports.
Account Group Name From this drop-down list, select a summary account group name. This name displays as a label on general ledger reports.
Exclude from Report Total Your setting for this option for the summary account group overrides the corresponding setting for its constituent detail account groups.

Select this option to define subtotals on general ledger reports without those subtotals impacting the bottom line. If you run the Test Setup option, any account assigned to an account group marked for exclusion from report totals displays in the list of accounts not yet assigned.

Do not select this option if you want accounts to impact the bottom line.

This option affects the Balance Sheet, Income Statement, and Profit Planning Monitor.

Show Account Detail Use this option to specify whether or not the detail account groups associated with the current summary account group display on general ledger reports.

Select one of the following settings from the drop-down list:

  • Yes: The names of the detail account groups display beneath each summary account group on the report. This setting overrides any settings on the report's Sorting/Grouping section.
  • No: The detail account groups do not display on the report. This setting overrides any settings on the report's Sorting/Grouping section.

This option does not affect the display of account names and numbers on the report. To control their display, use the Show Account Detail option on the Detail Groups tab (of Account Group Tables).

This option affects the Balance Sheet, Income Statement, and Profit Planning Monitor.

Group Total Select one of the following settings from the drop-down list:
  • Yes: Display a total for the summary account group on the report if more than one account is included in the definitions for any associated detail account groups. The total displays under the account group name. This setting overrides any settings on the report's Sorting/Grouping section.
  • No: Do not display a total for the account group on the report. This setting overrides any settings on the report's Sorting/Grouping section.
  • Report: Display a total on the report only if you select it on the account group record on the Sorting/Grouping section for the report.

This option affects the Balance Sheet, Income Statement, and Profit Planning Monitor.

+ Add Summary Account Group Click this option to add a new summary account group name to the grid.
Delete Select a grid row, and click to remove the summary account group name from the account group table.

Detail Account Group Name in Summary Account Groups Grid

Use this grid to associate one or more detail account groups with the summary account group. When you select a row in the Summary Account Groups grid, the title of this grid changes to reflect the current account group name selection.

Field Description
Detail Account Group Detail account groups that you created on the Detail Groups tab are available from the drop-down list for this option. You must set up the detail account groups, including your designations of which accounts are associated with the detail account groups, before you can associate them with a summary account group here.

If you attempt to select a detail account group that is already associated with another summary account group, Vantagepoint displays a warning message.

+ Add Detail Account Group Open an account group table and click this option to insert a detail account group name for the summary account group table.

The detail account groups that you specify are considered sub accounts of the summary account group. This means that all accounts named as part of each detail account group belong to the summary account group.

Delete Select a grid row and click to remove the detail account group name from the summary account group table.