SWIFT MT102 General Financial Institution Transfer
This dataset provides detailed records of bulk financial institution transfers (SWIFT MT102), including individual beneficiary transactions for salary, dividend, and bulk disbursements. Each entry captures sender and beneficiary details, transaction amounts, status, and processing information, enabling granular tracking and compliance reporting for financial operations.
Sample rows
preview · 8 of 450 rows · all 22 columns| transfer_idstring | payment_typestring | amountfloat | beneficiary_address_countrystring | transaction_referencestring | transaction_datedate | currencystring | sender_bank_bicstring | sender_account_numberstring | beneficiary_namestring | beneficiary_account_numberstring | beneficiary_bank_bicstring | beneficiary_address_streetstring | beneficiary_address_citystring | beneficiary_address_statestring | beneficiary_address_postal_codestring | purposestring | statusstring | processing_datetimedatetime | chargesfloat | exchange_ratefloat | remarksstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TRF20240601A | salary | 1563.22 | US | TXN001 | 2024-06-01 | USD | BOFAUS3NXXX | 9123456780 | Jessica Hayden | US123456789012 | CITIUS33XXX | 298 Maple Lane | New York | NY | 10016 | June 2024 payroll for employee E10001 | completed | 2024-06-01T09:48:12 | 1.5 | blank | On-time salary payment |
| TRF20240601A | salary | 1671.09 | US | TXN002 | 2024-06-01 | USD | BOFAUS3NXXX | 9123456780 | Katherine West | US109876543210 | WELLSF1DXXX | 1147 Sycamore St | Los Angeles | CA | 90017 | June 2024 payroll for employee E10002 | completed | 2024-06-01T10:05:34 | 0.75 | blank | On-time salary payment |
| TRF20240601A | salary | 1492.57 | US | TXN003 | 2024-06-01 | USD | BOFAUS3NXXX | 9123456780 | Samuel Patel | US112345678901 | CHASUS33XXX | 49 Oakridge Ave | Houston | TX | 77002 | June 2024 payroll for employee E10003 | completed | 2024-06-01T10:22:09 | 1.25 | blank | On-time salary payment |
| TRF20240601A | salary | 1803.02 | US | TXN004 | 2024-06-01 | USD | BOFAUS3NXXX | 9123456780 | Derek Wong | US109283746512 | PNCBAUS33XXX | 730 Pinecrest Blvd | Chicago | IL | 60604 | June 2024 payroll for employee E10004 | completed | 2024-06-01T10:39:45 | 0.85 | blank | On-time salary payment |
| TRF20240601A | salary | 1645.34 | US | TXN005 | 2024-06-01 | USD | BOFAUS3NXXX | 9123456780 | Megan Lee | US123987654321 | USBKUS44XXX | blank | Seattle | WA | 98101 | June 2024 payroll for employee E10005 | pending | blank | 1.1 | blank | blank |
| TRF20240601A | salary | 1534.47 | US | TXN006 | 2024-06-01 | USD | BOFAUS3NXXX | 9123456780 | Carlos Rivera | US100987654321 | TDOMCATTTOR | 8231 Lincoln Rd | Miami | FL | 33131 | June 2024 payroll for employee E10006 | failed | 2024-06-01T10:51:00 | 1.2 | blank | Transaction failed due to account validation |
| TRF20240601B | bulk_disbursement | 100000 | DE | TXN007 | 2024-06-30 | EUR | DEUTDEFFXXX | DE893704004405 | Meyer & Sons GmbH | DE125001051706 | COBADEFFXXX | 21 Friedrichstrasse | Berlin | blank | 10117 | Supplier Q2 payment | completed | 2024-06-30T14:13:23 | 500 | blank | Bulk supplier payment |
| TRF20240601B | bulk_disbursement | 350000 | GB | TXN008 | 2024-06-30 | EUR | DEUTDEFFXXX | DE893704004405 | Alpha Ltd. | GB29NWBK601613 | BARCGB22XXX | 42 King Street | London | blank | WC2N5DU | Project funding: Thames Delta | pending | blank | 1200 | 0.85 | blank |
| TRF20240601B | bulk_disbursement | 85000 | CN | TXN009 | 2024-06-30 | EUR | DEUTDEFFXXX | DE893704004405 | Liu Manufacturing Co. | CN320010105000 | ICBKCNBJXXX | 90 Nanjing Road | Shanghai | blank | 200003 | Supplier Q2 payment | completed | 2024-06-30T14:29:16 | 950 | 7.98 | Bulk supplier payment |
| TRF20240601B | bulk_disbursement | 2100000 | JP | TXN010 | 2024-06-30 | EUR | DEUTDEFFXXX | DE893704004405 | Matsuda Holdings | JP112233445566 | BOTKJPJTXXX | 1-5 Marunouchi | Tokyo | blank | 100-0005 | Bulk disbursement: Tokyo Project | completed | 2024-06-30T15:02:44 | 25000 | 170.35 | Scheduled for future processing |
| TRF20240601B | bulk_disbursement | 154000 | IT | TXN011 | 2024-06-30 | EUR | DEUTDEFFXXX | DE893704004405 | Rossi SRL | IT60X0542811101000000123456 | BCITITMMXXX | Corso Italia 25 | Milan | MI | 20122 | Bulk disbursement: Milan Expo | completed | 2024-06-30T16:22:51 | 1350 | blank | Bulk supplier payment |
| TRF20240601B | bulk_disbursement | 13500 | FR | TXN012 | 2024-06-30 | EUR | DEUTDEFFXXX | DE893704004405 | Smith Industries | FR7630006000011234567890189 | BNPAFRPPXXX | blank | Paris | blank | 75008 | Project funding: Paris Expansion | completed | 2024-06-30T16:45:17 | 200 | blank | blank |
| TRF20240601C | dividend | 2775.15 | CH | TXN013 | 2024-06-30 | CHF | UBSWCHZH80A | CH9300762011623852957 | Clara Müller | CH5604835012345678001 | ZKBKCHZZ80A | Bahnhofstrasse 8 | Zurich | blank | 8001 | Quarterly dividend Q2/2024 | completed | 2024-06-30T11:15:12 | 2 | blank | End-of-quarter dividend |
| TRF20240601C | dividend | 6500 | CH | TXN014 | 2024-06-30 | CHF | UBSWCHZH80A | CH9300762011623852957 | Bernard Stalder | CH8901234567890123456 | POFICHBEXXX | blank | Geneva | blank | 1202 | Quarterly dividend Q2/2024 | completed | 2024-06-30T11:17:08 | 2 | blank | blank |
| TRF20240601C | dividend | 9200 | CH | TXN015 | 2024-06-30 | CHF | UBSWCHZH80A | CH9300762011623852957 | Schneider AG | CH5004835012345678999 | RAIFCH22XXX | Dorfstrasse 4 | Bern | blank | 3011 | FY2024 profit share payout | failed | 2024-06-30T11:18:32 | 2.5 | blank | IBAN validation failed |
| TRF20240601C | dividend | 710.75 | CH | TXN016 | 2024-06-30 | CHF | UBSWCHZH80A | CH9300762011623852957 | Elena Fischer | CH9100762011623852950 | CRESCHZZ80A | Seestrasse 16 | Zurich | blank | 8002 | Quarterly dividend Q2/2024 | completed | 2024-06-30T11:20:05 | 1.75 | blank | blank |
| TRF20240601C | dividend | 1284.9 | CH | TXN017 | 2024-06-30 | CHF | UBSWCHZH80A | CH9300762011623852957 | Hans Keller | CH7204835012345678002 | ZKBKCHZZ80A | Hauptstrasse 88 | Basel | blank | 4051 | Quarterly dividend Q2/2024 | cancelled | 2024-06-30T11:21:41 | 2 | blank | Dividend payment cancelled |
| TRF20240601D | other | 89.25 | JP | TXN018 | 2024-06-10 | JPY | SMBCJPJTXXX | JP001234567890 | Akira Sato | JP987654321000 | MIZUJPJTXXX | 3-16 Shibuya | Tokyo | blank | 150-0002 | Refund for order #3456 | completed | 2024-06-10T16:06:02 | 0.5 | blank | E-commerce refund |
| TRF20240601D | other | 14.5 | JP | TXN019 | 2024-06-10 | JPY | SMBCJPJTXXX | JP001234567890 | Yuko Tanaka | JP123456789012 | MHCBJPJTXXX | blank | Osaka | blank | 530-0001 | Withdrawal from savings | completed | 2024-06-10T16:07:44 | 0.25 | blank | blank |
| TRF20240601D | other | 2.01 | JP | TXN020 | 2024-06-10 | JPY | SMBCJPJTXXX | JP001234567890 | Kenji Nakamura | JP123490876543 | NISSJPJTXXX | 2-4 Minato | Nagoya | blank | 460-0003 | Credit card payment | completed | 2024-06-10T16:09:15 | 0.1 | blank | Monthly card payment |
What the 450 rows show
from the 450-row sampleBulk_
- 1,637median amount
- 4statuses
- 11currencies
- 43sender bank bics
- 50beneficiary address states
- 77sender accounts
Median 1,637, from 0.01 to 8,500,000.
- string 17
- float 3
- date 1
- datetime 1
Columns
22 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
transfer_id | string | Unique identifier for the bulk transfer instruction (MT102 message)unique | TRF20240601A |
transaction_reference | string | Unique reference for the individual transaction within the bulk transfer | TXN001 |
currency | string | ISO 4217 currency code for the transaction amount11 currencies | USD |
sender_bank_bic | string | BIC code of the sending financial institution | BOFAUS3NXXX |
sender_account_number | string | Account number of the sender initiating the bulk transfer | 9123456780 |
beneficiary_name | string | Full name of the beneficiary receiving the funds | Jessica Hayden |
beneficiary_account_number | string | Account number of the beneficiary | US123456789012 |
beneficiary_bank_bic | string | BIC code of the beneficiary's financial institution | CITIUS33XXX |
beneficiary_address_street | string | Street address of the beneficiaryoptional | 298 Maple Lane |
beneficiary_address_city | string | City of the beneficiary's addressoptional | New York |
beneficiary_address_state | string | State or province of the beneficiary's addressoptional | NY |
beneficiary_address_postal_code | string | Postal code of the beneficiary's addressoptional | 10016 |
beneficiary_address_country | string | Country of the beneficiary's address (ISO 3166-1 alpha-2 code)optional | US |
payment_type | string | Type of payment (e.g., salary, dividend, bulk disbursement)salary · dividend · bulk_disbursement · other | salary |
purpose | string | Narrative or description of the payment purposeoptional | Supplier Q2 payment |
status | string | Current status of the transactionpending · completed · failed · cancelled | completed |
remarks | string | Additional remarks or notes for the transactionoptional | On-time salary payment |
| Numbers 3 columns | |||
amount | float | Amount to be transferred in the transaction0.01 or more | 1563.22 |
charges | float | Any transaction charges or fees applied0 or more · optional | 1.5 |
exchange_rate | float | Exchange rate applied if currency conversion is involved0 or more · optional | 0.85 |
| Dates and times 2 columns | |||
transaction_date | date | Date the individual transaction was initiated | 2024-06-01 |
processing_datetime | datetime | Timestamp when the transaction was processedoptional | 2024-06-01T09:48:12 |
Use it for
A finance dashboard
Amount by payment_
type and a breakdown of beneficiary_ address_ country. Excel, Power BI or Tableau. Why do the 93 bulk_
disbursement rows have a mean amount of 559,820? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Transfers450TRF20240601A1563.22salaryTRF20240601A1671.09salaryTRF20240601A1492.57salary
A software demo
Believable transfers with transaction_
reference, transaction_ date and amount to fill a screen in front of a buyer.
blueprint · swift-mt102-general-financial-institution-transfer
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.
- Sender reference in field 20
- Multiple credit entries in single message
- Total transaction amount in field 32B
- Ordering customer in field 50C/F/K
- Each beneficiary with account and name (field 59)
- Value date applies to all transactions
- Sum validation of individual amounts
- Bank operation code if required (field 23B)
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-mt102-general-financial-institution-transfer