A guide to CSV files

One of the ways to make a mass payment with Altery is by uploading a CSV file, which can be a little tricky when handling a large volume of transfers. This guide will outline the requirements for filling in a CSV file before uploading it to Altery, ensuring that your mass payments experience is as smooth and efficient as possible.

Please note that all files must be saved in .csv format with ‘;’ delimiters.

If you’re looking for information about the fees for this service, please visit our website. For more information on making a mass payment, please refer to this article.

We currently support mass payments of up to 150 transactions to bank accounts, up to 300 transactions to bank cards and up to 300 transactions to other Altery clients.

To outline the various criteria for mass payments via CSV file, we have included the following tables and examples:

Bank accounts: SEPA transfer (EEA countries, EUR) - example_bank_transfer_SEPA
Bank accounts: Faster Payments (UK, GBP) - example_bank_transfer_faster
Bank accounts: SWIFT transfer (EUR, USD, GBP) - example_bank_transfer_swift
Bank accounts: Transfer in local currency - example_bank_transfer_local
Bank cards:Payouts to cards - example_bank_card
To Altery clients: Internal transfers - example_internal_transfer

SEPA transfer (EEA countries, EUR)

Here you can find an example of CSV-file: example_bank_transfer_SEPA

Designated order of parameters	Letter symbol of the column in Microsoft Excel	Purpose	Requirements for completion
1	A	User’s system	Always enter “ewallet”
2	B	Sender’s AlteryID	Your wallet number (AlteryID)
3	C	Wallet currency	Enter the required currency code for the wallet section from which you will be deducting the funds: USD, EUR or GBP.
4	D	Outgoing amount	The amount to be debited from your wallet (the fee amount will be included), with up to two digits after the decimal point Skip this parameter if column 6 (Amount to be received) is completed
5	E	Currency to be received	3-letter currency code in ISO 4217 format, for example, EUR
6	F	Amount to be received	The amount you want to transfer (the fee amount is not included), with up to two digits after the decimal point Skip this parameter if column 4 (Outgoing amount) is completed
7	G	External Id	A unique code of numbers or letters provided by the sender to clearly identify the payment instruction. It can be up to 60 characters long. Note: This field is not mandatory, but if you complete it, the value must be unique
8	H	Details	Text with payment details, up to 120 characters
9	I	Transfer type	For mass bank transfers, always enter “bankwire”
10	J	Recipient’s name	Name of the legal entity (company). Up to 34 characters. Latin letters and dashes can be written. If the recipient is an individual, skip this parameter and see the columns 27 (Recipient’s first name), 28 (Recipient’s surname)
11	K	———	Skip this parameter
12	L	Recipient type	“Business” — transfer for companies “Individual” — transfer for individuals Note: Parameter is case-sensitive.
13	M	———	Skip this parameter
14	N	Recipient’s country code of residence	Enter the recipient’s country code of residence in ISO 3166 Digital format. For example, the code for the United Kingdom is 826 or GBR You can view country codes here.
15	O	Recipient’s city	The name of the recipient’s city of residence. Up to 34 characters, only Latin letters are permitted.
16	P	Recipient’s address	Payment recipient’s residential address. Up to 34 characters, only Latin letters and digits are permitted.
17	Q	Recipient’s IBAN	Recipient’s IBAN. Up to 34 characters. Latin letters and numbers are permitted.
18	R	Recipient’s bank BIC/SWIFT code	Recipient’s bank BIC/SWIFT code (8-11 characters)
19-26	S-Z	———	Skip these parameters
27	AA	Recipient’s first name	Individual’s first name (if the transfer is made to an individual) in Latin letters If the recipient is a legal entity (company), skip this parameter and see the column 10 (Recipient’s name)
28	AB	Recipient’s surname	Individual’s surname (if the transfer is made to an individual) in Latin letters If the recipient is a legal entity (company), skip this parameter and see the column 10 (Recipient’s name)
29–31	AC-AE	———	Skip these parameters
32	AF	Recipient’s region/province/state	Payment recipient’s residential region/province/state. Up to 34 characters, only Latin letters are permitted
33-39	AG-AM	———	Skip these parameters and start a new row. Please don’t use “;” symbol after last parameter

