SWIFT MT950 Account Balance Statement
This dataset provides comprehensive account balance statements in the SWIFT MT950 format, including opening and closing balances, interim balances, total debits and credits, and transaction counts. Ideal for financial reconciliation, audit trails, and regulatory reporting, it supports detailed analysis of account activity across banks and branches.
Sample rows
preview · 8 of 500 rows · all 18 columns| statement_idstring | opening_balancefloat | account_currencystring | account_numberstring | statement_datedate | opening_balance_datedate | closing_balancefloat | closing_balance_datedate | total_debitsfloat | total_creditsfloat | number_of_debitsinteger | number_of_creditsinteger | interim_balancefloat | interim_balance_datedate | statement_referencestring | bank_namestring | branch_codestring | account_holder_namestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| STAT20230401QXJZ1 | 1500.25 | USD | US12345678ABCD8901 | 2023-04-01 | 2023-03-01 | 1275.4 | 2023-04-01 | 500 | 275.15 | 14 | 8 | 1352.1 | 2023-03-15 | BANKUS20230401 | First National Bank USA | US0031 | Patricia Simmons |
| STAT20230401KLMN2 | 2200 | GBP | GB29NWBK60161331926819 | 2023-04-01 | 2023-03-01 | 2900.5 | 2023-04-01 | 400 | 1100.5 | 9 | 10 | 2600.3 | 2023-03-21 | NWBNGB20230401 | NatWest Bank | GB4561 | William Turner |
| STAT20230401TPQW3 | 500 | EUR | DE89370400440532013000 | 2023-04-01 | 2023-03-01 | 1200 | 2023-04-01 | 200 | 900 | 6 | 12 | 950 | 2023-03-16 | DEUTDE20230401 | Deutsche Bank | DE7201 | Sabine Keller |
| STAT20230401HJKL4 | 0 | EUR | FR7630006000011234567890189 | 2023-04-01 | 2023-03-01 | 0 | 2023-04-01 | 0 | 0 | 0 | 0 | blank | blank | BNPFR20230401 | BNP Paribas | FR3001 | Luc Moreau |
| STAT20230401VBNM5 | 120000 | CHF | CH9300762011623852957 | 2023-04-01 | 2023-03-01 | 125000 | 2023-04-01 | 2000 | 7000 | 2 | 1 | 122500 | 2023-03-20 | UBSCH20230401 | UBS Switzerland | CH9876 | Hans Meier |
| STAT20230401FGHJ6 | 25000 | INR | IN00123456789012345678 | 2023-04-01 | 2023-03-01 | 25000 | 2023-04-01 | 0 | 0 | 0 | 0 | blank | blank | SBIIN20230401 | State Bank of India | IN1002 | Rohit Sharma |
| STAT20230401YUIS7 | 3000000 | JPY | JP892345678901234567 | 2023-04-01 | 2023-03-01 | 3055000 | 2023-04-01 | 100000 | 155000 | 11 | 12 | 3025000 | 2023-03-18 | MIZUJP20230401 | Mizuho Bank | JP3012 | Yuki Tanaka |
| STAT20230401POIU8 | 3750 | CAD | CA1234567890123456 | 2023-04-01 | 2023-03-01 | 3250 | 2023-04-01 | 900 | 400 | 13 | 8 | 3575 | 2023-03-17 | TDCA20230401 | TD Canada Trust | CA2103 | Sandra Martin |
| STAT20230401LKJH9 | 0 | NZD | NZ123456789012345 | 2023-04-01 | 2023-03-01 | 0 | 2023-04-01 | 0 | 0 | 0 | 0 | blank | blank | ANZNZ20230401 | ANZ Bank New Zealand | NZ1014 | Matthew Cooper |
| STAT20230401QWER10 | 900 | SGD | SG1234567890123456 | 2023-04-01 | 2023-03-01 | 1700 | 2023-04-01 | 300 | 1100 | 4 | 10 | 1350 | 2023-03-19 | DBSSG20230401 | DBS Bank | SG0203 | Wei Ling Tan |
| STAT20230401ASDF11 | 0 | AUD | AU1234567890123456 | 2023-04-01 | 2023-03-01 | 0 | 2023-04-01 | 0 | 0 | 0 | 0 | blank | blank | CBAAU20230401 | Commonwealth Bank | AU3210 | Jessica Holmes |
| STAT20230401ZXCV12 | 570000 | KRW | KR1234567890123456 | 2023-04-01 | 2023-03-01 | 585000 | 2023-04-01 | 30000 | 45000 | 18 | 16 | 577000 | 2023-03-20 | KBKR20230401 | Kookmin Bank | KR4012 | Jihoon Lee |
| STAT20230401BNML13 | 250 | BRL | BR1234567890123456 | 2023-04-01 | 2023-03-01 | -200 | 2023-04-01 | 650 | 200 | 12 | 2 | -50 | 2023-03-18 | ITBR20230401 | Itaú Unibanco | BR2020 | Bruna Lima |
| STAT20230401POLK14 | 50 | ZAR | ZA1234567890123456 | 2023-04-01 | 2023-03-01 | 1050 | 2023-04-01 | 0 | 1000 | 0 | 1 | 550 | 2023-03-19 | FNBZA20230401 | First National Bank South Africa | ZA3005 | Sipho Dlamini |
| STAT20230401IUYT15 | 250000 | USD | US87654321DCBA1234 | 2023-04-01 | 2023-03-01 | 240000 | 2023-04-01 | 15000 | 5000 | 4 | 1 | 245000 | 2023-03-15 | BOFAUS20230401 | Bank of America | US0098 | James Reynolds |
| STAT20230401OLKM16 | 1800 | GBP | GB82WEST12345698765432 | 2023-04-01 | 2023-03-01 | 1800 | 2023-04-01 | 0 | 0 | 0 | 0 | blank | blank | WESTGB20230401 | Westpac UK | GB6512 | Alexandra Clark |
| STAT20230401PLKM17 | 3500 | USD | US23456789JKLO8765 | 2023-04-01 | 2023-03-01 | 3725 | 2023-04-01 | 900 | 1125 | 16 | 12 | 3600 | 2023-03-17 | WFUS20230401 | Wells Fargo | US1007 | Brian Foster |
| STAT20230401QAZX18 | 0 | CAD | CA9876543210987654 | 2023-04-01 | 2023-03-01 | 0 | 2023-04-01 | 0 | 0 | 0 | 0 | blank | blank | BMOCA20230401 | Bank of Montreal | CA2105 | Linda Edwards |
| STAT20230401WSXD19 | 1000000 | USD | US34567890MNOP2345 | 2023-04-01 | 2023-03-01 | 950000 | 2023-04-01 | 60000 | 10000 | 2 | 1 | 970000 | 2023-03-20 | CITIUS20230401 | Citibank USA | US1111 | Rachel Goodman |
| STAT20230401EDCR20 | 300 | EUR | FR1420041010050500013M02606 | 2023-04-01 | 2023-03-01 | -400 | 2023-04-01 | 900 | 200 | 17 | 3 | -50 | 2023-03-19 | SGFR20230401 | Société Générale | FR4002 | Julien Lefevre |
What the 500 rows show
from the 500-row sample- 803.2median opening_
balance - 1,275median closing_
balance - 200.0median total_
debits - 200.0median total_
credits - 3median number_
of_ debits - 2median number_
of_ credits
Median 803.2, from 0.0 to 1,000,000,000.
- string 7
- integer 2
- float 5
- date 4
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
statement_id | string | Unique identifier for the account balance statementunique | STAT20230401QXJZ1 |
account_number | string | Bank account number for which the statement is issued | US12345678ABCD8901 |
account_currency | string | ISO 4217 currency code of the account (e.g., USD, EUR) | USD |
statement_reference | string | Reference or identifier provided by the issuing bank for the statementoptional | BANKUS20230401 |
bank_name | string | Name of the bank issuing the statementoptional | First National Bank USA |
branch_code | string | Code identifying the bank branch (if applicable)optional | US0031 |
account_holder_name | string | Name of the account holderoptional | Patricia Simmons |
| Numbers 7 columns | |||
opening_balance | float | Opening balance at the start of the statement period | 1500.25 |
closing_balance | float | Closing balance at the end of the statement period | 1275.4 |
total_debits | float | Total amount of debits during the statement period0 or more | 500 |
total_credits | float | Total amount of credits during the statement period0 or more | 275.15 |
number_of_debits | integer | Number of debit transactions during the statement period0 or more | 14 |
number_of_credits | integer | Number of credit transactions during the statement period0 or more | 8 |
interim_balance | float | Interim balance at a specified point within the statement periodoptional | 1352.1 |
| Dates and times 4 columns | |||
statement_date | date | Date the statement was issued | 2023-04-01 |
opening_balance_date | date | Date of the opening balance | 2023-03-01 |
closing_balance_date | date | Date of the closing balance | 2023-04-01 |
interim_balance_date | date | Date of the interim balanceoptional | 2023-03-15 |
Use it for
A finance dashboard
Opening_
balance and a breakdown of account_ currency. Excel, Power BI or Tableau. What pattern can you find in 500 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 500 rows.
- Statements500STAT20230401QXJZ11500.25STAT20230401KLMN22200STAT20230401TPQW3500
A software demo
Believable statements with account_
number, account_ currency and statement_ date to fill a screen in front of a buyer.
This dataset500 rows18 columns
Yours1,000 rows18 columnsbranch_code: UK only
blueprint · swift-mt950-account-balance-statement
Behind this dataset
Same schema. As many rows as you need.
These 500 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.
Rules it was built with
- Statement reference unique
- Account identification
- Statement number and page
- Opening balance with date
- All transactions itemized
- Value dates for each entry
- Running balance after each transaction
- Closing booked balance
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-mt950-account-balance-statement