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-XXXSubsidiary 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-XXXXXXSubsidiary 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-XXXXXSubsidiary 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.XXSubsidiary 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.XXSubsidiary 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!