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.

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

Interbank deposit reconciliation and audit

Sample rows

preview · 8 of 400 rows · all 22 columns
confirmation_idstringinterest_basisstringinterest_ratefloataccount_bank_address_statestringtransaction_referencestringsender_bicstringreceiver_bicstringdeposit_amountfloatcurrencystringvalue_datedatematurity_datedateaccount_numberstringaccount_namestringaccount_bank_namestringaccount_bank_address_streetstringaccount_bank_address_citystringaccount_bank_address_postal_codestringaccount_bank_address_countrystringdeposit_typestringconfirmation_datedatetimeremarksstringsettlement_instructionsstring
FZ2J7B9XQKACT/3603.25NYTXREF20240601-001BOFAUS3NXXXDEUTDEFFXXX2500000USD2024-06-012025-06-01009832745Global Holdings LLCBank of America100 Broadway AveNew York10005USFixed2024-06-01T09:12:34Corporate cash managementCredit USD 2500000.00 to account 009832745 at Bank of America, New York
V9N4K2T5WJACT/3651.75blankREF-20240601-002HSBCGB2LXXXBNPAFRPPXXX185000.5EUR2024-06-032024-12-0300123456789Mosaic Trading LtdHSBC UK1 Queen's RoadLondonEC2R8AHGBFixed2024-06-03T10:11:26SME cross-border depositTransfer EUR 185000.50 to account 00123456789 at HSBC UK, London
J6E3R8Q1UZACT/3652.1blankMTC20240601-003NEDSZAJJXXXCITICNSHXXX800000ZAR2024-06-052024-09-05000567891234Rainbow Mining Pty LtdNedbank135 Rivonia RoadJohannesburg2196ZAFixed2024-06-05T14:52:07Major exporterDeposit ZAR 800000.00 to account 000567891234 at Nedbank, Johannesburg
X8M2L7D4PAACT/3650.25blankCALL-20240601-004SMBCJPJTXXXBARCGB22XXX50000000JPY2024-06-07blank000987654321Daiwa TrustSumitomo Mitsui Bank2-1 MarunouchiTokyo100-0005JPCall2024-06-07T11:44:15Funds available on demandCredit JPY 50000000.00 to account 000987654321 at Sumitomo Mitsui Bank, Tokyo
G3B7K9Q6SH30/3600.9blankNOTICE-20240601-005DBSSSGSGXXXOCBCSGSGXXX120000SGD2024-06-08blank0111122233BrightStart Pte LtdDBS Bank12 Marina BoulevardSingapore018982SGNotice2024-06-08T09:03:05Withdrawal notice requiredTransfer SGD 120000.00 to account 0111122233 at DBS Bank, Singapore
K4Z8T2L1FCACT/3654.15NYTXREF20240601-006CHASUS33XXXBKCHCNBJXXX4000000USD2024-06-092025-06-090001234567Evergreen Shipping CoJPMorgan Chase383 Madison AveNew York10017USFixed2024-06-09T16:21:19Corporate treasury operationCredit USD 4000000.00 to account 0001234567 at JPMorgan Chase, New York
Y7F1B3D9LMACT/3602blankREF20240601-007BNPAFRPPXXXCITIUS33XXX900500EUR2024-06-102024-12-100987654321Leclerc SARLBNP Paribas16 Blvd des ItaliensParis75009FRFixed2024-06-10T09:34:28Retail group depositTransfer EUR 900500.00 to account 0987654321 at BNP Paribas, Paris
M2S7Q4P8XEACT/3600.45blankCALL-20240601-008CITICNSHXXXHSBCCNSHXXX15000000CNY2024-06-11blank8765432109Oriental HoldingsChina CITIC Bank99 Century AvenueShanghai200120CNCall2024-06-11T15:09:45Liquidity poolCredit CNY 15000000.00 to account 8765432109 at China CITIC Bank, Shanghai

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
interest_basis400 rows by value
095190190ACT/36048%184ACT/36546%2630/3607%
interest_rate400 rows, in bands of 10
0200400395000000005050100interest_rate →

Median 1.3, from 0.0 to 100.0.

account_bank_address_state154 rows with a value · 246 left blank
  1. NY29
  2. NSW17
  3. BJ15
  4. Tokyo13
  5. ON10
  6. GP10
  7. Beijing7
  8. NC6
  9. TK6
  10. CA6
22 columns by typefrom the column list below
  • string 17
  • float 2
  • date 2
  • datetime 1

Columns

22 columns in three groups
blueprint · 22 columns
columntypedescriptionexample
Text 17 columns
confirmation_idstringUnique identifier for each SWIFT MT320 deposit confirmation messageuniqueFZ2J7B9XQK
transaction_referencestringReference code for the deposit transaction as provided by the sending institutionTXREF20240601-001
sender_bicstringSWIFT/BIC code of the sending financial institutionBOFAUS3NXXX
receiver_bicstringSWIFT/BIC code of the receiving financial institutionDEUTDEFFXXX
currencystringISO 4217 currency code for the deposit amount12 currenciesUSD
interest_basisstringInterest calculation basis (e.g., ACT/360, ACT/365, 30/360)ACT/360 · ACT/365 · 30/360ACT/360
settlement_instructionsstringInstructions for settlement, including account details and payment routingCredit USD 2500000.00 to …
account_numberstringAccount number where funds are to be credited or debited009832745
account_namestringName of the account holder for settlementGlobal Holdings LLC
account_bank_namestringName of the bank where the account is heldBank of America
account_bank_address_streetstringStreet address of the account bankoptional100 Broadway Ave
account_bank_address_citystringCity of the account bankoptionalNew York
account_bank_address_statestringState or province of the account bankoptionalNY
account_bank_address_postal_codestringPostal code of the account bankoptional10005
account_bank_address_countrystringCountry of the account bankoptionalUS
deposit_typestringType of deposit (e.g., Fixed, Call, Notice)Fixed · Call · NoticeFixed
remarksstringAdditional remarks or notes related to the deposit confirmationoptionalSME cross-border deposit
Numbers 2 columns
deposit_amountfloatPrincipal amount of the deposit in the specified currency0.01 or more2500000
interest_ratefloatAnnual interest rate applied to the deposit (percentage)0 to 1003.25
Dates and times 3 columns
value_datedateDate the deposit is placed and starts accruing interest2024-06-01
maturity_datedateDate the deposit matures and principal is returned2025-06-01
confirmation_datedatetimeTimestamp when the confirmation was issued2024-06-01T09:12:34

Use it for

  • median interes…1.3400 rowsmean interest rate by…1.6ACT/3601.5ACT/36519.930/360

    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.

  • A software demo

    Believable confirmations with transaction_reference, sender_bic and receiver_bic to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 22 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 dataset400 rows22 columns
Yours1,000 rows22 columnsaccount_bank_address_street: UK only

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.

Rules it was built with
  • 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
Rows
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-mt320-deposit-confirmation

What should your data show?

Preview 20 rows free
No signup. No card.