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:

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.

Data sources in relation to datasets

Element Description
1 One or more data sources can be imported into a dataset. Each data import file is listed as a separate data source. There is a data conflict between ImportFileA and ImportFileB in the data row whose Supplier ID is 1234 in both files. In this case the user has opted to keep the data in ImportFileA.
2 The resulting dataset does not necessarily contain all the data rows from all data sources depending on how any potential data conflicts are resolved.
3 You can view the data making up a dataset by exporting the dataset.

Dataset types described

Dataset type Description
General ledger General ledger transactions
Trial balance A worksheet in which all ledgers are compiled into debit and credit columns in order to ensure a company's bookkeeping system is mathematically correct.
Accounts payable - invoices

The Accounts payable—invoices dataset contains all invoices received during the period under review.
Accounts payable - payments made

The Accounts payable—payments Made dataset contains all payment transactions (check, wire transfer, cash, and so on) made during the period.
Accounts payable - suppliers

The Accounts payable—suppliers dataset contains all details related to the Supplier such as Contact details, address, credit limit and so on.
Accounts payable - open balances

The Open accounts payable dataset contains details regarding all open, unpaid, or unresolved payable transactions as of the close of business on a specified date.
Accounts receivable - invoices

The Accounts receivable—invoice dataset contains all invoices generated during the period under review.
Accounts receivable - cash received

The Accounts receivables—cash received dataset contains all payment transactions (check, wire transfer, cash, and so on) received during the period.
Accounts receivable - customers The Accounts receivable—customers dataset contains all details related to the customer, such as contact details, address, credit limit and so on.
Accounts receivable - open balances The Accounts receivable—open balances dataset contains details regarding all open, unpaid, or unresolved customer transactions as of the close of business on a specified date.
Inventory transactions Captures all transactions affecting inventory accounts during the time period specified (for example, receipts, shipments, transfers, returns, and adjustments).
Inventory on hand Captures the on-hand inventory quantities of items by location and amounts as of the specified date.
Other Unstructured transaction data that does not follow a predefined schema. Select this option to import data that does not correspond to any of the dataset types described here. Each file you import using this dataset type is considered its own dataset.