Get merchant reconciliation report grouped by settlement
Transaction-level reconciliation report grouped by settlement batch. Contains all fields of the standard reconciliation report plus actual_settlement_date.
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 Merchant Reconciliation Report
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_by_settlement_report/{yyyy}/{mm}/{dd}/{page}
Get merchant reconciliation report grouped by settlement
curl -X GET https://files.rapyd.net/v1/recon/partitioned_reports/merchant_reconciliation_by_settlement_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": 0, "current_page": 0, "total_records": 0, "data": [ { "transaction_type": "payment", "rapyd_transaction_id": "0dafda2b-57e0-4fe7-9898-6bb436a70b6a", "rapyd_reference_id": "string", "merchant_reference_id": "string", "transaction_method_type": "string", "country": "string", "presentment_currency": "string", "presentment_amount": 0.1, "wallet_account_currency": "string", "wallet_amount": 0.1, "transaction_exchange_rate_with_markup": 0.1, "transaction_exchange_rate_without_markup": 0.1, "transaction_exchange_fee": 0.1, "wallet_debit_credit": "credit", "fee_currency": "string", "fee_exchange_rate": 0.1, "transaction_fees": 0.1, "fees_in_wallet_currency": 0.1, "settlement_currency": "string", "settlement_exchange_rate": 0.1, "settlement_amount": 0.1, "reserve_amount": 0.1, "reserve_currency": "string", "expected_settlement_date": "2019-08-24T14:15:22Z", "action_created_at": "2019-08-24T14:15:22Z", "action_closed_at": "2019-08-24T14:15:22Z", "rapyd_transaction_group_id": "string", "destination_wallet": "string", "billing_wallet": "string", "invoice_id": "string", "card_brand": "string", "card_type": "string", "issuing_country": "string", "issued_card_token": "string", "card_holder_name": "string", "issued_bank_account_number": "string", "tax_amount": 0.1, "tax_currency": "string", "tax_amount_in_fee_currency": 0.1, "exchange_rate_tax_amount": 0.1, "exchange_rate_tax_currency": "string", "exchange_rate_tax_amount_in_fee_currency": 0.1, "interchange_fee_amount": 0.1, "scheme_fee_amount": 0.1, "source_wallet": "string", "invoice_currency": "string", "transaction_exchange_fee_in_invoice_currency": 0.1, "transaction_fees_in_invoice_currency": 0.1, "sender_name": "string", "sender_account_name": "string", "sender_remitter_reference": "string", "sender_sort_code": "string", "gateway_reference_id": "string", "static_reference_id": "string", "settlement_id": "string", "wallet_actual_fee_currency_deducted": "string", "wallet_actual_fee_amount_deducted": 0.1, "transaction_wallet": "string", "beneficiary_name": "string", "description": "string", "platform_type": "string", "transaction_regionality": "string", "platform_fee_count_of_items": 0.1, "platform_fee_fee_per_item": 0.1, "arn": "string", "transaction_amount_in_settlement_currency": 0.1, "fee_amount_in_settlement_currency": 0.1, "transaction_exchange_fee_in_settlement_currency": 0.1, "reserve_amount_in_settlement_currency": 0.1, "sub_merchant_wallet": "string", "sub_merchant_name": "string", "billing_date": "2019-08-24T14:15:22Z", "actual_settlement_date": "2019-08-24T14:15:22Z" } ] }