background
Tags:paymentlinkspaylinksinvitesimportbetaallink
Show me

Payment links can be imported using a CSV file. You can upload a basic file containing only fields related to the link or use a file
containing all payment link and customer headers to create a complete customer, both are accepted.

Updating some existing customer data is possible when uploading payment links, read below for more information.

On the payment links overview use the button or, use the global button and select Import to start importing a file.

Check "Allow overwrite of customer data when importing" to allow the update of existing customers.
The following customer fields can be updated:

  • email
  • address
  • mobile
  • language
  Important: When a field is left empty in your imported file, that customer field is also cleared. Ensure to fill in all the data needed.

Headers of the CSV file

Required:

amountThe amount of the payment link
msgThe message/title of the payment link
refThe reference/remittance of the payment link

A name or reference to an existing customer also is required:

firstnameThe first name of the customer
lastnameThe last name of the customer
customerNumberThe customer number, can be used to reference to an existing customer
emailThe email, can be used to reference to an existing customer

The header debtor can be used instead of first and lastname, the value of this
field is used in this order 'firstname lastname' as name for the customer.

Optional:

llanguage, used for the invitation of the payment link.
  • Accepted values: en, nl, fr, nl_nl (Netherlands), fr_fr (France), de, it, es, pt
  • When the language is not passed, the invitation is sent in the language configured on your company.
  • The language needs to be enabled on the selected profile to send invitations in that language, otherwise English is used by default.
ctprofile id, to use a specific profile for the payment link
mobile
  • Phone number, if the customer already exist with a mobile number the value is ignored.
  • Number in international format is preferred (+31, +32, +33,..).
expiryexpiration date of the payment link (yyyy-mm-dd)
companyNamecompany name
cocCoC number: The Chamber Of Commerce number of the customer or VAT-number (format: BE0123456789), if the invoiced entity is a person, and thus not a company, this field should be left blank.
addressstreet and number of the address
citycity of the customer
zippostal code
countryCountry ISO format (2 characters) for example BE, NL, FR

Template files


Tip: Some editors format date and transaction values to your local settings when opening a CSV file (ex: MS Excel)
Verify the file's content, or use another editor before uploading it in Twikey.
Last Update: 2025-08-12