Import the client trial balance into a spreadsheet program (e.g. Excel).
Insert a new column into the spreadsheet.
Apply an entity description to each GL account. If a pre-existing file it needs to match the existing entity in Caseware.
Import the Excel spreadsheet under Engagement> Import > Excel File making sure to include the entity column.
Assign the Entity Abbreviation field to the inserted column in the Field Details screen.
The account numbers are automatically mapped to the entities based on the the entity abbreviation.
If the entity abbreviation does not match any of the abbreviations in the client file (Engagement > Consolidate), Caseware will create a new entity with the new abbreviation. Use the Account > Assign Entity dialog to move the account numbers to the correct entity if necessary.
