SWIFT MT410 Advice of Payment

This dataset provides detailed records of SWIFT MT410 Advice of Payment messages, including transaction references, payment amounts, involved banks, payer details, and message status. It enables financial institutions to track, reconcile, and audit documentary collection payments efficiently, supporting compliance and operational transparency.

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

Reconciliation of documentary collection payments between banks

Sample rows

preview · 8 of 200 rows · all 28 columns
message_idstringmessage_statusstringcollection_amountfloatcollecting_bank_citystringtransaction_reference_numberstringcurrencystringvalue_datedatecollecting_bank_bicstringcollecting_bank_namestringcollecting_bank_street_addressstringcollecting_bank_statestringcollecting_bank_postal_codestringcollecting_bank_countrystringpresenting_bank_bicstringpresenting_bank_namestringpresenting_bank_street_addressstringpresenting_bank_citystringpresenting_bank_statestringpresenting_bank_postal_codestringpresenting_bank_countrystringpayer_namestringpayer_account_numberstringpayer_bank_bicstringdocumentary_collection_referencestringpayment_detailsstringcharges_amountfloatcharges_currencystringmessage_creation_datetimedatetime
A9X1B2C3D4E5F6G7H8sent87541.28CharlotteTXN-2024-001USD2024-03-15BOFAUS3NBank of America100 N Tryon StNC28202United StatesWELLSF1GWells Fargo Bank420 Montgomery StSan FranciscoCA94104United StatesJackson Trading LLC123456789012CITIGB2LCOL-US-2024-0001Payment received for invoice #10135USD2024-03-15T13:52:00
B7Y2C3X4M5N6K7L8P9received325000FrankfurtTXN-2024-002EUR2024-01-20DEUTDEFFDeutsche BankTaunusanlage 12blank60325GermanyBNPAFRPPBNP Paribas16 Boulevard des ItaliensParisblank75009FranceAlstom S.A.FR7630006000011234567890189SGFRA6ACOL-FR-2024-0002Documentary collection for order #20255EUR2024-01-20T09:41:00
C6W4V5Z6T7R8Q9L1D2sent12000.75LondonTXN-2024-003GBP2024-04-10BARCGB22Barclays Bank1 Churchill PlaceblankE14 5HPUnited KingdomHSBCGB2LHSBC UK8 Canada SquareLondonblankE14 5HQUnited KingdomBrighton Imports Ltd.GB29NWBK60161331926819LLOYGB2LCOL-UK-2024-0003Full payment for shipment #300318.5GBP2024-04-10T15:19:00
D5F1H2J3K4L5M6N7O8received2900000TokyoTXN-2024-004JPY2024-02-18MIZUJPJTMizuho Bank1-5-5 Otemachiblank100-8176JapanSMBCJPJTSumitomo Mitsui Banking Corporation1-1-2 MarunouchiTokyoblank100-0005JapanToshiba CorporationJP892100000000123456789MUFGJPJTCOL-JP-2024-0004Payment for contract #JP1234125JPY2024-02-18T11:35:00
E3S2T4U5V6W7X8Y9Z1pending0.01blankTXN-2024-005USD2024-04-14USBKUS44U.S. BankblankblankblankUnited StatesCHASEUS33JP Morgan ChaseblankblankblankblankUnited Statesblankblankblankblankblankblankblank2024-04-14T10:02:00
F4T3H5P6A7Q8Z9S1D2sent45678.92AmsterdamTXN-2024-006EUR2023-12-19INGBNL2AING BankBijlmerplein 888blank1102 MGNetherlandsRABONL2URabobankCroeselaan 18Utrechtblank3521 CBNetherlandsVan Gogh EnterprisesNL91ABNA0417164300ABNANL2ACOL-NL-2023-0006Payment for PO #NL-201947.5EUR2023-12-19T14:05:00
G2N1B4C3D5E6F7H8J9received7800MelbourneTXN-2024-007AUD2022-07-21ANZBAU3MANZ Bank833 Collins StreetVIC3008AustraliaCBAAU2SCommonwealth Bank48 Martin PlaceSydneyNSW2000AustraliaSydney Traders Pty Ltd1234-567890NABAAU33COL-AU-2022-0007Trade payment for shipment #AUS1722AUD2022-07-21T08:17:00
H9M8N7L6K5J4H3G2F1sent15000000BeijingTXN-2024-008CNY2021-09-12ICBKCNBJIndustrial and Commercial Bank of China55 Fuxingmennei Avenueblank100140ChinaBOCOCNBJBank of Communications188 Yincheng RdShanghaiblank200120ChinaSichuan Exports Ltd.6222021001001234567ABOCCNBJCOL-CN-2021-0008Boundary test: Large CNY transaction5000CNY2021-09-12T11:10:00

