Import and manage data

You can import trial balance, general ledger, and subledger data into your engagement from a variety of sources.

Data import files, such as Excel or CSV files, are referred to as data sources, which you can then configure and assign to a dataset on the Datasets page. Multiple data sources can be assigned to a single dataset. In addition, you can also import unstructured data—data that cannot be readily assigned to any of the existing dataset types—by selecting the Other dataset type. The import source and dataset options available to you vary based on your product.

Any engagement can have several types of datasets, which are collections of data normally found in an engagement. Each dataset stores data related to a different aspect of an engagement and has predetermined fields. See descriptions of datasets and their fields in Dataset types described.

To learn more about importing and managing your data, see these related topics:

• Import data from online accounting software
• Import data from desktop accounting software
• Import from Sage desktop
• Import the client's data from a CSV or Excel file
• Import the trial balance from an engagement file
• Manage your imported data

Data sources and datasets explained, an example

The diagram conceptualizes the differences between data sources and datasets. See also Resolve data import conflicts for more information on how data conflicts can arise and how to solve them.

Dataset types described