SWIFT MT820 Travellers Cheques Refund

This dataset provides detailed records of refund notifications for lost or stolen traveller's cheques, including customer identification, cheque details, verification status, and instructions for replacement. It enables financial institutions to track refund processes, ensure compliance, and support customer service for cheque-related incidents.

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

Automated processing and tracking of traveller's cheque refund requests

Sample rows

preview · 8 of 100 rows · all 31 columns
refund_idstringcustomer_id_typestringcheque_amountfloatreplacement_cheque_currencystringnotification_datedatetimecustomer_namestringcustomer_id_numberstringcustomer_contact_emailstringcustomer_contact_phonestringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringcheque_serial_number_startstringcheque_serial_number_endstringcheque_currencystringcheque_issuerstringloss_report_datedateloss_locationstringverification_statusstringverification_datedatetimereplacement_instructionsstringrefund_statusstringrefund_amountfloatrefund_datedatetimereplacement_cheque_serial_startstringreplacement_cheque_serial_endstringreplacement_cheque_amountfloatreplacement_cheque_issuerstringremarksstring
ZT1GF83KLCpassport300GBP2024-04-17T10:23:11ZAmanda JensenP87456302amanda.jensen@outlook.com+44 7715 98240177 Queen's RdLondonGreater LondonSW7 2AZUnited KingdomTC9845637TC9845639GBPAmerican Express2024-04-16London Heathrow Airportverified2024-04-18T08:09:23ZCollect replacement cheques at branch.completed3002024-04-18T14:40:01ZRC9845701RC9845703300American ExpressCustomer provided police report.
M9T4Y2L8RSnational_id100blank2024-05-02T15:02:45ZCarlos FernándezESX8349021c.fernandez@gmail.com+34 612 839201Calle Mayor 32MadridMadrid28013SpainTC2039451blankEURVisa2024-04-30Madrid Central StationpendingblankblankinitiatedblankblankblankblankblankblankAwaiting document verification.
N5JQ8R1B2Kdriver_license400USD2024-03-22T09:46:30ZEmily WongDLJ98256CAemily.wong@yahoo.com+1 415 332 9821415 Pine AveSan FranciscoCA94107USATC1102987TC1102990USDBank of America2024-03-21Golden Gate Parkverified2024-03-23T12:36:22ZReplacement mailed to home address.completed4002024-03-24T09:17:03ZRC1103012RC1103015400Bank of AmericaCustomer confirmed receipt.
V2H6W9A3QSpassport200blank2024-06-10T17:22:11ZSophie TremblayCA9827611sophie.tremblay@hotmail.com+1 514 220 98111295 Rue Saint-DenisMontrealQCH2X 3J4CanadaTC9182371blankCADRoyal Bank of Canada2024-06-09Montreal Airportpendingblankblankin_progressblankblankblankblankblankblankInvestigation ongoing.
X8D1P5Q6LMnational_id200CHF2024-02-14T12:11:04ZTobias KellerCH8237402t.keller@swissmail.ch+41 79 823 4912Bahnhofstrasse 44ZurichZurich8001SwitzerlandTC5029381TC5029382CHFUBS2024-02-12Zurich Main Stationverified2024-02-14T15:08:17ZPick up at Zurich branch.completed2002024-02-15T10:29:45ZRC5029401RC5029402200UBSblank
R7K4M2V1QZpassport400blank2024-01-07T09:00:00ZAnita SharmaIN9937451anita.sharma@gmail.com+91 98765 3210145 MG RoadDelhiDelhi110001IndiaTC7721301TC7721304USDAmerican Express2024-01-06Delhi IGI AirportpendingblankblankinitiatedblankblankblankblankblankblankIdentity documents requested.
L3B8S6Q9WNdriver_license100USD2024-04-28T18:17:32ZLucas BrownDLN98231NYlucas.brown@aol.com+1 212 555 8341103 5th AveNew YorkNY10003USATC1928374TC1928374USDCitibank2024-04-27Times Squareverified2024-04-29T09:44:22ZReplacement sent by courier.completed1002024-04-29T17:32:11ZRC1928401RC1928401100CitibankCourier tracking provided.
T5V2C9L7ENpassport250blank2024-05-21T11:33:03ZLina MüllerDE2763912l.mueller@mail.de+49 172 8392012Hauptstrasse 22BerlinBerlin10115GermanyTC1938475blankEURDeutsche Bank2024-05-20Berlin Hauptbahnhofrejected2024-05-22T08:15:30ZblankfailedblankblankblankblankblankblankInvalid cheque serial.

What the 100 rows show

from the 100-row sample
  • 300.0median cheque_amount
  • 3verification statuses
  • 4refund statuses
  • 6cheque currencies
  • 28address countries
  • 550median refund_amount
