To check vendors, you can use either the form in Trustpair to make one-off checks or you can check small batches by importing files (max. 99 lines).

Here is the format and content expected for this file to check batches :

File format and content

Your CSV file must contain all the columns shown below (they may be empty if the content is not mandatory). To ensure proper processing of the file, the headers (without spaces) must be respected.

Note that the order of the columns is not important.

File "control requests" imported into Trustpair"

Header/column name	Content for legal entities	Content for individuals	Description	Example
custom_id	Mandatory	Mandatory	Unique supplier reference per pair	FG0123
company_registration_country_code	Mandatory		Country code in format ISO 3166 (2 or 3 char.)	FR or FRA
company_registration			National identification number of the vendor	832940670
tax_number			European VAT number	FR40123456824
duns			9-digit identification number issued by the private company D&B	270243120
company_name	Reco - outside of UE		Name of the company	Trustpair
company_raw_address	Reco - outside of UE		Address of the company	174 quai de Jemmapes 75010 Paris
bank_account_country_code	Mandatory	Mandatory	Country code in format ISO 3166 (2 or 3 char.)	FR or FRA
iban	Mandatory - for IBAN zone	Mandatory - for IBAN zone	Supplier's account number in IBAN format	FR7612548029981234567890161
bank_account_number	Mandatory - for non IBAN zone	Mandatory - for non IBAN zone	Bank account number of the vendor	019389857
bic_code	1 of the 2 is mandatory - for non-IBAN zone	1 of the 2 is mandatory - for non-IBAN zone	SWIFT BIC code	WFBIUS6S
routing_number	1 of the 2 is mandatory - for non-IBAN zone	1 of the 2 is mandatory - for non-IBAN zone	Routing number or bank code	Depending on countries Ex: ABA for the US
control_key	Optional	Optional	Control key	Depending on countries
natural_person_country_code		Mandatory	Country code in format ISO 3166	FR or FRA
natural_person_tax_number		Optional	Tax ID for individuals	123345555
last_name		Mandatory	Family name	Dupont
first_name		Mandatory	First name	Marie
other_name		Optional	Other name
middle_name		Optional	Middle name
birthdate		Optional	Birthdate	JJ/MM/AAAA
contact_email		Optional	Email of your contact person	[email protected]
contact_first_name		Optional	First name of your contact person	Jane
contact_last_name		Optional	Last name of your contact person	Doe
contact_department		Optional	Department of your contact person	Enumeration, one of `accounting`, `financial`, `procurement`, `treasury`, `other`.

Template & examples

📘
Please reach out to your Customer Success Manager for an example
If needed, we can provide you with a .csv sheet that displays all the columns required with several examples. You can then duplicate it, fill-it with your extraction file informations and name it according to the conventions above.