Scenario 4. Reconciliation reports

Koshelek Pay API

Documentation has moved

The information on this page is no longer updated and may be obsolete. The most current Koshelek documentation is now available at the new address:

https://developers.koshelek.app/en/

About regular reconciliations

To provide regular reporting for transactions made with Koshelek Pay, a special reconcilication reporting process is implemented.

Please note that reconciliation process varies for each of the payment providers (Dolyame / SBP):

• Dolyame: reconciliation is done between merchant's legal entity and Dolyame.

• SBP: reconciliation is done between merchant's legal entity and Koshelek.

Dolyame reconciliations

Reconciliations with Dolyame is arranged as follows:

1	Dolyame service generates transaction registry file and sends it over to merchant's legal entity at specified email address.
2	Merchant's legal entity verifies received data with internal data: Registries match: ОК, no further actions requred. Registries mismatch: merchant's legal entity must communicate mismatch to Dolyame.

• Sender: Dolyame

• Registry types:

  • Daily registry

    • Contains full list of Dolyame transactions for past business day

    • Sent daily

  • Monthly registry

    • Contains full list of Dolyame transactions for past business month

    • Sent in the beginning of month

• Registry format: CSV

• Recipient address: email specified by merchant's legal entity

Example of Dolyame registry

Since Dolyame reconciliations do not involve Koshelek and run strictly between merchant and Dolyame, below example shall not be considered as reference. Registry fields, format and naming conventions may differ, and final representation of the registry shall be agreed between parties at contract signing stage.

2KB

dolyame_123324_2022_09-30.csv

SBP reconciliations

Reconciliations with SBP is arranged as follows:

1	Koshelek server generates transaction registry file and sends it over to merchant's legal entity at specified email address.
2	Merchant's legal entity verifies received data with internal data about Koshelek Pay payment transactions ran through cash desks, and refund transactions received on the account. Registries match: ОК, no further actions requred. Registries mismatch: merchant's legal entity must communicate mismatch to Koshelek.

• Sender: Koshelek (ООО «Бесконтакт»)

• Registry types:

  • Daily registry

    • Contains full list of SBP transactions for past business day

    • Sent daily

  • Monthly registry

    • Contains full list of SBP transactions for past business month

    • Sent in the beginning of month

• Registry format: CSV

• Recipient address: email specified by merchant's legal entity

Example of SBP registry

2KB

Реестр СБП. Бесконтакт-ООО_Ваш-Магазин_(7777777). За 2023-3-13 от 2023-03-14 T040000.csv

Filed mapping: SBP registry <> Pay API

SBP registry field	Description	Pay API field
Operation Id	Unique ID of payment or refund transaction	transactionId for payment refTransactionId for refund
Original payment operation id	Reference to payment transaction ID Note: filled in only for refunds	transactionId for refund
Request Id	Unique ID from cash desk for payment or refund transaction	requestId
Order ID	Purchase ID in merchant system	orderId
Date/Time from POS	Date and Time when transaction request was received from merchant	—
Date/Time to SBP	Date and Time when Koshelek Pay sent a request to SBP to initiate payment / refund transaction	—
Date/Time payment status from SBP	Date and Time when final transaction status was received from SBP	—
Payment Store ID	ID of Store that payment transaction originates from	storeId for payment
Refund Store ID	ID of Store that refund transaction originates from (empty for payments)	storeId for refund
Merchant Id	Merchant ID assigned by SBP (issued by recipient bank which integrates merchant with SBP)	merchantId
Payment Terminal id	ID of POS that processed payment	terminalId for payment
Refund Terminal id	ID of POS that processed refund	terminalId for refund
Amount	Total transaction amount in rubles	totalAmount
Operation Type	Transaction type: payment refund	paymentType
member Id	Merchant's bank ID	memberId configuration stored in Koshelek directories
bank_account_id	Account number for legal entity, individual entrepreneur or self-employed for SBP	bankAccountId
Qrc Id	qrcId number from Pay API request	qrcId