ISO20022 Card Payment Clearing (casr.001)

This dataset provides detailed records of card payment clearing messages exchanged between acquirers and issuers, including transaction, settlement, fee, and merchant information. It enables robust analysis of card payment flows, reconciliation, and financial settlement processes, supporting compliance, fraud detection, and operational optimization in the payments industry.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Payment reconciliation and settlement analysis

Sample rows

preview · 8 of 700 rows · all 28 columns
clearing_message_idstringresponse_codestringtransaction_amountfloatcard_schemestringtransaction_idstringacquirer_idstringissuer_idstringcard_number_maskedstringtransaction_typestringtransaction_datetimedatetimeclearing_datetimedatetimetransaction_currencystringsettlement_amountfloatsettlement_currencystringmerchant_idstringmerchant_namestringmerchant_category_codestringmerchant_countrystringauthorization_codestringfee_amountfloatfee_currencystringinterchange_amountfloatinterchange_currencystringreconciliation_referencestringacquirer_countrystringissuer_countrystringprocessing_codestringsettlement_datedate
CLR-00000100158.75VisaTXN-20240601124530-01A2BACQ00123ISS00245************2745Purchase2024-06-01T12:45:30Z2024-06-01T13:25:41ZUSD157.2USDMER-10001NYCoffee US5814USA12B341.55USD0.65USDREC-20240601-001USUS0000002024-06-02
CLR-0000020023.9MasterCardTXN-20240601130517-02B8XACQ00341ISS00422************8392Purchase2024-06-01T13:05:17Z2024-06-01T13:44:56ZUSD23.68USDMER-10002SuperStore US5311USB23C560.22USD0.09USDREC-20240601-002USUS0000002024-06-02
CLR-0000030049.99AmexTXN-20240601131542-03C7YACQ00297ISS00611***********3821Refund2024-06-01T13:15:42Z2024-06-01T13:59:01ZUSD49.6USDMER-10003ZeroSale US5999USC34D780.39USD0.17USDREC-20240601-003USUS2000002024-06-02
CLR-0000041191.45DiscoverTXN-20240601132905-04D4RACQ00512ISS00789************4816Chargeback2024-06-01T13:29:05Z2024-06-01T13:52:10ZUSD91.45USDMER-10004MicroShop US5942USblankblankblankblankblankREC-20240601-004USUS4800002024-06-02
CLR-00000500589VisaTXN-20240601134327-05E6TACQ00666ISS00912**********5369Purchase2024-06-01T13:43:27Z2024-06-01T14:24:05ZUSD583.7USDMER-10005LuxuryCars US5511USD45E895.1USD2.05USDREC-20240601-005USUS0000002024-06-02
CLR-000006001100MasterCardTXN-20240601140009-06F3JACQ00731ISS00345************6227Pre-Authorization2024-06-01T14:00:09Z2024-06-01T14:46:13ZUSD1093.6USDMER-10006USHotels7011USF56G016.4USD2.66USDREC-20240601-006USCA3000002024-06-02
CLR-00000700850UnionPayTXN-20240601141520-07G1KACQ00812ISS00810************1948Completion2024-06-01T14:15:20Z2024-06-01T14:45:17ZUSD844.5USDMER-10007LuxuryCars US5511USG12H235.5USD2.2USDREC-20240601-007USCN4000002024-06-02
CLR-0000080015.8VisaTXN-20240601143044-08H8ZACQ00971ISS00522***********4722Purchase2024-06-01T14:30:44Z2024-06-01T15:03:12ZUSD15.7USDMER-10008NYCoffee US5814USH34J450.1USD0.04USDREC-20240601-008USUS0000002024-06-02

What the 700 rows show

from the 700-row sample
  • 48.5median transaction_amount
  • 6transaction types
  • 6processing codes
  • 9transaction currencies
  • 9settlement currencies
  • 9fee currencies
response_code699 rows by value
03156306210089%32065%28124%18113%
transaction_amount699 rows, in bands of 10k
0350700693500001040k70ktransaction_amount →

Median 48.5, from 0.0 to 65,843.

