ISO20022 Foreign Exchange Trade Confirmation (fxtr.016)

This dataset provides detailed ISO20022-compliant confirmations of foreign exchange (FX) trades, including trade identifiers, agreed rates, amounts, value dates, and bilateral settlement details for both counterparties. It is ideal for post-trade reconciliation, regulatory reporting, and risk management in financial institutions.

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

Post-trade reconciliation and audit

Sample rows

preview · 8 of 400 rows · all 23 columns
trade_confirmation_idstringtrade_typestringsell_amountfloatsell_currencystringtrade_idstringtrade_datedatevalue_datedatecurrency_pairstringbuy_currencystringbuy_amountfloatexchange_ratefloatsettlement_methodstringparty_1_idstringparty_1_namestringparty_1_account_numberstringparty_1_bank_namestringparty_2_idstringparty_2_namestringparty_2_account_numberstringparty_2_bank_namestringconfirmation_statusstringconfirmation_datetimedatetimeadditional_termsstring
TC-00001-2022-SPOTSpot2154000USDT-100012022-02-142022-02-15EUR/USDEUR20000001.077CLSLEI-5493001KJTIIGC8Y1R12Deutsche Bank AGDE89370400440532013000Deutsche BankBIC-HSBCHKHHHSBC Bank PLCGB82WEST12345698765432HSBC UKConfirmed2022-02-14T16:10:12ZStandard CLS settlement. No holidays observed.
TC-00002-2023-SPOTSpot748000000JPYT-100022023-03-222023-03-23USD/JPYUSD5000000149.6CLSLEI-213800D1EI4B9WTWWD28JPMorgan Chase BankUS12345678901234567890JPMorgan ChaseBIC-MIZUJPJTMizuho Bank LtdJP123456789012345678901Mizuho BankConfirmed2023-03-22T10:48:22ZJPY spot trade, CLS settlement.
TC-00003-2023-FWDForward7140000CZKT-100032023-01-102023-07-10EUR/CZKEUR30000023.8BilateralLEI-529900M876P3S5RQON41Siemens AGDE75512108001245126199Santander DEBIC-CSOBCZPPCSOB BankCZ6508000000192000145399CSOB BankConfirmed2023-01-10T14:02:18ZCorporate forward FX, bilateral settlement.
TC-00004-2021-SWAPSwap1216000000JPYT-100042021-08-082023-08-08CHF/JPYCHF8000000152OtherLEI-549300G7W6L8Y6YQF633UBS AGCH9300762011623852957UBS SwitzerlandBIC-SMBCJPJTSumitomo Mitsui BankJP987654321012345678901SMBCConfirmed2021-08-08T09:34:10ZLong-dated swap, custom settlement.
TC-00005-2022-OPTOption13020000000KRWT-100052022-04-112023-04-11USD/KRWUSD100000001302NettingLEI-213800VUVB2RZDJJUU36Citibank N.A.US11223344556677889900CitibankBIC-KBKBKRSEKookmin BankKR700123456789012345678Kookmin BankConfirmed2022-04-11T17:38:05ZUSD/KRW option, netted settlement.
TC-00006-2024-SPOTSpot950250USDT-100062024-01-032024-01-04GBP/USDGBP7500001.267CLSLEI-213800D1EI4B9WTWWD29Barclays Bank PLCGB33BUKB20201555555555Barclays UKBIC-JPMAGB2LJPMorgan LondonGB29NWBK60161331926819JPMorganConfirmed2024-01-03T13:17:41ZCLS settlement, GBP/USD spot.
TC-00007-2022-SPOTSpot7070000CNYT-100072022-11-292022-11-30USD/CNYUSD10000007.07CLSLEI-5493001KJTIIGC8Y1R13Bank of AmericaUS99887766554433221100Bank of AmericaBIC-ICBKCNBJICBC BeijingCN12345678901234567890ICBCConfirmed2022-11-29T09:57:37ZCLS settlement, USD/CNY spot.
TC-00008-2024-SPOTSpot2247500CHFT-100082024-04-022024-04-03USD/CHFUSD25000000.899CLSLEI-213800A1J1LJSL7QBN32Credit Suisse AGCH5604835012345678000Credit SuisseBIC-BNPAFRPPBNP ParibasFR761234598765432112345678901BNP ParibasConfirmed2024-04-02T12:22:14ZCLS settlement, USD/CHF spot.

What the 400 rows show

from the 400-row sample

