How do I Re-Import the Trial Balance if the Previous Import was Incorrect?
Article ID: 77 | Rating: Unrated | Last Updated: Mon, Jan 4, 2016 at 12:25 AM
If the accounts have not been mapped within CaseWare, complete the following steps:
- From the File tab, select Copy Components to display the ’Copy Components Wizard’ dialog.
- In the Copy Components Wizard, select Copy Into This File.
- In the Select Source screen, click on the Audit System or FinancialsIFRS template then click Next.
- In the Copy Components screen, select The following components, then tick the Trial Balance checkbox.
- Click the Next button.
- Click the Next button again on the Clearing Components screen.
- Click Finish.
If the accounts have been mapped within CaseWare, and a re-import for the same period is required, complete the following steps:
- 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
- Select the same settings from the previous import.
- Within the ’Field Details’ screen:
- Right click on the column that contain the account numbers, and select Account Details | Account Number.
- Right click on the column that contain the period balances to re-import, and select Balances | [same period].
- Click the Next button.
- Within the Advanced Specifications | Account Options area, tick the Clear Balances of Period(s) Being Imported checkbox.
- Complete the import process.
If the accounts have been mapped within CaseWare, and the incorrect period was selected, complete the following steps:
- Launch Microsoft Excel and open the import file.
- Edit the import file by adding a new column with zero balances as the last column.
- Save the import file.
- 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.
- Select the same settings from the previous import.
- Within the ’Field Details’ screen:
- Right click on the column that contain the account numbers, and select Account Details | Account Number.
- Right click on the column that contain the zero balances, and select Balances | [incorrect period].
- Right click on the column that contain the period balances, and select Balances | [correct period].
- Complete the import process.