card_scheme699 rows with a value · 1 left blank
  1. Visa276
  2. MasterCard123
  3. UnionPay73
  4. Other63
  5. JCB62
  6. Amex52
  7. Discover50
28 columns by typefrom the column list below
  • string 21
  • float 4
  • date 1
  • datetime 2

Columns

28 columns in three groups
blueprint · 28 columns
columntypedescriptionexample
Text 21 columns
clearing_message_idstringUnique identifier for the card payment clearing message.uniqueCLR-000001
transaction_idstringUnique identifier for the original card transaction being settled.TXN-20240601124530-01A2B
acquirer_idstringIdentifier for the acquiring bank or institution.ACQ00123
issuer_idstringIdentifier for the issuing bank or institution.ISS00245
card_number_maskedstringMasked card number used in the transaction (e.g., last 4 digits).************2745
card_schemestringCard network or scheme (e.g., Visa, MasterCard, Amex).7 valuesVisa
transaction_typestringType of card transaction (e.g., purchase, refund, reversal).6 valuesPurchase
transaction_currencystringISO 4217 currency code of the transaction (e.g., USD, EUR).9 currenciesUSD
settlement_currencystringISO 4217 currency code for settlement.9 currenciesUSD
merchant_idstringIdentifier for the merchant where the transaction occurred.MER-10001
merchant_namestringName of the merchant.optionalNYCoffee US
merchant_category_codestringMCC code representing the merchant's business category.12 codes · optional5814
merchant_countrystringISO 3166-1 alpha-2 country code for merchant location.optionalUS
authorization_codestringCode provided by issuer authorizing the transaction.optionalA12B34
response_codestringResponse code indicating transaction approval or reason for decline.4 codes00
fee_currencystringCurrency code for the fee amount.9 currencies · optionalUSD
interchange_currencystringCurrency code for interchange amount.9 currencies · optionalUSD
reconciliation_referencestringReference used for reconciliation between acquirer and issuer.optionalREC-20240601-001
acquirer_countrystringISO country code for acquirer institution.optionalUS
issuer_countrystringISO country code for issuer institution.optionalUS
processing_codestringCode indicating how the transaction is processed (ISO8583 standard).6 codes · optional000000
Numbers 4 columns
transaction_amountfloatAmount of the transaction in the transaction currency.0 or more158.75
settlement_amountfloatAmount settled between acquirer and issuer, possibly after fees and conversions.157.2
fee_amountfloatFee charged for processing the transaction.0 or more · optional1.55
interchange_amountfloatInterchange fee amount paid by acquirer to issuer.0 or more · optional0.65
Dates and times 3 columns
transaction_datetimedatetimeDate and time when the original transaction occurred.2024-06-01T12:45:30Z
clearing_datetimedatetimeDate and time when the clearing message was processed.2024-06-01T13:25:41Z
settlement_datedateDate when settlement between acquirer and issuer occurs.optional2024-06-02

Use it for

  • median transac…48.5699 rowsmean transaction amou…701.70060.30680.112126.411

    A finance dashboard

    Transaction_amount by response_code and a breakdown of card_scheme. Excel, Power BI or Tableau.

  • What pattern can you find in 700 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 700 rows.

  • A software demo

    Believable clearing messages with transaction_id, acquirer_id and issuer_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 28 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset700 rows28 columns
Yours1,000 rows28 columnsmerchant_country: UK only

blueprint · iso20022-card-payment-clearing-casr001

Behind this dataset

Same schema. As many rows as you need.

These 700 rows came out of a blueprint — 28 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Original authorization reference
  • Clearing date T+1 or T+2
  • Interchange fee calculated
  • Acquirer and issuer identification
  • Merchant settlement amount
  • Currency conversion if applicable
  • Chargeback period starts
  • Batch reference for grouping
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
iso20022-card-payment-clearing-casr001

More in Finance

Browse all
Also in FinanceISO20022 Financial Institution to Financial Institution Payment Status (pacs.002)Banking Transaction Categorization DatasetDigital Wallet Transaction DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.