SWIFT MT541 Securities Settlement Instruction

This dataset provides comprehensive records of SWIFT MT541 securities settlement instructions, detailing transaction types, parties, securities, payment information, and settlement status. It is ideal for financial institutions to automate, reconcile, and audit securities settlements, supporting regulatory compliance and operational efficiency.

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

Automated reconciliation of securities settlements

Sample rows

preview · 8 of 450 rows · all 22 columns
instruction_idstringtransaction_typestringquantityfloatplace_of_settlementstringtrade_datedatesettlement_datedatesecurity_isinstringsecurity_descriptionstringcurrencystringsettlement_amountfloatcounterparty_bicstringcounterparty_namestringcounterparty_accountstringdepository_bicstringdepository_namestringdepository_accountstringsettlement_methodstringinstruction_statusstringcreated_atdatetimeupdated_atdatetimereference_numberstringnotesstring
INS-00001DVP25000Paris2024-01-022024-01-05FR0000123456BNP Paribas SA Ord ShsEUR1235000.25BNPAFRPPXXXBNP Paribas SecuritiesFR-BNP-ACC12345678901SOGEFRPPXXXSociete Generale SecuritiesFR-SOGE-DEP87654321DVPsettled2023-12-28T10:44:00Z2024-01-05T16:30:00ZEXT-20240105-001Year-start institutional settlement
INS-00002FOP1500London2023-12-292024-01-02GB0002634946Barclays PLC Ord ShsGBP0BARCGB22XXXBarclays LondonGB-BARC-ACC998877665544CRELGB2LXXXClearstream LondonGB-CREL-DEP1122334FOPsettled2023-12-27T09:50:00Z2024-01-02T12:05:00ZEXT-20240102-002Corporate action transfer
INS-00003RVP5000New York2024-02-282024-02-29US0378331005Apple Inc. Common StockUSD855000.5CITIGB2LXXXCitibank NAUS-CITI-ACC11235813213455DTCCUS33XXXDTCC New YorkUS-DTCC-DEP998877RVPpending2024-02-27T14:10:00ZblankblankLeap year receipt
INS-00004DVP225000Frankfurt2024-03-152024-03-18DE0005557508Deutsche Telekom AG Ord ShsEUR3795000DEUTDEFFXXXDeutsche Bank FrankfurtDE-DEUT-ACC6202041CLEARDEFFXXXClearstream FrankfurtDE-CLEAR-DEP753951DVPsettled2024-03-13T09:02:00Z2024-03-18T16:10:00ZEXT-20240318-004Large institutional block
INS-00005FOP120Mumbai2024-01-312024-02-01IN0020100348State Bank of India BondsINRblankSBININBBXXXState Bank of IndiablankNSDLINBBXXXNSDL MumbaiIN-NSDL-DEP101112FOPsettled2024-01-29T11:30:00Z2024-02-01T13:05:00ZEXT-20240201-005Month-end bond distribution
INS-00006DVP80000Helsinki2024-04-022024-04-04FI0009000681Nokia Oyj Ord ShsEUR375200NDEAFIHHXXXNordea Bank FinlandFI-NDEA-ACC321654987EUROFIHHXXXEuroclear FinlandFI-EURO-DEP765432DVPpending2024-04-01T08:44:00Zblankblankblank
INS-00007FOP200Hong Kong2024-05-202024-05-21HK0000059686HSBC Holdings PLC Hong KongHKD0HSBCHKHHXXXHSBC Hong KongHK-HSBC-ACC208877CCASSHKHXXXCCASSHK-CCASS-DEP555555FOPsettled2024-05-19T15:22:00Z2024-05-21T10:15:00ZEXT-20240521-007Dividend distribution
INS-00008RVP350000Moscow2024-06-282024-07-01RU0009029540Gazprom PJSC Ord ShsRUB1400000GAZPRUMMXXXGazprombank MoscowRU-GAZP-ACC87654321NSDERRUMXXXNSD MoscowRU-NSDE-DEP4567890RVPsettled2024-06-27T11:10:00Z2024-07-01T17:45:00ZEXT-20240701-008Quarter-end settlement

