Tax & Accounting Blog

Using the Client Consolidation Feature in Accounting CS and Workpapers CS

CS Professional Suite Accounting & Auditing Solutions April 7, 2014

Accounting CS and Workpapers CS iconsThe client consolidation feature enables you to combine account and balance data from multiple subsidiary client records into one master client record, while retaining the data in the original client records. This is useful for reporting purposes, and for making comparisons between different companies.

The client consolidation feature also includes diagnostic tools to manage any changes in subsidiary clients. These tools make it easy to spot any subsidiary clients with new or deleted accounts, changes in account balance, or changes in account grouping or tax code assignment.

Creating a New Master Client

The first step in using the client consolidation feature is to create a new master client in Accounting CS or Workpapers CS. Here are the steps to follow:

  1. Choose Setup > Clients, and then click the Add button.
  2. In the Add Client dialog, enter information in the Identification and Address sections.
  3. Accounting CS: In the Services section, mark the Accounting checkbox and/or the Workpapers checkbox. Do not mark either of the payroll checkboxes; the consolidation feature is not available if either of these checkboxes is marked.
    Workpapers CS: Mark the Workpapers checkbox.
  4. In the Consolidation section, mark the Master client checkbox.
  5. Click the Add button to create the consolidation client record.

    Note: Once you’ve created a client, you can’t change its master status. All master clients remain master clients and all non-master clients remain non-master clients.

Consolidating Subsidiary Clients into a Master Client

After you’ve created a new master client, the next step is to choose the subsidiary clients to consolidate into it. Keep in mind that each subsidiary client can be included in only one master client. Here are the steps to follow:

  1. Choose Actions > Consolidate Clients.
  2. Select the master client from the client selection list in the upper-right corner of the screen.

    Note: The client selection list includes only those clients that are not associated with another master client and that meet the consolidation requirements (same fiscal year end and same period frequency).

  3. In the Subsidiary clients list grid, mark the checkbox for each client to include in the consolidation.
  4. In the Grouping Type section, choose the method by which to consolidate accounts. If you choose to consolidate by account grouping, you must also choose the appropriate account grouping and specify whether or not to include subcode detail.
  5. In the Balance Type section, select the method by which to consolidate the account balances, and specify whether or not to consolidate all budget balances from each subsidiary client into the master client.
  6. In the Periods section, select the date range for which to consolidate balances. The drop-down list includes all period end dates for the master client.
  7. Click the Consolidate Selected button.

More information on the consolidation feature is available in our Help & How-To Center.