Importing from Excel
 
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.