Examples of consolidated account numbers

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

Error processing SSI file

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

Core segment

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

Related topics

Consolidating client accounting data overview

Creating a consolidated master client record

Consolidating client account and balance data

Reconsolidating client data

Examples of consolidated account balances

Share This