What the 450 rows show

from the 450-row sample
  • 3,350median quantity
  • 3settlement methods
  • 4instruction statuses
  • 22currencies
  • 130depository names
  • 670,800median settlement_amount
transaction_type450 rows by value
085170166DVP37%128RVP28%156FOP35%
quantity450 rows, in bands of 100k
0195390389251061612370500k1Mquantity →

Median 3,350, from 0.00 to 1,000,000.

place_of_settlement450 rows · top 10 of 33 values
  1. New York35
  2. Toronto29
  3. Helsinki26
  4. Sydney24
  5. Moscow22
  6. Singapore21
  7. London20
  8. Tokyo20
  9. Zurich20
  10. Dublin20
22 columns by typefrom the column list below
  • string 16
  • float 2
  • date 2
  • datetime 2

Columns

22 columns in three groups
blueprint · 22 columns
columntypedescriptionexample
Text 16 columns
instruction_idstringUnique identifier for the securities settlement instructionuniqueINS-00001
transaction_typestringType of settlement transaction (Delivery vs Payment, Receipt vs Payment, Free of Payment)DVP · RVP · FOPDVP
security_isinstringInternational Securities Identification Number for the securityFR0000123456
security_descriptionstringShort description or name of the securityoptionalBNP Paribas SA Ord Shs
currencystringCurrency code for the settlement amount (ISO 4217)EUR
counterparty_bicstringBank Identifier Code of the counterpartyBNPAFRPPXXX
counterparty_namestringName of the counterparty institutionoptionalBNP Paribas Securities
counterparty_accountstringAccount number at the counterparty institutionoptionalFR-BNP-ACC12345678901
depository_bicstringBank Identifier Code of the securities depositorySOGEFRPPXXX
depository_namestringName of the securities depositoryoptionalClearstream London
depository_accountstringAccount number at the securities depositoryoptionalFR-SOGE-DEP87654321
settlement_methodstringMethod of settlement (e.g., DVP, FOP, RVP)DVP · FOP · RVPDVP
place_of_settlementstringLocation or market where the settlement takes placeoptionalParis
instruction_statusstringCurrent status of the instruction (e.g., pending, settled, cancelled)pending · settled · cancelled · failedsettled
reference_numberstringExternal reference number for reconciliationoptionalEXT-20240105-001
notesstringAdditional remarks or instructionsoptionalLeap year receipt
Numbers 2 columns
quantityfloatNumber of securities to be delivered or received0 or more25000
settlement_amountfloatTotal amount to be paid or received for the transaction0 or more · optional1235000.25
Dates and times 4 columns
trade_datedateDate the trade was executed2024-01-02
settlement_datedateDate the securities are to be settled2024-01-05
created_atdatetimeTimestamp when the instruction was created2023-12-28T10:44:00Z
updated_atdatetimeTimestamp when the instruction was last updatedoptional2024-01-05T16:30:00Z

Use it for

  • median quantity3,350450 rowsmean quantity by tran…121.9kDVP66kRVP939.9FOP

    A finance dashboard

    Quantity by transaction_type and a breakdown of place_of_settlement. Excel, Power BI or Tableau.

  • What pattern can you find in 450 rows?

    A class exercise

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

  • A software demo

    Believable instructions with transaction_type, trade_date and settlement_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 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 dataset450 rows22 columns
Yours1,000 rows22 columns

blueprint · swift-mt541-securities-settlement-instruction

Behind this dataset

Same schema. As many rows as you need.

These 450 rows came out of a blueprint — 22 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
  • Instruction reference unique (field 20C)
  • Settlement date specified (field 98A)
  • ISIN code required (field 35B)
  • Quantity for settlement
  • Delivering agent details
  • Receiving agent details
  • Settlement amount if DVP/RVP
  • Payment currency specified
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-mt541-securities-settlement-instruction

More in Finance

Browse all
Also in FinanceSWIFT MT320 Deposit ConfirmationDigital Wallet Transaction DatasetFinancial Statement Fraud IndicatorsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.