Scenario 4. Reconciliations
Pay API
About regular reconciliations
To provide regular reporting for transactions made with Koshelek Pay, a special reconciliation 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:
- Dolyame service generates transaction registry file and sends it over to merchant’s legal entity at specified email address.
- Merchant’s legal entity verifies received data with internal data:
- Registries match: ОК, no further actions required.
- Registries mismatch: merchant’s legal entity must communicate mismatch to Dolyame.
Dolyame registry: properties
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.
Dolyame registry: example
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.
:fontawesome-regular-file-lines: dolyame_123324_2022_09-30.csv
SBP reconciliations
Reconciliations with SBP is arranged as follows:
- Koshelek server generates transaction registry file and sends it over to merchant’s legal entity at specified email address.
- 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 required.
- Registries mismatch: merchant’s legal entity must communicate mismatch to Koshelek.
SBP registry: properties
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.
SBP registry: example
Field 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 (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 / Time when transaction request was received from merchant. | — |
Date/Time to SBP |
Date / Time when Koshelek Pay sent a request to SBP to initiate payment / refund transaction. | — |
Date/Time payment status from SBP |
Date / 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:
|
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 |