ISO20022 Card Chargeback (casr.003)
This dataset provides comprehensive records of card chargeback transactions, detailing disputed payments, standardized reason codes, investigation progress, and representment deadlines. It enables financial institutions, merchants, and regulators to analyze chargeback trends, monitor dispute resolution processes, and ensure compliance with ISO20022 standards.
Sample rows
preview · 8 of 300 rows · all 20 columns| chargeback_idstring | investigation_statusstring | transaction_amountfloat | representment_submittedboolean | final_decisionstring | original_transaction_idstring | card_number_maskedstring | cardholder_namestring | merchant_namestring | merchant_idstring | transaction_currencystring | transaction_datedatetime | chargeback_datedatetime | chargeback_reason_codestring | chargeback_reason_descriptionstring | investigator_idstring | representment_deadlinedate | representment_datedatetime | final_decision_datedatetime | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CB-001-2024-01 | pending | 129.99 | false | pending | TX-7845123 | 9142 | Amanda Hughes | BestBuy San Francisco | M-238947 | USD | 2024-01-12T13:28:15 | 2024-01-14T09:17:35 | FR01 | Unauthorized transaction reported by cardholder | INV-1001 | 2024-01-30 | blank | blank | Cardholder claims card was stolen prior to purchase. |
| CB-002-2024-01 | in_review | 22.5 | true | cardholder_won | TX-7845124 | 2754 | Michael Chen | Uber Technologies | M-239001 | USD | 2024-01-07T21:44:51 | 2024-01-09T10:10:00 | NR02 | Goods or services not received | INV-1002 | 2024-01-28 | 2024-01-15T15:32:17 | 2024-01-22T09:00:00 | Merchant unable to provide evidence of completed ride. |
| CB-003-2024-01 | resolved | 59.99 | false | chargeback_accepted | TX-7845125 | 5661 | Elena Garcia | Amazon UK | M-239002 | GBP | 2024-01-04T16:00:31 | 2024-01-08T11:48:20 | FR01 | Suspected fraudulent transaction | INV-1003 | 2024-01-23 | blank | 2024-01-20T12:30:00 | Cardholder confirmed no knowledge of purchase. |
| CB-004-2024-01 | pending | 3.75 | false | blank | TX-7845126 | 7317 | Rajesh Kumar | Starbucks India | M-239003 | INR | 2024-01-06T08:41:19 | 2024-01-07T13:59:22 | NR03 | Cardholder claims incorrect amount charged | blank | 2024-01-21 | blank | blank | Merchant to provide receipt for verification. |
| CB-005-2024-01 | in_review | 94.2 | false | blank | TX-7845127 | 8821 | Linda Nielsen | Zalando SE | M-239004 | EUR | 2024-01-10T17:22:05 | 2024-01-12T13:08:59 | FR02 | Suspicious activity detected | INV-1004 | 2024-01-29 | blank | blank | High-value order flagged by issuer. |
| CB-006-2024-01 | resolved | 45.67 | true | merchant_won | TX-7845128 | 4902 | Grace Lee | Target Stores | M-239005 | USD | 2024-01-09T13:05:00 | 2024-01-11T10:45:11 | NR02 | Merchandise not received | INV-1005 | 2024-01-25 | 2024-01-13T11:02:35 | 2024-01-17T13:45:00 | Tracking info provided, delivery confirmed. |
| CB-007-2024-01 | reversed | 31.49 | true | chargeback_reversed | TX-7845129 | 1903 | Aaron Smith | Walmart Canada | M-239006 | CAD | 2024-01-14T19:20:49 | 2024-01-15T09:21:30 | NR03 | Incorrect item delivered | INV-1006 | 2024-01-31 | 2024-01-20T14:15:17 | 2024-01-27T11:00:00 | Merchant replaced item after investigation. |
| CB-008-2024-01 | in_review | 78 | false | blank | TX-7845130 | 6018 | Nina Johansson | H&M Sweden | M-239007 | SEK | 2024-01-02T10:15:00 | 2024-01-05T08:59:46 | FR01 | Cardholder claims not present at time of purchase | INV-1007 | 2024-01-20 | blank | blank | Dispute under review. |
| CB-009-2024-01 | pending | 14.95 | false | blank | TX-7845131 | 4126 | Lucas Brown | Etsy Marketplace | M-239008 | USD | 2024-01-13T13:55:12 | 2024-01-15T10:17:23 | NR02 | Digital product not delivered | blank | 2024-01-28 | blank | blank | Awaiting merchant response. |
| CB-010-2024-01 | resolved | 25.1 | true | merchant_won | TX-7845132 | 3874 | Julia Fischer | Lidl Germany | M-239009 | EUR | 2024-01-03T17:33:44 | 2024-01-06T09:00:00 | NR04 | Service not as described | INV-1008 | 2024-01-19 | 2024-01-10T10:30:00 | 2024-01-15T15:00:00 | Evidence supports merchant claim. |
| CB-011-2024-01 | in_review | 52.75 | false | blank | TX-7845133 | 6631 | Victor Nguyen | Sainsbury's London | M-239010 | GBP | 2024-01-09T09:24:00 | 2024-01-11T10:45:00 | NR03 | Overcharged for groceries | INV-1009 | 2024-01-27 | blank | blank | Receipt requested for verification. |
| CB-012-2024-01 | pending | 63 | false | blank | TX-7845134 | 2347 | Isabella Rossi | Carrefour France | M-239011 | EUR | 2024-01-08T13:10:10 | 2024-01-10T09:30:00 | FR01 | Cardholder claims transaction is fraudulent | blank | 2024-01-23 | blank | blank | Cardholder reported lost card. |
| CB-013-2024-01 | in_review | 999.99 | false | blank | TX-7845135 | 7832 | Daniel Evans | Apple Store | M-239012 | USD | 2024-01-05T15:42:01 | 2024-01-08T14:17:00 | FR02 | High-value purchase flagged as suspicious | INV-1010 | 2024-01-24 | blank | blank | Issuer investigation ongoing. |
| CB-014-2024-01 | pending | 150.5 | false | blank | TX-7845136 | 4256 | Mohammed Al-Farsi | Noon UAE | M-239013 | AED | 2024-01-13T20:30:00 | 2024-01-15T09:00:00 | NR02 | Cardholder claims item not delivered | blank | 2024-01-28 | blank | blank | Merchant to provide shipping confirmation. |
| CB-015-2024-01 | resolved | 38.75 | true | cardholder_won | TX-7845137 | 8472 | Sophie Dubois | FNAC Paris | M-239014 | EUR | 2024-01-10T16:17:00 | 2024-01-12T11:00:00 | NR04 | Product description mismatch | INV-1011 | 2024-01-27 | 2024-01-18T12:00:00 | 2024-01-23T14:00:00 | Product returned, refund issued. |
| CB-016-2024-01 | pending | 8000 | false | blank | TX-7845138 | 6591 | Yuki Yamamoto | Rakuten Japan | M-239015 | JPY | 2024-01-03T09:45:00 | 2024-01-05T11:23:00 | FR01 | Multiple unauthorized charges detected | blank | 2024-01-20 | blank | blank | Issuer monitoring for further activity. |
| CB-017-2024-01 | reversed | 64 | true | chargeback_reversed | TX-7845139 | 9127 | Emily Carter | Tesco Ireland | M-239016 | EUR | 2024-01-12T14:00:00 | 2024-01-13T10:15:00 | NR03 | Incorrect billing amount | INV-1012 | 2024-01-29 | 2024-01-20T15:00:00 | 2024-01-26T12:00:00 | Merchant refunded difference. |
| CB-018-2024-01 | pending | 210.85 | false | blank | TX-7845140 | 6731 | Carlos Silva | Mercado Livre Brazil | M-239017 | BRL | 2024-01-08T08:17:00 | 2024-01-10T09:00:00 | NR02 | Order never shipped | blank | 2024-01-27 | blank | blank | Merchant failed to respond. |
| CB-019-2024-01 | in_review | 350 | false | blank | TX-7845141 | 3204 | James O'Connor | Airbnb Ireland | M-239018 | EUR | 2024-01-06T20:00:00 | 2024-01-09T09:30:00 | NR04 | Accommodation not as described | INV-1013 | 2024-01-26 | blank | blank | Awaiting merchant response. |
| CB-020-2024-01 | resolved | 120 | true | cardholder_won | TX-7845142 | 5739 | Anna Müller | Booking.com | M-239019 | EUR | 2024-01-11T18:30:00 | 2024-01-14T10:00:00 | NR02 | Hotel booking not honored | INV-1014 | 2024-01-30 | 2024-01-18T13:00:00 | 2024-01-24T12:00:00 | Merchant unable to provide confirmation. |
What the 300 rows show
from the 300-row sampleResolved (investigation status) stands out: 70 of its 81 rows have representment_
- 37%representment_
submitted = true - 62.0median transaction_
amount - 18chargeback reason codes
- 24transaction currencies
Median 62.0, from 3.8 to 15,000.
- string 13
- float 1
- date 1
- datetime 4
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
chargeback_id | string | Unique identifier for the chargeback transactionunique | CB-001-2024-01 |
original_transaction_id | string | Reference identifier for the original card payment transaction | TX-7845123 |
card_number_masked | string | Masked card number involved in the disputed transaction (e.g., last 4 digits) | 9142 |
cardholder_name | string | Name of the cardholder who initiated the dispute | Amanda Hughes |
merchant_name | string | Name of the merchant where the original transaction occurred | BestBuy San Francisco |
merchant_id | string | Unique identifier for the merchantoptional | M-238947 |
transaction_currency | string | Currency code of the original transaction (ISO 4217) | USD |
chargeback_reason_code | string | Standardized reason code for the chargeback (e.g., fraud, goods not received) | FR01 |
chargeback_reason_description | string | Detailed description of the chargeback reasonoptional | Merchandise not received |
investigation_status | string | Current status of the chargeback investigationpending · in_review · resolved · declined · reversed | pending |
investigator_id | string | Identifier for the person or team handling the investigationoptional | INV-1001 |
final_decision | string | Final outcome of the chargeback case5 values · optional | pending |
notes | string | Additional notes or comments related to the chargeback caseoptional | Dispute under review. |
| Numbers 1 column | |||
transaction_amount | float | Amount of the original transaction0.01 or more | 129.99 |
| Dates and times 5 columns | |||
transaction_date | datetime | Date and time of the original transaction | 2024-01-12T13:28:15 |
chargeback_date | datetime | Date and time when the chargeback was initiated | 2024-01-14T09:17:35 |
representment_deadline | date | Deadline for the merchant to submit representment evidence | 2024-01-30 |
representment_date | datetime | Date and time when representment evidence was submittedoptional | 2024-01-15T15:32:17 |
final_decision_date | datetime | Date and time when the final decision was madeoptional | 2024-01-22T09:00:00 |
| True or false 1 column | |||
representment_submitted | boolean | Indicates whether representment evidence has been submitted by the merchant | false |
Use it for
A finance dashboard
The representment_
submitted rate, transaction_ amount by investigation_ status and a breakdown of final_ decision. Excel, Power BI or Tableau. Why do 110 of 300 rows have representment_
submitted = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Chargebacks300CB-001-2024-01129.99pendingCB-002-2024-0122.5in_reviewCB-006-2024-0145.67resolved
A software demo
Believable chargebacks with original_
transaction_ id, card_ number_ masked and cardholder_ name to fill a screen in front of a buyer.
This dataset300 rows20 columns
Yours1,000 rows20 columns
blueprint · iso20022-card-chargeback-casr003
Behind this dataset
Same schema. As many rows as you need.
These 300 rows came out of a blueprint — 20 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 transaction reference
- Chargeback reason code per card scheme
- Dispute amount not exceeding original
- Time limit for chargeback filing
- Supporting evidence attached
- Merchant notification sent
- Representment deadline calculated
- Provisional credit to cardholder
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-chargeback-casr003