---
title: "Get merchant reconciliation report grouped by settlement for partner"
source_url: https://docs.rapyd.net/en/get-merchant-reconciliation-report-grouped-by-settlement-for-partner.html
lang: en
---

# Get merchant reconciliation report grouped by settlement for partner

Transaction-level reconciliation report grouped by settlement batch, accessible by the partner for a specific merchant. 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](https://docs.rapyd.net/en/merchant-reconciliation-report-695927.md "Merchant Reconciliation Report")

### Parameters

### Request Path Parameters

- - rapyd_client_id
  - The Rapyd client ID of the merchant whose reconciliation report is being retrieved.

  - 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_pages` in the response to paginate.

### Request Header Parameters

- - access_key
  - Unique access key provided by Rapyd for each authorized user.

    See [Developers](https://docs.rapyd.net/en/developers.md "Developers").
- - Content-Type
  - Indicates that the data appears in JSON format. Set to **application/json**.
- - salt
  - Random string. Recommended length: 8-16 characters.
- - signature
  - Signature calculated for each request individually.

    See [Request Signatures](https://docs.rapyd.net/en/request-signatures.md "Request Signatures").
- - timestamp
  - Timestamp for the request, in [Unix time](https://docs.rapyd.net/en/glossary.md#UUID-945d98cf-adae-e1cf-2606-c7fae8b4a7e1_unix_time "Unix time") (seconds).

### 200 OK Response

- - 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.

    - transaction_type
    - Enum: `payment` `refund` `refund_reversal` `payment_reversal`. Type of transaction action.

    - rapyd_transaction_id
    - Unique Rapyd identifier for the transaction.

    - rapyd_reference_id
    - Platform-level reference ID.

    - merchant_reference_id
    - Merchant-supplied reference ID.

    - transaction_method_type
    - Payment method used (for example, sb_rapydgw_card).

    - country
    - Two-letter ISO 3166-1 alpha-2 country code.

    - presentment_currency
    - Currency in which the customer was charged (ISO 4217).

    - presentment_amount
    - Amount charged to the customer.

    - wallet_account_currency
    - Currency of the merchant wallet.

    - wallet_amount
    - Amount credited or debited to the merchant wallet.

    - transaction_exchange_rate_with_markup
    - Applied FX rate including markup.

    - transaction_exchange_rate_without_markup
    - Raw FX rate before markup.

    - transaction_exchange_fee
    - FX conversion fee. Null when no conversion occurred. May be returned as `null`.

    - wallet_debit_credit
    - Enum: `credit` `debit`. Direction of wallet movement.

    - fee_currency
    - Currency in which fees are charged.

    - fee_exchange_rate
    - FX rate used to convert fees to wallet currency.

    - transaction_fees
    - Total platform fee for the transaction.

    - fees_in_wallet_currency
    - Transaction fees in wallet currency.

    - settlement_currency
    - Currency used for settlement (ISO 4217).

    - settlement_exchange_rate
    - FX rate applied at settlement.

    - settlement_amount
    - Net amount settled.

    - reserve_amount
    - Amount held in reserve, if applicable. May be returned as `null`.

    - reserve_currency
    - Currency of the reserve amount. May be returned as `null`.

    - expected_settlement_date
    - Expected settlement date (ISO 8601 UTC). May be returned as `null`.

    - action_created_at
    - Timestamp when the transaction action was created (ISO 8601 UTC).

    - action_closed_at
    - Timestamp when the transaction action was closed (ISO 8601 UTC).

    - rapyd_transaction_group_id
    - Group ID linking related transactions. May be returned as `null`.

    - destination_wallet
    - Wallet ID receiving the funds.

    - billing_wallet
    - Wallet ID responsible for fees.

    - invoice_id
    - Associated invoice identifier.

    - card_brand
    - Card network (for example, VISA). Null for non-card methods. May be returned as `null`.

    - card_type
    - DEBIT or CREDIT. Null for non-card methods. May be returned as `null`.

    - issuing_country
    - ISO country code of the card-issuing bank. May be returned as `null`.

    - issued_card_token
    - Tokenized card identifier, if applicable. May be returned as `null`.

    - card_holder_name
    - Name on the card. Null for non-card methods. May be returned as `null`.

    - issued_bank_account_number
    - Bank account number, for bank-based methods. May be returned as `null`.

    - tax_amount
    - Tax amount applied. May be returned as `null`.

    - tax_currency
    - Currency of the tax amount. May be returned as `null`.

    - tax_amount_in_fee_currency
    - Tax expressed in fee currency. May be returned as `null`.

    - exchange_rate_tax_amount
    - Tax applied on the FX exchange rate. May be returned as `null`.

    - exchange_rate_tax_currency
    - Currency of the exchange-rate tax. May be returned as `null`.

    - exchange_rate_tax_amount_in_fee_currency
    - Exchange-rate tax in fee currency. May be returned as `null`.

    - interchange_fee_amount
    - Interchange fee charged by the card network.

    - scheme_fee_amount
    - Card-scheme fee.

    - source_wallet
    - Source wallet ID (wallet-to-wallet transactions). May be returned as `null`.

    - invoice_currency
    - Currency of the invoice.

    - transaction_exchange_fee_in_invoice_currency
    - FX fee in invoice currency. Null when no conversion occurred. May be returned as `null`.

    - transaction_fees_in_invoice_currency
    - Total fees in invoice currency.

    - sender_name
    - Name of the sender (bank transfers). May be returned as `null`.

    - sender_account_name
    - Account name of the sender. May be returned as `null`.

    - sender_remitter_reference
    - Sender's reference number. May be returned as `null`.

    - sender_sort_code
    - Sort code of the sender's bank. May be returned as `null`.

    - gateway_reference_id
    - Payment gateway reference. May be returned as `null`.

    - static_reference_id
    - Static reference identifier. May be returned as `null`.

    - settlement_id
    - Unique settlement batch ID. Links to `merchant_settlement_report.settlement_id`.

    - wallet_actual_fee_currency_deducted
    - Currency of the fee actually deducted from the wallet. May be returned as `null`.

    - wallet_actual_fee_amount_deducted
    - Fee amount actually deducted from the wallet. May be returned as `null`.

    - transaction_wallet
    - Wallet associated with this specific transaction. May be returned as `null`.

    - beneficiary_name
    - Name of the beneficiary. May be returned as `null`.

    - description
    - Transaction description. May be returned as `null`.

    - platform_type
    - Platform type. May be returned as `null`.

    - transaction_regionality
    - Transaction regionality. May be returned as `null`.

    - platform_fee_count_of_items
    - Number of items included in the platform fee. May be returned as `null`.

    - platform_fee_fee_per_item
    - Per-item platform fee. May be returned as `null`.

    - arn
    - Acquirer Reference Number. May be returned as `null`.

    - transaction_amount_in_settlement_currency
    - Gross transaction amount in settlement currency.

    - fee_amount_in_settlement_currency
    - Fees in settlement currency.

    - transaction_exchange_fee_in_settlement_currency
    - FX fee in settlement currency. Null when no conversion occurred. May be returned as `null`.

    - reserve_amount_in_settlement_currency
    - Reserve amount in settlement currency. May be returned as `null`.

    - sub_merchant_wallet
    - Sub-merchant wallet ID. May be returned as `null`.

    - sub_merchant_name
    - Sub-merchant name. May be returned as `null`.

    - billing_date
    - Date the transaction was billed (ISO 8601 UTC).

    - actual_settlement_date
    - Actual date the settlement occurred (ISO 8601 UTC, for example 2026-05-09T00:00:00Z). May be returned as `null`.

- /v1/recon/partitioned_reports/merchant_reconciliation_by_settlement_report_for_partner/merchant/{rapyd_client_id}/{yyyy}/{mm}/{dd}/{page}

- Get merchant reconciliation report grouped by settlement for partner
- ```curl
  curl -X GET
  https://files.rapyd.net/v1/recon/partitioned_reports/merchant_reconciliation_by_settlement_report_for_partner/merchant/{rapyd_client_id}/{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'
  ```
- ```json
  {
    "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"
      }
    ]
  }
  ```