SWIFT MT210 Confirmation of Debit
This dataset contains detailed records of SWIFT MT210 debit confirmations, including transaction references, amounts, currency, account owner and servicing institution details, and remittance information. It is ideal for financial institutions, auditors, and compliance teams to track, reconcile, and analyze interbank fund transfers and account debits.
Sample rows
preview · 8 of 400 rows · all 18 columns| confirmation_idstring | debit_amountfloat | account_owner_address_countrystring | transaction_referencestring | message_datedatetime | debit_value_datedate | currencystring | account_owner_namestring | account_owner_identifierstring | account_servicing_institution_namestring | account_servicing_institution_bicstring | account_owner_address_streetstring | account_owner_address_citystring | account_owner_address_statestring | account_owner_address_postal_codestring | remittance_informationstring | sender_referencestring | related_message_idstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Q8Z9JF3L6KX2W1H5 | 3.25 | SG | TRN20201215001 | 2020-12-15T10:23:41Z | 2020-12-15 | SGD | Wei Ming Tan | SG901234567890123 | DBS Bank Ltd | DBSSSGSG | 18 Marina Blvd | Singapore | blank | 018980 | App transfer | blank | blank |
| L2F6GQ9J7B8X3P0V | 5000000 | US | TRN20180105002 | 2018-01-05T14:06:31Z | 2018-01-05 | USD | Jocelyn Cooper | US314159265358979 | Citibank N.A. | CITIUS33 | 123 Liberty St | New York | NY | 10006 | Investment capital injection | BATCH2018A | MT202US20180105 |
| N1K4R8T2S9M7B6E3 | 1200.5 | FR | TRN20230620003 | 2023-06-20T08:00:00Z | 2023-06-20 | EUR | Julien Martin | FR7630006000011234567890189 | BNP Paribas | BNPAFRPP | 25 Rue de Rivoli | Paris | IDF | 75001 | Tuition payment | UNI2023FR | MT103FR20230620 |
| W4M8H2D7S6V1Q9X5 | 35.5 | MX | TRN20210930004 | 2021-09-30T15:55:09Z | 2021-09-30 | MXN | Luis Hernandez | MX10293847561029384756 | BBVA Bancomer | BCMRMXMM | Av. Reforma 123 | Ciudad de México | CDMX | 06600 | Mobile bill | BILLSEP2021 | blank |
| C3J7L6B8H5S2F4N9 | 450.75 | CA | TRN20190801005 | 2019-08-01T12:30:00Z | 2019-08-01 | CAD | Amelia White | CA1234567890123456789 | Royal Bank of Canada | ROYCCAT2 | 200 Bay St | Toronto | ON | M5J2J5 | Rent payment | RENT2019AUG | blank |
| R6D8F3G1Q5K7M2Z4 | 10000000 | AE | TRN20240512006 | 2024-05-12T09:46:02Z | 2024-05-12 | AED | Khalid Al Mansoori | AE470331234567890123456 | Emirates NBD | EBILAEAD | Sheikh Zayed Rd 57 | Dubai | DU | 00000 | Property purchase | PROP2024 | MT202AE20240512 |
| G9B2S1M6H5T8Z4C7 | 0.75 | HK | TRN20170322007 | 2017-03-22T07:50:00Z | 2017-03-22 | HKD | Wing Cheung | HK7890123456789012 | HSBC Hong Kong | HSBCHKHH | 1 Queen's Road | Hong Kong | blank | 00000 | Test transfer | blank | blank |
| T2C7X8B5N1L6F3J4 | 27000 | CH | TRN20200211008 | 2020-02-11T20:10:36Z | 2020-02-11 | CHF | Daniel Meier | CH9300762011623852957 | Credit Suisse | CRESCHZZ80A | Bahnhofstrasse 12 | Zurich | ZH | 8001 | Mortgage settlement | MORT2020CH | MT103CH20200211 |
| F8H3B6V2N5S9L7K1 | 89.99 | AU | TRN20160405009 | 2016-04-05T11:45:20Z | 2016-04-05 | AUD | Olivia Smith | AU123456789012345678 | Commonwealth Bank | CTBAAU2S | 48 George St | Sydney | NSW | 2000 | Shopping payment | SHOP2016AU | blank |
| J2M9S8F1H4Q7G5L6 | 999999.99 | GB | TRN20151218010 | 2015-12-18T17:20:00Z | 2015-12-18 | GBP | Henry Brown | GB29NWBK60161331926819 | NatWest | NWBKGB2L | 10 Downing St | London | ENG | SW1A2AA | Business settlement | SETTLE2015GB | MT202GB20151218 |
| E4B9K6H2T8S1J7V3 | 800.25 | SE | TRN20191129011 | 2019-11-29T09:12:00Z | 2019-11-29 | SEK | Erik Larsson | SE3550000000054910000003 | SEB | ESSESESS | Kungsträdgården 4 | Stockholm | STH | 11147 | Rent | RENT2019SE | blank |
| S5F2K1L9H7M3T8G6 | 195000 | JP | TRN20180523012 | 2018-05-23T16:00:00Z | 2018-05-23 | JPY | Kenji Yamamoto | JP893000000000000000000000 | Mizuho Bank | MHCBJPJT | 2-1 Marunouchi | Tokyo | TK | 100-0005 | Salary payment | SAL2018JP | blank |
| K3V8Q6S5F4M1H2N7 | 21000 | IN | TRN20230109013 | 2023-01-09T14:30:45Z | 2023-01-09 | INR | Priya Sharma | IN09123456789012345678 | State Bank of India | SBININBB | 15 MG Road | Mumbai | MH | 400001 | Tuition fees | TUITION2023IN | MT103IN20230109 |
| H2L5D9N3S7K1F8M4 | 9.99 | NZ | TRN20180718014 | 2018-07-18T13:20:00Z | 2018-07-18 | NZD | James Wilson | NZ12345678901234567 | ANZ Bank New Zealand | ANZBNZ22 | 1 Queen St | Auckland | AUK | 1010 | Micro-payment | blank | blank |
| B7G4T8S5K2F1N9H3 | 15000000 | CN | TRN20210207015 | 2021-02-07T19:20:00Z | 2021-02-07 | CNY | Li Wei | CN987654321012345678 | Bank of China | BKCHCNBJ | 88 Chang'an Ave | Beijing | BJ | 100010 | Corporate investment | INVEST2021CN | MT202CN20210207 |
| M6T1R9Q4V8S2K5F7 | 25.99 | ZA | TRN20160221016 | 2016-02-21T06:30:00Z | 2016-02-21 | ZAR | Thabo Nkosi | ZA123456789012345678 | Standard Bank South Africa | SBZAZAJJ | 101 Sandton Dr | Johannesburg | GT | 2196 | Utility bill | UTIL2016ZA | blank |
| P2N6V3F8K5S1L4H7 | 350000 | BR | TRN20230307017 | 2023-03-07T11:47:00Z | 2023-03-07 | BRL | Ana Souza | BR10987654321098765432 | Banco do Brasil | BRASBRRJ | Av. Paulista 1234 | São Paulo | SP | 01310-100 | Equipment purchase | PURCH2023BR | MT210BR20230307 |
| D5M8K1S2F4N9L7H3 | 2000 | RU | TRN20211125018 | 2021-11-25T17:00:00Z | 2021-11-25 | RUB | Irina Ivanova | RU12345678901234567890 | Sberbank | SABRRUMM | Tverskaya St 12 | Moscow | MOW | 101000 | Bill payment | BILL2021RU | blank |
| A9V4T6G1N3F8S5K2 | 1850.75 | AU | TRN20221214019 | 2022-12-14T08:10:00Z | 2022-12-14 | AUD | Lucas Taylor | AU987654321012345678 | Westpac Banking Corp | WPACAU2S | 100 Pitt St | Sydney | NSW | 2000 | Mortgage payment | MORT2022AU | MT103AU20221214 |
| X3Z5F8K2N7M1T6L9 | 0.01 | US | TRN20161017020 | 2016-10-17T16:30:00Z | 2016-10-17 | USD | Michael Johnson | US1234567890123456 | Bank of America | BOFAUS3N | 150 N Michigan Ave | Chicago | IL | 60601 | Micro-test | blank | blank |
What the 400 rows show
from the 400-row sample- 876.1median debit_
amount - 18currencies
- 65account owner address states
- 68account owner address cities
- 88account servicing institution bics
Median 876.1, from 0.01 to 50,000,000.
- string 15
- float 1
- date 1
- datetime 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
confirmation_id | string | Unique identifier for the SWIFT MT210 confirmation messageunique | Q8Z9JF3L6KX2W1H5 |
transaction_reference | string | Reference number for the underlying transaction | TRN20201215001 |
currency | string | ISO 4217 currency code of the debited amount | SGD |
account_owner_name | string | Name of the account owner whose account was debited | Wei Ming Tan |
account_owner_identifier | string | Unique identifier for the account owner (e.g., account number, IBAN) | SG901234567890123 |
account_servicing_institution_name | string | Name of the institution servicing the account | DBS Bank Ltd |
account_servicing_institution_bic | string | BIC (Bank Identifier Code) of the servicing institution | DBSSSGSG |
account_owner_address_street | string | Street address of the account owneroptional | 18 Marina Blvd |
account_owner_address_city | string | City of the account owneroptional | Singapore |
account_owner_address_state | string | State or province of the account owneroptional | NY |
account_owner_address_postal_code | string | Postal code of the account owneroptional | 018980 |
account_owner_address_country | string | Country of the account owner (ISO 3166-1 alpha-2 code)optional | SG |
remittance_information | string | Additional information or purpose of payment provided in the messageoptional | App transfer |
sender_reference | string | Reference provided by the sender institutionoptional | BATCH2018A |
related_message_id | string | Identifier for any related SWIFT message (e.g., MT103, MT202)optional | MT202US20180105 |
| Numbers 1 column | |||
debit_amount | float | Amount debited from the account for the funds transfer0.01 or more | 3.25 |
| Dates and times 2 columns | |||
message_date | datetime | Date and time when the confirmation message was sent | 2020-12-15T10:23:41Z |
debit_value_date | date | Value date on which the account was debited | 2020-12-15 |
Use it for
A finance dashboard
Debit_
amount and a breakdown of account_ owner_ address_ country. Excel, Power BI or Tableau. What pattern can you find in 400 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 400 rows.
- Confirmations400Q8Z9JF3L6KX2W1H53.25L2F6GQ9J7B8X3P0V5000000N1K4R8T2S9M7B6E31200.5
A software demo
Believable confirmations with transaction_
reference, message_ date and debit_ value_ date to fill a screen in front of a buyer.
blueprint · swift-mt210-confirmation-of-debit
Behind this dataset
Same schema. As many rows as you need.
These 400 rows came out of a blueprint — 18 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.
- Sender reference in field 20
- Related reference to original instruction
- Account identification (field 25)
- Value date of debit (field 30)
- Currency and amount debited (field 32B)
- Ordering customer if applicable
- Account statement line reference
- Nostro/vostro indicator
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-mt210-confirmation-of-debit