SWIFT MT412 Advice of Acceptance

This dataset provides detailed records of SWIFT MT412 Advice of Acceptance messages, documenting the acceptance of bills of exchange in documentary collections. It includes comprehensive information on transaction references, involved parties, financial amounts, and message metadata, supporting compliance, audit, and payment tracking in international trade finance.

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

Automated reconciliation and tracking of accepted bills of exchange

Sample rows

preview · 8 of 150 rows · all 22 columns
message_idstringamountfloatcurrencystringtransaction_referencestringbill_of_exchange_numberstringacceptance_datedatematurity_datedatedrawee_namestringdrawee_account_numberstringdrawee_bank_namestringdrawee_bank_bicstringdrawer_namestringdrawer_bank_namestringdrawer_bank_bicstringpresenting_bank_namestringpresenting_bank_bicstringcollection_instruction_referencestringacceptance_confirmedbooleanacceptance_conditionsstringmessage_creation_datetimedatetimesender_bicstringreceiver_bicstring
MT412-00000124568.45CNYTRX2023-1001BOE-2023-000012023-04-042023-08-04Shenzhen Trading Co Ltd6227001234567890123Bank of ChinaBKCHCNBJXXXMoscow Exporters LLCSberbank RussiaSABRRUMMHSBC Hong KongHSBCHKHHCOLL-CN-100100truePayable on confirmed shipment.2023-04-04T09:15:22HSBCHKHHBKCHCNBJXXX
MT412-00000298562.23AUDTRX2023-1002BOE-2023-000022023-03-122023-09-12Brisbane Steelworks Pty035001234567890Westpac AustraliaWPACAU2STokyo Industrial CorpMizuho BankMHCBJPJTANZ AustraliaANZBAU3MCOLL-AU-100101truePayment after inspection.2023-03-12T11:33:10ANZBAU3MWPACAU2S
MT412-0000031200CNYTRX2023-1001BOE-2023-000032023-04-042023-07-04Shenzhen Trading Co Ltd6227001234567890123Bank of ChinaBKCHCNBJXXXMoscow Exporters LLCSberbank RussiaSABRRUMMHSBC Hong KongHSBCHKHHblanktrueblank2023-04-04T09:15:22HSBCHKHHBKCHCNBJXXX
MT412-00000485EURTRX2023-1003BOE-2023-000042023-05-172023-05-17Paris Textiles SARLFR7630006000011234567890189BNP ParibasBNPAFRPPBarcelona Cottons SABanco SantanderBSCHESMMSociete GeneraleSOGEFRPPblanktrueblank2023-05-17T14:02:39SOGEFRPPBNPAFRPP
MT412-00000554122.5GBPTRX2023-1004BOE-2023-000052023-07-082023-10-08London Electronics LtdGB29NWBK60161331926819Barclays Bank UKBARCGB22Frankfurt Components AGDeutsche BankDEUTDEFFHSBC UKHBUKGB4BCOLL-GB-100102truePayable immediately.2023-07-08T10:23:30HBUKGB4BBARCGB22
MT412-000006125000.75USDTRX2023-1005BOE-2023-000062023-06-112023-08-11New York Commodities Inc1234567890Bank of AmericaBOFAUS3NToronto Grain TradersRoyal Bank of CanadaROYCCAT2Citibank NACITIUS33COLL-US-100103trueSubject to customs clearance.2023-06-11T15:45:55CITIUS33BOFAUS3N
MT412-0000074300INRTRX2023-1006BOE-2023-000072023-03-212023-04-21Mumbai Chemicals Pvt LtdIN0123456789012345State Bank of IndiaSBININBBDubai Plastics LLCEmirates NBDEBILAEADHDFC BankHDFCINBBblanktrueblank2023-03-21T12:50:11HDFCINBBSBININBB
MT412-000008780000.01CHFTRX2023-1007BOE-2023-000082023-02-102023-08-10Zurich Pharma AGCH9300762011623852957UBS SwitzerlandUBSWCHZH80AVienna Health GmbHErste BankGIBAATWWCredit SuisseCRESCHZZ80ACOLL-CH-100104truePayment after quality check.2023-02-10T09:28:02CRESCHZZ80AUBSWCHZH80A

What the 150 rows show

from the 150-row sample
amount150 rows, in bands of 1M
070140134930011204M8Mamount →

Median 53,100, from 0.01 to 7,800,000.

currency150 rows · top 10 of 22 values
  1. EUR17
  2. INR13
  3. CHF11
  4. CNY10
  5. AUD10
  6. SEK8
  7. BRL8
  8. JPY8
  9. ZAR7
  10. AED7
22 columns by typefrom the column list below
  • string 17
  • float 1
  • date 2
  • datetime 1
  • boolean 1

Columns

22 columns in four groups
blueprint · 22 columns
columntypedescriptionexample
Text 17 columns
message_idstringUnique identifier for the SWIFT MT412 messageuniqueMT412-000001
transaction_referencestringReference number assigned to the documentary collection transactionTRX2023-1001
bill_of_exchange_numberstringUnique identifier for the bill of exchange being acceptedBOE-2023-00001
drawee_namestringName of the party accepting the bill of exchange (drawee)Shenzhen Trading Co Ltd
drawee_account_numberstringAccount number of the draweeoptional6227001234567890123
drawee_bank_namestringName of the drawee's bankBank of China
drawee_bank_bicstringSWIFT/BIC code of the drawee's bankBKCHCNBJXXX
drawer_namestringName of the party issuing the bill of exchange (drawer)Moscow Exporters LLC
drawer_bank_namestringName of the drawer's bankoptionalSberbank Russia
drawer_bank_bicstringSWIFT/BIC code of the drawer's bankoptionalSABRRUMM
currencystringCurrency code of the accepted amount (ISO 4217)CNY
presenting_bank_namestringName of the bank presenting the bill for acceptanceHSBC Hong Kong
presenting_bank_bicstringSWIFT/BIC code of the presenting bankHSBCHKHH
collection_instruction_referencestringReference number for the documentary collection instructionoptionalCOLL-CN-100100
acceptance_conditionsstringAny conditions or remarks attached to the acceptanceoptionalPayable immediately.
sender_bicstringSWIFT/BIC code of the sending institutionHSBCHKHH
receiver_bicstringSWIFT/BIC code of the receiving institutionBKCHCNBJXXX
Numbers 1 column
amountfloatAmount accepted for payment under the bill of exchange0.01 or more24568.45
Dates and times 3 columns
acceptance_datedateDate when the drawee accepted the bill of exchange2023-04-04
maturity_datedateDate when the payment is due for the accepted bill of exchange2023-08-04
message_creation_datetimedatetimeDate and time when the MT412 message was created2023-04-04T09:15:22
True or false 1 column
acceptance_confirmedbooleanIndicates whether acceptance is formally confirmedtrue

Use it for

  • median amount53,100150 rows

    A finance dashboard

    Amount and a breakdown of currency. 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.

  • A software demo

    Believable messages with transaction_reference, bill_of_exchange_number and acceptance_date 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 dataset150 rows22 columns
Yours1,000 rows22 columns

blueprint · swift-mt412-advice-of-acceptance

Behind this dataset

Same schema. As many rows as you need.

These 150 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
  • Collection reference in field 20
  • Related reference to original advice
  • Acceptance date recorded
  • Maturity date calculated
  • Accepted amount confirmed
  • Drawee acceptance documented
  • Bill details specified
  • Documents released status
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-mt412-advice-of-acceptance

More in Finance

Browse all
Also in FinanceSWIFT MT710 Documentary Credit AdviceLoan Default Prediction DatasetPersonal Finance Budgeting RecordsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.