Import the client's transactions from a CSV

If you're using desktop or online third-party accounting software, you typically get the option to choose to import transactions data as you import the trial balance data.

If you're importing the client's transactional data from a CSV file, you must import the trial balance data before you import the transactions.

Go to the Import tab in the Data page and select Import Transactions CSV.

To successfully import transactions from a CSV file:

  1. Prepare the CSV file.
  2. Import the CSV file.
  3. Map the fields.
  4. Save the data layout.
  5. Optionally, import additional transactions.

Step 1: Prepare the CSV file

Make sure the transactions CSV file is valid. The validity requirements display in the page once you select Import Transactions CSV. To learn more, see Prepare the transactions CSV file.

Based on the data analytics feature enabled in your product, you may need to include specific data in the CSV file to ensure the feature functions correctly. To learn more, see Mandatory fields for importing transactions.

Step 2: Import the CSV file

  1. Drag and drop the file or browse.

    Drag and drop here or browse the CSV file

  2. Select the desired field Delimiter type.

    Available options:

    • Comma (,)
    • Tab (\t)
    • Vertical Bar (|)
    • Semicolon (;)
    • Record Separator (\u001e)
    • Unit Separator (\u001f)
  3. Select Continue.

Step 3: Assign data fields

You must assign the source fields in the CSV file to predefined target fields that match the data, so they properly display in the Transactions tab in the engagement.

The figure below explains what data assignment means. When the source field in the CSV file "nr" is assigned to "Entry Number", the values of the column will display in the Entry Number column in the Transactions tab. Similarly, the values for "cw_js" will display in the Document Type column, and so on.

Transaction file tagging example

To assign the source fields in the CSV file:

  1. Select ASSIGN DATA FIELDS.

    Assign data fields

    The page splits into two sections. The upper section shows the source fields from the CSV and the lower section shows the data in each field.

  2. Use the available drop-downs to select a target field to assign each source field in the CSV.

    The main categories and their respective fields display in the drop-downs.

    For field descriptions, see:

    Tip: Move your cursor to a specific field to view a description of it to help you assign the values correctly. You can also find specific target fields using the search field at the top of the drop-down menu.

    Move your cursor to a specific field to view a description of the field so you can do correct mapping. If you know the target field, use the Search field at the top to find it.

  3. If value mapping is required for a specific field, the MAP COLUMN VALUES drop-down displays at that field.

    1. Select the MAP COLUMN VALUES drop-down.

    2. Specify your selections, then click outside of the drop-down menu when you're done.

      The following figure shows an example of field value mapping for DOCUMENT TYPE. Note that DOCUMENT TYPE has been mapped to the cw_js field in the source CSV file. In the process of value mapping, the target value General Ledger Entries (GJ) is mapped to GJ from the CSV file.

      Value mapping for originating_document_type.

  4. Once you finish the mapping process, select the Import button () to complete the import.

    Tip: You can restart the mapping process if needed using the CHANGE DATA FIELDS button on the Import Transactions page.

To view the account transactions you've just imported, open the Data page and select the Transactions tab. To learn more, see View the client's transactions.

Step 4: Save data layouts

You can save the layout of the data field assignment you've just completed. This allows you to reuse the structure you've initially defined in subsequent transaction reimports.

To save a DATA LAYOUT:

  1. From the Import Transactions page, select SAVE from the DATA LAYOUT column.
    Import transactions page - save data layout
  2. Enter a Data Layout Name in the Save Data Layout dialog, for example, Standard Import.
    The DATA LAYOUT name is updated on the Import Transactions page.

    Now, when you select ASSIGN DATA FIELDS or CHANGE DATA FIELDS, a drop-down containing available layouts displays.
    data layout drop-down

To select a different DATA LAYOUT, select the drop-down and select the desired data layout from the list that displays.

To delete a DATA LAYOUT,

  • From the SELECT DATA LAYOUT drop-down, select the delete icon beside the desired Data Layout.

A layout can only be deleted by the person who created it.

Delete data layout