Warning
Product support for the ended on September 30, 2020.
- Write Up CS
- Payroll CS
- Engagement CS
- Client Bookkeeping Solution
- Financial Analysis CS
Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.
The Creative Solutions Accounting software enables you to consolidate selected clients into a single (parent) client that has already been set up and flagged as a Consolidation Client.
First you must create and save the Consolidation Client (by marking the Consolidation Client checkbox on the General Information tab of the File > New Client dialog or the File > Client Properties dialog, to flag it as the parent client). When you are ready to begin the consolidation, open the Consolidation Client and then choose Consolidate Clients from the File menu.
Fields & buttons
All clients in your CSAData folder are listed here except the Consolidation Client (parent) and those already listed in the right (Selected) pane.
Double-click a client to select it for consolidation into the current Consolidation Client.
All clients that have been selected for this client consolidation are listed in this pane.
To remove a client from the Selected list, double-click it.
Mark one or more of the following checkboxes to indicate the type of information to be included in the consolidation:
- Current-period only
To include all payroll information for employees and vendors from the subsidiary clients but only current-period GL or Trial Balance transactions and Chart of Accounts balances, mark this checkbox. (Note that all current-period transactions in the parent client will be deleted except those entered in the Consolidation Adjustments Journal.)
Note: Only the balances for the current period will be part of the consolidation when the Account Balances Only checkbox is marked on the General Information tab of the File > New Client dialog or the File > Client Properties dialog.
- Non-payroll data only
To exclude payroll data such as employee and vendor information, mark this checkbox.
Note: This checkbox is marked by default when the Account Balances Only checkbox is marked on the General Information tab of the File > New Client dialog or the File > Client Properties dialog.
- Account Groups
To overwrite current Account Group information for the (parent) Consolidation Client, mark this checkbox. Not applicable for a Payroll CS-only client.
- Transmittal Letters
To overwrite current Transmittal Letter definitions for the (parent) Consolidation Client, mark this checkbox.
- Financial Statements
To overwrite current Financial Statement definitions for the (parent) Consolidation Client, mark this checkbox. (Not applicable for a Payroll CS-only client.)
- Retain existing accounts (available only when consolidating account balances only)
To retain the current Chart of Accounts and journal entries for the (parent) Consolidation Client, mark this checkbox. When marked, only the account balances are removed and replaced each time a consolidation is performed. If new accounts exist in the subsidiary client, then these accounts are added to the (parent) Consolidation Client.
If this checkbox is unmarked, the Chart of Accounts and all journal entries will be deleted during the consolidation process. The Chart of Accounts will be created based on the options selected, and the journal entries will need to be re-entered when the consolidation process is complete.
If this checkbox is marked and you have previously consolidated the client at least once with the Account Balances Only checkbox left unmarked (on the General Information tab of the File > New Client dialog or the File > Client Properties dialog), you will be prompted by the program to continue to replace all previously consolidated transactions and balances with new amounts, or to discontinue the consolidation process.
- Combine Employees
To combine employee records from the subsidiary clients during client consolidation, based on matching SSNs, mark this checkbox. (We recommend preparing an Earnings Report for each subsidiary client, with the Missing W-2 Info option included for each report to indicate whether any employees are missing an SSN or have duplicate SSNs.) Also see Combining employee information during client consolidation.
Choose one of the following options for a Trial Balance CS-only consolidated client:
- Grouping Type
Select one of the available Grouping Schedules (1-5) or Account Number (default) from the drop-down list to include in the consolidation process.
- Include Subcode Detail
Mark this checkbox to include subcode detail for the subsidiary client in the consolidation process. This checkbox is available only if a Grouping Schedule (1-5) is selected from the Grouping type drop-down list.
Note: The Grouping type drop-down menu and the Include Subcode Detail checkbox are not available (grayed) when the Retain Existing Accounts checkbox is marked.
- Balance Type
Select one of the following balance types from the available drop-down list to be consolidated from each of the subsidiaries. This will become the new unadjusted balance in the (parent) Consolidated Client:
- Adjusted
- Report
- Tax
- Other
- Budget
- Adjusted Budget
Related topics
Overview of client consolidation
Overview of client consolidation with account balances Only
Consolidating clients
Combining employee information during client consolidation