Set Up Account Set Totaling and Indenting

On the Account Sets and Account Set Analysis pages, you can group and indent the display of account sets, which provides a better viewing experience and allows totals to be set up and viewed for a group.

For account sets that have an Account Set Type of Total, you must specify a value in the Totaling field.

When you indent account sets, an indent is applied to the account set Description field of rows that have an Account Set Type of Posting and that are between rows that have an Account Set Type of Begin-Total and End-Total. Also, When you indent, the Totaling field is automatically populated on account sets that have an Account Set Type of End-Total.

Important

Important:
Indenting must be performed after totals are set up so that subtotals are correct depending on where Begin-Total and End-Total rows have been specified.
Indenting overwrites the values in the Totaling fields for rows that have an Account Set Type of End-Total. When you indent account sets, you must enter the values in Totaling fields again.

To set up account set totaling

  1. Choose Lightbulb that opens the Tell Me feature., enter account sets, and then choose the related link.

    The Account Sets page opens.

  2. To add a row for a heading or total, on the action bar, choose New, and then specify a Code and a Description.

    Rows are sorted in ascending order by Code.

  3. For each row, in the Account Set Type column, specify the purpose of the account set in regards to totaling.

    The following options are available:

    • Posting: Specifies that the account set is used for posting and is to be included in totals.
    • Heading: Specifies a description of the lines that are totaled below and is used for grouping purposes.
    • Total: Totals a series of balances on account sets from many different account groupings.
    • Begin-Total: Indicates the beginning of a series of accounts to be totaled. The series ends with the next account set that has an Account Set Type value of End-Total.
    • End-Total: Indicates the ending of a series of accounts to be totaled. The series starts with the preceding account set that has an Account Set Type value of Begin-Total.

  4. For each row that has a value of Total or End-Total, in the Totaling column, specify how the total is defined.

    The value can be an account interval or a list of account set codes. The entries of the account set are totaled to provide a total balance. How entries are totaled depends on the value in the Account Set Type field.

  5. For each row, in Direct Posting, specify whether the account set can be posted to directly. This field is hidden by default. To learn how to make this field visible, see Personalize Your Workspace.

To indent account sets

  1. Choose Lightbulb that opens the Tell Me feature., enter account sets or account set analysis, and then choose the related link.

    The Account Sets or Account Set Analysis page opens.

  2. On the action bar, choose Indent Account Sets.

    A dialog box appears and displays the following text:

    This function updates the indentation of all the Account sets in the account set analysis. All account sets between a Begin-Total and the matching End-Total are indented one level. The Totaling for each End-total is also updated.

    Do you want to indent the account set analysis?

  3. Choose Yes.

See also

Account Sets

Feedback

To send feedback about this page, select the following link:

feedback-product-docs@sparkrock.com