If your client is using an accounting program (or version) not listed under Accounting Software or if you wish to have more control over the actual import, select the Excel File option under the import menu. Most accounting programs are able to export data directly to an Excel spreadsheet.
There are several advantages to viewing the data in a spreadsheet before importing:
-
You are able to make corrections to the data before it is imported.
-
You may wish to modify an account structure if it is outside of Caseware’s parameters (Division max 6/Account no max 40/Sub-account max 6).
You may wish to break the data into separate spreadsheets in order to import sections (usually divisions or subsidiaries) to different entities within a Caseware file using the consolidation function.
-
To import a MS Excel trial balance go to
Engagement > Import > Excel File.
-
Choose
Chart of accounts and general ledger balances.
-
Browse to the location of the saved client trial balance.
-
Complete the rest of the fields as required. Refer to the
Caseware help (F1) for more information on each option.
Click Next.
-
In the
Specify Data Properties screen, exclude any rows from the import, these can be headings, totals and/or blank rows. Click
Next.
-
In the
Field Details screen, assign a field to each column. Click on the
Ignore column heading and select the field, e.g.
Account Details > Account Number, Balances > Current Year Balance > Opening Balance, etc. Click
Next.
-
The options in the
Advance Specifications screen can be left as is. Refer to the
Caseware help (F1) for more information on each option. Click
Next.
-
The
Account Summary screen shows a list of accounts that have been added or modified in the client file. Click Next.
-
In the Complete Excel Import Wizard screen, select Import to complete the import process.