Manage your imported data

You can manage your imported data from the Datasets tab on the Data page. From this page, you can delete imported data from file-based sources such as Excel or CSV, as well as from online or desktop accounting software. In addition, you can save data layouts for data imported from CSV or Excel. A data layout captures how fields are matched from the incoming import file to Caseware fields in a dataset. Any data layouts you save can be reused for data imported into other engagements. You can also export datasets.

Delete data

You can delete a data source or dataset if necessary. When deleting the data imported for a trial balance, you only have the option to delete the whole dataset, not individual sources contributing to the dataset. As a result, the deletion confirmation dialog will be more detailed describing the data being deleted and how it may affect your engagement results. When deleting data imported for a general ledger and subledger, you have the option to delete the entire dataset or individual sources that make up the dataset.

To delete a data source or dataset:

  1. Go to the Data page. The Data page opens to the Datasets tab.

    1. For a trial balance: you can only delete the whole dataset.
    2. For a general ledger and subledger: you can delete the whole dataset or individual sources that make up the dataset.
  2. Select More actions () | Delete data if you are deleting a data source or More actions () | Delete dataset if you are deleting a dataset.

    For a trial balance:

delete entire dataset of a trial balance

Dialog for deleting the trial balance dataset.

For a general ledger:

Option to delete dataset of a general ledger.

Deleting data within a dataset for a general ledger.

Dialog box to delete the general ledger dataset.

Export a dataset

You can export datasets to CSV files.

To export a dataset:

  1. Go to the Data page. The Data page opens to the Datasets tab. Navigate to the data source or dataset you want to export.

  2. Select More actions () | Export dataset.

You can also export data sources with the Other dataset type by selecting More actions () | Export data.

Save a data layout

After you import data from a CSV or Excel file and assign the fields, you can save the data layout. You can then use the data layout for future imports to avoid manually assigning fields for files that share the same structure. Data layouts that you save can also be used for imports in other engagements.

To save a data layout:

  1. Navigate to the data source and select Save in the Data Layout column.

    The Save option for a data source on the Datasets page.

  1. In the Save data layout dialog, enter a Data layout name, then select Save.

Saving a data layout (assignment of incoming fields to Caseware fields).

The data layout is now available in the Select data layout dropdown when you assign fields for a data source.

Selecting a data layout (assignment of incoming data fields to Caseware fields).

If you want to delete a layout, you can select Delete () next to the data layout in the Select data layout dropdown. Note that a layout can only be deleted by the person who created it or by a firm administrator.