Audit your vendor database and strengthen Trustpair's analysis by sending us your payment history.

There are 2 files that you can transfer:

Vendor database audit: Complete extraction of your database, according to the format requested by Trustpair (described below).
Payment history: History of payments to your vendors. Details of the format on the next page.

File format and content

Your CSV file must contain all the columns described 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 columns is not important.

File "audit of the vendor database" imported into Trustpair

Please find below an example of an import file:

Header/column name	Content for legal entities	Content for individuals	Description	Example
company_registration_country_code	Mandatory		Country code in format ISO 3166 (2 or 3 car.)	FR or FRA
company_name	Mandatory		Name of the company	Trustpair
company_registration	Mandatory		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
natural_person_country_code		Mandatory	Country code in format ISO 3166 (2 or 3 car.)	FR or FRA
natural_person_tax_number		Optional	Used for countries with tax ID for natural persons	12345678
last_name		Mandatory	Family name	Dupont
first_name		Mandatory	First name	Marie
middle_name		Optional	Middle name of the individual	Jean
other_name		Optional	Other name
birthdate		Optional	birthdate	JJ/MM/AAAA
bank_account_country_code	Mandatory	Mandatory	Country code in format ISO 3166 (2 or 3 car.)	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	123550679
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	019389857
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
supplier_id	Mandatory	Mandatory	Unique identifier of the supplier in your database. Its content should never change for a supplier	Specific to your company
supplier_status	Optional	Optional	Status of the supplier in the database allowing to indicate a deactivated supplier but still present in the supplier database	2 types of values are accepted: empty - provider has not been disabled disabled - supplier disabled_
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`.
company_raw_address	Optional	Optional	Full address of the vendor as a single plain-text string	Single plain-text string like: 4 Rue de Brural, 56450 Theix-Noyalo, 350 Fifth Avenue, New York, NY 10118, United States
tag	Optional	Optional	Pipe-delimited list of tags to assign to the supplier. Tags must be lowercase, digits or hyphens only, and must exist in your Trustpair account.Label used to categorize the supplier in Trustpair	`my-tag-1\|my-tag-2`

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.