SWIFT MT542 Securities Cancellation

This dataset provides comprehensive records of SWIFT MT542 securities settlement cancellation requests, including transaction identifiers, security details, parties involved, and cancellation status. It enables tracking and analysis of cancellation activity, supports regulatory reporting, and facilitates operational risk management in securities settlement operations.

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

Auditing and reconciliation of cancelled securities settlement instructions

Sample rows

preview · 8 of 200 rows · all 19 columns
cancellation_request_idstringcurrencystringquantityfloatreceiver_bicstringoriginal_instruction_idstringtransaction_referencestringcancellation_reason_codestringrequest_datedaterequest_datetimedatetimesender_bicstringsecurity_isinstringsecurity_descriptionstringsettlement_datedatetrade_amountfloatcounterparty_accountstringstatusstringstatus_update_datetimedatetimecancellation_reason_descriptionstringremarksstring
CANREQ00123EUR320.5BNPAFRPPXXXORGINST000456TXREF0987ADUPL2024-06-012024-06-01T13:17:21DEUTDEFF500DE000BASF111BASF SE Common Stock2024-06-0321012.35DE89370400440532013000pendingblankDuplicate instruction identified during reconciliation.Cancellation request submitted promptly.
CANREQ00124EUR1500ABNANL2A005ORGINST000457TXREF0987BERRO2024-06-052024-06-05T09:02:45INGBNL2AXXXNL0000009827Heineken NV Ordinary Shares2024-06-07139800NL91ABNA0417164300accepted2024-06-06T12:54:10Incorrect settlement date in original instruction.Instruction cancelled due to client error.
CANREQ00125USD12000BOFAUS3NXXXORGINST000458TXREF0987CCUST2024-06-102024-06-10T15:31:59CITIUS33XXXUS0378331005Apple Inc. Common Stock2024-06-1223280000210000211234567890accepted2024-06-11T17:09:05Client requested amendment to trade details.Client changed trade terms; cancellation necessary.
CANREQ00126USD800000WELLSF1DXXXORGINST000459TXREF0987DOTHR2024-06-152024-06-15T23:59:59CHASUS33XXXUS5949181045Microsoft Corp Common Stock2024-06-172956000000260095937654321123accepted2024-06-16T08:32:00System outage affected settlement process.High-value trade cancelled due to outage.
CANREQ00127GBP200HSBCGB2LXXXORGINST000460TXREF0987EDUPL2024-06-202024-06-20T07:33:12BARCGB22XXXGB0002634946Barclays PLC Ordinary Shares2024-06-223360GB29XABC10161234567801accepted2024-06-21T09:48:47Instruction sent twice by mistake.Duplicate detected in batch review.
CANREQ00128GBP800LLOYGB2LXXXORGINST000461TXREF0987FERRO2024-06-222024-06-22T12:40:56HSBCGB2LXXXGB00B03MLX29HSBC Holdings PLC Ordinary Shares2024-06-2413440GB92BARC20201530093459rejected2024-06-23T16:15:50Wrong currency selected in original trade.Rejected due to late notification.
CANREQ00129SGD75DBSSSGSGXXXORGINST000462TXREF0987GCUST2024-06-252024-06-25T14:08:38SCBLHKHHXXXSG1L01001701Singapore Airlines Ltd Ordinary Shares2024-06-265000SG90DBSS1234567890pendingblankCounterparty unable to complete trade.Awaiting counterparty confirmation.
CANREQ00130INR100HDFCINBBXXXORGINST000463TXREF0987HOTHR2024-06-272024-06-27T18:22:13ICICINBBXXXINE062A01020State Bank of India Equity Shares2024-06-293200IN91ICIC1234567890123456rejected2024-06-28T10:10:00Regulatory review pending; cancellation required.Rejected after compliance review.

What the 200 rows show

from the 200-row sample

USD currency stands out: mean quantity is 188,998, against 745.0 for the rest.

  • 700.0median quantity
  • 3statuses
  • 4cancellation reason codes
  • 27sender bics
  • 55security isins
  • 21,171median trade_amount
