Payees Template
The following table lists the fields in the payees template. All values input to the template are case sensitive.The maximum file size allowed is 20 MB (~20,000 payees).
If you have more than 20,000 payees to import, you need to split the file and import each file separately.
Field Display Name | isMandatory? | Description | Field data type | Level | Value Display Names |
---|---|---|---|---|---|
ACH account number | No | The payee’s account number | String | Header | |
ACH account type | No | The payee’s account type | List | Header |
|
ACH bank name | No | The payee’s bank name | String | Header | |
ACH Name on account | No | The payee’s account name | String | Header | |
ACH routing code | No | The payee’s routing code | String | Header | |
Alias | No | An alternate name for the payee, if applicable | String | Header | |
City | No | Payee's city | String | Header | |
Company name | No | Payee's company name | String | Header | |
Country | No | Payee's country | String | Header | |
Country of birth | No | Payee's country of birth | String | Header | |
Date of birth | No | Payee's date of birth | Date | Header | |
No | Payee's email | String | Header | ||
External ID | Yes | The payee ID in the ERP | String | Header | |
First name | No | Payee's first name | String | Header | |
Invite to suppliers portal? | No |
Indicates if the payee should receive an invitation to the suppliers portal when the import process is completed:
|
List | Header |
|
Last name | No | Payee's last name | String | Header | |
Middle name | No | Payee's middle name | String | Header | |
Payee status | No | Payee risk status | List | Header |
|
Payee type | No | The type of payee: Individual, Company | List | Header |
|
Payer entity name | No | The name of the payer entity linked to the payee | String | Header | |
Payment country | No | Payee's payment country | String | Header | |
Payment method | No | The payee’s payment method | List | Header |
|
Payment terms ID | No | The ID associated with the payment term | String | Header | |
PayPal email address | No | The payee’s PayPal email | String | Header | |
Phone | No | Payee's phone | String | Header | |
Phone country | No | Payee's phone country | String | Header | |
State/Province | No | Payee's State or Province | String | Header | |
Street1 | No | Payee's first address | String | Header | |
Street2 | No | Payee's second address | String | Header | |
Tipalti Payee ID | No | Unique identifier of the payee in Tipalti Hub | String | Header | |
Zip | No | Payee's zip code | String | Header |