Finance
21 columns
300 rows
8 formats

ISO20022 Financial Institution to Financial Institution Payment Status (pacs.002)

This dataset provides detailed ISO20022 pacs.002 payment status messages exchanged between financial institutions, including payment lifecycle tracking, clearing and settlement confirmations, and exception notifications. It enables comprehensive monitoring, reconciliation, and analysis of interbank payment processing, supporting compliance and operational efficiency.

last updated 29 Oct 2025
by GoMask

The brief that made it

Interbank payment reconciliation and tracking

Sample rows

preview · 8 of 300 rows · all 21 columns

message_idstring	processing_channelstring	amountfloat	currencystring	original_payment_idstring	status_codestring	status_datetimedatetime	clearing_system_referencestring	settlement_datedate	debtor_bank_bicstring	creditor_bank_bicstring	exception_codestring	initiating_party_namestring	receiving_party_namestring	address_streetstring	address_citystring	address_statestring	address_postal_codestring	address_countrystring	status_descriptionstring	exception_descriptionstring
MSG-20240601-001	SWIFT	blank	blank	PAY-20240601-00001	ACCP	2024-06-01T09:21:15Z	CLRREFX001	blank	CHASUS33XXX	ICBKCNBJXXX	blank	North American Export LLC	Shanghai Global Trading Co.	100 Main Street	Chicago	IL	60601	US	Accepted by receiving bank, pending settlement.	blank
MSG-20240601-002	SEPA	950.5	EUR	PAY-20240601-00002	RJCT	2024-06-01T10:05:32Z	CLRREFG002	blank	DEUTDEFFXXX	BNPAFRPPXXX	NOFUNDS	Berlin Supplies GmbH	Paris Import SARL	Prenzlauer Allee 200	Berlin	blank	10405	DE	Payment rejected due to insufficient funds.	Sender account balance is below required minimum.
MSG-20240601-003	SWIFT	1200000	USD	PAY-20240601-00003	PDNG	2024-06-01T11:13:42Z	CLRREFK003	blank	BOFAUS3NXXX	HSBCGB2LXXX	blank	Pacific Tech Holdings Inc.	London Financial Group PLC	500 Market St.	San Francisco	CA	94105	US	Pending compliance review before approval.	blank
MSG-20240601-004	CHAPS	50000	GBP	PAY-20240601-00004	ACSC	2024-06-01T12:45:23Z	CLRREFQ004	2024-06-01	BARCGB22XXX	LOYDGB2LXXX	blank	Manchester Retail Ltd.	Oxford University	22 King Street	Manchester	blank	M2 6AW	GB	Payment settled and completed successfully.	blank
MSG-20240601-005	FEDWIRE	1000	USD	PAY-20240601-00005	PART	2024-06-01T13:56:12Z	CLRREFW005	blank	CITIGB2LXXX	WELLSUS6SXXX	blank	New York Investment Corp.	California Realty Trust	700 Park Avenue	New York	NY	10022	US	Partial payment processed; awaiting completion.	blank
MSG-20240601-006	SWIFT	blank	blank	PAY-20240601-00006	ACCP	2024-06-01T14:03:54Z	CLRREFE006	blank	HSBCCN2NXXX	SMBCJPJTXXX	blank	Beijing Export Ltd.	Tokyo Electronics Co.	88 Chaoyang Road	Beijing	blank	100020	CN	Payment accepted by intermediary bank.	blank
MSG-20240601-007	SEPA	500.75	CHF	PAY-20240601-00007	CANC	2024-06-01T15:21:10Z	CLRREFH007	blank	UBSWCHZH80A	CSCHCHZZXXX	SENDERREQ	Zurich Holdings AG	Geneva International SA	Bahnhofstrasse 1	Zurich	blank	8001	CH	Payment cancelled by sender request.	Sender requested cancellation before settlement.
MSG-20240601-008	SWIFT	blank	blank	PAY-20240601-00008	ACCP	2024-06-01T16:05:17Z	CLRREFM008	blank	ICICINBBNRI	SBININBBXXX	blank	Mumbai Textiles Pvt Ltd.	Delhi Glass Works	22 Marine Drive	Mumbai	MH	400020	IN	Accepted, awaiting processing by clearing system.	blank
MSG-20240601-009	SEPA	1275.25	EUR	PAY-20240601-00009	ACSC	2024-06-01T16:59:41Z	CLRREFS009	2024-06-01	INGBNL2AXXX	DEUTDEFFXXX	blank	Amsterdam Ventures BV	Frankfurt Logistics GmbH	Herengracht 500	Amsterdam	blank	1017CB	NL	Payment settled without exception.	blank
MSG-20240601-010	SWIFT	10000000	KRW	PAY-20240601-00010	PDNG	2024-06-01T17:26:38Z	CLRREFD010	blank	KOEXKRSEXXX	KBKOKRSEXXX	blank	Seoul Electronics Ltd.	Busan Shipping Co.	123 Gangnam-daero	Seoul	blank	06030	KR	Pending validation of beneficiary details.	blank
MSG-20240601-011	CHAPS	blank	blank	PAY-20240601-00011	ACCP	2024-06-01T18:03:54Z	CLRREFT011	blank	NATAGB2LXXX	RBSGGB2LXXX	blank	Edinburgh Insurance PLC	Glasgow Manufacturing Ltd.	10 Princess Street	Edinburgh	blank	EH2 2AN	GB	Accepted and queued for next processing window.	blank
MSG-20240601-012	SWIFT	5000	USD	PAY-20240601-00012	RJCT	2024-06-01T18:34:27Z	CLRREFU012	blank	PNCCUS33XXX	TDOMCATTTOR	INVACC	Denver Exporters Inc.	Toronto Import Co.	2500 Blake St.	Denver	CO	80205	US	Rejected due to invalid beneficiary account.	Beneficiary account number not recognized.
MSG-20240601-013	SEPA	250	CHF	PAY-20240601-00013	ACSC	2024-06-01T19:15:09Z	CLRREFV013	2024-06-01	ZURICHCHZZZX	RAIFCH22XXX	blank	Bern Consulting AG	Lucerne Engineering GmbH	Bundesplatz 10	Bern	blank	3011	CH	Payment settlement confirmed and completed.	blank
MSG-20240601-014	SWIFT	100000	JPY	PAY-20240601-00014	PART	2024-06-01T20:02:17Z	CLRREFP014	blank	MIZUJPJTXXX	SMBCJPJTXXX	blank	Tokyo Chemicals Ltd.	Osaka Steel Corp.	1 Chiyoda-ku	Tokyo	blank	100-0001	JP	Partial payment processed; balance remains.	blank
MSG-20240601-015	SWIFT	blank	blank	PAY-20240601-00015	ACCP	2024-06-01T20:41:00Z	CLRREFB015	blank	ANZBAU3MXXX	CBAAU2SXXX	blank	Sydney Mining Pty Ltd.	Melbourne Freight Ltd.	120 George Street	Sydney	NSW	2000	AU	Payment received, processing will commence.	blank
MSG-20240601-016	FEDWIRE	750.35	USD	PAY-20240601-00016	RJCT	2024-06-01T21:22:09Z	CLRREFR016	blank	WELLSUS6SXXX	BOFAUS3NXXX	REGFAIL	Houston Oil & Gas	Seattle Equipment Co.	5555 Richmond Ave.	Houston	TX	77056	US	Rejected due to regulatory restrictions.	Payment failed regulatory compliance checks.
MSG-20240601-017	SEPA	1200.99	EUR	PAY-20240601-00017	ACSC	2024-06-01T21:58:32Z	CLRREFC017	2024-06-01	SPKRDEFFXXX	BNPAFRPPXXX	blank	Munich Technologies GmbH	Lyon Food SARL	Maximilianstrasse 20	Munich	blank	80539	DE	Funds settled, confirmation sent to all parties.	blank
MSG-20240601-018	SWIFT	273.2	AUD	PAY-20240601-00018	PDNG	2024-06-01T22:37:45Z	CLRREFL018	blank	CBAAU2SXXX	NABAAU3MXXX	blank	Brisbane Paper Pty Ltd.	Perth Steel Supplies	20 Queen Street	Brisbane	QLD	4000	AU	Pending due to additional documentation required.	blank
MSG-20240601-019	SWIFT	0.01	USD	PAY-20240601-00019	PART	2024-06-01T23:19:02Z	CLRREFF019	blank	TDOMCATTTOR	PNCCUS33XXX	blank	Montreal Logistics Inc.	Chicago Hardware LLC	400 St. Catherine St.	Montreal	QC	H3B 1A1	CA	Partial transfer completed, remainder pending.	blank
MSG-20240601-020	SWIFT	blank	blank	PAY-20240601-00020	ACCP	2024-06-01T23:54:17Z	CLRREFN020	blank	HSBCHKHHHKH	ICBKCNBJXXX	blank	Hong Kong Finance Ltd.	Beijing Imports Co.	88 Connaught Road	Hong Kong	blank	999077	CN	Accepted for processing in next batch.	blank

