How to export your data from Ondorse?

Last updated: November 28, 2025

The Export feature lets you download all your application data (also called cases) into a single Excel (.xlsx) file. This export gives you a complete, structured view of applications, related entities, and associated documents—useful for audits, reporting, reconciliation, and offline analysis.

You can find the export interface by clicking your name in the bottom left, accessing Settings > Import / Export and navigating to the tab Export.

Your export file contains four tabs:

1. applications

2. related_persons

3. related_businesses

4. documents

Each tab presents specific information about your cases. Below is a detailed explanation of what you’ll find in each one.

Applications tab

This tab includes all core information about each application in your account.

Basic application information

  • account_id – Your account’s identifier

  • id – Unique application ID (e.g., AN1234)

  • application_external_reference – Your internal reference

  • application_typeperson (KYC) or business (KYB)

Main Entity Information

Depending on the application type, the corresponding entity fields are populated.

For KYB (business)

  • business_id

  • plus built-in business fields such as: name, country, registration_number, legal_type, registration_date, VAT number, phone number, IBAN, and closure information.

For KYC (person)

  • person_id

  • plus canonical person fields such as: given names, last name, email, nationalities, phone number, gender, birth details, PEP status, and account access.

Address Information

Depending on how data was entered or imported, address data may appear in either single-line or multi-line formats:

  • address_country

  • address_single_line

  • address_line_1

  • address_line_2

  • address_building_number

  • address_street

  • address_town

  • address_state

  • address_postcode

Trading Address (KYB only)

Same fields as above, prefixed with trading_.

Custom Fields

Any custom fields configured on your account appear with the prefix:

custom_field.<field_name>

Examples:

  • custom_field.has_hq_in_belgium

  • custom_field.emea_business_unit

Compliance & risk Information

Includes the most recent risk assessment:

  • risk_level – UNSET, LOW, MEDIUM, HIGH, or FORBIDDEN

  • risk_score

  • decision_last_refreshed_at

  • decision_next_refresh_at

  • onboarding_date

Portal information

Information about the latest portal request:

  • last_portal_request_status

  • last_portal_request_created_at

  • last_portal_request_closed_at

  • portal_url

  • portal_contact_email_address

Assignee

  • assignee_user_email

  • assignee_user_fullname

Relationship Counts (KYB only)

Overview of related entities (excluding the main business itself):

  • related_party_count

  • related_person_count

  • related_business_count

  • ubo_count

  • shareholder_count

  • director_count

  • account_owner_count

Risk Rules

Risk rule columns appear at the end in the format:

[Risk] <Rule Name> (<Rule ID>)

Each contains the score produced by that rule during the most recent evaluation.

Empty cells mean the rule did not run for the application.

Related persons tab

This tab lists all non-primary persons associated with your applications (e.g., directors, UBOs, signatories).

Basic person information

Includes account_id, application_id, person_id, and personal details (names, email, nationalities, PEP status, etc.).

Address Information

Same structure as in the Applications tab.

Relationship with the Application

Filed only if the person is directly linked to the application:

  • roles – DIRECTOR, SIGNATORY, SHAREHOLDER, UBO

  • direct_ownership_percentage

  • appointed_on

Relationships with other entities

The other_relationships field lists additional links (in JSON format) to other entities within the application structure.

Custom fields

Same logic as in the Applications tab.

Related businesses tab

This tab contains data about related businesses that are not the main business of the application.

Basic business information

Includes identification and core business fields (name, country, registration number, legal type, registration date, VAT number, phone number, IBAN, cessation details, etc.).

Address information

Same structure as other tabs.

Trading address

Same fields, prefixed with trading_.

Relationship with the application

Filed only if the business is directly linked:

- roles – DIRECTOR, SIGNATORY, SHAREHOLDER

- direct_ownership_percentage

- appointed_on

Relationships with other entities

Listed under other_relationships (JSON format), excluding the direct relationship with the application.

## Custom Fields

Configured per account.

Documents Tab

This tab lists all documents associated with applications or related entities.

Note: The export does not include the document files—only the metadata. To get the files, reach out to the support.

Document information

  • account_id

  • document_id

  • external_reference

  • document_name

  • document_type

  • issuing_country

  • expiry_date

  • validity (unset / valid / invalid)

  • document_invalidation_motive_code

Attached entity information

The document is either attached to an application, a person or a business. Depending on this, these columns will be filled:

  • application_id + external reference

  • person_id + external reference (if applicable)

  • business_id (if applicable)

Links

  • document_details_url – Opens the document details page in Ondorse (not a download link)

Additional Notes

  • Columns appear in the exact order shown in this guide.

  • Empty cells indicate missing or non-applicable data.

  • Lists (like nationalities or roles) appear as comma-separated values.

  • Dates are formatted to YYYY-MM-DD hh:mm:ss from UTC timezone