You can import your trial balance directly from a CSV or Excel file into your engagement.
There are several ways to import trial balance data into your engagement. To learn more about other methods, refer to: Import and manage data.
You would import using a CSV or Excel file, if the accounting software package you have is not supported by any of our import utilities. You can export your client data to a CSV (comma-separated value) or Excel file and then import this file to your engagement.
The format of the file can be either .xlsx or .csv and must meet the file requirements for successful import. To learn more, see Prepare a CSV or Excel file to import transactions or subledger data and Date format.
Note: If you are importing a trial balance containing dimensions, see Set up and import a trial balance containing dimensions for more information. This feature may not be available in your product.
After you upload the file, you need to assign the data fields in the file to predefined target fields in a Caseware dataset, to complete the import. To learn more about the dataset options, see Dataset types described. Note that some dataset types may not be available in your product.
In fields where a date is required, date format must be properly set:
To import client data from an Excel or CSV file:
Go to the Data page. The Data page opens to the Datasets tab.
If you’ve previously imported data, select Add data.
If your engagement is consolidated and has internal subsidiary entities, select the entity for which you want to import data from the list.
Under DATA FILE UPLOAD, browse or drag the CSV or Excel file to the file upload area. If the file has already been uploaded to the Documents tab, select Import from Documents, then select it from the list of available documents in the engagement.
In the Configure new dataset dialog, select the Dataset type from the dropdown.
To learn more about the dataset options, see Dataset types described. Note that some dataset types may not be available in your product.
If you are importing a trial balance, in Dataset type, select Trial balance. If planning balances are enabled in your product, select whether you are importing the Final trial balance or a Planning trial balance.
Review the automatically selected header row to ensure the correct header has been selected. If you want to manually select the header row, select Adjust header row and select the correct row.
If you are importing a CSV file and want to change the delimiter to something other than the default comma (,), select Adjust header row and select the correct delimiter.
Note: Both the automatic header detection and manual header selection only take into account the first 30 rows of the imported file. Rows beyond the first 30 rows cannot be selected as a header.
Select Upload.
On the Datasets tab, click Configure to assign columns in the imported data to Caseware fields.
You can assign columns automatically or manually:
To autoassign columns:
After importing your trial balance, from the Assign Fields window, select Assign columns. Columns are autoassigned.
Review the autoassignment. Make any adjustments as necessary.
Note: AI-column autoassignment supports all English-language trial balance data imports. AI-column autoassignment also works on non-English trial balances, but the results will not be as accurate. Always review the column assignment before importing any data.
Columns that are autoassigned with the use of AI will have headers marked with a symbol to differentiate those that are manually assigned or those that are unassigned.
To manually assign columns, on the Assign Fields page,
Use the dropdowns to manually assign a field to each column in the imported file.
Use the Select data layout dropdown to apply a previously saved data layout and automatically assign the fields. To learn more, see Save a data layout.
If there are any errors, an indicator displays for the columns that contain the errors. You can then select the indicator and the error to view more information about the error and the specific rows that have been flagged.
If you are importing a trial balance, select Include zero-balance accounts if you want to include accounts with a balance of zero in the import.
Select Import.
To view the imported data, click View data next to the dataset you imported.
If you imported a trial balance, the Accounts tab appears. If general ledger or any of the subledgers, a new page appears displaying the dataset.
By default, all the columns in your dataset display. Click Columns to deselect those you want to hide.
Click Filters to filter the data displayed in the dataset.
See View the client's general and subledger data, for more information.
When you import or reimport a trial balance, the system overwrites the balances of any existing accounts in the engagement that have the same account number as accounts in the imported file — for example, accounts from a previous import or a user-entered account.
The Partial data imported indicator appears only if some accounts fail to import — for example:
Due to a technical duplication or other validation issue.
Because of a system error such as a timeout.
Note: This article does not address cases where a fresh import file (for example, CSV or Excel files) contains duplicate account numbers within the file itself. To learn more about how to resolve duplicate account numbers in the same import file, refer to Resolve duplicate account numbers in the same import file.
To resolve a partial import:
On the Datasets tab, select the Partial data imported indicator.
A Trial balance data partially imported dialog appears.
Choose one of the following options:
Export a list of duplicate accounts that were not imported, then select Accept to continue with the import.
Accounts with unique numbers are imported regardless of the option you choose.
Warning: Once you select Accept, you can no longer export the list of duplicate accounts.
Select Cancel to close the dialog.
You can correct the duplicate accounts in the source file and reimport the trial balance.
Accounts with unique numbers are imported regardless of the option you choose.
If you reimport after correcting duplicates, any existing accounts that are also in the reimported file are overwritten.
To delete the partial import:
On the Datasets tab, select the View more actions (
) menu next to the imported file.
Select Delete data.
After deletion, correct the duplicate account numbers in the source file and reimport the trial balance.
Where there are two or more identical account numbers in the trial balance you are importing, an indicator is displayed for the columns with errors.
Select the error indicator to view more information about the error and the specific rows that have been flagged.
If the error is related to duplicate account numbers, the Error: Duplicate Values option appears. Select it to view the duplicate values.
The duplicate values are highlighted.
Delete the trial balance and reimport.
Select the Datasets tab.
You are prompted with a warning that you have unsaved changed. Select Discard changes.
Delete the trial balance file you just imported by clicking the Delete icon 
nearest the file.
In the file, remove the duplicate accounts and reimport.