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.

Note: The Datasets page is not available for data imported from Working Papers or from another engagement. It is available for trial balance data imported from CSV or Excel only if enabled in your product.

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

• Import the trial balance from a CSV or Excel file (old method)

• Import the trial balance from a CSV or Excel file (new method)

• Import data from online accounting software

• Import data from desktop accounting software

• Import from Sage desktop

• Import the trial balance from an engagement file

• Import the client's transactions and other subledger data from a CSV or Excel 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.

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.