ISO20022 Foreign Exchange Settlement Instruction (fxtr.015)

This dataset provides detailed ISO20022-compliant foreign exchange settlement instructions, including trade references, payment amounts, currency codes, value dates, and full payment chain bank details. It enables precise tracking, reconciliation, and compliance for FX transactions across global financial institutions, supporting operational efficiency and regulatory reporting.

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

Automated reconciliation of FX trades and settlements

Sample rows

preview · 8 of 400 rows · all 39 columns
instruction_idstringsettlement_methodstringamount_soldfloatpayer_bank_statestringtrade_idstringtrade_datedatevalue_datedatecurrency_soldstringcurrency_boughtstringamount_boughtfloatexchange_ratefloatpayer_namestringpayer_account_numberstringpayer_bank_namestringpayer_bank_bicstringpayer_bank_street_addressstringpayer_bank_citystringpayer_bank_postal_codestringpayer_bank_countrystringpayee_namestringpayee_account_numberstringpayee_bank_namestringpayee_bank_bicstringpayee_bank_street_addressstringpayee_bank_citystringpayee_bank_statestringpayee_bank_postal_codestringpayee_bank_countrystringcorrespondent_bank_namestringcorrespondent_bank_bicstringcorrespondent_bank_street_addressstringcorrespondent_bank_citystringcorrespondent_bank_statestringcorrespondent_bank_postal_codestringcorrespondent_bank_countrystringinstruction_statusstringcreated_datetimedatetimelast_updated_datetimedatetimeadditional_instructionsstring
FX-1001CLS2500000NYTRD-20012024-01-152024-01-17USDEUR22972501.0882Global Tech Inc.US93200012345678901JPMorgan Chase BankCHASUS33270 Park AvenueNew York10017USAEuroFin Ltd.DE89370400440532013000Deutsche Bank AGDEUTDEFFTaunusanlage 12Frankfurtblank60325GermanyBNP ParibasBNPAFRPP16 Boulevard des ItaliensParisblank75009Francepending2024-01-15T09:12:002024-01-16T10:21:00Urgent settlement requested.
FX-1002wire100000blankTRD-20022024-01-182024-01-19EURUSD1088200.9187Alpha Holdings ABSE3550000000054910000003SEBESSESESSKungsträdgårdsgatan 8Stockholm11147SwedenAcme Electronics LLCUS00123456789012345Bank of AmericaBOFAUS3N100 N Tryon StCharlotteNC28202USAblankblankblankblankblankblankblanksettled2024-01-18T14:25:002024-01-19T16:42:00Standard business settlement.
FX-1003CLS75000000NYTRD-20032024-01-202024-01-24USDJPY112500000000.00667Zenith Exporters LLCUS021000021234567890Citibank N.A.CITIUS33388 Greenwich StreetNew York10013USANippon Trading Co.JP892340123456789012345Mizuho BankMHCBJPJT1-3-3 MarunouchiTokyoblank100-8210JapanSumitomo MitsuiSMBCJPJT1-1-2 MarunouchiTokyoblank100-0005Japanpending2024-01-20T08:10:002024-01-22T12:44:00blank
FX-1004ACH0.01blankTRD-20042024-01-212024-01-21GBPUSD0.01270.7874Mary Louise HarperGB29NWBK60161331926819NatWest BankNWBKGB2L250 BishopsgateLondonEC2M4AAUnited KingdomThomas P. ReedUS12340009876543210Wells FargoWFBIUS6S420 Montgomery StSan FranciscoCA94104USAblankblankblankblankblankblankblankfailed2024-01-21T09:15:002024-01-21T14:33:00Transaction failed: amount below minimum threshold.
FX-1005wire500000blankTRD-20052024-01-222024-01-27CHFEUR523809.520.9545Swiss Traders SACH9300762011623852957UBS Switzerland AGUBSWCHZH80ABahnhofstrasse 45Zurich8001SwitzerlandEuro Global GmbHDE49370501980012345678Commerzbank AGCOBADEFFKaiserstrasse 16Frankfurtblank60311Germanyblankblankblankblankblankblankblankpending2024-01-22T10:44:002024-01-23T15:27:00blank
FX-1006RTGS10000000blankTRD-20062024-01-232024-01-25JPYUSD66700149.91Taro SuzukiJP1234567890123456789MUFG BankBOTKJPJT2-7-1 MarunouchiTokyo100-8388JapanFranklin West LLCUS34567890123456789Wells FargoWFBIUS6S420 Montgomery StSan FranciscoCA94104USABank of TokyoBOTKJPJT2-7-1 MarunouchiTokyoblank100-8388Japansettled2024-01-23T08:30:002024-01-26T09:35:00Confirmed delivery to US beneficiary.
FX-1007CLS15000000NYTRD-20072024-01-252024-01-28USDGBP118110001.2711Westport Manufacturing Ltd.US56789012345678900HSBC Bank USAMRMDUS33452 Fifth AvenueNew York10018USABrighton Components PLCGB12BARC20201530093459Barclays BankBARCGB221 Churchill PlaceLondonblankE14 5HPUnited KingdomBarclays BankBARCGB221 Churchill PlaceLondonblankE14 5HPUnited Kingdompending2024-01-25T10:01:002024-01-27T12:43:00Priority settlement - time sensitive trade.
FX-1008ACH900NCTRD-20082024-01-262024-01-26USDGBP7071.2738Hannah J. DonnellyUS2000123456789012Bank of AmericaBOFAUS3N100 N Tryon StCharlotte28202USAJames K. FosterGB99BARC20201530093459Barclays BankBARCGB221 Churchill PlaceLondonblankE14 5HPUnited Kingdomblankblankblankblankblankblankblanksettled2024-01-26T13:17:002024-01-26T18:29:00Beneficiary notified by SMS.

