List in CSV format
You can make payouts from your Merchant Profile using XLSX and CSV files. If you want to fill in the information manually, we recommend using an XLSX file. If you use a special program for keeping the records of recipients, for example, CRM, you can download the information to a CSV file, then upload it to your Merchant Profile.
In this article, you will learn how to fill in a CSV file correctly:
The format of the report file conforms to the recommendations of IETF RFC4180. The semicolon (;) is used as the field divider. Encoding is UTF‑8.
We recommend using UTF‑8 with BOM so that the file can be opened and checked in Microsoft Excel.
The CSV text format is a set of rows separated by the line feed character (LF or CRLF). Each row contains fields separated by semicolons (;). If any parameter values contain double quote characters ("), semicolons (;), or line feeds, these parameters must be enclosed in quotation marks (").
It is allowed to put all fields in quotation marks, regardless of which characters they contain. If a field is not enclosed in quotation marks, all the surrounding spaces (up to the semicolon or up to the start or end of the line) are ignored.
The report file contents consist of the following elements:
- HD row — report header;
- D rows — data about payouts.
The report header must always contain the following:
HD;№;Тип;"Unique payout number";Amount;Currency;"Bank card number (or synonym)";"Wallet number";"Current account";BIC;Name;"City of branch";"Correspondent account";Phone number;Last name;First name;Patronymic or middle name;"Recipient's INN (TIN) (optional)";"Recipient's OMS (optional)";"Recipient's SNILS (optional)";"Passport series and number";"Date of passport issue";"Date of birth";"Does the recipient accept the offer?";"Recipient's nationality";City;Street;Building;Apartment;Postal code;"User ID (optional)"
For each payout, you need to create a separate D row. The total number of fields is always the same, the number of filled in fields depends on the type of payout.
| Field | Description | Indicates whether the field must be filled in |
|---|---|---|
| Row type | Type of row in the CSV file. Possible value: D (payout row) | For all types of payouts |
| Number of the payout in the list | Number of the payout in your list. This number will be used by YooMoney in error messages regarding file loading | For all types of payouts |
Type | Type of payout in YooMoney. Possible values:
| For all types of payouts |
| Unique payout number | ID that is unique to all your payouts. Displayed in the payout history of your Merchant Profile | For all types of payouts |
| Amount | Payout amount. The minimum and maximum value depends on the type of payout. Format: decimal number with two characters after the decimal point, separated by a dot or comma | For all types of payouts |
| Currency | Payout currency. Possible value: 643 (Russian ruble) | For all types of payouts |
| Bank card number (or synonym) | Number of the bank card for making the payout, or its synonym issued via the YooMoney form. Card number format: 16 or 18 digits without spaces | For payouts to a bank card |
| Wallet number | Number of the wallet for making the payout. Format: 12 to 16 digits without spaces, number begins with 41001 | For payouts to a YooMoney for Shopping wallet |
| Current account | Number of the current account for making the payout. Format: 20 digits without spaces | For payouts to a bank account |
| BIC | Bank’s BIC number. Format: 9 digits without spaces | For payouts to a bank account |
| Bank name | Name of the bank. | For payouts to a bank account |
| City of the branch | The city where the bank branch is located. | For payouts to a bank account |
| Correspondent account | Correspondence account of the bank branch. Format: 20 digits without spaces | For payouts to a bank account |
Phone | Recipient’s phone number. Format: number begins with 8, the number of digits depends on the type of payouts:
| For payouts to a bank card, bank account, and mobile phone number |
Last name | Last name of the recipient (exactly as in the passport). Submit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to a bank card and bank account |
First name | First name of the recipient (exactly as in the passport). Submit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to a bank card and bank account |
| Patronymic or middle name | Patronymic or middle name of the recipient, if specified in the passport. Submit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to a bank card and bank account |
Recipient's INN (TIN) (optional) | Payout recipient's INN. Example: 123456789012Submit it if you’re collecting the details on your own without using the YooMoney form. Optional parameter | For payouts to a bank card and bank account |
Recipient's OMS (optional) | OMS insurance policy number. Example: 12345678901234Submit it if you’re collecting the details on your own without using the YooMoney form. Optional parameter | For payouts to a bank card and bank account |
Recipient's SNILS (optional) | Payout recipient's SNILS (digits only, no spaces). Example: 12345678901Submit it if you’re collecting the details on your own without using the YooMoney form. Optional parameter | For payouts to a bank card and bank account |
Passport series and number | Series and number of the Internal Russian passport. Format: 10 digits without spaces. Submit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to a bank card and bank account |
Passport’s date of issue | Date of issue of the recipient’s passport. Format: DD.MM.YYYYSubmit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to a bank card and bank account |
Date of birth | Date of birth of the recipient. Format: DD.MM.YYYYSubmit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to a bank card and bank account |
| Does the recipient accept the offer? | Confirmation that the recipient has accepted the offer. Possible value: Да (Yes) | For payouts to a bank card, bank account, and mobile phone number |
| Nationality of the recipient | Nationality. Possible value: РФ | For payouts to a bank card and bank account |
City | Payout recipient’s city. You need to specify the actual residential address. Submit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to bank cards issued by foreign banks and for payouts of more than 15,000 rubles to a bank card and bank account |
Street | Payout recipient’s street. You need to specify the actual residential address. Submit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to bank cards issued by foreign banks and for payouts of more than 15,000 rubles to a bank card and bank account |
Building | Number of payout recipient’s building (if necessary, building letter and block are specified here). You need to specify the actual residential address. Submit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to bank cards issued by foreign banks and for payouts of more than 15,000 rubles to a bank card and bank account |
Apartment | Payout recipient’s apartment (if present). You need to specify the actual residential address. Submit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to bank cards issued by foreign banks and for payouts of more than 15,000 rubles to a bank card and bank account |
Postal code | Postal code of the recipient. You need to specify the actual residential address. Submit it if you’re collecting the details on your own without using the YooMoney form. | For payouts to bank cards issued by foreign banks and for payouts of more than 15,000 rubles to a bank card and bank account |
User ID (optional) | ID of the payout recipient in YooMoney, received as part of data collection via the form. Example: 410012345678933Optional parameter
| For payouts to a bank card and bank account |
Payout of up to 15,000 rubles to a bank card issued by a Russian bank
D;1;card;example_payout_20190101_1;100.00;643;ХХХХХХХХХХХХХХХХ;;;;;;;8ХХХХХХХХХХ;Иванов;Иван;Иванович;ХХХХХХХХХХХХ;;;ХХХХХХХХХХ;24.11.2010;24.11.2010;Да;РФ;;;;;;
Payout of more than 15,000 rubles or payout to a bank card issued by a foreign bank
D;2;card;example_payout_20190101_2;100.00;643;ХХХХХХХХХХХХХХХХ;;;;;;;8ХХХХХХХХХХ;Иванов;Иван;Иванович;ХХХХХХХХХХХХ;;;ХХХХХХХХХХ;24.11.2010;24.11.2010;Да;РФ;Санкт-Петербург;Ленина;"22а/1 к1";33;100291
Payouts to bank cards using the synonym and recipient’s ID
D;3;card;example_payout_20190101_2;100.00;643;Ubc1CrurSqRQ5Va09IeVIRI6.SC.000.201812;;;;;;;8ХХХХХХХХХХ;;;;;;;;;;Да;;;;;;;410012345678933
Payout to a wallet
D;4;wallet;example_payout_20190101_3;1.00;643;;41001ХХХХХХХХХХХ;;;;;;;;;;;;;;;;;;;;;;;
Payout of up to 15,000 rubles to a bank account
D;5;bank;example_payout_20190101_4;20.00;643;;;XXXXXXXXXXXXXXXXXXXX;XXXXXXXXX;"ПАО Сбербанк";Москва;XXXXXXXXXXXXXXXXXXXX;8ХХХХХХХХХХ;Иванов;Иван;Иванович;ХХХХХХХХХХХХ;;;ХХХХХХХХХХ;24.11.2010;24.11.2010;Да;РФ;;;;;;
Payout of more than 15,000 rubles to a bank account
D;6;bank;example_payout_20190101_5;20.00;643;;;XXXXXXXXXXXXXXXXXXXX;XXXXXXXXX;"ПАО Сбербанк";Москва;XXXXXXXXXXXXXXXXXXXX;8ХХХХХХХХХХ;Иванов;Иван;Иванович;ХХХХХХХХХХХХ;;;ХХХХХХХХХХ;24.11.2010;24.11.2010;Да;РФ;Санкт-Петербург;Ленина;"22а/1 к1";33;100291;
Payouts to bank cards using recipient’s ID
D;7;card;example_payout_20190101_2;100.00;643;ХХХХХХХХХХХХХХХХ;;;;;;;8ХХХХХХХХХХ;;;;;;;;;;Да;;;;;;410012345678933
Payout to a mobile phone number
D;8;tel;example_payout_20190101_6;1.00;643;;;;;;;;8ХХХХХХХХХХ;;;;;;;;;;Да;;;;;;;
Step 1. Add the header (HD row).
Step 2. Add data about payouts (D rows). Use any number of rows. One file can contain payouts of different types (to a wallet, bank card, bank account, and phone number). You can use any order but we recommend grouping payouts by type, for example, start with listing all payouts to bank cards, then all payouts to wallets, and so on. This will make it easier for you to sort through the data.
Step 3. Save the file. You can use any file name.
Step 4. Test yourself:
- Data is filled in the correct order.
- Data is filled in depending on the type of payout, the extra fields are empty.
- Data is in the correct format.
- Payout amount corresponds to limits.
- Recipients of payouts to bank cards, bank accounts, or phone numbers accepted the offer.
- Recipients of payouts to bank cards and bank accounts are citizens of the Russian Federation.
- When making a payout to a bank card issued by foreign bank or making a payout of more than 15,000 rubles to a bank card issued by a Russian bank card or an account in a Russian bank, the recipient’s actual residence address is specified.
- When making a payout to a bank card or bank account, either recipient's personal data or their user ID in YooMoney is specified.
- The file size is not more than 2 MB.
- The file is saved in CSV format with UTF‑8 encoding.
We recommend using UTF‑8 with BOM so that the file can be opened and checked in Microsoft Excel.
Done! You can upload the file to your Merchant Profile. If there is an error, YooMoney will provide you with the serial number of the payout and tell you what needs to be corrected. If everything is correct, YooMoney will generate a hash of the downloaded file using the SHA-256 algorithm, display the hash as well as the total amount of payouts. You will only need to check the hash and the amount to verify that you’ve downloaded the current version of the file and confirm the payouts by text message.
See also