Mean quantity by currency200 rows
0100k200k1,350EUR77 ro…189kUSD40 ro…395.6GBP32 ro…55.9SGD14 ro…35.3MXN13 ro…67.0INR12 ro…47.4AUD12 ro…
quantity200 rows, in bands of 100k
01002001912000000160500k1Mquantity →

Median 700.0, from 0.00 to 1,000,000.

receiver_bic200 rows · top 10 of 31 values
  1. BNPAFRPPXXX23
  2. DEUTDEFFXXX23
  3. BARCGB22XXX17
  4. BOFAUS3NXXX15
  5. CHASUS33XXX11
  6. HSBCGB2LXXX9
  7. HDFCINBBXXX8
  8. BANAMXMMXXX7
  9. DZBKDEFFXXX7
  10. HSBCSGSGXXX7
19 columns by typefrom the column list below
  • string 13
  • float 2
  • date 2
  • datetime 2

Columns

19 columns in three groups
blueprint · 19 columns
columntypedescriptionexample
Text 13 columns
cancellation_request_idstringUnique identifier for the cancellation requestuniqueCANREQ00123
original_instruction_idstringIdentifier of the original securities settlement instruction to be cancelledORGINST000456
transaction_referencestringReference code for the transaction being cancelledTXREF0987A
cancellation_reason_codestringStandard code indicating the reason for cancellationDUPL · ERRO · CUST · OTHRDUPL
cancellation_reason_descriptionstringDetailed description of the cancellation reasonup to 255 · optionalTechnical system error.
sender_bicstringBIC code of the institution sending the cancellation requestDEUTDEFF500
receiver_bicstringBIC code of the institution receiving the cancellation requestBNPAFRPPXXX
security_isinstringISIN code of the security involved in the original instructionDE000BASF111
security_descriptionstringShort description of the security (e.g., company name, instrument type)up to 100 · optionalBASF SE Common Stock
currencystringCurrency code for the transaction (ISO 4217)7 currenciesEUR
counterparty_accountstringAccount number or identifier of the counterparty in the original instructionup to 34 · optionalDE89370400440532013000
statusstringStatus of the cancellation request (e.g., pending, accepted, rejected)pending · accepted · rejectedpending
remarksstringAdditional remarks or notes related to the cancellation requestup to 1,000 · optionalBoundary time request.
Numbers 2 columns
quantityfloatQuantity of securities involved in the original instruction0 or more320.5
trade_amountfloatTotal amount of the trade in the specified currency0 or more · optional21012.35
Dates and times 4 columns
request_datedateDate the cancellation request was made2024-06-01
request_datetimedatetimeTimestamp of when the cancellation request was submitted2024-06-01T13:17:21
settlement_datedateScheduled settlement date of the original instruction2024-06-03
status_update_datetimedatetimeTimestamp of the last status updateoptional2024-06-06T12:54:10

Use it for

  • median quantity700.0200 rowsmean quantity by curr…1.3kEUR189kUSD395.6GBP55.9SGD

    A finance dashboard

    Quantity by currency and a breakdown of receiver_bic. Excel, Power BI or Tableau.

  • Why do the 40 USD rows have a mean quantity of 188,998?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable cancellation requests with original_instruction_id, transaction_reference and cancellation_reason_code to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 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 dataset200 rows19 columns
Yours1,000 rows19 columns

blueprint · swift-mt542-securities-cancellation

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 19 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
  • Reference to original instruction (field 20C)
  • Related reference field populated
  • Cancellation reason specified
  • Original ISIN code referenced
  • Original settlement date
  • Must be before settlement execution
  • Counterparty notification
  • Acknowledgment expected
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
swift-mt542-securities-cancellation

More in Finance

Browse all
Also in FinanceMiFID II Transaction ReportingDigital Wallet Transaction DatasetBank Transaction Categorization SampleAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.