Examples of consolidated account numbers

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

During the data consolidation process, the application creates new accounts based on the selected grouping type. The application also updates the account mask for the consolidated master client to include a new segment that precedes the account mask for the subsidiary segment.

Subsidiary segment

  • The application creates a segment called Subsidiary and designates it as the Primary segment on the Account Mask tab of the Setup > Clients screen. The mask for the subsidiary segment is XXX.
  • In the Setup > Account Segments screen, the application assigns the subsidiary client number (based on the order in which it is listed in the Subsidiary clients list) as the Code and the subsidiary client name as the Description.
  • For the master client, the code cannot be modified, and no new codes can be added.

Core segment

  • The application creates a segment called Account and designates it as the Core segment on the Account Mask tab of the Setup > Clients screen.
  • The mask for the core segment is based on the grouping type selected in the Actions > Consolidate Clients screen and is comprised of all Xs. When you consolidate by account number, the application creates the mask based on the longest mask of all subsidiary clients. When you consolidate by account grouping or tax code, the application creates the mask based on the longest core account number that will be created from the subsidiary clients.

Examples

The application creates the consolidated mask based on the grouping type selected.

Grouping type: account number

  • The account numbers from each subsidiary become the core accounts in the master client, and the descriptions for the consolidated accounts match the descriptions for the supporting account from each subsidiary. Example
    Subsidiary client name Subsidiary account number Consolidated account number
    Mask = X-XXX
    Subsidiary A 100 1-100
    Subsidiary A 200 1-200
    Subsidiary A 400 1-400
    Subsidiary A 600 1-600
    Subsidiary A 800 1-800
    Subsidiary B 100 2-100
    Subsidiary B 200 2-200
    Subsidiary B 400 2-400
    Subsidiary B 600 2-600
    Subsidiary B 800 2-800
    Subsidiary C 100 3-100
    Subsidiary C 200 3-200
    Subsidiary C 400 3-400
    Subsidiary C 600 3-600
    Subsidiary C 800 3-800
  • If the subsidiary clients use different account formats, the application creates the consolidated accounts accordingly. The mask will be as long as the longest subsidiary account. Example
    Subsidiary client name Subsidiary account number Consolidated account number
    Mask = X-XXXXXX
    Subsidiary A 100 1-000100
    Subsidiary A 200 1-000200
    Subsidiary A 400 1-000400
    Subsidiary A 600 1-000600
    Subsidiary A 800 1-000800
    Subsidiary B 12-100 2-12-100
    Subsidiary B 12-200 2-12-200
    Subsidiary B 12-400 2-12-400
    Subsidiary B 12-600 2-12-600
    Subsidiary B 12-800 2-12-800
    Subsidiary C 100000 3-100000
    Subsidiary C 200000 3-200000
    Subsidiary C 400000 3-400000
    Subsidiary C 600000 3-600000
    Subsidiary C 800000 3-800000

Grouping type: account grouping with no subcode detail

When you choose the Account Grouping option in the Grouping Type section of the Actions > Consolidate Clients screen, the Account Grouping drop-down list includes the description for all account groupings in the first subsidiary client record. If the account grouping names for any of the subsequent subsidiary clients do not match any of the account grouping names for the first subsidiary, the application will not create accounts for that subsidiary, and that client's balances will not be consolidated. Example

Subsidiary client name Account grouping code Consolidated account number
Mask = X-XXX
Subsidiary A CA 1-0CA
Subsidiary A CL 1-0CL
Subsidiary A EQ 1-0EQ
Subsidiary A INC 1-INC
Subsidiary A EXP 1-EXP
Subsidiary B CA 2-0CA
Subsidiary B CL 2-0CL
Subsidiary B EQ 2-0EQ
Subsidiary B INC 2-INC
Subsidiary B EXP 2-EXP
Subsidiary C CA 3-0CA
Subsidiary C CL 3-0CL
Subsidiary C EQ 3-0EQ
Subsidiary C INC 3-INC
Subsidiary C EXP 3-EXP

