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	Description	Field data type	Level	Value display names
Account number	The payee's bank account number	String		ACH eCheck
Account type	The payee's account type	Enum		ACH eCheck Map as Checking or Savings
ACH account number	The payee’s account number	String	Header
ACH account type	The payee’s account type	List	Header	Checking Savings
ACH bank name	The payee’s bank name	String	Header
ACH Name on account	The payee’s account name	String	Header
ACH routing code	The payee’s routing code	String	Header
Alias	An alternate name for the payee, if applicable	String	Header
Bank address	The bank city, province, zip code	String		eCheck
Bank city	The payee's bank address, city, province, and zip code	String		eCheck
Bank code	The payee's bank code	String		eCheck
Bank giro number	The payee's bank giro number (for Swedish accounts)	String		eCheck
Bank name	The payee's bank name	String		ACH Check
Branch code	The payee's bank branch code	String		eCheck
Check City	The payee's city	String		Check
Check State	The payee's state or province	String		Check
Check Street 1	The payee's street address 1	String		Check
Check Street 2	The payee's street address 2	String		Check
Check Zip	The payee's zip or postal code	String		Check
City	The payee's city	String	Header
Company name	The payee's company name	String	Header
Country	The payee's country	String	Header
Country of birth	The payee's country of birth	String	Header
Currency	The payee's account currency	String		ACH Check eCheck PayPal
Date of birth	The payee's date of birth	Date	Header
Email	The payee's email	String	Header
External ID	The payee ID in the ERP	String	Header
First name	The payee's first name	String	Header
IBAN	The payee's bank account IBAN code	String		eCheck
IFSC	The IFSC (Indian Financial System Code) of the payee's bank	String		eCheck
Invite to suppliers portal?	Indicates if the payee should receive an invitation to the suppliers portal when the import process is completed: Yes No	List	Header	Yes No
Last name	Payee's last name	String	Header
Middle name	Payee's middle name	String	Header
Name on account	Name as it appears on the payee's bank statement	String		ACH eCheck
Name on Check	Name as it appears on the payee's bank account	String		Check
Payee status	Payee risk status	List	Header	Active Suspended Blocked Blocked by provider Under fraud review Internal fraud review
Payee type	The type of payee: Individual, Company	List	Header	Individual Company
Payer entity name	The name of the payer entity linked to the payee	String	Header
Payment country	Payee's payment country	String	Header
Payment method	The payee’s payment method	List	Header	ACH Check PayPal Local bank transfer
Payment terms ID	The ID associated with the payment term	String	Header
PayPal email address	The payee’s PayPal email	String	Header	PayPal
Phone	Payee's phone	String	Header
Phone country	Payee's phone country	String	Header
State/Province	Payee's State or Province	String	Header
Street1	Payee's first address	String	Header
Street2	Payee's second address	String	Header
SWIFT	The payee's bank SWIFT code	String		eCheck
Tipalti Payee ID	Unique identifier of the payee in Tipalti Hub	String	Header
Zip	Payee's zip code	String	Header

The following table shows which payment methods are supported and can be updated when importing a list of payees via CSV file into Tipalti.

Payee payment method	REST API Support	File Import Support
ACH	Yes	Yes
BACS (GBP only)	Yes	Yes
Check	Yes	Yes
EFT	Yes	Yes
PayPal	Yes	Yes
SEPA (EUR only)	Yes	Yes
Additional Local Bank Transfer Routes	Yes	Yes

Payees are still required to enter their tax information and agree to the terms and conditions on the iFrame or Supplier Hub. This ensures compliance and accuracy in their onboarding process.

ZD.4.log-1212665864.zip
20 KB Download

Articles in this section

Payees Template