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 data from online accounting software
- Import data from desktop accounting software
- Import from Sage desktop
- 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 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.
|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.|
|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. |