Import Transactions with Uploaded CSV or XLSX file

Managing your own Transaction Imports can be completed in a matter of just a few steps and a little bit of organization ahead of time.

A CSV file or 'comma-separated value' file is an easy to export and import file type that is standard for nearly all systems to understand. While an XLSX file is standard as modern Excel files. You can easily export from many other systems to these file type, as well as, Microsoft Excel, Apple Numbers, Google Sheets and many other applications or services. With most spreadsheet programs, a CVS or XLSX can be obtained by 'downloading', 'exporting' or 'saving' as CSV or XLSX respectively.

It may be helpful to start with this Transaction/Loan Import Template: Download Here

🚧  When importing dates, to ensure all dates are imported as expected, it's high suggested including the full year, for example: 1/1/1947 and 2/2/2002


Importing Walk-Through

  1. In the Transactions section, look for the button on the upper-right with three vertical dots - Click it and choose, "Upload CSV".

    ImportTransactions1a
  2. A pop-up will appear, allowing us to choose the User for whom we're importing transactions. This is to allow anyone on the team to import transactions on behalf of another user. If we're uploading on behalf of another User on our Team, we'll click the drop-down and choose their name. This will automatically set the Transaction creator to that user.

    ImportTransactions1-2
  3. Next, the screen will be taken over by the Transaction Import screen. At any point, we can click the 'X' in the upper-right corner to return back to the Transactions section.

    ImportTransactions2
  4. From this point, we can either drag-and-drop a file into the browser, or we can click the 'Select file' button to add a file using the normal file manager (File Explorer on Windows, Finder on Mac). See the below animated GIF showing both methods of uploading.

    ImportTransactions3
  5. After a successful upload, we will see a preview of the uploaded document. If the uploaded document does not have a row for Header showing what each column title is, click the link, 'Skip and use alphabets as headers'. If we do have a row for Header, click the 'Continue' button.

    ImportTransactions4a
  6. We can hover over each to preview the data (preview displayed at right side of screen) to make an informed decision. Chances are, the majority of fields will be automatically mapped correctly. However, it's important that we verify each field and the data contained to ensure everything is setup to map correctly. When all fields have been specified, click 'Continue' button. See animated GIF below.

    ImportTransactions5-1

  7. Once we are satisfied with the transaction field mappings, click the 'Continue' button at bottom. This will take us to the final import step - "Review and finalize". In this step, it will display any errors that would keep a new contact from being generated. We can also directly edit any fields before submitting for the final import. In the animated GIF below, we will show a single phone# error and how to remedy.

    Be sure to click the 'Submit' button when we receive the success message!

    ImportTransactions6-1
  8. Once the process is complete (depends on how many contacts are imported and a number of other factors), we will be returned to the Contacts section where we can now find the imported contacts. If there are errors from the import, we will be notified in the 'Import Completed' email and given the opportunity to review those errors.

    It's imperative that when we get to the 'Success' screen, we finalize the import submission by clicking the, 'Submit' button at the bottom.

    ImportTransactions6-1

🌟  If, at any point, you exit the import process - you can return to it and pick-up where you left off. We do not suggest relying on this functionality; it is intended to be a protective feature for accidental or situational exits.

👍  This concludes the importing walk-through.

 



Transaction Fields Available - Linking/Mapping columns to appropriate transaction fields

There are may be times when a column name doesn't match-up automatically with an appropriate contact field, -or- there may not be column names on the document. Here, we will demonstrate how to match those missing field mappings.

While this method does work, it can be more time consuming than simply adding header titles to a spreadsheet before importing.

  1. Using the same import document (CSV) as previously used, but without column names, we will click on, 'Skip and use alphabets as headers'.

    ImportTransactions7a
  2. The next screen will appear similar as a normal import, but now, we must choose the fields to map each data-set to. For the most part, these should be very intuitive. In the below animated GIF, we will show how to link/map each data column to their corresponding transaction field.

    Hover over each Column or corresponding field drop-down to load a preview the data contained within each column of the spreadsheet we uploaded.

    ImportTransactions8a
  3. To view the next steps in importing, click here to jump to the previous section.

👍  This concludes the overview of what transaction fields are available for import.