Option (trade type) stands out: mean sell_amount is 6,414,411,821, against 791,851,265 for the rest.

  • 10,596,000median sell_amount
  • 3confirmation statuses
  • 4settlement methods
  • 8buy currencies
  • 63currency pairs
  • 900,000median buy_amount
Mean sell_amount by trade_type400 rows
04B8B586.7MSpot243 rows402.9MForward79 rows2.8BSwap40 rows6.4BOption38 rows
sell_amount400 rows, in bands of 10B
019539038211411001040B80Bsell_amount →

Median 10,596,000, from 0.00 to 79,450,000,000.

sell_currency400 rows · top 10 of 37 values
  1. USD60
  2. JPY46
  3. INR23
  4. CHF22
  5. KRW21
  6. SGD20
  7. CNY15
  8. BRL14
  9. PLN14
  10. HKD13
23 columns by typefrom the column list below
  • string 17
  • float 3
  • date 2
  • datetime 1

Columns

23 columns in three groups
blueprint · 23 columns
columntypedescriptionexample
Text 17 columns
trade_confirmation_idstringUnique identifier for the FX trade confirmation messageuniqueTC-00001-2022-SPOT
trade_idstringUnique identifier for the executed FX tradeT-10001
currency_pairstringISO currency codes for the traded currency pair (e.g., 'EUR/USD')EUR/USD
trade_typestringType of FX trade (e.g., 'Spot', 'Forward', 'Swap')Spot · Forward · Swap · OptionSpot
buy_currencystringISO currency code for the currency being bought8 currenciesEUR
sell_currencystringISO currency code for the currency being soldUSD
settlement_methodstringMethod of settlement (e.g., 'Bilateral', 'CLS', 'Netting')Bilateral · CLS · Netting · OtherCLS
party_1_idstringUnique identifier for the first party in the trade (e.g., BIC, LEI)LEI-5493001KJTIIGC8Y1R12
party_1_namestringLegal name of the first party in the tradeDeutsche Bank AG
party_1_account_numberstringAccount number for settlement for party 1DE89370400440532013000
party_1_bank_namestringName of the bank for party 1's settlement accountoptionalDeutsche Bank
party_2_idstringUnique identifier for the second party in the trade (e.g., BIC, LEI)BIC-HSBCHKHH
party_2_namestringLegal name of the second party in the tradeHSBC Bank PLC
party_2_account_numberstringAccount number for settlement for party 2GB82WEST12345698765432
party_2_bank_namestringName of the bank for party 2's settlement accountoptionalHSBC UK
confirmation_statusstringStatus of the trade confirmation (e.g., 'Confirmed', 'Pending', 'Rejected')Confirmed · Pending · RejectedConfirmed
additional_termsstringAny additional terms or notes relevant to the trade confirmationoptionalStandard CLS settlement. …
Numbers 3 columns
buy_amountfloatAmount of the currency being bought0 or more2000000
sell_amountfloatAmount of the currency being sold0 or more2154000
exchange_ratefloatAgreed FX rate for the trade0 or more1.077
Dates and times 3 columns
trade_datedateDate on which the FX trade was executed2022-02-14
value_datedateDate on which the FX trade is settled2022-02-15
confirmation_datetimedatetimeTimestamp when the trade confirmation was issued2022-02-14T16:10:12Z

Use it for

  • median sell am…10,596,000400 rowsmean sell amount by t…586.7MSpot402.9MForw…2.8BSwap6.4BOpti…

    A finance dashboard

    Sell_amount by trade_type and a breakdown of sell_currency. Excel, Power BI or Tableau.

  • Why do the 38 Option rows have a mean sell_amount of 6,414,411,821?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable trade confirmations with trade_id, trade_date and value_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 23 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 rows23 columns
Yours1,000 rows23 columns

blueprint · iso20022-foreign-exchange-trade-confirmation-fxtr016

Behind this dataset

Same schema. As many rows as you need.

These 400 rows came out of a blueprint — 23 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 date and time executed
  • Confirmation sent within agreed timeframe
  • Currency pair matches instruction
  • Rate and amounts confirmed
  • Value date agreed by both parties
  • Settlement bank details for each currency
  • Any premiums or discounts documented
  • Confirmation status: matched or mismatched
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-trade-confirmation-fxtr016

More in Finance

Browse all
Also in FinanceSWIFT MT300 Treasury Money Market Deal NotificationDigital Wallet Transaction DatasetBanking Transaction Categorization DatasetAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.