What the 400 rows show

from the 400-row sample
  • 175,000median amount_sold
  • 4instruction statuses
  • 7currency solds
  • 8correspondent bank cities
  • 9correspondent bank countries
  • 12payee bank states
settlement_method400 rows by value
07014096CLS24%131wire33%63RTGS16%110ACH28%
amount_sold400 rows, in bands of 100M
01953903825211100080500M1Bamount_sold →

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

payer_bank_state165 rows with a value · 235 left blank
  1. NY61
  2. CA37
  3. NC25
  4. PA12
  5. ON8
  6. DE5
  7. VIC4
  8. IL3
  9. NJ3
  10. QC3
39 columns by typefrom the column list below
  • string 32
  • float 3
  • date 2
  • datetime 2

Columns

39 columns in three groups
blueprint · 39 columns
columntypedescriptionexample
Text 32 columns
instruction_idstringUnique identifier for the FX settlement instructionuniqueFX-1001
trade_idstringReference identifier for the underlying FX tradeTRD-2001
currency_soldstringISO 4217 currency code of the currency being sold7 soldsUSD
currency_boughtstringISO 4217 currency code of the currency being boughtEUR
payer_namestringName of the party sending the paymentGlobal Tech Inc.
payer_account_numberstringAccount number from which the currency will be sentUS93200012345678901
payer_bank_namestringName of the payer's bankJPMorgan Chase Bank
payer_bank_bicstringBIC/SWIFT code of the payer's bankCHASUS33
payer_bank_street_addressstringStreet address of the payer's bankoptional270 Park Avenue
payer_bank_citystringCity of the payer's bankoptionalNew York
payer_bank_statestringState/region of the payer's bankoptionalNY
payer_bank_postal_codestringPostal code of the payer's bankoptional10017
payer_bank_countrystringCountry of the payer's bankoptionalUSA
payee_namestringName of the party receiving the paymentEuroFin Ltd.
payee_account_numberstringAccount number to which the currency will be deliveredDE89370400440532013000
payee_bank_namestringName of the payee's bankDeutsche Bank AG
payee_bank_bicstringBIC/SWIFT code of the payee's bankDEUTDEFF
payee_bank_street_addressstringStreet address of the payee's bankoptionalTaunusanlage 12
payee_bank_citystringCity of the payee's bankoptionalFrankfurt
payee_bank_statestringState/region of the payee's bank12 states · optionalNC
payee_bank_postal_codestringPostal code of the payee's bankoptional60325
payee_bank_countrystringCountry of the payee's bankoptionalGermany
correspondent_bank_namestringName of the correspondent/intermediary bank (if applicable)optionalBNP Paribas
correspondent_bank_bicstringBIC/SWIFT code of the correspondent/intermediary bankoptionalBNPAFRPP
correspondent_bank_street_addressstringStreet address of the correspondent/intermediary bankoptional1-1-2 Marunouchi
correspondent_bank_citystringCity of the correspondent/intermediary bank8 cities · optionalParis
correspondent_bank_statestringState/region of the correspondent/intermediary bankoptionalNY
correspondent_bank_postal_codestringPostal code of the correspondent/intermediary bankoptional75009
correspondent_bank_countrystringCountry of the correspondent/intermediary bank9 countries · optionalFrance
settlement_methodstringMethod of settlement (e.g., CLS, wire, RTGS)CLS · wire · RTGS · ACH · otherCLS
instruction_statusstringCurrent status of the settlement instructionpending · settled · cancelled · failedpending
additional_instructionsstringFree-text field for any additional settlement instructions or notesoptionalPersonal transfer.
Numbers 3 columns
amount_soldfloatAmount of currency being sold0.01 or more2500000
amount_boughtfloatAmount of currency being bought0.01 or more2297250
exchange_ratefloatAgreed exchange rate for the FX trade0 or more1.0882
Dates and times 4 columns
trade_datedateDate the FX trade was executed2024-01-15
value_datedateDate on which the currency is to be delivered/settled2024-01-17
created_datetimedatetimeTimestamp when the instruction was created2024-01-15T09:12:00
last_updated_datetimedatetimeTimestamp of the last update to the instruction2024-01-16T10:21:00

Use it for

  • median amount …175,000400 rowsmean amount sold by s…109.4MCLS2.7Mwire2MRTGS19.5kACH

    A finance dashboard

    Amount_sold by settlement_method and a breakdown of payer_bank_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 instructions with trade_id, trade_date and value_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 39 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 rows39 columns
Yours1,000 rows39 columnspayer_bank_street_address: UK only

blueprint · iso20022-foreign-exchange-settlement-instruction-fxtr015

Behind this dataset

Same schema. As many rows as you need.

These 400 rows came out of a blueprint — 39 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
  • Trade reference for settlement
  • Settlement date matches trade value date
  • Currency to be delivered specified
  • Payment amount exact to trade
  • Beneficiary bank details
  • Correspondent bank if required
  • CLS settlement if eligible
  • Cut-off times respected per currency
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
iso20022-foreign-exchange-settlement-instruction-fxtr015

More in Finance

Browse all
Also in FinanceISO20022 Securities Settlement Transaction Instruction (sese.023)Bank Transaction Categorization SampleBanking Transaction Categorization DatasetAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.