SWIFT MT548 Securities Movement Confirmation
This dataset provides detailed records of internal securities movement confirmations, including transfers, registrations, withdrawals, and other non-settlement events, as reported via SWIFT MT548 messages. Each record captures transaction references, security identifiers, account relationships, movement types, and confirmation statuses, making it ideal for operational tracking, audit, and compliance in financial institutions.
Sample rows
preview · 8 of 300 rows · all 17 columns| confirmation_idstring | statusstring | quantityfloat | settlement_locationstring | transaction_referencestring | confirmation_datedatetime | movement_typestring | security_isinstring | security_descriptionstring | currencystring | account_numberstring | counterparty_account_numberstring | counterparty_namestring | reason_codestring | reason_descriptionstring | initiator_namestring | commentsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MT548-20240601-00001 | confirmed | 2500 | CREST | TXN-20240601-1001 | 2024-06-01T09:12:34Z | transfer | GB00B03MLX29 | Barclays PLC Ordinary Shares | GBP | ACC-UK-0001 | ACC-UK-0002 | HSBC Securities | INT_TRF | Internal transfer between accounts | Eleanor Fisher | Routine monthly transfer |
| MT548-20240601-00002 | confirmed | 500.25 | DTCC | TXN-20240601-1002 | 2024-06-01T09:21:10Z | registration | US0378331005 | Apple Inc. Common Stock | USD | ACC-US-0003 | blank | blank | CORP_ACT | Corporate action registration | Automated System | Registration following stock split |
| MT548-20240601-00003 | pending | 1000.5 | Euroclear | TXN-20240601-1003 | 2024-06-01T09:34:45Z | withdrawal | FR0000121014 | L'Oréal S.A. Shares | EUR | ACC-FR-0007 | blank | blank | WD_REQ | Client requested withdrawal | Camille Legrand | blank |
| MT548-20240601-00004 | confirmed | 125.75 | Clearstream | TXN-20240601-1004 | 2024-06-01T09:47:22Z | transfer | DE000BASF111 | BASF SE Registered Shares | EUR | ACC-DE-0022 | ACC-DE-0023 | Deutsche Bank | INT_TRF | Internal transfer for portfolio rebalancing | Martin Schulz | Part of quarterly rebalancing |
| MT548-20240601-00005 | confirmed | 20000 | JASDEC | TXN-20240601-1005 | 2024-06-01T10:02:10Z | other | JP3902900004 | Mitsubishi UFJ Financial Group | JPY | ACC-JP-0040 | blank | blank | OTH | Adjustment due to system update | System Admin | Book balance adjustment |
| MT548-20240601-00006 | confirmed | 150 | DTCC | TXN-20240601-1006 | 2024-06-01T10:15:07Z | transfer | US5949181045 | Microsoft Corp. Common Stock | USD | ACC-US-0005 | ACC-US-0008 | Morgan Stanley | INT_TRF | Internal transfer to margin account | Sophie Chen | blank |
| MT548-20240601-00007 | confirmed | 75 | SIX SIS | TXN-20240601-1007 | 2024-06-01T10:24:15Z | withdrawal | CH0012032048 | Nestle SA Registered Shares | CHF | ACC-CH-0015 | blank | blank | WD_REQ | Withdrawal per client request | Lukas Meyer | Urgent withdrawal processed |
| MT548-20240601-00008 | confirmed | 300 | Euroclear | TXN-20240601-1008 | 2024-06-01T10:36:09Z | registration | NL0000235190 | ING Groep NV Shares | EUR | ACC-NL-0006 | blank | blank | CORP_ACT | Dividend registration | Automated System | blank |
| MT548-20240601-00009 | confirmed | 400 | DTCC | TXN-20240601-1009 | 2024-06-01T10:43:22Z | transfer | US4592001014 | IBM Common Stock | USD | ACC-US-0012 | ACC-US-0022 | Goldman Sachs | INT_TRF | Internal transfer to trading account | James Lee | Trade settlement |
| MT548-20240601-00010 | confirmed | 50 | DTCC | TXN-20240601-1010 | 2024-06-01T10:59:17Z | withdrawal | US88160R1014 | Tesla Inc. Common Stock | USD | ACC-US-0007 | blank | blank | WD_REQ | Client withdrawal after sale | Automated System | blank |
| MT548-20240601-00011 | pending | 100 | CDS | TXN-20240601-1011 | 2024-06-01T11:07:12Z | other | CA1363851017 | Canadian National Railway Co. | CAD | ACC-CA-0004 | blank | blank | ADJ | System adjustment for reconciliation | System Admin | Awaiting final review |
| MT548-20240601-00012 | confirmed | 5000 | CHESS | TXN-20240601-1012 | 2024-06-01T11:21:33Z | transfer | AU000000CBA7 | Commonwealth Bank of Australia | AUD | ACC-AU-0009 | ACC-AU-0010 | Westpac Banking | INT_TRF | Internal transfer for settlement | Olivia Turner | Settlement completed |
| MT548-20240601-00013 | confirmed | 1200 | Euroclear | TXN-20240601-1013 | 2024-06-01T11:32:55Z | registration | IE00B4BNMY34 | CRH PLC Ordinary Shares | EUR | ACC-IE-0002 | blank | blank | CORP_ACT | Bonus share registration | Automated System | blank |
| MT548-20240601-00014 | confirmed | 80 | DTCC | TXN-20240601-1014 | 2024-06-01T11:46:39Z | withdrawal | US17275R1023 | Cisco Systems Common Stock | USD | ACC-US-0030 | blank | blank | WD_REQ | Client withdrawal for custody change | Automated System | blank |
| MT548-20240601-00015 | confirmed | 3000 | Euroclear Finland | TXN-20240601-1015 | 2024-06-01T11:59:50Z | other | FI0009007132 | Nokia Oyj Shares | EUR | ACC-FI-0016 | blank | blank | ADJ | Adjustment for share consolidation | System Admin | Consolidation complete |
| MT548-20240601-00016 | confirmed | 250 | DTCC | TXN-20240601-1016 | 2024-06-01T12:13:05Z | transfer | US42809H1077 | Hewlett Packard Enterprise | USD | ACC-US-0021 | ACC-US-0025 | JPMorgan Chase | INT_TRF | Internal transfer for trading | Ava Smith | End-of-day transfer |
| MT548-20240601-00017 | confirmed | 600.5 | Euroclear Belgium | TXN-20240601-1017 | 2024-06-01T12:21:42Z | registration | BE0974293251 | Anheuser-Busch InBev NV Shares | EUR | ACC-BE-0001 | blank | blank | CORP_ACT | Registration for dividend payment | Automated System | blank |
| MT548-20240601-00018 | rejected | 120 | DTCC | TXN-20240601-1018 | 2024-06-01T12:39:25Z | withdrawal | US30231G1022 | Exxon Mobil Corporation | USD | ACC-US-0040 | blank | blank | WD_REQ | Client withdrawal | Automated System | Insufficient balance |
| MT548-20240601-00019 | pending | 100 | DTCC | TXN-20240601-1019 | 2024-06-01T12:47:03Z | other | US1912161007 | Coca-Cola Company Shares | USD | ACC-US-0042 | blank | blank | OTH | Manual adjustment | System Admin | Pending review |
| MT548-20240601-00020 | confirmed | 850 | DTCC | TXN-20240601-1020 | 2024-06-01T13:02:16Z | transfer | US4781601046 | Johnson & Johnson Common Stock | USD | ACC-US-0051 | ACC-US-0052 | Citibank | INT_TRF | Internal transfer for settlement | Mia Johnson | blank |
What the 300 rows show
from the 300-row sample- 300.0median quantity
- 4movement types
- 11currencies
- 28reason codes
Median 300.0, from 2.0 to 500,000.
- string 15
- float 1
- datetime 1
Columns
17 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
confirmation_id | string | Unique identifier for each securities movement confirmation messageunique | MT548-20240601-00001 |
transaction_reference | string | Reference number assigned to the internal securities movement transaction | TXN-20240601-1001 |
movement_type | string | Type of securities movement (e.g., transfer, registration, withdrawal, other)transfer · registration · withdrawal · other | transfer |
security_isin | string | International Securities Identification Number for the security | GB00B03MLX29 |
security_description | string | Description of the security involved in the movementoptional | Apple Inc. Common Stock |
currency | string | Currency code associated with the security movement (if applicable)11 currencies · optional | GBP |
account_number | string | Internal account number from which the securities are moved | ACC-UK-0001 |
counterparty_account_number | string | Internal account number to which the securities are moved (if applicable)optional | ACC-UK-0002 |
counterparty_name | string | Name of the counterparty involved in the movement (if applicable)optional | HSBC Securities |
settlement_location | string | Location or system where the securities are held or registeredoptional | CREST |
reason_code | string | Code indicating the reason for the movement (e.g., internal transfer, corporate action, etc.)optional | INT_TRF |
reason_description | string | Detailed description of the reason for the movementoptional | Dividend registration |
status | string | Status of the movement confirmation (e.g., confirmed, rejected, pending)confirmed · rejected · pending | confirmed |
initiator_name | string | Name of the person or system initiating the movementoptional | Eleanor Fisher |
comments | string | Additional comments or notes regarding the movement confirmationoptional | Routine monthly transfer |
| Numbers 1 column | |||
quantity | float | Number of securities units moved0 or more | 2500 |
| Dates and times 1 column | |||
confirmation_date | datetime | Date and time when the confirmation was issued | 2024-06-01T09:12:34Z |
Use it for
A finance dashboard
Quantity by status and a breakdown of settlement_
location. Excel, Power BI or Tableau. What pattern can you find in 300 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 300 rows.
- Confirmations300MT548-20240601-000012500confirmedMT548-20240601-00002500.25confirmedMT548-20240601-000031000.5pending
A software demo
Believable confirmations with transaction_
reference, confirmation_ date and movement_ type to fill a screen in front of a buyer.
blueprint · swift-mt548-securities-movement-confirmation
Behind this dataset
Same schema. As many rows as you need.
These 300 rows came out of a blueprint — 17 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.
- Movement reference unique (field 20C)
- Movement type: transfer, withdrawal, pledge
- ISIN of security (field 35B)
- Quantity moved
- Movement date effective
- From account specified
- To account specified
- Reason for movement
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-mt548-securities-movement-confirmation