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:

Change to CS Support service hours

Our Support department is closed on Friday, April 28th for a company event. However, limited Workpapers CS phone support is available on that date from 9 AM - 5 PM ET.

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

Top of page

Examples

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

Grouping type: account number

Top of page

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

Top of page

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

Top of page

Grouping type: tax code

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