SWIFT MT900 Debit Confirmation

This dataset provides detailed records of SWIFT MT900 debit confirmations, including transaction references, account and institution identifiers, amounts, currencies, and timestamps. It is designed for financial reconciliation, audit trails, and regulatory reporting, supporting robust analysis of account debits and institutional activity.

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

Bank reconciliation and transaction matching

Sample rows

preview · 8 of 402 rows · all 17 columns
confirmation_idstringdebit_amountfloatcurrencystringmessage_typestringtransaction_referencestringaccount_owner_namestringaccount_owner_idstringaccount_numberstringservicing_institution_bicstringservicing_institution_namestringvalue_datedatedebit_datetimedatetimedebit_reasonstringrelated_transaction_idstringstatement_referencestringadditional_informationstringconfirmation_datetimedatetime
CONF00000014200.75GBPMT900TXNREF00001Olivia MartinezCUST0001GB29NWBK60161331926819NWBKGB2LNatWest Bank London2024-05-272024-05-27T10:23:19Mortgage payment MayTXNREL00001STMREF0000000001Monthly direct debit for mortgage loan.2024-05-27T10:27:45
CONF000000212350EURMT900TXNREF00002Lucas ChenCUST0002DE89370400440532013000DEUTDEFFDeutsche Bank Frankfurt2024-05-282024-05-28T14:10:30Tuition fee Spring semesterblankSTMREF0000000002University payment processed.2024-05-28T14:14:19
CONF0000003590.12SEKMT900TXNREF00003Emma JohanssonCUST0003SE3550000000054910000003ESSESESSSEB Bank Stockholm2024-05-292024-05-29T09:03:09Utility bill MayTXNREL00002STMREF0000000003Automated utility payment.2024-05-29T09:05:12
CONF0000004250EURMT900TXNREF00004Sophie DuboisCUST0004FR1420041010050500013M02606BNPAFRPPBNP Paribas Paris2024-05-302024-05-30T16:22:31Mobile phone chargeblankSTMREF0000000004blank2024-05-30T16:23:15
CONF0000005780.55EURMT900TXNREF00005Juan PerezCUST0005ES9121000418450200051332CAIXESBBCaixaBank Barcelona2024-05-312024-05-31T11:15:43Credit card paymentTXNREL00003STMREF0000000005Monthly card bill.2024-05-31T11:17:02
CONF00000063500.2USDMT900TXNREF00006Ava WilsonCUST0006US123456789012345678901234CHASUS33JPMorgan Chase NY2024-06-012024-06-01T13:45:22Rent JuneblankSTMREF0000000006Landlord direct debit.2024-06-01T13:47:39
CONF000000759000AEDMT900TXNREF00007Mohamed HassanCUST0007AE070331234567890123456EBILAEADEmirates NBD Dubai2024-06-022024-06-02T08:30:15Car purchaseTXNREL00004STMREF0000000007Vehicle down payment.2024-06-02T08:33:00
CONF000000832500INRMT900TXNREF00008Priya SharmaCUST0008IN091234567890123456789SBININBBState Bank of India Mumbai2024-06-032024-06-03T12:27:48Education loan EMIblankSTMREF0000000008Automated EMI debit.2024-06-03T12:30:21

What the 402 rows show

from the 402-row sample
debit_amount402 rows, in bands of 2M
02004004000010106M12Mdebit_amount →

Median 725.0, from 22.4 to 12,000,000.

currency402 rows · top 10 of 39 values
  1. EUR121
  2. USD40
  3. GBP31
  4. RUB27
  5. SEK24
  6. AED17
  7. INR14
  8. BRL13
  9. CNY11
  10. PLN10
17 columns by typefrom the column list below
  • string 13
  • float 1
  • date 1
  • datetime 2

Columns

17 columns in three groups
blueprint · 17 columns
columntypedescriptionexample
Text 13 columns
confirmation_idstringUnique identifier for the debit confirmation messageuniqueCONF0000001
message_typestringSWIFT message type, e.g., MT900MT900MT900
transaction_referencestringReference identifier for the transaction being confirmedTXNREF00001
account_owner_namestringName of the account owner whose account was debitedOlivia Martinez
account_owner_idstringUnique identifier for the account owner (e.g., customer number)CUST0001
account_numberstringAccount number of the debited accountGB29NWBK60161331926819
servicing_institution_bicstringBIC code of the account servicing institutionNWBKGB2L
servicing_institution_namestringName of the account servicing institutionNatWest Bank London
currencystringISO 4217 currency code of the debit amountGBP
debit_reasonstringReason or description for the debit transactionoptionalMortgage payment May
related_transaction_idstringIdentifier for a related transaction, if applicableoptionalTXNREL00001
statement_referencestringReference number for the account statement entryoptionalSTMREF0000000001
additional_informationstringAny additional information provided by the servicing institutionoptionalMonthly card bill.
Numbers 1 column
debit_amountfloatAmount debited from the account0.01 or more4200.75
Dates and times 3 columns
value_datedateDate when the debit was executed2024-05-27
debit_datetimedatetimeExact date and time when the debit occurredoptional2024-05-27T10:23:19
confirmation_datetimedatetimeDate and time when the confirmation was sent2024-05-27T10:27:45

Use it for

  • median debit a…725.0402 rows

    A finance dashboard

    Debit_amount and a breakdown of currency. Excel, Power BI or Tableau.

  • What pattern can you find in 402 rows?

    A class exercise

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

  • A software demo

    Believable confirmations with message_type, transaction_reference and account_owner_name to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 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 dataset402 rows17 columns
Yours1,000 rows17 columns

blueprint · swift-mt900-debit-confirmation

Behind this dataset

Same schema. As many rows as you need.

These 402 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.

Rules it was built with
  • Transaction reference (field 20)
  • Related reference if applicable (field 21)
  • Account identification (field 25)
  • Value date of debit (field 32A)
  • Currency and amount
  • Ordering customer if known (field 50)
  • Purpose of debit (field 86)
  • Real-time notification
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-mt900-debit-confirmation

More in Finance

Browse all
Also in FinanceSWIFT MT950 Account Balance StatementBank Transaction Categorization SampleDigital Wallet Transaction DatasetAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.