Grouping type: account grouping with subcode detail

If you mark the Include subcode detail checkbox in the Grouping Type section of the Actions > Consolidate Clients screen, the application creates the account number using both the code and subcode, separated by a decimal. Example

Subsidiary client name Account grouping code Account grouping subcode Consolidated account number
Mask = X-XXX.XXXX
Subsidiary A CA CASH 1-0CA.CASH
Subsidiary A CL AR 1-0CL.AR
Subsidiary A EQ RE 1-0EQ.RE
Subsidiary A INC SALE 1-INC.SALE
Subsidiary A EXP GEN 1-EXP.GEN
Subsidiary B CA CASH 2-0CA.CASH
Subsidiary B CL AR 2-0CL.AR
Subsidiary B EQ RE 2-0EQ.RE
Subsidiary B INC SALE 2-INC.SALE
Subsidiary B EXP GEN 2-EXP.GEN
Subsidiary C CA 3-0CA
Subsidiary C CL AR 3-0CL.AR
Subsidiary C EQ RE 3-0EQ.RE
Subsidiary C INC SALE 3-INC.SALE
Subsidiary C EXP GEN 3-EXP.GEN

Grouping type: tax code

  • The application creates accounts for tax codes that are assigned to at least one account in a subsidiary client. Example
    Subsidiary client name Tax code Consolidated account number
    Mask = X-XXXXX
    Subsidiary A 400 1-00400
    Subsidiary A 425 1-00425
    Subsidiary A 465 1-00465
    Subsidiary A 100 1-00100
    Subsidiary A 200 1-00200
    Subsidiary B 400 2-00400
    Subsidiary B 425 2-00425
    Subsidiary B 465 2-00465
    Subsidiary B 100 2-00100
    Subsidiary B 200 2-00200
    Subsidiary C 400 3-00400
    Subsidiary C 425 3-00425
    Subsidiary C 465 3-00465
    Subsidiary C 100 3-00100
    Subsidiary C 88888 3-88888
  • If a subsidiary client uses custom tax codes, the application creates the consolidated accounts using the custom tax code as the core segment, separated by a decimal. Example
    Subsidiary client name Tax code Consolidated account number
    Mask = X-XXX.XX
    Subsidiary A 400-1 1-400.1
    Subsidiary A 400-2 1-400.2
    Subsidiary A 465 1-465
    Subsidiary A 100 1-100
    Subsidiary A 200 1-200
    Subsidiary B 400-1 2-400.1
    Subsidiary B 400-2 2-400.2
    Subsidiary B 465 2-465
    Subsidiary B 100 2-100
    Subsidiary B 200 2-200
    Subsidiary C 400-1 3-400.1
    Subsidiary C 400-2 3-400.2
    Subsidiary C 465 3-465
    Subsidiary C 100 3-100
    Subsidiary C 200 3-200
  • If a tax code includes a tax code unit for any subsidiary account, the unit will be included as part of the account. The application places the unit before the core segment. Example
    Subsidiary client name Tax code Tax code unit Consolidated account number
    Mask = X-XXXXX.XX
    Subsidiary A 400-1 1 1-01400.1
    Subsidiary A 400-2 2 1-02400.2
    Subsidiary A 465 3 1-03465
    Subsidiary A 100 1-00100
    Subsidiary A 200 1-00200
    Subsidiary B 400-1 2-00400.1
    Subsidiary B 400-2 2-00400.2
    Subsidiary B 465 2-00465
    Subsidiary B 100 2-00100
    Subsidiary B 200 2-00200
    Subsidiary C 400-1 10 3-10400.1
    Subsidiary C 400-2 11 3-11400.2
    Subsidiary C 465 3-00465
    Subsidiary C 100 3-00100
    Subsidiary C 88888 3-88888

Was this article helpful?

Thank you for the feedback!