Import the client's transactions and other subledger data from a CSV or Excel file

You can import the client’s transaction and other subledger data after importing the trial balance data.

Note that:

To import transactions and other subledger data from an Excel or CSV file:

  1. From the Data page, select the Import tab.

  2. Select Accounting Software or Structured File.

  3. If you’ve previously imported data, select Add data.

  4. If your engagement is consolidated and has internal subsidiary entities, select which entity you want to import data for from the list.

  5. Select either the CSV File Import or Excel File Import option.

  6. In the Add new dataset dialog, browse or drag the CSV or Excel file to the file upload area.

  7. If you uploaded a CSV file, the Select Delimiter dialog displays. Select the Delimiter used in the file, and then select Continue.

  8. In the Configure new dataset dialog, select the Dataset type from the drop-down menu.

    To learn more about the dataset options, see Dataset types. Not all dataset types may be available if they have not been enabled in your product.

  9. Review the automatically selected header row to ensure the correct header has been selected. If you want to manually select the header row, select Adjust header row and select the correct row.

    Note: Both the automatic header detection and manual header selection only take into account the first 30 rows of the imported file. Rows beyond the first 30 rows cannot be selected as a header.

  10. Select Upload.

  11. On the Assign Fields page, you can:

    • Use the drop-downs to manually assign a field to each column in the imported file

    • Use the Select Data Layout drop-down to apply a previously saved data layout and automatically assign the fields. To learn more, see Save a data layout.

  12. If there are any errors, an indicator displays for the columns that contain the errors. You can then select the indicator and the error to view more information about the error and the specific rows that have been flagged.

    The Assign Fields page with an error selected to display the rows with the error.

  13. Select Import.

If you want to reassign the fields later, you can select Options () | Reassign fields on the Datasets page.

If you imported general ledger data, you can view the data in the Transactions tab of the Data page. To learn more, see View the client's transactions.

Note: Any other type of subledger data cannot currently be viewed in the Data page but can be used in analytics tests.

Dataset types

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.