Examples of consolidated account balances

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.

Workpapers CS consolidates balances using only the total balances (based on the balance type selected in the Actions > Consolidate Clients screen) for each subsidiary client. If you choose to consolidate by account grouping or tax code, you can combine multiple account balances to create the master client balance.

The unadjusted balance in the consolidated master is comprised of the consolidated balance from all of the subsidiaries. This balance is stored in the Actions > Enter Transactions screen as an activity journal entry.

An activity entry is a regular journal entry that is used to support balances that are not directly created from existing general ledger transactions.

Top of page

Examples

The following examples demonstrate how the application calculates balances when consolidating two subsidiary clients, using the following selections in the Actions > Consolidate Clients screen.

Subsidiary clients do not have existing beginning balances

If one or more of the subsidiary clients do not have an existing beginning balance, the program calculates the balances for a consolidated account by summing the balance of all accounts assigned to the selected account grouping for each subsidiary. For example, the balance for account 1-CA ($35,000) is the sum of the balances for accounts 100 ($10,000) and 105 ($25,000).

Subsidiary client name Account number Account grouping code Report balance (12/31/10) Consolidated account number (Mask=X-XX) Consolidated balance (12/31/10)
Subsidiary A 100 CA
10,000.00
1-CA
35,000.00
Subsidiary A 105 CA
25,000.00
Subsidiary A 200 CL
-15,000.00
1-CL
-20,000.00
Subsidiary A 250 CL
-5,000.00
Subsidiary A 300 EQ
-15,000.00
1-EQ
-15,000.00
Subsidiary A total
0.00
0.00
Subsidiary B 100 CA
15,000.00
2-CA
30,000.00
Subsidiary B 101 CA
10,000.00
Subsidiary B 110 CA
5,000.00
Subsidiary B 200 CL
-50,000.00
2-CL
-50,000.00
Subsidiary B 300 EQ
10,000.00
2-EQ
20,000.00
Subsidiary B 310 EQ
10,000.00
Subsidiary B total
0.00
0.00

Top of page

Subsidiary clients have existing beginning balances

If the subsidiary clients have an existing beginning balance, the program calculates the consolidated balances as follows.

Subsidiary client name Account number Account grouping code Beg. balance (2010) Report balance (CP, 12/31/10) Consolidated account number (Mask=X-XX) Consolidated beg. balance (2010) Consolidated balance (CP, 12/31/10)
Sub A 100 CA
5,000.00
10,000.00
1-CA
11,000.00
35,000.00
Sub A 105 CA
6,000.00
25,000.00
Sub A 200 CL
0.00
-15,000.00
1-CL
4,000.00
-20,000.00
Sub A 250 CL
4,000.00
-5,000.00
Sub A 300 EQ
-15,000.00
-15,000.00
1-EQ
-15,000.00
-15,000.00
Sub A total
0.00
0.00
0.00
Sub B 100 CA
0.00
15,000.00
2-CA
20,000.00
30,000.00
Sub B 101 CA
5,000.00
10,000.00
Sub B 110 CA
15,000.00
5,000.00
Sub B 200 CL
-37,000.00
-50,000.00
2-CL
-37,000.00
-50,000.00
Sub B 300 EQ
2,000.00
10,000.00
2-EQ
17,000.00
20,000.00
Sub B 310 EQ
15,000.00
10,000.00
Sub B total
0.00
0.00
0.00

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 numbers

Share This