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.