Tipalti Help Center home page
  • Get started
    • Onboarding tools
    • Video tutorials
    • Live training
  • User guides
    • Tipalti Hub Home
      • Log in to the Tipalti Hub
      • Manage finances from Home
    • Tipalti AI Assistant
      • Ask the assistant
      • Common prompts
    • Administration
      • General
      • Communications
      • Bills setup
    • Multiple entities
      • Multiple entities
      • Switch entities with multi-instance setup
    • Funding
      • Funds overview
      • Manage virtual accounts
      • Fund Tipalti accounts
      • Transfer funds between accounts
      • Fund Multi-FX accounts
    • Payees
      • Add, import, and invite payees
      • Search payee information
      • Manage payee status and settings
      • iFrame/ Supplier Hub
      • Managing your payees
      • Manage actions as a payee
      • Add and review payee documents
      • Verification of payee
    • Taxation
      • US tax forms
      • Tax form expiration
      • Tax withholding
      • Certificate of No US Activities
      • Additional documents
      • Non-US tax collection
      • Tax form statuses
    • Procurement
      • New Procurement
      • Original Procurement
    • PO matching
      • New PO matching
      • Original PO matching
    • Bills
    • Tipalti Expenses
      • Get started
      • Create and submit expenses
      • Manage and approve expenses
      • Build expense approval workflows
      • Reimburse expenses
      • Connect and manage your corporate cards
    • Tipalti Cards
      • Tipalti Cards
      • Fund your card
      • Manage cards
      • Monitor card transactions
      • Process transactions
      • ERP sync
      • Credit card statement report
    • Payments
      • Submit payments
      • Manage payments
      • Schedule payments
      • Understanding payment statuses
      • Payment methods coverage: US and ROW
      • Payment methods coverage: UK and EU
      • Payment methods coverage: Canada
      • Payment error codes
      • Managing unsuccessful payments
    • Reports
      • AI-powered reports
      • Payment reports
      • Bill reports
      • Payee reports
      • Tax reports
      • User reports
    • Security practices
      • Email security
      • Business continuity practices
      • Two-factor authentication
      • Detect
  • Integrations
    • 3rd Party Apps
      • Partner Platforms
      • SSO
    • ERPs
      • Sage Intacct
      • NetSuite 2.0
      • Microsoft Business Central
      • QuickBooks
      • Xero
      • Tipalti Connect
      • Acumatica
      • SAP B1
    • File Integration
      • Configure auto-sync settings
      • Import files
      • Export files
  • FAQs
    • General FAQs
    • User guide FAQs
      • Payee FAQs
      • Bill FAQs
      • Card FAQs
      • PO Matching FAQs
      • Payment FAQs
      • Detect FAQs
      • Taxation FAQs
      • Administration FAQs
      • Expenses FAQs
    • ERP FAQs
  • Release notes
  • Dev docs
Sign in
  • Get started  
    • Onboarding tools  
    • Video tutorials  
    • Live training  
  • User guide  
    • Log in to the Tipalti Hub
    • Administration  
      • Administrative operations
      • User roles
    • Multiple entities
    • Funding  
      • View funds required
      • Fund Tipalti accounts
      • Fund Multi-FX accounts  
        • Currency cutoffs and validations
    • Payees  
      • Search payee information
      • Manage payee status and settings
      • iFrame/ Supplier Hub
      • Managing your payees
      • Documents review
    • Taxation  
      • US tax forms
      • Tax form expiration
      • Tax withholding  
        • Withholding rates
        • Income types
        • Tax form and entity types
      • Certificate of No US Activities
      • Additional documents
      • Non-US tax collection
      • Tax form statuses
    • Procurement  
      • System overview
      • Create and track purchase requests
      • Approve purchase requests
      • Mark goods and services as received
      • Vendor registration
      • Send PO PDF
      • Back office  
        • Set reminders
        • Run parallel PR/ vendor approval
        • Emails
        • PO PDF customization
        • Upload budget
        • Customize Procurement forms
        • Contract repository
      • Workflow integrations
    • PO Matching  
      • Matching process
      • Handle matching exceptions
      • Bill routing
      • Matching policies
      • Bill coding
      • Bill approval for PO-backed bills  
        • Approvable bills
        • Non-approvable bills
        • PO updates
      • Prepayments (NetSuite 2.0)
      • Track and match a dropship invoice  
        • Set payees up as dropship vendors
        • Upload and match a dropship invoice
    • Bills  
      • Bill flows
      • Usability
      • Add invoices
      • Manage bills
      • Add comments and files to bills
      • Bill approvers
      • Invoice processing approvals
      • Email Security
      • Tax collection in Bills
      • Bill statuses
    • Tipalti Expenses  
      • Get started
      • Create and submit expenses
      • Manage and approve expenses
      • Reimburse expenses
      • Connect your corporate cards
    • Tipalti Cards  
      • Funds flow
      • Manage cards
      • Card transactions overview
      • Process transactions
      • ERP sync
      • Credit card statement report
    • Submitting payments
    • Payment information  
      • Payment statuses defined
      • Payment methods coverage: US and ROW
      • Payment methods coverage: UK and EU
      • Payment methods coverage: Canada
      • Payment error codes
    • Reports  
      • Smart report builder
      • Payment reports
      • Bill reports
      • Payee reports
      • Tax reports
      • User reports
    • Security practices  
      • Email security
      • Business continuity practices
      • Two-factor authentication
    • Detect
  • Integrations  
    • 3rd Party Apps  
      • Partner Platforms
      • SSO
    • ERPs  
      • Sage Intacct
      • NetSuite 2.0
      • Microsoft Business Central
      • QuickBooks
      • Xero
      • Tipalti Connect
      • Acumatica
      • SAP B1
    • File Integration  
      • Configure auto-sync settings
      • Import files
      • Export files
  • FAQs  
    • General FAQs
    • User guide FAQs  
      • Bill FAQs
      • Card FAQs
      • PO Matching FAQs
      • Payment FAQs
      • Detect FAQs
      • Taxation FAQs
      • Administration FAQs
      • Expenses FAQs
    • ERP FAQs
  • Release notes
  • Dev docs
  1. Tipalti
  2. Integrations
  3. File Integration
  4. Import files
  5. Templates
Follow

Articles in this section

  • Purchase orders
  • GRNs
  • GL accounts
  • Custom field values
  • Payment terms
  • Units
  • Tax codes
  • Payees

Payees template

This article 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.

Prepare payees list file

Prepare a CSV file of new payees you want added to Tipalti. Each row in the file details a different payee. Click the image below to download a sample of the CSV file structure. You can clear all data in the file and enter your own data for upload. The maximum file size allowed is 20 MB (~100,000 payees).

Payees List - sample file

File structure

Field display name Description 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  

Supported payment methods

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
  • PayeesList-SampleFile.csv
    198 Bytes Download
Was this article helpful?

We’d love the opportunity to improve. Submit your feedback.

We’re glad you enjoyed the article!

Have more questions? Submit a request
Return to top
Privacy Policy | Terms of Use | Payer/Sender Rights | Customer Assistance Policy
LinkedIn Instagram Facebook Twitter YouTube
Contact support