Importing with entity abbreviation
-
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.
|