Map accounts to account groups

Use the Accounts to account group map page to see if any accounts have not been assigned or have been assigned twice.

In the Account to account group map view, your chart of accounts is directly associated with account names and groups. This correlation makes it easy for you to determine not only to which group the account is assigned, but also whether any accounts have not been assigned, or have been assigned twice.

You make the initial correlation using the Account Groups view, and then use the Account groups hierarchy report to check your work.

To access the report, go to General Ledger > All > Reports > Account groups hierarchy.

You make the initial correlation using the Account Groups view, and then use the Account to account group map view to check your work. To make edits after you have finished checking your list in the Account to account group map view, select Flip view again to return to the Account Groups view, and then select Members.

To access this page, go to General Ledger > All > Financial report structures > Account groups. In the Account Groups list, select Flip view to see the Account to account group map view.

View a list of accounts mapped to account groups

Subscription

General Ledger

Regional availability

All regions

User type Business, Employee, Project Manager, and Warehouse
Permissions

Account Groups: List and View

Use the Account Groups Hierarchy report to make sure that your account groups are mapped correctly.

  1. Go to General Ledger > All > Reports > Account groups hierarchy.

  2. Select filters and other options.

  3. Select View to generate the report as a web page.

    Or select Print to generate a PDF.

For more information, see About the Account Groups Hierarchy report.

  1. Go to General Ledger > All > Financial report structures > Account groups.

  2. Select Flip view at the top of the page.

    • This displays the Account to account group map view, which lists all of your accounts with the account groups to which they belong.

    • If the Account group name column is blank, the account isn't mapped to any account groups.

Another way to see if your account groups are mapped correctly is to run the Account Group Hierarchy report.

Add an account to an account group

How you add an account to an account group depends on the type of account group you're adding it to. If you're on the account groups mapping list, select Flip view to return to Account Group Information.

Subscription

General Ledger

Regional availability

All regions

User type

Business, Employee, Project Manager, and Warehouse
Permissions

Account Groups: List, View, Add, Edit
Account group options
Structure type Add members

Accounts

Specify the discrete GL accounts you want this account group to consist of. You can:

  1. Select a range of accounts. Select the From account down arrow and then select an account from the list that appears. Then select the To account down arrow and select an account.
  2. Enter a specific account ID, if you know it, in the data entry boxes.
  3. Select Add to group.

Statistical accounts

Specify the discrete GL statistical accounts you want this statistical account group to consist of. You can:

  1. Select a range of statistical accounts. Select the From account down arrow and then select an account from the list that appears. Then select the To account down arrow and select an account.
  2. Enter a specific account ID, if you know it, in the data entry boxes.
  3. Select Add to group.

Groups of account groups
  1. Specify the discrete account groups you want this account group to consist of. Select the Account group down arrow and then select an account group from the list that appears. To filter the list for a specific type of account:
    1. Select the Account group purpose down arrow.
    2. Select the purpose to filter for.
    3. Select the account group from the list.
  2. Select Add to group.
  3. Specify another account group, and so on, until you've included all the groups you want in this account group.

Computation
  1. On the left side of the equation, use the top of the 2 boxes to specify a constant, a single GL account, or an account group. These are discrete account groups you want this account group to contain. Select the Account group down arrow and select an account group from the list that appears.
  2. Repeat this for the right side of the equation.
  3. Specify whether you want to add, subtract, multiply, or divide.
  4. Set the display options. Use display options to define the number and unit of measurement for the computation. The options include decimal places, type such as number or percentage, unit, and alignment.
    For example, you could set:
    • 0
    • number
    • each (unit)
    • right
    to display the item as x each using only whole numbers, or set:
    • 2
    • number
    • R
    • left
    to display the item as R x.
  5. Specify another account group, and so on, until you've included all the groups you want in this Computation Account Group.
Some operators (add, subtract, multiply, divide) aren't compatible with all display options. For example, addition, subtraction, and multiplication can't be displayed as a percentage.

Categories

Applies only to companies that were created using a setup template.

Specify the discrete category you want this account group to consist of. However, you can't modify categories or create new ones, you must choose from the predefined list.

Select the Category down arrow and then select an account category from the list that appears. Then select Add to group.

You can repeat this as often as you like, until you've added all the accounts you want to this group.

Using a Services setup template? By default, the categories "Manpower" and "Direct Materials" are assigned to account groups that are only used in the reports "Project Profitability" and "Project Estimation versus Actual." These two categories don’t appear in balance sheet reports or income statements. If you’ve assigned any accounts to these two categories that you also want to show up in your balance sheet, income statement, or other reports, assign these categories manually to the appropriate account groups.

Statistical categories

Specify the discrete statistical category you want this account group to consist of. Select the Category down arrow and then select a statistical account category from the list that appears. Then select Add to group.

You can repeat this as often as you like, until you've added all the accounts you want to this group.

Field descriptions

The following table describes each field in the Account to account group map page.

Fields

Account to account group map page field descriptions
Field Description

Account no.

The primary and subaccount numbers assigned to this account.

Account title

The title name of the account group as entered in the Account Information page. You can edit the title.
Account group name The name of the account group to which this account is mapped.

Buttons

Buttons field descriptions
Field Description

Flip view

Display the Account Groups list view. Shows the Account Number, Account name, and Account Group name.

Done

Go back to the Account Groups list view.
Export Export the list of account group mapping to Word, Excel, CSV, or PDF.