What information do I need to add to my Centtrip Global recipient import file?
Here’s a guide to all the columns in the recipient import template.
Importing Recipients
Here’s a guide to all the columns in the recipient import template
Field |
Description |
Validation Requirements |
|---|---|---|
Nickname |
Short reference for the recipient |
Required, maximum 100 characters. Must be unique. |
Company Name |
If this is a company, enter the company name. |
Required if First Name and Last Name is empty, maximum 100 characters. |
First Name |
If this is an individual, enter the first name. If this is a company, leave it blank. |
Required if Company Name is empty, maximum 50 characters. |
Last Name |
If this is an individual, enter the last name. If this is a company, leave it blank. |
Required if Company Name is empty, maximum 50 characters. |
Date of Birth (YYYY-MM-DD) |
The date of birth of the individual. If this is a company, leave it blank. |
Optional, but will often speed up the payment. Enter the value in the format provided (YYYY-MM-DD). DD/MM/YYYY will also work. |
Recipient Street 1 |
The first line of the address of the recipient. |
Required, maximum 250 characters. |
Recipient Street 2 |
The second line of the address of the recipient. |
Optional, maximum 250 characters. |
Recipient City |
The city of the recipient. |
Required, maximum 50 characters. |
Recipient State |
The US state of the recipient. |
Required for USA payments. |
Recipient Postal Code |
The postal code of the recipient. |
Required, maximum 30 characters. |
Recipient Country |
The country of residence of the recipient. |
Required. CSV requires the 2 characters ISO format. For XLS you can enter the code or the country name (or select the country name from the list in the template). |
Reference |
Default entry for the reference for payments made to this recipient. |
Optional, maximum 70 characters. Accepted characters: a-z A-Z 0-9 / - ? : ( ) . , ‘ + space The reference must not start with : or - |
Reason |
Default entry for the reason for payments made to this recipient. |
Optional. Must be one of the following: Payment of invoice Payment to own account Inter-company transfer Property Investment Salary Expenses Redemptions Subscriptions Other In the XLS template you can select from a list. |
Currency |
The currency you will be paying this recipient in. |
Required, three character currency code. In the XLS template you can select this from a list. |
Bank Account Country |
The country of the bank account you will be paying to. |
Required. CSV requires the 2 characters ISO format. For XLS you can enter the code or the country name (or select the country name from the list in the template). |
Account Number / IBAN |
The IBAN of the account (or account number for domestic payments). |
The requirements for this vary from country to country. It will be checked dynamically as part of the import. Maximum 30 characters. |
Sort Code / BIC / SWIFT / Routing Code |
The BIC/SWIFT of the account (or sort code for domestic payments). |
The requirements for this vary from country to country. It will be checked dynamically as part of the import. Maximum 100 characters. |