Faster Payments (The United Kingdom, GBP)

Here you can find an example of CSV-file: example_bank_transfer_faster

Designated order of parameters	Letter symbol of the column in Microsoft Excel	Purpose	Requirements for completion
1	A	User’s system	Always enter “ewallet”
2	B	Sender’s AlteryID	Your wallet number (AlteryID)
3	C	Wallet currency	Enter the required currency code for the wallet section from which you will be deducting the funds: USD, EUR or GBP.
4	D	Outgoing amount	The amount to be debited from your wallet (the fee amount will be included), with up to two digits after the decimal point Skip this parameter if column 6 (Amount to be received) is completed
5	E	Currency to be received	3-letter currency code in ISO 4217 format, for example, GBP
6	F	Amount to be received	The amount you want to transfer (the fee amount is not included), with up to two digits after the decimal point Skip this parameter if column 4 (Outgoing amount) is completed
7	G	External Id	A unique code of numbers or letters provided by the sender to clearly identify the payment instruction. It can be up to 60 characters long. Note: This field is not mandatory, but if you complete it, the value must be unique
8	H	Details	Text with payment details, up to 120 characters
9	I	Transfer type	For mass bank transfers, always enter “bankwire”
10	J	Recipient’s name	Name of the legal entity (company). Up to 34 characters. Latin letters and dashes can be written. If the recipient is an individual, skip this parameter and see the columns 27 (Recipient’s first name), 28 (Recipient’s surname)
11	K	———	Skip this parameter
12	L	Recipient type	“Business” — transfer for companies “Individual” — transfer for individuals Note: Parameter is case-sensitive.
13-16	M-P	———	Skip these parameters
17	Q	Recipient’s bank account number	Recipient’s bank account number. Up to 8 characters
18	R	Recipient’s bank BIC/SWIFT code	Recipient’s bank BIC/SWIFT code (8-11 characters)
19-25	S-Y	———	Skip these parameters
26	Z	Sort Code	Recipient’s British bank code for transfers in GBP. Up to 6 characters, digits.
27	AA	Recipient’s first name	Individual’s first name (if the transfer is made to an individual) in Latin letters If the recipient is a legal entity (company), skip this parameter and see the column 10 (Recipient’s name)
28	AB	Recipient’s surname	Individual’s surname (if the transfer is made to an individual) in Latin letters If the recipient is a legal entity (company), skip this parameter and see the column 10 (Recipient’s name)
29–39	AC-AM	———	Skip these parameters and start a new row. Please don’t use “;” symbol after last parameter

SWIFT transfer (EUR, USD, GBP)

Here you can find an example of CSV-file: example_bank_transfer_swift

Designated order of parameters	Letter symbol of the column in Microsoft Excel	Purpose	Requirements for completion
1	A	User’s system	Always enter “ewallet”
2	B	Sender’s AlteryID	Your wallet number (AlteryID)
3	C	Wallet currency	Enter the required currency code for the wallet section from which you will be deducting the funds: USD, EUR or GBP.
4	D	Outgoing amount	The amount to be debited from your wallet (the fee amount will be included), with up to two digits after the decimal point Skip this parameter if column 6 (Amount to be received) is completed
5	E	Currency to be received	3-letter currency code in ISO 4217 format, for example, USD
6	F	Amount to be received	The amount you want to transfer (the fee amount is not included), with up to two digits after the decimal point Skip this parameter if column 4 (Outgoing amount) is completed
7	G	External Id	A unique code of numbers or letters provided by the sender to clearly identify the payment instruction. It can be up to 60 characters long. Note: This field is not mandatory, but if you complete it, the value must be unique
8	H	Details	Text with payment details, up to 120 characters
9	I	Transfer type	For mass bank transfers, always enter “bankwire”
10	J	Recipient’s name	Name of the legal entity (company). Up to 34 characters. Latin letters and dashes can be written. If the recipient is an individual, skip this parameter and see the columns 27 (Recipient’s first name), 28 (Recipient’s surname)
11	K	———	Skip this parameter
12	L	Recipient type	“Business” — transfer for companies “Individual” — transfer for individuals Note: Parameter is case-sensitive.
13	M	———	Skip this parameter
14	N	Recipient’s country code of residence	Enter the numeric code of the recipient’s country of residence in ISO 3166 format. For example, the code for the United Kingdom is 826 or GBR You can view country codes here.
15	O	Recipient’s city	The name of the recipient’s city of residence. Up to 34 characters, only Latin letters are permitted
16	P	Recipient’s address	Payment recipient’s residential address. Up to 34 characters, only Latin letters and digits are permitted
17	Q	Recipient’s bank account number or IBAN	Recipient’s bank account number or IBAN. Up to 34 characters, Latin letters and numbers are permitted
18	R	Recipient’s bank SWIFT code	Recipient’s bank SWIFT code (8-11 characters)
19–26	S-Z	———	Skip these parameters
27	AA	Recipient’s first name	Individual’s first name (if the transfer is made to an individual) in Latin letters If the recipient is a legal entity (company), skip this parameter and see the column 10 (Recipient’s name)
28	AB	Recipient’s surname	Individual’s surname (if the transfer is made to an individual) in Latin letters If the recipient is a legal entity (company), skip this parameter and see the column 10 (Recipient’s name)
29–31	AC-AE	———	Skip these parameters
32	AF	Recipient’s region/province/state	Payment recipient’s residential region/province/state. Up to 34 characters, only Latin letters are permitted
33–39	AG-AM	———	Skip these parameters and start a new row. Please don’t use “;” symbol after last parameter

