Introduction
The Bulk Upload Template for Responders allows you to efficiently submit KYC information in response to a request using a structured spreadsheet.
Rather than entering data manually, you can complete the template with details about:
- Companies (legal entities)
- Individuals (e.g., officers, directors, shareholders)
- Relationships between companies and individuals
Once completed, the file can be uploaded directly to the platform.
Why This Is Important
Providing accurate and complete information helps:
- Speed up the review and approval process
- Minimize follow-up requests
- Ensure compliance with regulatory requirements
- Accurately reflect ownership and management structures
Incomplete or incorrect submissions may result in delays or rejection.
Template Overview
Below is an overview of the template structure:
The template includes:
- Companies
- Officers
- Company Relations
- Officer Relations
- Dropdowns (reference data)
Understanding Mandatory vs Optional Fields
The template includes both mandatory and optional fields.
Mandatory Fields
Mandatory fields must be completed for each record. These are required to:
- Identify companies and individuals
- Establish relationships
- Meet compliance standards
If any mandatory fields are missing, the upload will fail validation.
Optional Fields
Optional fields are not required but are strongly recommended where available.
Providing additional details can:
- Improve data quality
- Reduce follow-up queries
- Support faster verification
How to Identify Required Fields
Refer to the Introduction sheet in the template for:
- Field definitions
- Required vs optional indicators
- Accepted formats and examples
How to Complete the Responder Template
The template is organized into several sheets, each capturing a specific type of information.
1. Companies Sheet
Use this sheet to enter information about each company involved in the request.
Each row represents one company.
Typical fields include:
- Company name
- Registration number
- Country of incorporation
- Address
Ensure that:
- Company names match official registration records
- Each company is entered only once
- Identifiers (if used) are consistent across sheets
2. Officers Sheet
Use this sheet to capture details about individuals associated with companies.
Each row represents one individual.
Typical fields include:
- Full legal name
- Date of birth
- Nationality
- Role (e.g., Director, CEO)
Make sure:
- Names match official identification documents
- Dates follow the required format
3. Company Relationships Sheet
This sheet defines relationships between companies.
Examples include:
- Parent company
- Subsidiary
- Ownership structures
When completing this sheet:
- Reference the correct companies from the Companies sheet
- Ensure relationships accurately reflect the corporate structure
4. Officer Relationships Sheet
This sheet defines how individuals are related to companies.
Examples include:
- Director
- Shareholder
- Beneficial owner
- Authorized signatory
To complete this sheet:
- Ensure the individual exists in the Officers sheet
- Ensure the company exists in the Companies sheet
- Select the appropriate relationship type from the predefined values
5. Dropdowns Sheet
This sheet contains predefined values used across the template (e.g., roles, relationship types, countries).
Do not edit this sheet. It ensures:
- Consistent data entry
- Successful validation during upload
What to Do
- Use only the provided template
- Complete all mandatory fields
- Follow the required formats (e.g., dates, country values)
- Use dropdown values exactly as provided
- Ensure consistency across sheets (IDs and names must match)
- Complete Companies and Officers sheets before relationships
- Double-check all relationships for accuracy
What Not to Do
- Do not delete or rename columns
- Do not modify the Dropdowns sheet
- Do not leave mandatory fields blank
- Do not use free text where dropdown values are required
- Do not reference companies or individuals that are not defined in their respective sheets
It is possible to add new columns to the far right as custom fields (unless it is a relations sheet).
Final Checks Before Upload
Before submitting your file:
- Confirm all required fields are complete
- Verify all relationships are correctly linked
- Check formatting (dates, spelling, codes)
- Ensure no duplicate or conflicting records
- Save the file in .xlsx format