Tipalti Help Center home page
  • Get started
    • Onboarding tools
    • Video tutorials
    • Live training
  • User guide
    • Log into the Tipalti Hub
    • Administration
      • Administrative operations
      • User roles
    • Multiple entities
    • Funding
      • View funds required
      • Fund Tipalti accounts
      • Multi-FX
        • Currency cutoffs and validations
    • Payees overview
      • Search payee information
      • Manage payee status and settings
      • iFrame/ Supplier Hub
      • Manage Supplier Hub 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
      • Payment methods coverage
      • Payment methods coverage: US and ROW
      • Payment methods coverage: UK and EU
      • Payment error codes
    • Generate 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
        • Setup
        • SAP B1 PO Matching
    • 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
Sign in
  • Get started  
    • Onboarding tools  
    • Video tutorials  
    • Live training  
  • User guide  
    • Log into the Tipalti Hub
    • Administration  
      • Administrative operations
      • User roles
    • Multiple entities
    • Funding  
      • View funds required
      • Fund Tipalti accounts
      • Multi-FX  
        • Currency cutoffs and validations
    • Payees overview  
      • Search payee information
      • Manage payee status and settings
      • iFrame/ Supplier Hub
      • Manage Supplier Hub 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
      • Payment methods coverage
      • Payment methods coverage: US and ROW
      • Payment methods coverage: UK and EU
      • Payment error codes
    • Generate 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  
      • Usability
      • Manage Payee risk
  • Integrations  
    • 3rd Party Apps  
      • Partner Platforms
      • SSO
    • ERPs  
      • Sage Intacct
      • NetSuite 2.0
      • Microsoft Business Central
      • QuickBooks
      • Xero
      • Tipalti Connect
      • Acumatica
      • SAP B1  
        • Setup
        • SAP B1 PO Matching
    • 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

Articles in this section

  • Templates
  • Purchase Orders
  • GRNs
  • GL Accounts
  • Custom Field Values
  • Payment Terms
  • Units
  • Tax Codes
  • Payees
    Skip To Main Content
    Account
    Settings
    Logout
    • placeholder
    Account
    Settings
    Logout
    Filter:
    Submit Search

        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
        • Checking

        • Savings

        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  
        Email 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:

        • Yes

        • No

        List Header
        • Yes

        • No

        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
        • Active

        • Suspended

        • Blocked

        • Blocked by provider

        • Under fraud review

        • Internal fraud review

        Payee type No The type of payee: Individual, Company List Header
        • Individual

        • Company

        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
        • ACH,

        • PAYPAL

        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  
        • ZD.4.log-1212665864.zip
          20 KB 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