Transfer in local currency

Here you can find an example of CSV-file: example_bank_transfer_local

Designated order of parameters	Letter symbol of the column in Microsoft Excel	Purpose	Requirements for completion
1	A	User’s system	Always enter ewallet
2	B	Sender’s AlteryID	Your wallet number (AlteryID)
3	C	Wallet currency	Enter the code of the wallet currency you are debiting: USD, EUR, GBP
4	D	Outgoing amount	Amount to debit from your wallet (fee included). Use up to 2 decimals. Leave blank if column 6 is completed
5	E	Currency to be received	ISO 4217 currency code of the payout (e.g. INR, IDR, TRY, COP, MXN, NGN, PHP, BRL, AED)
6	F	Amount to be received	Amount to be credited to the recipient (fee not included). Use up to 2 decimals. Leave blank if column 4 is completed
7	G	External Id	Optional unique code (up to 60 characters) for your own reference
8	H	Details	Payment details (up to 120 characters). Latin letters, digits and standard symbols only
9	I	Transfer type	Always enter bankwire
10	J	Recipient’s name	Legal entity name (up to 34 characters, Latin letters and dashes). If the recipient is an individual, skip and fill columns 27–28
12	L	Recipient type	Business or Individual (case-sensitive)
14	N	Recipient’s country code	ISO 3166 numeric code of recipient’s country of residence
15	O	Recipient’s city	Recipient’s city (Latin letters only, up to 34 characters)
16	P	Recipient’s address	Recipient’s residential address (Latin letters/numbers, up to 34 characters)
17	Q	Recipient’s bank account number	Local account number/IBAN (up to 34 characters)
21	U	Beneficiary account type	For some countries (e.g. BRL, INR, COP) you must specify account type (e.g. SA/CH, current/savings). See local requirements
23	W	Beneficiary bank code	For some countries (INR – IFSC; IDR – bank code; PH – bank code; NGN – NUBAN; MXN – CLABE; etc.) specify local clearing code
24	X	Beneficiary branch code	Where required (e.g. IDR, BRL), provide local branch code
27	AA	Recipient’s first name	If Individual – first name in Latin letters
28	AB	Recipient’s surname	If Individual – surname in Latin letters
32	AF	Recipient’s region/province/state	Where required, up to 34 characters
34	AH	Beneficiary CPF (Brazil)	For Brazilian individuals – CPF (11 digits)
35	AI	Beneficiary CNPJ (Brazil)	For Brazilian businesses – CNPJ (14 digits)
40	AN	Beneficiary IFSC code	For Indian payments (INR) – enter 11-character IFSC code
43	AQ	Beneficiary document type	Required for COP, BRL, AED. Provide government ID type.
44	AR	Beneficiary number	Required for COP, BRL, AED. Provide government ID number.
45	AS	Beneficiary phone	Required for COP, AED. Provide the phone number of the recipient.
46	AT	Relationship	Required for COP (dropdown)
47	AU	Payment channel type	For US wires (ACH/Fedwire) – specify channel if applicable

