Dividing the existing trial balance into different worksheets
-
Add the entities to the consolidation structure in the
Engagement > Consolidate dialog.
-
Import the client trial balance into a spreadsheet program (e.g. Excel).
-
Break the trial balance into separate worksheets.
-
Import each worksheet individually to each entity in Caseware by selecting
Engagement > Import > Excel File.
-
When you click
Next on the
Assign Entity screen, you will be prompted to assign the unassigned account numbers to an entity.