customer_id_type100 rows by value
0255047passport47%30national_id30%23driver_licen…23%
cheque_amount100 rows, in bands of 10k
05010097100011040k70kcheque_amount →

Median 300.0, from 100.0 to 70,000.

replacement_cheque_currency55 rows with a value · 45 left blank
  1. USD24
  2. EUR21
  3. GBP3
  4. CHF3
  5. JPY2
  6. CAD2
31 columns by typefrom the column list below
  • string 24
  • float 3
  • date 1
  • datetime 3

Columns

31 columns in three groups
blueprint · 31 columns
columntypedescriptionexample
Text 24 columns
refund_idstringUnique identifier for the refund notificationuniqueZT1GF83KLC
customer_namestringFull name of the customer requesting the refundAmanda Jensen
customer_id_typestringType of identification provided by the customer (e.g., passport, national_id)passport · national_id · driver_license · otherpassport
customer_id_numberstringIdentification number of the customerP87456302
customer_contact_emailstringCustomer's email address for contact and verificationc.fernandez@gmail.com
customer_contact_phonestringCustomer's phone number for contact and verificationoptional+44 7715 982401
address_streetstringStreet address of the customeroptional77 Queen's Rd
address_citystringCity of the customer's addressoptionalLondon
address_statestringState or province of the customer's addressoptionalGreater London
address_postal_codestringPostal code of the customer's addressoptionalSW7 2AZ
address_countrystringCountry of the customer's addressoptionalUnited Kingdom
cheque_serial_number_startstringSerial number of the first lost/stolen traveller's chequeTC9845637
cheque_serial_number_endstringSerial number of the last lost/stolen traveller's cheque (if a range)optionalTC9845639
cheque_currencystringCurrency of the lost/stolen traveller's cheques8 valuesGBP
cheque_issuerstringName of the institution that issued the traveller's chequesAmerican Express
loss_locationstringLocation where the cheques were lost or stolenoptionalLondon Heathrow Airport
verification_statusstringStatus of verification (e.g., pending, verified, rejected)pending · verified · rejectedverified
replacement_instructionsstringInstructions for replacement of lost/stolen chequesoptionalCollect at Paris branch.
refund_statusstringCurrent status of the refund process (e.g., initiated, completed, failed)initiated · in_progress · completed · failedcompleted
replacement_cheque_serial_startstringSerial number of the first replacement cheque issuedoptionalRC9845701
replacement_cheque_serial_endstringSerial number of the last replacement cheque issued (if a range)optionalRC9845703
replacement_cheque_currencystringCurrency of the replacement cheques8 values · optionalGBP
replacement_cheque_issuerstringName of the institution issuing the replacement chequesoptionalAmerican Express
remarksstringAdditional remarks or notes regarding the refund processoptionalInvestigation ongoing.
Numbers 3 columns
cheque_amountfloatTotal amount of the lost/stolen traveller's cheques0.01 or more300
refund_amountfloatAmount refunded to the customer0 or more · optional300
replacement_cheque_amountfloatTotal amount of the replacement cheques issued0 or more · optional300
Dates and times 4 columns
notification_datedatetimeDate and time when the refund notification was issued2024-04-17T10:23:11Z
loss_report_datedateDate when the loss or theft was reported2024-04-16
verification_datedatetimeDate and time when verification was completedoptional2024-04-18T08:09:23Z
refund_datedatetimeDate and time when the refund was processedoptional2024-04-18T14:40:01Z

Use it for

  • median cheque …300.0100 rowsmean cheque amount by…3kpasspo…924.0nation…391.3driver…

    A finance dashboard

    Cheque_amount by customer_id_type and a breakdown of replacement_cheque_currency. Excel, Power BI or Tableau.

  • What pattern can you find in 100 rows?

    A class exercise

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

  • A software demo

    Believable refunds with notification_date, customer_name and customer_id_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 31 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 dataset100 rows31 columns
Yours1,000 rows31 columnsaddress_street: UK only

blueprint · swift-mt820-travellers-cheques-refund

Behind this dataset

Same schema. As many rows as you need.

These 100 rows came out of a blueprint — 31 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
  • Refund reference unique
  • Original serial numbers of lost cheques
  • Purchaser identification verified
  • Loss date and location
  • Police report reference if applicable
  • Refund amount in original currency
  • Replacement cheques issued
  • Verification procedures completed
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
swift-mt820-travellers-cheques-refund

More in Finance

Browse all
Also in FinanceFinancial Transaction Pattern AnalysisFinancial Statement Fraud IndicatorsBank Customer Segmentation DatasetAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.