ISO20022 Notification to Receive (camt.057)
This dataset provides comprehensive advance notifications of expected incoming payments, including beneficiary and remitter details, payment references, expected settlement dates, and reconciliation status. It enables financial institutions and corporate treasuries to allocate and reconcile funds efficiently before actual settlement, improving cash flow visibility and operational planning.
Sample rows
preview · 8 of 400 rows · all 18 columns| notification_idstring | statusstring | expected_amountfloat | reconciliation_flagboolean | currencystring | notification_datetimedatetime | payment_referencestring | expected_settlement_datedate | beneficiary_account_numberstring | beneficiary_namestring | beneficiary_bank_namestring | beneficiary_bank_bicstring | remitter_account_numberstring | remitter_namestring | remitter_bank_namestring | remitter_bank_bicstring | purpose_codestring | additional_informationstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| NTF-2024010001 | confirmed | 1200.75 | true | USD | 2024-01-02T10:14:37Z | PMT-REF-10001 | 2024-01-03 | 435671278900 | Rachel Cooper | U.S. Bank | USBKUS44XXX | 987654321012 | Acme Corp | Citibank | CITIUS33 | SUPP | Invoice #8943 payment for office supplies |
| NTF-2024010002 | cancelled | 0 | false | GBP | 2024-01-04T15:42:05Z | INV-2024-0002 | 2024-01-05 | GB29NWBK60161331926819 | Michael S. Patel | Barclays Bank | BARCGB22 | GB72LOYD30995317812234 | TestCo Ltd | Lloyds Bank | LOYDGB2L | TEST | Automated test transaction - no funds |
| NTF-2024010003 | pending | 95.25 | false | EUR | 2024-01-08T13:07:28Z | PMT-REF-10003 | 2024-01-09 | DE89370400440532013000 | Svenja Müller | Deutsche Bank | DEUTDEFF | FR7630006000011234567890189 | Café Parisien | BNP Paribas | BNPAFRPP | CORT | Contract payment Q1 |
| NTF-2024010004 | confirmed | 120000 | true | USD | 2024-01-10T11:30:40Z | INV-2024-0004 | 2024-01-12 | 512398745321 | Jennifer Lee | Wells Fargo | WFBIUS6S | 874563210987 | GlobalTech Inc. | Bank of America | BOFAUS3N | TECH | Technology partnership settlement |
| NTF-2024010005 | pending | 5000 | false | GBP | 2024-01-15T09:15:12Z | PMT-REF-10005 | 2024-01-16 | GB82WEST12345698765432 | Oliver Evans | HSBC UK | HBUKGB4B | GB22BARC20201512345678 | Evans Consulting | Barclays Bank | BARCGB22 | SUPP | Consultancy invoice #2024-15 |
| NTF-2024010006 | confirmed | 753.21 | true | USD | 2024-02-01T13:46:59Z | PMT-REF-10006 | 2024-02-02 | 900112233445 | Sophia Turner | Bank of America | BOFAUS3N | 112233445566 | Turner Supplies | Chase Bank | CHASUS33 | SUPP | Office supplies - PO 3345 |
| NTF-2024010007 | confirmed | 50 | true | EUR | 2024-02-14T18:03:10Z | GIFT-VAL-2024-07 | 2024-02-14 | ES9121000418450200051332 | Maria González | Banco Santander | BSCHESMM | blank | blank | blank | blank | GIFT | Valentine's Day gift |
| NTF-2024010008 | pending | 287.65 | false | CHF | 2024-02-28T12:01:20Z | PMT-REF-10008 | 2024-02-29 | CH9300762011623852957 | Monika Weiss | Credit Suisse | CRESCHZZ80A | CH5604835012345678000 | Swiss Foods AG | UBS Switzerland | UBSWCHZH80A | SUPP | Food products order #1120 |
| NTF-2024010009 | confirmed | 350 | true | GBP | 2024-03-01T09:45:53Z | PMT-REF-10009 | 2024-03-04 | GB07LOYD30995300112244 | Emily Watson | Lloyds Bank | LOYDGB2L | GB62HBUK40051512345678 | Watson Designs | HSBC UK | HBUKGB4B | SUPP | Design services invoice #WW132 |
| NTF-2024010010 | confirmed | 45000 | true | USD | 2024-03-10T10:22:18Z | INV-2024-0010 | 2024-03-12 | 878912345678 | Brian McCarthy | JPMorgan Chase | CHASUS33 | 321654987012 | McCarthy Holdings | Citibank | CITIUS33 | DIVI | Dividend payout Q1 2024 |
| NTF-2024010011 | confirmed | 2000 | true | SGD | 2024-03-15T14:21:10Z | BONUS-0315 | 2024-03-15 | SG50DBSS1234567890 | Wei Zhang | DBS Bank | DBSSSGSG | SG68UOBB9876543210 | UOB Finance | UOB | UOVBSGSG | BONU | Annual performance bonus |
| NTF-2024010012 | confirmed | 99.99 | true | AUD | 2024-03-27T09:30:00Z | PMT-REF-10012 | 2024-03-28 | AU123456789012345678 | Jessica Taylor | Westpac Banking | WPACAU2S | AU987654321012345678 | Taylor Family Trust | Commonwealth Bank | CTBAAU2S | GIFT | Birthday gift from family |
| NTF-2024010013 | pending | 345.67 | false | USD | 2024-04-02T11:15:45Z | PMT-REF-10013 | 2024-04-04 | 701234567890 | Donald Harris | Bank of America | BOFAUS3N | 110098765432 | Harris Trading | Wells Fargo | WFBIUS6S | SUPP | Invoice #00345 supply |
| NTF-2024010014 | confirmed | 10.55 | true | JPY | 2024-04-10T18:05:30Z | PMT-REF-10014 | 2024-04-11 | JP1234567890123456 | Hiroshi Tanaka | Mizuho Bank | MHCBJPJT | JP9876543210123456 | Tanaka Imports | SMBC | SMBCJPJT | CASH | Cash settlement for order #22 |
| NTF-2024010015 | confirmed | 28765 | true | USD | 2024-04-19T09:28:44Z | PMT-REF-10015 | 2024-04-22 | 667788990011 | Linda Martinez | US Bank | USBKUS44XXX | 998877665544 | Martinez Manufacturing | Citibank | CITIUS33 | SUPP | PO #2024-04 payment |
| NTF-2024010016 | pending | 123456.78 | false | GBP | 2024-05-02T10:35:22Z | PMT-REF-10016 | 2024-05-02 | GB33BUKB20201555555555 | Sarah Williams | Barclays Bank | BARCGB22 | GB88HBUK40051598765432 | Williams Innovations | HSBC UK | HBUKGB4B | TECH | Technology transfer settlement |
| NTF-2024010017 | confirmed | 450 | true | EUR | 2024-05-11T11:22:11Z | PMT-REF-10017 | 2024-05-13 | IT60X0542811101000000123456 | Francesca Rossi | Intesa Sanpaolo | BCITITMM | ES9121000418450200051123 | Rossi Consulting | Banco Santander | BSCHESMM | SUPP | Consulting invoice #2024/17 |
| NTF-2024010018 | pending | 2024 | false | USD | 2024-05-20T17:55:04Z | CORT-2024-18 | 2024-05-22 | 123450987654 | Edward Johnson | Wells Fargo | WFBIUS6S | 543210987654 | Johnson Contracting | JPMorgan Chase | CHASUS33 | CORT | Contract payment Q2 |
| NTF-2024010019 | confirmed | 1 | true | GBP | 2024-05-29T08:21:00Z | GIFT-CHILDREN-19 | 2024-05-29 | GB22HBUK40051598765432 | Amelia Brown | HSBC UK | HBUKGB4B | blank | blank | blank | blank | GIFT | Children charity donation |
| NTF-2024010020 | confirmed | 6000 | true | USD | 2024-06-01T09:12:30Z | PMT-REF-10020 | 2024-06-03 | 104578963214 | Steven Clark | Citibank | CITIUS33 | 204567891234 | Clark Construction | Bank of America | BOFAUS3N | SUPP | Building materials invoice #91 |
What the 400 rows show
from the 400-row sample- 64%reconciliation_
flag = true - 753.0median expected_
amount - 10purpose codes
- 56remitter bank bics
- 58beneficiary bank bics
- 66remitter bank names
Median 753.0, from 0.0 to 100,000,000.
- string 14
- float 1
- date 1
- datetime 1
- boolean 1
Columns
18 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
notification_id | string | Unique identifier for each notification to receive messageunique | NTF-2024010001 |
payment_reference | string | Reference identifier for the incoming payment, as provided by the remitter | PMT-REF-10001 |
currency | string | ISO currency code for the expected payment (e.g., USD, EUR)10 currencies | USD |
beneficiary_account_number | string | Account number of the beneficiary expected to receive the funds | 435671278900 |
beneficiary_name | string | Full name of the beneficiary | Rachel Cooper |
beneficiary_bank_name | string | Name of the beneficiary's bank | U.S. Bank |
beneficiary_bank_bic | string | Bank Identifier Code (BIC/SWIFT) of the beneficiary's bankoptional | USBKUS44XXX |
remitter_account_number | string | Account number of the remitter (payer)optional | 987654321012 |
remitter_name | string | Full name of the remitter (payer)optional | Acme Corp |
remitter_bank_name | string | Name of the remitter's bankoptional | Citibank |
remitter_bank_bic | string | Bank Identifier Code (BIC/SWIFT) of the remitter's bankoptional | CITIUS33 |
purpose_code | string | ISO20022 purpose code for the payment (e.g., SALA for salary, SUPP for supplier payment)10 codes · optional | SUPP |
additional_information | string | Any additional information or remittance advice provided with the notificationoptional | Contract payment Q1 |
status | string | Status of the notification (e.g., pending, confirmed, cancelled)pending · confirmed · cancelled | confirmed |
| Numbers 1 column | |||
expected_amount | float | Expected amount to be received in the payment notification0 or more | 1200.75 |
| Dates and times 2 columns | |||
notification_datetime | datetime | Date and time when the notification was issued | 2024-01-02T10:14:37Z |
expected_settlement_date | date | Date when the payment is expected to be settled and funds credited | 2024-01-03 |
| True or false 1 column | |||
reconciliation_flag | boolean | Indicates if the notification has been reconciled with an actual incoming payment | true |
Use it for
A finance dashboard
The reconciliation_
flag rate, expected_ amount by status and a breakdown of currency. Excel, Power BI or Tableau. Why do 256 of 400 rows have reconciliation_
flag = true? A class exercise
Hand out the rows and one question. Everyone works from the same 400 rows.
- Notifications400NTF-20240100011200.75confirmedNTF-20240100020cancelledNTF-2024010004120000confirmed
A software demo
Believable notifications with notification_
datetime, payment_ reference and expected_ settlement_ date to fill a screen in front of a buyer.
blueprint · iso20022-notification-to-receive-camt057
Behind this dataset
Same schema. As many rows as you need.
These 400 rows came out of a blueprint — 18 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.
- Expected payment amount
- Expected value date
- Debtor information provided
- Payment reference for reconciliation
- Creditor account identification
- Notification sent before settlement
- Currency and amount specified
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-notification-to-receive-camt057