Bank card payouts

To make a mass payment to bank cards, you need to upload a CSV file under the Send → Mass payments → Bank cards section.

Note: Please use a file saved in .csv format with ‘;’ delimiters.

Limits on the number of payments in a file:
Min 1 - Max 300 transactions for transfers to bank cards.

To learn more about the fees for this service, please visit our website.

Parameters and requirements for filling in the file are in the table below. Please note that there are limitations regarding the countries and card brands to which payments can be sent to.

Here you can find an example of CSV-file: example_bank_card

Designated order of parameters	Letter symbol of the column in Microsoft Excel	Purpose	Requirements for completion
1	A	User’s system	Always enter “ewallet”
2	B	Sender’s AlteryID	Your wallet number (AlteryID)
3	C	Wallet currency	Enter the required currency code for the wallet section from which you will be deducting the funds: USD, EUR or GBP
4	D	Outgoing amount	The amount to be debited from your wallet (including the fee amount), with up to two digits after the decimal point Skip this parameter if column 6 (Amount to be received) is completed
5	E	Currency to be received	3-letter currency code in ISO 4217 format, for example, EUR.
6	F	Amount to be received	The amount you want to transfer (including the fee amount), with up to two digits after the decimal point Skip this parameter if column 4 (Outgoing amount) is completed
7	G	External ID	A unique code of numbers or letters provided by the sender to clearly identify the payment instruction. It can be up to 60 characters long Note: This field is not mandatory, but if you complete it, the value must be unique
8	H	Transfer type	For mass bank card transfers, always enter “card”
9	I	Card number	Full card number of the payment recipient. Only digits. Spaces are not allowed
10	J	Card holder name	First and last name of the cardholder. Field length is 1-100 characters. Only Latin characters and special characters . - ' (dot, hyphen, apostrophe)

To Altery clients

To make a mass internal payment, you need to upload a CSV file under the Send → Mass payments → To Altery Clients section.

To make a transfer, you can use the receiver's Altery ID or phone number/email verified in their Altery account.

Note: Please use a file saved in .csv format with ‘;’ delimiters.

Limits on the number of payments in a file:
Min 1 - Max 300 transactions for transfers to other Altery clients.

To learn more about the fees for this service, please visit our website.

Parameters and requirements for filling in the file are in the table below.

Here you can find an example of CSV-file: example_internal_transfer

Designated order of parameters	Letter symbol of the column in Microsoft Excel	Purpose	Requirements for completion
1	A	User’s system	Always enter “ewallet”
2	B	Sender’s AlteryID	Your wallet number (AlteryID)
3	C	Wallet currency	Enter the required currency code for the wallet section from which you will be deducting the funds: USD, EUR or GBP
4	D	Outgoing amount	The amount to be debited from your wallet (including the fee amount), with up to two digits after the decimal point Skip this parameter if column 6 (Amount to be received) is completed
5	E	Currency to be received	3-letter currency code in ISO 4217 format, for example, EUR
6	F	Amount to be received	The amount you want to transfer (including the fee amount), with up to two digits after the decimal point Skip this parameter if column 4 (Outgoing amount) is completed
7	G	External ID	A unique code of numbers or letters provided by the sender to clearly identify the payment instruction. It can be up to 60 characters long Note: This field is not mandatory, but if you complete it, the value must be unique
8	H	Operation details	Additional details of operation. This can include numbers or letters and can be up to 300 characters long. Note: This field is not mandatory
9	I	Receiver's system	Always enter “ewallet”
10	J	Receiver’s contact details	Receiver's identificator: AlteryID, email or phone number. Requirements depend on the contact details: for AlteryID, you can enter numbers (up to 10 characters) for phone, you can enter numbers and "+" (9 to 15 characters) for email, you can enter Latin characters, numbers and symbols . - _ @
11	K	Type of the receiver's contact details	Always enter "AlteryID" or "email" or "phone"