Get merchant reconciliation report
Transaction-level reconciliation report. Each row in the data array represents a single transaction action.
Pagination: Request page 0 to retrieve the first page. The response includes a total_pages field that tells you how many pages exist for that date. If there is more than one page, request the remaining pages one at a time (page 1, page 2, and so on up to total_pages), and combine the data array from each page to assemble the full day's records.
See also Informe de conciliación de comercio
yyyy
Four-digit year (for example, 2026).
mm
Two-digit, zero-padded month (for example, 06).
dd
Two-digit, zero-padded day (for example, 18).
page
Page number, starting from 0 (the first page). Use
total_pagesin the response to paginate.
total_pages
Total pages available for the requested date. Use this field value to determine how many additional requests are needed.
current_page
The page number returned in this response.
total_records
Total number of report records across all pages, for completeness verification.
data
Array of report record objects. Field definitions vary by report type.
/v1/recon/partitioned_reports/merchant_reconciliation_report/{yyyy}/{mm}/{dd}/{page}
Get merchant reconciliation report
curl -X GET https://files.rapyd.net/v1/recon/partitioned_reports/merchant_reconciliation_report/{yyyy}/{mm}/{dd}/{page} -H 'access_key: your-access-key-here' \ -H 'Content-Type: application/json' \ -H 'salt: your-random-string-here' \ -H 'signature: your-calculated-signature-here' \ -H 'timestamp: your-unix-timestamp-here'{ "total_pages": 1, "current_page": 0, "total_records": 2, "data": [ { "transaction_type": "payment", "rapyd_transaction_id": "3b2110b8-c1bf-4889-8f7d-8d1968a7a635", "rapyd_reference_id": "payment_fe75dad41ad9023a6f0b8f767c5232e2", "merchant_reference_id": "payment_fe75dad41ad9023a6f0b8f767c5232e2", "transaction_method_type": "sb_rapydgw_card", "country": "IL", "presentment_currency": "AUD", "presentment_amount": 7.92, "wallet_account_currency": "USD", "wallet_amount": 5, "transaction_exchange_rate_with_markup": 0.63120189, "transaction_exchange_rate_without_markup": 0.6507236, "transaction_exchange_fee": 0.15, "wallet_debit_credit": "credit", "fee_currency": "USD", "fee_exchange_rate": 0.65072359, "transaction_fees": 0.48, "fees_in_wallet_currency": 0.48, "settlement_currency": "USD", "settlement_exchange_rate": 1, "settlement_amount": 4.52, "reserve_amount": null, "reserve_currency": null, "expected_settlement_date": "2026-06-20T00:00:00.000Z", "action_created_at": "2026-06-17T00:05:32.000Z", "action_closed_at": "2026-06-17T00:05:32.000Z", "rapyd_transaction_group_id": null, "destination_wallet": "ewallet_4a435918da3fc4d796eea136a2f175c7", "billing_wallet": "ewallet_f7d6a6bfade1cabb06f3e264d8f1899b", "invoice_id": "97041c4ce7e091222ad215aefc3323e7", "card_brand": "VISA", "card_type": "DEBIT", "issuing_country": "PL", "issued_card_token": null, "platform_type": null, "transaction_regionality": null, "card_holder_name": "Auto Test", "issued_bank_account_number": null, "tax_amount": null, "tax_currency": "USD", "tax_amount_in_fee_currency": null, "exchange_rate_tax_amount": null, "exchange_rate_tax_currency": "USD", "exchange_rate_tax_amount_in_fee_currency": null, "interchange_fee_amount": 0, "scheme_fee_amount": 0, "source_wallet": null, "invoice_currency": "USD", "transaction_exchange_fee_in_invoice_currency": 0.15, "transaction_fees_in_invoice_currency": 0.48, "sender_name": null, "sender_account_name": null, "sender_remitter_reference": null, "sender_sort_code": null, "gateway_reference_id": "payment_fe75dad41ad9023a6f0b8f767c5232e2", "static_reference_id": null, "settlement_id": "2254FE70210C5FA494B6ACAA3A22422D", "wallet_actual_fee_currency_deducted": null, "wallet_actual_fee_amount_deducted": null, "transaction_wallet": null, "beneficiary_name": null, "description": null, "platform_fee_count_of_items": null, "platform_fee_fee_per_item": null, "arn": null, "transaction_amount_in_settlement_currency": 5.15, "fee_amount_in_settlement_currency": 0.48, "transaction_exchange_fee_in_settlement_currency": 0.15, "reserve_amount_in_settlement_currency": null, "sub_merchant_wallet": null, "sub_merchant_name": null, "billing_date": "2026-06-18T00:00:00.000Z" }, { "transaction_type": "refund", "rapyd_transaction_id": "ba1eeb06-56ef-4ca8-a032-3769415550c1", "rapyd_reference_id": "refund_783997215f94723e5c9d5095bd705050", "merchant_reference_id": "payment_450560093934ebf6e08c0c355549e21b", "transaction_method_type": "sb_rapydgw_card", "country": "IL", "presentment_currency": "USD", "presentment_amount": 31.73, "wallet_account_currency": "EUR", "wallet_amount": 30, "transaction_exchange_rate_with_markup": 1.057785, "transaction_exchange_rate_without_markup": 1.0905, "transaction_exchange_fee": 0.9, "wallet_debit_credit": "debit", "fee_currency": "EUR", "fee_exchange_rate": 0.721155, "transaction_fees": 0, "fees_in_wallet_currency": 0, "settlement_currency": "EUR", "settlement_exchange_rate": 1, "settlement_amount": 30, "reserve_amount": null, "reserve_currency": null, "expected_settlement_date": "2026-06-18T00:00:00.000Z", "action_created_at": "2026-06-17T00:13:31.000Z", "action_closed_at": "2026-06-17T00:13:31.000Z", "rapyd_transaction_group_id": null, "destination_wallet": "ewallet_4d2a4cd364d93cb2c2ddf62dbff23214", "billing_wallet": "ewallet_f7d6a6bfade1cabb06f3e264d8f1899b", "invoice_id": "97041c4ce7e091222ad215aefc3323e7", "card_brand": "VISA", "card_type": "DEBIT", "issuing_country": "PL", "issued_card_token": null, "platform_type": null, "transaction_regionality": null, "card_holder_name": "Auto Test", "issued_bank_account_number": null, "tax_amount": null, "tax_currency": "EUR", "tax_amount_in_fee_currency": null, "exchange_rate_tax_amount": null, "exchange_rate_tax_currency": "EUR", "exchange_rate_tax_amount_in_fee_currency": null, "interchange_fee_amount": 0, "scheme_fee_amount": 0, "source_wallet": null, "invoice_currency": "EUR", "transaction_exchange_fee_in_invoice_currency": 0.9, "transaction_fees_in_invoice_currency": 0, "sender_name": null, "sender_account_name": null, "sender_remitter_reference": null, "sender_sort_code": null, "gateway_reference_id": null, "static_reference_id": null, "settlement_id": "EB73D1B67B4DA66E83E090A3D20E42DA", "wallet_actual_fee_currency_deducted": null, "wallet_actual_fee_amount_deducted": null, "transaction_wallet": null, "beneficiary_name": null, "description": null, "platform_fee_count_of_items": null, "platform_fee_fee_per_item": null, "arn": null, "transaction_amount_in_settlement_currency": 30.9, "fee_amount_in_settlement_currency": 0, "transaction_exchange_fee_in_settlement_currency": 0.9, "reserve_amount_in_settlement_currency": null, "sub_merchant_wallet": null, "sub_merchant_name": null, "billing_date": "2026-06-18T00:00:00.000Z" } ] }