CSV Downloads & Uploads

Within the Entities section, the user has the ability to import entities (2 or more) to be added to the solution or the ability to extract from the solution in an CSV format.

 
Download CSV (1)

The Download CSV ability enables the user to gather all or a portion of the entities that have been entered into the solution.

Once the Download CSV has been selected, a pop-up screen will appear

A. The first option allows you to Download the filtered results via CSV format

B. the second option provides the ability to Download the CSV with no filters applied

C. The third option exhibits the status of the main Entities page, highlighting any chosen entities that are set to be filtered out.

Once the Download CSV has been selected, the Preparing CSV Download pop-up will be displayed. The CSV will be emailed to the current user that requested it or you can go to Administration -> Files Management -> CSV -> Under the Exports section, select the Download button beside the export request done.

 
Filter (2)

Selecting the Filter option on the main Entities dashboard area allows for the narrowing down of the listings of the entities displayed and the same results can be exported into a CSV file.

Date - With the ability to filter by date, the user can select a date range for the results & export to match the entities entered into the system, within the specified date range

Next KYC Review - By utilizing the date filtering feature, users can specify a date range for their search results, ensuring that the exported data matches the entities entered into the system during the designated time frame

Entity Type - The Entity Type filter enables the user to select the entities entered into the system by a Natural Person or Legal Entity

Status - This filter enables the user to select the entities by their status: New, Review, Escalated, Approved, Rejected, and KYC Refresh

Country - The Country filter enables the user to select 1 or more countries, instead of all countries

Risk Levels - This filter enables the user to select the Risk Level that was assigned to each Entity from 1-5

Assigned To - This filter enables the user to filter all entities that were assigned to be reviewed by a specific system user

Tags - This filter enables the user to filter by the Tags that were assigned to each entity

 
Upload CSV (3)

The ability to Upload CSV in the solution enables the user to do a bulk upload of entities to be added to the system.

A. Predefined Templates are available to be downloaded for ease of use to upload to the solution. The templates are either for Natural Persons or Legal Entities

Natural Persons Template Fields: FirstName, LastName, Nationality, DateOfBirth, Phone, Email, Street, City, StateProvince, Country, PostalZip, KYCStatus, AddCase, Title, Next KYC Review, Affiliated With, Roles, and Ownership %. (Note: The last five fields are optional)

Legal Entity Template Fields: Name, DateOfIncorporation, CompanyPhone, Street, City, StateProvince, Country, PostalZip, KYCStatus, AddCase, Business Number, Next KYC Review, Affiliated With, Roles, and Ownership %.(Note: The last five fields are optional)

Establishing an affiliation between a Natural Person and a Legal Entity:

In the Natural Person CSV template, when you add an entry that includes the Business Number of an existing Legal Entity in the "Affiliated With" column while specifying Roles and Ownership, the system will identify the specified Legal Entity, and the Natural Person entity will then be added as an affiliated entity for the identified Legal Entity.

Establishing an affiliation between two Legal Entities:

Similarly, in the Legal Entity CSV template, when you add an entry that includes the Business Number of an existing Legal Entity in the "Affiliated With" column while specifying Roles and Ownership, the system will identify the specified Legal Entity and the Legal Entity will then be added as an affiliated entity for the identified Legal Entity.

To avoid formatting errors, transfer your data to the downloaded CSV template and ensure that the date format follows the Year-month-date convention with dashes (ie. 1978-01-21).

TIP - With the addition and the selection under AddCase, if entered Yes to add a case, the entities will be screened and a case will be created to be reviewed.

B. Once the user has populated the CSV file, they would then locate that file and then select Upload CSV. When the Upload CSV is selected, the above screen will display a summary of the CSV contents for review. Selection of the Confirm Upload CSV will proceed to process the CSV file to populate the entities into the solution.

When the CSV has been selected to be uploaded into the solution, the system will email the user with the results and this will include if any errors were found during the processing of the CSV file. The user can also go within the solution to review the result via Administration -> Files Management -> CSV -> Imports