SWIFT MT320 Deposit Confirmation
This dataset provides detailed records of SWIFT MT320 interbank deposit confirmations, including transaction references, counterparties, deposit amounts, interest rates, maturity dates, and settlement instructions. It enables robust tracking, reconciliation, and analysis of interbank placements and funding activities, supporting risk management and regulatory reporting in financial institutions.
Sample rows
preview · 8 of 400 rows · all 22 columns| confirmation_idstring | interest_basisstring | interest_ratefloat | account_bank_address_statestring | transaction_referencestring | sender_bicstring | receiver_bicstring | deposit_amountfloat | currencystring | value_datedate | maturity_datedate | account_numberstring | account_namestring | account_bank_namestring | account_bank_address_streetstring | account_bank_address_citystring | account_bank_address_postal_codestring | account_bank_address_countrystring | deposit_typestring | confirmation_datedatetime | remarksstring | settlement_instructionsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FZ2J7B9XQK | ACT/360 | 3.25 | NY | TXREF20240601-001 | BOFAUS3NXXX | DEUTDEFFXXX | 2500000 | USD | 2024-06-01 | 2025-06-01 | 009832745 | Global Holdings LLC | Bank of America | 100 Broadway Ave | New York | 10005 | US | Fixed | 2024-06-01T09:12:34 | Corporate cash management | Credit USD 2500000.00 to account 009832745 at Bank of America, New York |
| V9N4K2T5WJ | ACT/365 | 1.75 | blank | REF-20240601-002 | HSBCGB2LXXX | BNPAFRPPXXX | 185000.5 | EUR | 2024-06-03 | 2024-12-03 | 00123456789 | Mosaic Trading Ltd | HSBC UK | 1 Queen's Road | London | EC2R8AH | GB | Fixed | 2024-06-03T10:11:26 | SME cross-border deposit | Transfer EUR 185000.50 to account 00123456789 at HSBC UK, London |
| J6E3R8Q1UZ | ACT/365 | 2.1 | blank | MTC20240601-003 | NEDSZAJJXXX | CITICNSHXXX | 800000 | ZAR | 2024-06-05 | 2024-09-05 | 000567891234 | Rainbow Mining Pty Ltd | Nedbank | 135 Rivonia Road | Johannesburg | 2196 | ZA | Fixed | 2024-06-05T14:52:07 | Major exporter | Deposit ZAR 800000.00 to account 000567891234 at Nedbank, Johannesburg |
| X8M2L7D4PA | ACT/365 | 0.25 | blank | CALL-20240601-004 | SMBCJPJTXXX | BARCGB22XXX | 50000000 | JPY | 2024-06-07 | blank | 000987654321 | Daiwa Trust | Sumitomo Mitsui Bank | 2-1 Marunouchi | Tokyo | 100-0005 | JP | Call | 2024-06-07T11:44:15 | Funds available on demand | Credit JPY 50000000.00 to account 000987654321 at Sumitomo Mitsui Bank, Tokyo |
| G3B7K9Q6SH | 30/360 | 0.9 | blank | NOTICE-20240601-005 | DBSSSGSGXXX | OCBCSGSGXXX | 120000 | SGD | 2024-06-08 | blank | 0111122233 | BrightStart Pte Ltd | DBS Bank | 12 Marina Boulevard | Singapore | 018982 | SG | Notice | 2024-06-08T09:03:05 | Withdrawal notice required | Transfer SGD 120000.00 to account 0111122233 at DBS Bank, Singapore |
| K4Z8T2L1FC | ACT/365 | 4.15 | NY | TXREF20240601-006 | CHASUS33XXX | BKCHCNBJXXX | 4000000 | USD | 2024-06-09 | 2025-06-09 | 0001234567 | Evergreen Shipping Co | JPMorgan Chase | 383 Madison Ave | New York | 10017 | US | Fixed | 2024-06-09T16:21:19 | Corporate treasury operation | Credit USD 4000000.00 to account 0001234567 at JPMorgan Chase, New York |
| Y7F1B3D9LM | ACT/360 | 2 | blank | REF20240601-007 | BNPAFRPPXXX | CITIUS33XXX | 900500 | EUR | 2024-06-10 | 2024-12-10 | 0987654321 | Leclerc SARL | BNP Paribas | 16 Blvd des Italiens | Paris | 75009 | FR | Fixed | 2024-06-10T09:34:28 | Retail group deposit | Transfer EUR 900500.00 to account 0987654321 at BNP Paribas, Paris |
| M2S7Q4P8XE | ACT/360 | 0.45 | blank | CALL-20240601-008 | CITICNSHXXX | HSBCCNSHXXX | 15000000 | CNY | 2024-06-11 | blank | 8765432109 | Oriental Holdings | China CITIC Bank | 99 Century Avenue | Shanghai | 200120 | CN | Call | 2024-06-11T15:09:45 | Liquidity pool | Credit CNY 15000000.00 to account 8765432109 at China CITIC Bank, Shanghai |
| R8P3J6U5TN | ACT/365 | 1.1 | VIC | NOTICE20240601-009 | ANZBAU3MXXX | WBCBAU2SXXX | 50000 | AUD | 2024-06-13 | blank | 0007778889 | BlueSky Ventures | ANZ Bank | 833 Collins Street | Melbourne | 3008 | AU | Notice | 2024-06-13T09:27:16 | Liquidity management | Transfer AUD 50000.00 to account 0007778889 at ANZ Bank, Melbourne |
| S4Q9H2F6LB | ACT/365 | 1.7 | blank | MTC20240601-010 | DEUTDEFFXXX | HSBCGB2LXXX | 2200000 | EUR | 2024-06-15 | 2024-12-15 | 0123456789 | Nordic Steel AG | Deutsche Bank | Taunusanlage 12 | Frankfurt | 60325 | DE | Fixed | 2024-06-15T10:14:52 | Corporate deposit | Deposit EUR 2200000.00 to account 0123456789 at Deutsche Bank, Frankfurt |
| L7U2J5M8VN | ACT/360 | 2.25 | ON | TXREF20240601-011 | CIBCATTXXXX | HSBCCADTTOR | 125000 | CAD | 2024-06-17 | 2024-12-17 | 0003456789 | Maple Leaf Foods | CIBC | 199 Bay Street | Toronto | M5L1A2 | CA | Fixed | 2024-06-17T11:29:31 | Food industry deposit | Credit CAD 125000.00 to account 0003456789 at CIBC, Toronto |
| H5P3D9F2TX | ACT/365 | 0.85 | blank | FX-EDGE20240601-012 | BARCGB22XXX | HSBCGB2LXXX | 375000 | GBP | 2024-06-18 | 2024-09-18 | 0012345678 | London Art Fund | Barclays Bank | 1 Churchill Place | London | E14 5HP | GB | Fixed | 2024-06-18T15:49:02 | Non-profit deposit | Deposit GBP 375000.00 to account 0012345678 at Barclays Bank, London |
| N3D8B5Z1CV | ACT/360 | 0.3 | blank | REF20240601-013 | UBSWCHZHXXX | CITICHBXXX | 95000 | CHF | 2024-06-20 | 2024-12-20 | 0008889997 | Swiss Innovation AG | UBS | Bahnhofstrasse 45 | Zurich | 8001 | CH | Fixed | 2024-06-20T10:22:41 | Tech sector deposit | Credit CHF 95000.00 to account 0008889997 at UBS, Zurich |
| W8E1R9F4LT | 30/360 | 99.99 | ON | TXREF20240601-014 | HSBCCADTTOR | BOFAUS3NXXX | 80000000 | CAD | 2024-06-21 | 2025-06-21 | 0000001234 | Northern Resources | HSBC Canada | 70 York Street | Toronto | M5J1S9 | CA | Fixed | 2024-06-21T11:10:50 | Edge case: boundary values | Deposit CAD 80000000.00 to account 0000001234 at HSBC Canada, Toronto |
| Q2S5F1P8ZK | ACT/365 | 0 | blank | NOTICE20240601-015 | OCBCSGSGXXX | DBSSSGSGXXX | 10000 | SGD | 2024-06-23 | blank | 0023456789 | Test Account Pte Ltd | OCBC Bank | 65 Chulia Street | Singapore | 049513 | SG | Notice | 2024-06-23T09:47:58 | Edge case: zero interest rate | Transfer SGD 10000.00 to account 0023456789 at OCBC Bank, Singapore |
| B4K7P2M9AL | ACT/360 | 1.15 | blank | CALL-20240601-016 | BARCGB22XXX | HSBCGB2LXXX | 89000000 | GBP | 2024-06-24 | blank | 0123456789 | Central Trust | Barclays Bank | 2 Churchill Place | London | E14 5HP | GB | Call | 2024-06-24T11:53:32 | Funds available on demand | Deposit GBP 89000000.00 to account 0123456789 at Barclays Bank, London |
| V6F3J9L2QW | ACT/365 | 2.5 | blank | TXREF20240601-017 | BKCHCNBJXXX | CITICNSHXXX | 1500000 | CNY | 2024-06-25 | 2024-12-25 | 1234567890 | Red Dragon Imports | Bank of China | 1 Finance Street | Beijing | 100033 | CN | Fixed | 2024-06-25T10:34:17 | Corporate cash management | Credit CNY 1500000.00 to account 1234567890 at Bank of China, Beijing |
| T3B7K2M1XG | 30/360 | 0.2 | blank | REF20240601-018 | CITICHBXXX | UBSWCHZHXXX | 80000 | CHF | 2024-06-27 | 2024-12-27 | 9876543210 | Alpine Trading Ltd | China CITIC Bank | No. 6 Fuchengmen | Beijing | 100037 | CN | Fixed | 2024-06-27T09:58:21 | SME cross-border deposit | Deposit CHF 80000.00 to account 9876543210 at China CITIC Bank, Beijing |
| E1T9N6Z3JU | ACT/360 | 2.25 | NY | TXREF20240601-019 | BOFAUS3NXXX | HSBCGB2LXXX | 300000 | USD | 2024-06-29 | 2024-12-29 | 0001112223 | Allied Software Inc | Bank of America | 555 5th Avenue | New York | 10017 | US | Fixed | 2024-06-29T13:57:44 | Corporate deposit | Credit USD 300000.00 to account 0001112223 at Bank of America, New York |
| U9L2E4F7KM | ACT/365 | 4.5 | NSW | NOTICE20240601-020 | WBCBAU2SXXX | ANZBAU3MXXX | 1000000 | AUD | 2024-07-01 | blank | 1234567001 | Test Holdings Pty Ltd | Westpac Bank | 275 Kent Street | Sydney | 2000 | AU | Notice | 2024-07-01T09:11:14 | Liquidity management | Credit AUD 1000000.00 to account 1234567001 at Westpac Bank, Sydney |
What the 400 rows show
from the 400-row sample- 1.3median interest_
rate - 3deposit types
- 12currencies
- 14account bank address countries
- 36account bank address cities
- 68sender bics
Median 1.3, from 0.0 to 100.0.
- string 17
- float 2
- date 2
- datetime 1
Columns
22 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
confirmation_id | string | Unique identifier for each SWIFT MT320 deposit confirmation messageunique | FZ2J7B9XQK |
transaction_reference | string | Reference code for the deposit transaction as provided by the sending institution | TXREF20240601-001 |
sender_bic | string | SWIFT/BIC code of the sending financial institution | BOFAUS3NXXX |
receiver_bic | string | SWIFT/BIC code of the receiving financial institution | DEUTDEFFXXX |
currency | string | ISO 4217 currency code for the deposit amount12 currencies | USD |
interest_basis | string | Interest calculation basis (e.g., ACT/360, ACT/365, 30/360)ACT/360 · ACT/365 · 30/360 | ACT/360 |
settlement_instructions | string | Instructions for settlement, including account details and payment routing | Credit USD 2500000.00 to … |
account_number | string | Account number where funds are to be credited or debited | 009832745 |
account_name | string | Name of the account holder for settlement | Global Holdings LLC |
account_bank_name | string | Name of the bank where the account is held | Bank of America |
account_bank_address_street | string | Street address of the account bankoptional | 100 Broadway Ave |
account_bank_address_city | string | City of the account bankoptional | New York |
account_bank_address_state | string | State or province of the account bankoptional | NY |
account_bank_address_postal_code | string | Postal code of the account bankoptional | 10005 |
account_bank_address_country | string | Country of the account bankoptional | US |
deposit_type | string | Type of deposit (e.g., Fixed, Call, Notice)Fixed · Call · Notice | Fixed |
remarks | string | Additional remarks or notes related to the deposit confirmationoptional | SME cross-border deposit |
| Numbers 2 columns | |||
deposit_amount | float | Principal amount of the deposit in the specified currency0.01 or more | 2500000 |
interest_rate | float | Annual interest rate applied to the deposit (percentage)0 to 100 | 3.25 |
| Dates and times 3 columns | |||
value_date | date | Date the deposit is placed and starts accruing interest | 2024-06-01 |
maturity_date | date | Date the deposit matures and principal is returned | 2025-06-01 |
confirmation_date | datetime | Timestamp when the confirmation was issued | 2024-06-01T09:12:34 |
Use it for
A finance dashboard
Interest_
rate by interest_ basis and a breakdown of account_ bank_ address_ state. 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.
- Confirmations400FZ2J7B9XQK3.25ACT/360V9N4K2T5WJ1.75ACT/365J6E3R8Q1UZ2.1ACT/365
A software demo
Believable confirmations with transaction_
reference, sender_ bic and receiver_ bic to fill a screen in front of a buyer.
blueprint · swift-mt320-deposit-confirmation
Behind this dataset
Same schema. As many rows as you need.
These 400 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.
- Deal reference unique
- Trade date specified
- Value date for deposit
- Maturity date calculated
- Principal amount and currency
- Interest rate agreed
- Day count basis (e.g., ACT/360)
- Interest amount at maturity
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-mt320-deposit-confirmation