What the 200 rows show

from the 200-row sample
  • 66,000median collection_amount
  • 13currencies
  • 13presenting bank states
  • 13charges currencies
  • 15collecting bank states
  • 18collecting bank countries
message_status200 rows by value
060120117sent59%65received33%18pending9%
collection_amount200 rows, in bands of 100M
01002001962000000020500M1Bcollection_amount →

Median 66,000, from 0.01 to 1,000,000,000.

collecting_bank_city179 rows with a value · 21 left blank
  1. Mumbai21
  2. London19
  3. Frankfurt17
  4. Beijing13
  5. Tokyo12
  6. Toronto12
  7. Paris10
  8. New York9
  9. Melbourne8
  10. Singapore8
28 columns by typefrom the column list below
  • string 24
  • float 2
  • date 1
  • datetime 1

Columns

28 columns in three groups
blueprint · 28 columns
columntypedescriptionexample
Text 24 columns
message_idstringUnique identifier for the SWIFT MT410 messageuniqueA9X1B2C3D4E5F6G7H8
transaction_reference_numberstringReference number assigned to the transaction by the collecting bankTXN-2024-001
currencystringISO 4217 currency code of the collection amountUSD
collecting_bank_bicstringBIC (Bank Identifier Code) of the collecting bankBOFAUS3N
collecting_bank_namestringName of the collecting bankBank of America
collecting_bank_street_addressstringStreet address of the collecting bankoptional100 N Tryon St
collecting_bank_citystringCity of the collecting bankoptionalCharlotte
collecting_bank_statestringState or province of the collecting bankoptionalNC
collecting_bank_postal_codestringPostal code of the collecting bankoptional28202
collecting_bank_countrystringCountry of the collecting bankUnited States
presenting_bank_bicstringBIC (Bank Identifier Code) of the presenting bankWELLSF1G
presenting_bank_namestringName of the presenting bankWells Fargo Bank
presenting_bank_street_addressstringStreet address of the presenting bankoptional420 Montgomery St
presenting_bank_citystringCity of the presenting bankoptionalSan Francisco
presenting_bank_statestringState or province of the presenting bankoptionalCA
presenting_bank_postal_codestringPostal code of the presenting bankoptional94104
presenting_bank_countrystringCountry of the presenting bankUnited States
payer_namestringName of the payer who made the paymentoptionalJackson Trading LLC
payer_account_numberstringAccount number of the payeroptional123456789012
payer_bank_bicstringBIC of the payer's bankoptionalCITIGB2L
documentary_collection_referencestringReference number for the documentary collectionoptionalCOL-US-2024-0001
payment_detailsstringAdditional payment details or instructionsoptionalPayment for PO #NL-2019
charges_currencystringCurrency of the charges amountoptionalUSD
message_statusstringStatus of the message (e.g., sent, received, pending, rejected)sent · received · pending · rejectedsent
Numbers 2 columns
collection_amountfloatAmount received for the documentary collection0.01 or more87541.28
charges_amountfloatAmount of charges or fees deducted from the payment0 or more · optional35
Dates and times 2 columns
value_datedateDate on which the funds were received by the collecting bank2024-03-15
message_creation_datetimedatetimeDate and time when the MT410 message was created2024-03-15T13:52:00

Use it for

  • median collect…66,000200 rowsmean collection amoun…21.2Msent368.5kreceiv…10.4kpending

    A finance dashboard

    Collection_amount by message_status and a breakdown of collecting_bank_city. Excel, Power BI or Tableau.

  • What pattern can you find in 200 rows?

    A class exercise

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

  • A software demo

    Believable messages with transaction_reference_number, collection_amount and currency to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 28 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 dataset200 rows28 columns
Yours1,000 rows28 columnscollecting_bank_street_address: UK only

blueprint · swift-mt410-advice-of-payment

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 28 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
  • Reference to original collection (field 20)
  • Related reference to MT400 (field 21)
  • Payment amount and currency
  • Payment date recorded
  • Method of payment
  • Value date for credit
  • Charges deducted if any
  • Net proceeds calculated
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-mt410-advice-of-payment

More in Finance

Browse all
Also in FinanceSWIFT MT742 Documentary Credit ReimbursementFinancial Statement Fraud IndicatorsAccounts Receivable and Aging AnalysisAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.