Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Consolidate client data

Consolidated account numbers example

Subsidiary segment

  • The application creates a segment called Subsidiary and designates it as the Primary segment on the Account Mask tab in the Clients screen. The mask for the subsidiary segment is XXX.
  • In the Account Segments screen, the application assigns the subsidiary client number (based on the order it's listed in the Subsidiary clients list) as the code and the subsidiary client name as the description.
  • For the master client, the code can't 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 in the Clients screen.
  • The mask for the core segment is based on the grouping type selected in the Consolidate Clients screen and is comprised of all Xs. When you consolidate by account number, the application creates the mast 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.

Example: Account number grouping type

  • 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.
  • 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.
Subsidiary client name
Subsidiary account number
Consolidated account number (Mask is 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

Example: Account grouping with no subcode detail grouping type

When you choose the Account Grouping option in the Grouping Type section of the Consolidate Clients screen, the Account Grouping field includes the description for all account groupings in the 1st subsidiary client. If the account grouping names for any of the other subsidiary clients don't match any of the account grouping names for the 1st subsidiary, the application won't create accounts for that subsidiary, and that client's balances won't be consolidated.
Subsidiary client name
Account grouping code
Consolidated account number (Mask is 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

Example: Account grouping with subcode detail grouping type

If you mark the
Include subcode detail
 checkbox in the Grouping Type section in the Consolidate Clients screen, the application creates the account number using both the code and subcode, separated by a decimal.
Subsidiary client name
Account grouping code
Account grouping subcode
Consolidated account number (Mask is 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

Example: Tax code grouping type

  • The application creates accounts for tax codes that are assigned to at least 1 account in a subsidiary client.
  • 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.
  • 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.
Subsidiary client name
Tax code
Tax code unit
Consolidated account number (Mask is 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

This article applies to:

  • Subject: Consolidations

Related content