What the 300 rows show

from the 300-row sample

400.0median amount
6status codes
15address countries
27address states
70creditor bank bics
72debtor bank bics

processing_channel300 rows by value

amount237 rows, in bands of 100M

Median 400.0, from 0.0 to 800,000,001.

currency237 rows with a value · 63 left blank

USD55
EUR52
CHF30
GBP25
KRW19
AUD16
JPY15
INR11
CNY11
CAD2

21 columns by typefrom the column list below

string 18
float 1
date 1
datetime 1

Columns

21 columns in three groups

blueprint · 21 columns
column	type	description	example
Text 18 columns
`message_id`	string	Unique identifier for the pacs.002 status messageunique	MSG-20240601-001
`original_payment_id`	string	Unique identifier of the original payment instruction (pacs.008 or equivalent)	PAY-20240601-00001
`status_code`	string	Standardized code indicating the payment status (e.g., ACCP, RJCT, PDNG)6 values	ACCP
`status_description`	string	Human-readable description of the payment statusoptional	Accepted by receiving ban…
`clearing_system_reference`	string	Reference assigned by the clearing system for trackingoptional	CLRREFX001
`currency`	string	ISO 4217 currency code for the payment amount11 currencies · optional	EUR
`debtor_bank_bic`	string	BIC code of the originating (debtor) financial institution	CHASUS33XXX
`creditor_bank_bic`	string	BIC code of the receiving (creditor) financial institution	ICBKCNBJXXX
`exception_code`	string	Code indicating the reason for rejection or exception (if applicable)optional	NOFUNDS
`exception_description`	string	Detailed description of the exception or error (if applicable)optional	Sender account balance is…
`initiating_party_name`	string	Name of the party initiating the paymentoptional	Berlin Supplies GmbH
`receiving_party_name`	string	Name of the party receiving the paymentoptional	Paris Import SARL
`processing_channel`	string	Channel or network used for payment processing (e.g., SWIFT, SEPA)SWIFT · SEPA · FEDWIRE · CHAPS · TARGET2 · optional	SWIFT
`address_street`	string	Street address of the initiating party (if available)optional	100 Main Street
`address_city`	string	City of the initiating party (if available)optional	Chicago
`address_state`	string	State or province of the initiating party (if available)optional	IL
`address_postal_code`	string	Postal code of the initiating party (if available)optional	60601
`address_country`	string	Country of the initiating party (ISO 3166-1 alpha-2 code)optional	US
Numbers 1 column
`amount`	float	Amount of the payment being referenced0 or more · optional	950.5
Dates and times 2 columns
`status_datetime`	datetime	Timestamp when the status was issued	2024-06-01T09:21:15Z
`settlement_date`	date	Date when the payment was settled (if applicable)optional	2024-06-01

Use it for

A finance dashboard
Amount by processing_channel and a breakdown of currency. Excel, Power BI or Tableau.
What pattern can you find in 300 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 300 rows.
Messages300
MSG-20240601-001SWIFT
MSG-20240601-002950.5SEPA
MSG-20240601-0031200000SWIFT
A software demo
Believable messages with original_payment_id, status_code and status_description to fill a screen in front of a buyer.

This dataset300 rows21 columns

Yours1,000 rows21 columnsaddress_street: UK only

blueprint · iso20022-financial-institution-to-financial-institution-payment-status-pacs002

Behind this dataset

Same schema. As many rows as you need.

These 300 rows came out of a blueprint — 21 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

Original instruction reference
Status code: pending, accepted, rejected, settled
Settlement timestamp if completed
Reason code for rejections
Instructing agent informed
Transaction status per payment in batch

Rows1,000 rows10,000 rows100,000 rows1,000,000 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-financial-institution-to-financial-institution-payment-status-pacs002

What should your data show?

No signup. No card.

Sample rows

What the 300 rows show

Columns

Use it for

A finance dashboard

A class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Finance

What should your data show?