How do I Re-Import the Trial Balance if the Previous Import was Incorrect?

If the accounts have not been mapped within CaseWare, complete the following steps:

1. From the File tab, select Copy Components to display the ’Copy Components Wizard’ dialog.
2. In the Copy Components Wizard, select Copy Into This File.
3. In the Select Source screen, click on the Audit System or FinancialsIFRS template then click Next.
4. In the Copy Components screen, select The following components, then tick the Trial Balance checkbox.
   
5. Click the Next button.
6. Click the Next button again on the Clearing Components screen.
7. Click Finish.

If the accounts have been mapped within CaseWare, and a re-import for the same period is required, complete the following steps:

1. From the Engagement tab, select Import > ASCII Text File or Excel File (this will depend on the original import process) to display the ’File Import’ screen
2. Select the same settings from the previous import.
3. Within the ’Field Details’ screen:
1.  Right click on the column that contain the account numbers, and select Account Details | Account Number.
2. Right click on the column that contain the period balances to re-import, and select Balances | [same period].
4. Click the Next button.
   
5. Within the Advanced Specifications | Account Options area, tick the Clear Balances of Period(s) Being Imported checkbox.
   
6. Complete the import process.

If the accounts have been mapped within CaseWare, and the incorrect period was selected, complete the following steps:

1. Launch Microsoft Excel and open the import file.
2. Edit the import file by adding a new column with zero balances as the last column.
3. Save the import file.
4. From the Engagement tab, select Import > ASCII Text File or Excel File (this will depend on the original import process) to display the ’File Import’ screen.
5. Select the same settings from the previous import.
6. Within the ’Field Details’ screen:
1. Right click on the column that contain the account numbers, and select Account Details | Account Number.
2. Right click on the column that contain the zero balances, and select Balances | [incorrect period].
3. Right click on the column that contain the period balances, and select Balances | [correct period].
7. Complete the import process.