Adjustable transaction reports
Adjustable reports have more flexible settings than the standard ones.
If you are still using the standard reports but would like to switch to the adjustable ones, check in your Merchant Profile for availability of this option. The stores for which the switch is available have a block with a Switch now button in the Transaction reports
You can get a report for the specific period (three months maximum) at any time.
- Just click Get a reporton the Transaction reports page.The registry file will be generated with the settings you see on the page. To change them, click Change settings.
- Select the required period and specify the address to receive a report (or multiple ones). Then click Send a report to receive the file to the specified address.
YooMoney sends reports to the email address specified on the Transaction reports page
If there were no payments or refunds during the day, you will receive a report with no transactions. If you don't need to receive empty reports, disable the option in the settings. To do this, click Change settings, uncheck "Send reports if there were no transactions", and click Save.
To email
You can change the email address for receiving reports at any time in the settings on the Transaction reports page. To do this, click Change settings, specify a new email address (or multiple ones), and click Save.
YooMoney can send reports directly to your sftp server. To enable this option, contact us via b2b_support@yoomoney.ru
You can receive reports in Russian or English. To change the language, click Change settings on the Transaction reports page, select the required language, and click Save.
The report can be in CSV or Excel format.
A CSV file is useful for automated report processing. The reports of this format are sent in two separate emails: one with a payment report and one with a refund report.
If you handle reports manually, it's more convenient to work with Excel files. In this format, you receive one email with an Excel file with two tabs: one with payments and one with refunds.
To change the file format, click Change settings on the Transaction reports page, select the required format, and click Save.
Reports can provide additional information about transactions. To receive it, add additional fields in the settings.
Click Change settings on the Transaction reports page, select the required fields on the "Payment reports" and "Refund reports" tabs, and click Save.
After that, new columns will be added to the report files (to the right).
Note If you've integrated with YooMoney via API independently, you can add any required fields to the reports beyond those in settings. These can be, for example, fields with information from your internal systems (internal order ID, payer ID, and so on). If you need this, configure the transfer of this data in the metadata parameters and let us know at b2b_support@yoomoney.ru that you'd like to add data from these parameters to the report.
To check what the finished report file with the selected settings looks like, you can download an example.
If you download a file with an example in CSV format, only a file with a payment report will be downloaded.
It contains data on all successful payments (except for payments made via SberBank Business Online).
By default, it contains the following fields:
| Payment ID | A unique payment ID in YooMoney (if you've integrated via API independently, you'll receive it in the response when making a payment, in the id field). |
| Payment amount | Transaction amount. The decimals are separated by the dot, and there are always two digits after the decimal point, no thousands separator. |
| Payment currency | Three-letter currency code (RUB for Russian ruble) |
| Payment amount excluding commission | The amount that is credited to your checking account. The decimals are separated by the dot, and there are always two digits after the decimal point, no thousands separator. |
| Commission amount | The amount of payment commission. |
| Commission for receipts with VAT | Only for self-employed: amount of commission for submitting receipts automatically. If this option is turned off, the commission will be 0. |
Time of payment | Time of payment confirmation in YooMoney (in the format dd.MM.yyyy HH:mm:ss). Example: 18.06.2021 17:46:58 |
| ID of the means of payment | The number of the YooMoney wallet from which the payment was made. For other payment methods, it's the internal account number on YooMoney's side. |
| Description | The value of the description field (if you've integrated via API independently). |
| Payment type | Code of the payment method on YooMoney’s side. |
| Payer's name | Full name of the YooMoney wallet owner. To be filled in only if the payment amount is more than 15,000 rubles and the selected payment method is the YooMoney wallet, FPS, or cash. |
| Payer's address | Address of the YooMoney wallet owner. To be filled in only if the payment amount is more than 15,000 rubles and the selected payment method is the YooMoney wallet, FPS, or cash. |
| INN (TIN) | TIN of the YooMoney wallet owner. To be filled in only if the payment amount is more than 15,000 rubles and the selected payment method is the YooMoney wallet, FPS, or cash. |
In report settings, you can add the following fields:
| Fields in the report | Description |
|---|---|
| For issued invoices | |
| Invoice number | Number of issued invoice |
| Where the invoice was sent | Email address or phone number where the invoice was sent. |
| Payer's full name | The name of the invoice recipient. |
| For payments via bank cards, T-Pay, SberPay | |
| Payment authorization code | A unique transaction code assigned by the bank. |
| Payment RRN | Bank transaction ID (Retrieval Reference Number) is a number that may be used to find information about a payment in the payer's bank. |
| Card number | A masked number of the card from which the payment was made. |
| Payer's bank | A name of the bank that issued the payer's card. |
| Payment system of the payer's card | A payment system in which the card operates (MIR, Visa, UnionPay, or other). |
| For Sberbank's "Purchase on Credit" method | |
Loan option and discount amount | Option:
If the selected option is an installment plan, the report also displays the discount amount (the discount is provided by the store to compensate the customer for the overpayment). |
РЕЕСТР ПЛАТЕЖЕЙ ПО ДОГОВОРУ НЭК.11322.23 (152368) Дата платежей: 2022-12-15 Идентификатор платежа;Сумма платежа;Валюта платежа;Сумма за вычетом комиссии;Сумма комиссии;Время платежа;Идентификатор платежного средства;Описание;Тип платежа;Имя плательщика;Адрес плательщика;ИНН плательщика 276a9776-000f-5000-a000-179a4d5c6bad;2.00;RUB;1.93;0.07;15.12.2022 12:37:07;41001860899377;Заказ №72;AC;;; 21b212e1-0016-50fb-9000-07aebf184c41;8.00;RUB;7.72;0.28;15.12.2022 15:43:01;41001860899377;Заказ №73;PC;;; 21b212f1-000f-50fb-9000-0866ab629d70;4.00;RUB;3.86;0.14;15.12.2022 17:05:15;41001860899377;Заказ №74;AC;;; Сумма принятых платежей типа AC: 6.00 RUB Сумма принятых платежей за вычетом комиссии типа AC: 5.79 RUB Сумма комиссии за принятые платежи типа AC: 0.21 RUB Число платежей типа AC: 2 Сумма принятых платежей типа PC: 8.00 RUB Сумма принятых платежей за вычетом комиссии типа PC: 7.72 RUB Сумма комиссии за принятые платежи типа PC: 0.28 RUB Число платежей типа PC: 1 Сумма принятых платежей: 14.00 RUB Сумма принятых платежей за вычетом комиссии: 13.51 RUB Сумма комиссии за принятые платежи: 0.49 RUB Число платежей: 3 По договору НЭК.11322.23
This report contains all successful refunds.
By default, it contains the following fields:
| Fields in the report | Description |
|---|---|
| Refund ID | A unique payment ID in YooMoney (if you've integrated via API independently, you'll receive it in the response when creating a payment, in the id field). |
| Payment ID | A unique ID of the initial payment in YooMoney. |
| Refund amount | Transaction amount. The decimals are separated by the dot, and there are always two digits after the decimal point, no thousands separator. |
| Refund currency | Three-letter currency code (RUB for Russian ruble) |
Date and time of refund | Date and time of payment confirmation in YooMoney (in the format dd.MM.yyyy HH:mm:ss). Example: 18.06.2021 17:46:58 |
| ID of the means of payment | A number of the YooMoney wallet from which the payment was made. For other payment methods, it's the internal account number on YooMoney's side. |
| Refund amount in product's currency | Refund amount in product’s currency specified in the store settings. |
| Payment currency | Three-letter currency code (RUB for Russian ruble) |
| Description | The value of the description field |
| Payment type | Code of the payment method on YooMoney’s side. |
In report settings, you can add the following fields:
| Fields in the report | Description |
|---|---|
| Invoice number | Number of issued invoice |
| Where the invoice was sent | Email address or phone number where the invoice was sent. |
| Payer's full name | The name of the invoice recipient. |
| Payment authorization code | A unique transaction code assigned by the bank. |
| Card number | A masked number of the card from which the payment was made. |
| A payer's bank | A name of the bank that issued the payer's card. |
| Payment system of the payer's card | A payment system in which the card operates (MIR, Visa, UnionPay, or other). |
РЕЕСТР ВОЗВРАТОВ ПО ДОГОВОРУ НЭК.11322.23 (152368) Дата возвратов: 2022-12-15 Идентификатор возврата; Идентификатор платежа; Сумма возврата; Валюта возврата; Время возврата; Идентификатор платежного средства; Сумма возврата в валюте товара; Валюта платежа;Описание; Тип платежа 21b212e1-0016-50fb-9000-07aebf184c41;21b212de-000f-50fb-9000-07958ca92b2a;12.29;RUB;15.12.2022 15:52:47;410031218790019;12.29;RUB;Комментарий к возврату;AC 21b212f4-0016-50fb-9000-0742ef0ad6bd;21b212f1-000f-50fb-9000-0866ab629d70;11.52;RUB;15.12.2022 15:53:07;410031218790019;11.52;RUB;Комментарий к возврату 2;AC Сумма возвратов: 23.81 RUB Число возвратов: 2 По договору НЭК.11322.23
| Fields in the report | Description |
|---|---|
| Payment ID | A unique payment ID in YooMoney (if you've integrated via API independently, you'll receive it in the response when making a payment, in the id field). |
| Payment amount | Transaction amount. The decimals are separated by the dot, and there are always two digits after the decimal point, no thousands separator |
| Payment currency | Three-letter currency code (RUB for Russian ruble) |
| Commission amount | Amount of payment commission. The decimals are separated by the dot, and there are always two digits after the decimal point, no thousands separator |
Date and time of payment | Date and time of payment confirmation in YooMoney (in the format dd.MM.yyyy HH:mm:ss). Example: 18.06.2021 17:46:58 |
| Payment type | Code of the payment method on YooMoney’s side. |
| Payment purpose | The purpose of payment is delivered to SberBank Business Online at the moment of creating a draft payment order. The buyer may change it when paying via SberBank Business Online. |
| Full name of the organization | Information about the legal entity that made the payment. |
| Abbreviated name of the organization | Information about the legal entity that made the payment. |
| Address of the organization | Information about the legal entity that made the payment. |
| TIN of the paying organization | Information about the legal entity that made the payment. |
| KPP of the paying organization | Information about the legal entity that made the payment. |
| Name of the organization's bank | Information about the legal entity that made the payment. |
| Bank branch | Information about the legal entity that made the payment. |
| BIC of the paying bank | Information about the legal entity that made the payment. |
| Account number of the organization | Information about the legal entity that made the payment. |
REGISTER OF PAYMENTS FROM LEGAL ENTITIES FOR "Store name" LLC No. 3355 Date of payment: 13.06.2018 Payment ID; Payment amount; Currency; Commission amount; Time of payment; Payment type; Purpose of payment; Full name of the organization; Abbreviated name of the organization; Address of the organization; Taxpayer Identification Number of the organization; Tax Registration Reason Code of the organization; Name of the organization's bank; Branch of the organization's bank; Bank Identification Code of the organization's bank; Account number of the organization; Client ID 549755819524; 100500.00; RUB; 10500.00; 13.06.2018 17:46:58; 2S; Payment for contract No. 123; Public joint-stock company "Name"; PJSC "Name"; 1 Mira prospekt, Moscow, 123995, Russia; 0000000001; 000000001; PAO "SBERBANK of Russia", Severo-Zapadniy bank PAO "SBERBANK of Russia"; 046015602; 123456789; 4999 The amount of 2S-type payments accepted: 100500.00 RUB The amount of fees for 2S-type payments: 10500.00 RUB The number of 2S-type payments: 1 The balance of the deposit account: 60000.00 RUB To: "Store name" LLC (Under contract 111.1111.11)
This information is useful if you'd like to enable automated report processing.
Payment reports and refund reports in CSV format are sent in two separate files, in two emails.
Example of the name for a payment report: yoomoney-payments-shopId-yyyy-MM-dd.csv
Example of the subject for a payment report email: PAYMENT REPORT FOR date FOR shop name (shopId)
Example of the name for a refund report: yoomoney-refunds-shopId-yyyy-MM-dd.csv
Example of the subject for a refund report email: REFUND REPORT FOR date FOR shop name (shopId)
Payments and refunds in Excel format are sent in one file, in one email.
Example of the name: yoomoney-operations-shopId-yyyy-MM-dd.xls
Example of the email subject: PAYMENT AND REFUND REPORT FOR date FOR shop name (shopId)
If the report contains more than 10,000 transactions, it is sent in several files (10,000 transactions in each file and the rest of them in the final one). In this case, the part number is added to the file name: "-part-1", "-part-2", etc, and "-part-N-last" is added to the final part.
Example: yoomoney-payments-shopId-yyyy-MM-dd-part-3-last.csv
If you are receiving reports on the sftp server, there may be a technical problem (e.g. a temporary internet or server failure) when downloading the file. In such a case, YooMoney will retry to download the file until it succeeds. At each attempt, "attempt-N" (where N is the attempt number) is added to the file name.
Example: yoomoney-payments-shopId-yyyy-MM-dd-part-1-attempt-2.csv