SWIFT MT416 Advice of Non-Payment
This dataset provides detailed records of SWIFT MT416 Advice of Non-Payment messages, documenting instances where a drawee has refused payment or acceptance of a documentary collection. It includes comprehensive information on the parties involved, reasons for refusal, document disposition, and transaction details, making it valuable for compliance, risk analysis, and operational reporting in international trade finance.
Sample rows
preview · 8 of 150 rows · all 27 columns| advice_idstring | refusal_typestring | amountfloat | document_disposition_codestring | message_datedate | drawee_namestring | drawee_account_numberstring | drawee_address_streetstring | drawee_address_citystring | drawee_address_statestring | drawee_address_postal_codestring | drawee_address_countrystring | presenting_bank_namestring | presenting_bank_bicstring | presenting_bank_address_streetstring | presenting_bank_address_citystring | presenting_bank_address_statestring | presenting_bank_address_postal_codestring | presenting_bank_address_countrystring | collection_referencestring | refusal_reason_codestring | refusal_reason_descriptionstring | document_liststring | currencystring | sender_referencestring | additional_instructionsstring | document_disposition_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ADV00001 | acceptance | 85000 | held | 2021-05-24 | Mitsui Trading Co. | JP7654321 | 1-6-1 Marunouchi | Tokyo | Tokyo | 100-0005 | JP | Sumitomo Mitsui Banking Corporation | SMBCJPJT | 1-2-3 Yaesu | Tokyo | Tokyo | 104-0028 | JP | COLJP1001 | R07 | Documents missing required certificate of origin | bill of lading,certificate of origin | JPY | JP-SEND1001 | Please clarify certificate requirements | Documents held pending further instructions from sender |
| ADV00002 | payment | 1450 | returned | 2019-09-10 | Global Freight Ltd. | blank | 45 Queen Street | London | England | EC4R 1AP | GB | HSBC Bank PLC | HSBCGB2L | 8 Canada Square | London | England | E14 5HQ | GB | COLGB2001 | R02 | Insufficient funds in drawee account | invoice,bill of lading | GBP | GB-HSBC2001 | Notify sender of non-payment | Documents returned to sender as payment refused |
| ADV00003 | acceptance | 128000 | held | 2023-02-15 | Shanghai Textiles Corp | CN998877 | 88 Nanjing Road | Shanghai | Shanghai | 200002 | CN | Industrial & Commercial Bank of China | ICBKCNBJ | 100 Century Avenue | Shanghai | Shanghai | 200120 | CN | COLCN3001 | R09 | Draft not signed as per instructions | draft,bill of lading,packing list | CNY | CN-ICBC3001 | Await sender's reply on acceptance | Documents held awaiting sender's confirmation |
| ADV00004 | payment | 250000 | destroyed | 2018-11-03 | Amaravati Exports | IN0054321 | Plot 12, Gachibowli | Hyderabad | TS | 500032 | IN | State Bank of India | SBININBB | 11 Parliament Street | New Delhi | DL | 110001 | IN | COLIN4001 | R11 | Amount disputed by drawee | shipping documents,packing list,invoice | INR | IN-SBI4001 | Sender instructed destruction of documents | Documents destroyed as per sender instructions |
| ADV00005 | acceptance | 48000 | held | 2022-07-13 | DBS Singapore Pte Ltd | blank | 12 Marina Boulevard | Singapore | blank | 018982 | SG | DBS Bank Ltd | DBSSSGSG | 12 Marina Boulevard | Singapore | blank | 018982 | SG | COLSG5001 | R03 | Documents not conforming to terms | bill of lading,certificate of origin | SGD | SG-DBS5001 | Please advise next steps | Documents held awaiting sender's instructions |
| ADV00006 | payment | 1000000 | returned | 2017-03-27 | Lagos Imports | blank | blank | Lagos | blank | 100001 | NG | First Bank of Nigeria | FBNINGLA | Samuel Asabia House | Lagos | blank | 100001 | NG | COLNG6001 | R12 | Signature mismatch on draft | draft,invoice | NGN | NG-FBN6001 | Sender to verify signature | Documents returned due to signature mismatch |
| ADV00007 | payment | 75000 | returned | 2024-03-21 | Citibank NA | US1239876 | 399 Park Avenue | New York | NY | 10022 | US | Bank of America | BOFAUS3N | 100 N Tryon St | Charlotte | NC | 28202 | US | COLUS7001 | R01 | Payment refused by drawee | invoice,bill of lading | USD | US-CITI7001 | Sender notified by email | Documents returned to sender as per refusal |
| ADV00008 | acceptance | 3200 | held | 2020-06-18 | Deutsche Maschinen GmbH | DE100234 | Hauptstrasse 50 | Frankfurt | HE | 60313 | DE | Commerzbank AG | COBADEFF | Kaiserstrasse 16 | Frankfurt | HE | 60311 | DE | COLDE8001 | R06 | Acceptance declined for missing packing list | bill of lading,packing list | EUR | DE-COBA8001 | Sender to provide packing list | Documents held pending packing list |
| ADV00009 | payment | 500000 | destroyed | 2015-12-29 | Rio Commercial SA | blank | Rua das Flores 123 | Rio de Janeiro | RJ | 22040-040 | BR | Banco do Brasil | BRASBRRJ | Av. Paulista 1450 | Sao Paulo | SP | 01311-000 | BR | COLBR9001 | blank | Drawee unresponsive after notification | shipping documents,invoice | BRL | BR-BRAS9001 | Sender instructed to destroy docs | Documents destroyed as per sender request |
| ADV00010 | acceptance | 1800 | other | 2021-01-11 | AIB Ireland Group Plc | IE6785432 | 4-6 Main Street | Dublin | Leinster | D02 W272 | IE | Allied Irish Banks | AIBKIE2D | 10 Molesworth St | Dublin | Leinster | D02 W272 | IE | COLIE10001 | R14 | Draft terms unclear | draft,invoice | EUR | IE-AIB10001 | Clarify draft terms for acceptance | Documents awaiting sender clarification |
| ADV00011 | payment | 2500000 | other | 2022-10-04 | Standard Bank South Africa | blank | 5 Simmonds Street | Johannesburg | GP | 2001 | ZA | ABSA Bank | ABSAZAJJ | 7th Floor, 160 Main St | Johannesburg | GP | 2001 | ZA | COLZA11001 | R21 | Payment delayed by regulatory review | invoice,packing list | ZAR | ZA-ABSA11001 | Await regulatory approval | Documents pending regulatory clearance |
| ADV00012 | payment | 4800 | destroyed | 2023-08-28 | American Industrial Corp | US8765432 | 214 Michigan Ave | Chicago | IL | 60606 | US | Citibank NA | CITIUS33 | 701 E 60th St | Chicago | IL | 60637 | US | COLUS12001 | R04 | Document terms do not match collection instruction | invoice,draft | USD | US-AIC12001 | Notify sender of destruction | Documents destroyed at sender's request |
| ADV00013 | acceptance | 1500 | held | 2016-04-07 | Murray Foods Ltd. | blank | 17 Park Road | Manchester | England | M1 2HY | GB | Barclays Bank PLC | BARCGB22 | 1 Churchill Place | London | England | E14 5HP | GB | COLGB13001 | R18 | Document discrepancy detected | invoice,bill of lading | GBP | GB-BARC13001 | Contact sender for clarification | Documents held pending sender instructions |
| ADV00014 | acceptance | 65000 | held | 2020-02-19 | Guangzhou Electronics Ltd | CN998866 | 22 Tianhe Road | Guangzhou | Guangdong | 510620 | CN | Bank of China | BKCHCNBJ | No. 1 Fuxingmen Nei Ave | Beijing | Beijing | 100818 | CN | COLCN14001 | R08 | Bill of lading not original | bill of lading,invoice | CNY | CN-BOC14001 | Request sender for original document | Documents held for sender decision |
| ADV00015 | payment | 38000 | other | 2018-06-01 | San Paolo International | blank | blank | Milan | Lombardy | 20121 | IT | Intesa Sanpaolo | BCITITMM | Piazza San Carlo 156 | Turin | Piedmont | 10121 | IT | COLIT15001 | blank | Payment delayed by drawee's bank | packing list,invoice | EUR | IT-INTESA15001 | Sender to follow up | Documents pending at presenting bank |
| ADV00016 | acceptance | 92000 | held | 2023-05-12 | Singapore Marine Services | SG908123 | 22 Harbour Drive | Singapore | blank | 119223 | SG | OCBC Bank | OCBCSGSG | 65 Chulia Street | Singapore | blank | 049513 | SG | COLSG16001 | R15 | Guarantee letter not included | guarantee letter,draft | SGD | SG-OCBC16001 | Sender to forward guarantee letter | Documents held until guarantee letter received |
| ADV00017 | payment | 125000 | returned | 2019-04-22 | JPMorgan Chase & Co. | US7654321 | 270 Park Avenue | New York | NY | 10017 | US | Wells Fargo Bank | WFBIUS6S | 420 Montgomery St | San Francisco | CA | 94104 | US | COLUS17001 | R01 | Payment refused by drawee | invoice,bill of exchange | USD | US-JPM17001 | Notify sender of refusal | Documents returned to sender |
| ADV00018 | payment | 70000 | destroyed | 2016-07-30 | Dakar Enterprises | SN10345 | Rue de la Republique | Dakar | blank | 11000 | SN | Ecobank Senegal | ECOCSNDA | Avenue Cheikh Anta Diop | Dakar | blank | 11000 | SN | COLSN18001 | R22 | Cheque dishonored | cheque,invoice | XOF | SN-ECOC18001 | Sender notified of dishonor | Documents destroyed on sender request |
| ADV00019 | payment | 44000 | returned | 2022-12-16 | Bank of America | US2345678 | 100 N Tryon St | Charlotte | NC | 28202 | US | Wells Fargo Bank | WFBIUS6S | 420 Montgomery St | San Francisco | CA | 94104 | US | COLUS19001 | R02 | Insufficient funds in drawee account | invoice,bill of lading | USD | US-BOA19001 | Sender contacted by phone | Documents returned to sender |
| ADV00020 | payment | 212000 | other | 2019-11-18 | Mumbai Steel Works | blank | 143 Nariman Point | Mumbai | MH | 400021 | IN | ICICI Bank | ICICINBB | Bandra Kurla Complex | Mumbai | MH | 400051 | IN | COLIN20001 | R11 | Amount disputed by drawee | shipping documents,invoice | INR | IN-ICICI20001 | Sender to confirm next action | Documents pending sender decision |
What the 150 rows show
from the 150-row sample- 57,500median amount
- 27currencies
- 33drawee address countries
- 33presenting bank address countries
Median 57,500, from 700.0 to 4,800,000.
- string 25
- float 1
- date 1
Columns
27 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 25 columns | |||
advice_id | string | Unique identifier for the advice of non-payment messageunique | ADV00001 |
drawee_name | string | Name of the drawee who refused payment or acceptance | Mitsui Trading Co. |
drawee_account_number | string | Account number of the draweeoptional | JP7654321 |
drawee_address_street | string | Street address of the draweeoptional | 1-6-1 Marunouchi |
drawee_address_city | string | City of the draweeoptional | Tokyo |
drawee_address_state | string | State or province of the draweeoptional | Tokyo |
drawee_address_postal_code | string | Postal code of the draweeoptional | 100-0005 |
drawee_address_country | string | Country of the draweeoptional | JP |
presenting_bank_name | string | Name of the bank presenting the collection | HSBC Bank PLC |
presenting_bank_bic | string | BIC code of the presenting bankoptional | SMBCJPJT |
presenting_bank_address_street | string | Street address of the presenting bankoptional | 1-2-3 Yaesu |
presenting_bank_address_city | string | City of the presenting bankoptional | Tokyo |
presenting_bank_address_state | string | State or province of the presenting bankoptional | Tokyo |
presenting_bank_address_postal_code | string | Postal code of the presenting bankoptional | 104-0028 |
presenting_bank_address_country | string | Country of the presenting bankoptional | JP |
collection_reference | string | Reference number for the documentary collection | COLJP1001 |
refusal_type | string | Type of refusal: payment or acceptancepayment · acceptance | acceptance |
refusal_reason_code | string | Standardized code for the reason of refusaloptional | R07 |
refusal_reason_description | string | Detailed description of the reason for refusal | Draft terms unclear |
document_disposition_code | string | Code indicating disposition of documents (e.g., returned, held, destroyed)returned · held · destroyed · other · optional | held |
document_disposition_description | string | Detailed description of document dispositionoptional | Pending sender review |
document_list | string | Comma-separated list of documents involved in the collection (e.g., invoice, bill of lading)optional | invoice,bill of lading |
currency | string | Currency code of the amount (ISO 4217)optional | JPY |
sender_reference | string | Reference number assigned by the senderoptional | JP-SEND1001 |
additional_instructions | string | Any additional instructions or commentsoptional | Please advise next steps |
| Numbers 1 column | |||
amount | float | Amount involved in the collection0 or more · optional | 85000 |
| Dates and times 1 column | |||
message_date | date | Date the advice of non-payment was issued | 2021-05-24 |
Use it for
A finance dashboard
Amount by refusal_
type and a breakdown of document_ disposition_ code. Excel, Power BI or Tableau. What pattern can you find in 150 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 150 rows.
- Advices150ADV0000185000acceptan…ADV000021450paymentADV00003128000acceptan…
A software demo
Believable advices with message_
date, drawee_ name and drawee_ account_ number to fill a screen in front of a buyer.
blueprint · swift-mt416-advice-of-non-payment
Behind this dataset
Same schema. As many rows as you need.
These 150 rows came out of a blueprint — 27 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.
- Collection reference unique
- Related reference to MT400
- Non-payment reason code
- Drawee refusal date
- Amount unpaid
- Instructions for documents: return or hold
- Protest required indicator
- Alternative action instructions
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-mt416-advice-of-non-payment