Finance
20 columns
200 rows
8 formats

ISO20022 Payment Reversal (pacs.007)

This dataset provides detailed records of ISO20022 payment reversal requests, including references to original transactions, reversal reasons, investigation statuses, and party information. It is designed for financial institutions to track, analyze, and audit reversals due to errors, fraud, or customer disputes, supporting regulatory compliance and operational efficiency.

last updated 29 Oct 2025
by GoMask

The brief that made it

Tracking and managing payment reversals for compliance and audit

Sample rows

preview · 8 of 200 rows · all 20 columns

reversal_idstring	investigation_statusstring	reversal_amountfloat	error_indicatorboolean	currencystring	original_payment_idstring	reversal_request_datedatetime	reversal_reason_codestring	initiator_party_idstring	initiator_party_namestring	beneficiary_party_idstring	beneficiary_party_namestring	settlement_datedate	reversal_settlement_datedate	fraud_indicatorboolean	customer_dispute_indicatorboolean	reference_numberstring	external_investigation_idstring	reversal_reason_descriptionstring	investigation_detailsstring
RVSL-0001	COMPLETED	210.44	true	USD	PAY-10001	2023-01-02T08:15:00Z	ERR	INIT-001	Bank Operations	BEN-1001	Jackson Plumbing LLC	2022-12-30	2023-01-03	false	false	REF-20230102-01	blank	Duplicate payment processed due to system error.	Verified issue with payment batch, reversal approved.
RVSL-0002	PENDING	5200	false	EUR	PAY-10002	2023-02-15T23:59:00Z	FRAUD	INIT-002	Fraud Analysis Team	BEN-1002	Muller Trading GmbH	2023-02-14	blank	true	false	REF-20230215-02	EXTINV-0001	Suspected fraudulent activity detected post-settlement.	Transaction flagged by fraud engine, investigation ongoing.
RVSL-0003	PENDING	129.99	false	USD	PAY-10003	2023-03-01T10:45:00Z	DISPUTE	INIT-003	Customer Service	BEN-1003	Online Electronics	2023-02-28	blank	false	true	REF-20230301-03	blank	Customer reported non-receipt of goods.	Awaiting merchant response to customer dispute.
RVSL-0004	COMPLETED	50	true	USD	PAY-10001	2023-01-03T11:30:00Z	ERR	INIT-004	QA Team	BEN-1004	Samantha Lee	2022-12-30	2023-01-04	false	false	REF-20230103-04	blank	Payment amount entered incorrectly by teller.	Error confirmed, reversal processed.
RVSL-0005	COMPLETED	7100	false	CAD	PAY-10004	2023-04-15T12:20:00Z	OTHER	INIT-005	Compliance Desk	BEN-1005	Northern Exporters Inc.	2023-04-13	2023-04-16	false	false	REF-20230415-05	blank	Compliance review required for international remittance.	Compliance check passed, funds returned.
RVSL-0006	COMPLETED	40999.99	false	USD	PAY-10005	2023-05-02T09:00:00Z	FRAUD	INIT-006	blank	BEN-1006	Global Merchants Ltd.	2023-05-01	2023-05-05	true	false	REF-20230502-06	EXTINV-0002	Unauthorized access detected for high-value transfer.	Investigation confirmed fraud, reversal processed.
RVSL-0007	COMPLETED	86.5	false	GBP	PAY-10006	2023-06-12T14:10:00Z	DISPUTE	INIT-007	Retail Branch	BEN-1007	London Taxi Services	2023-06-10	2023-06-14	false	true	REF-20230612-07	blank	Customer disputes service charge for transaction.	Fee reviewed, charge reversed per policy.
RVSL-0008	COMPLETED	0.01	true	JPY	PAY-10007	2023-07-01T00:00:00Z	ERR	INIT-008	blank	BEN-1008	blank	2023-07-01	2023-07-02	false	false	TEST-EDGE-08	blank	System outage led to duplicate submission at midnight.	Test case for system edge scenario.
RVSL-0009	PENDING	120	false	USD	PAY-10008	2023-08-01T16:42:00Z	DISPUTE	INIT-009	Customer Service	BEN-1009	Blue Ridge Market	2023-07-30	blank	false	true	REF-20230801-09	blank	Customer claims incorrect charge on statement.	Awaiting supporting documents from customer.
RVSL-0010	REJECTED	55000	false	CHF	PAY-10009	2023-09-15T19:30:00Z	FRAUD	INIT-010	Security Division	BEN-1010	Alpine Holdings AG	2023-09-12	blank	true	false	REF-20230915-10	EXTINV-0003	Large transfer flagged as potential money laundering.	No evidence of fraud found, reversal denied.
RVSL-0011	COMPLETED	55.2	false	USD	PAY-10010	2023-10-05T08:25:00Z	DISPUTE	INIT-011	Travel Services	BEN-1011	Mountain Gear Outlet	2023-10-03	2023-10-06	false	true	REF-20231005-11	blank	Dispute over late delivery of goods to customer.	Merchant agreed to refund, reversal processed.
RVSL-0012	COMPLETED	300	true	USD	PAY-10011	2023-11-11T11:11:00Z	ERR	INIT-012	Merchant Support	BEN-1012	Emma Patterson	2023-11-10	2023-11-12	false	false	REF-20231111-12	blank	Manual entry error, incorrect account debited.	Entry error confirmed, funds returned.
RVSL-0013	COMPLETED	99999.99	false	USD	PAY-10012	2023-12-31T23:59:00Z	OTHER	INIT-013	Operations	BEN-1013	blank	2023-12-31	2024-01-02	false	false	EDGE-20231231-13	blank	Special reversal for fiscal year-end adjustment.	Year-end adjustment processed.
RVSL-0014	COMPLETED	160.99	true	USD	PAY-10013	2023-01-29T17:45:00Z	ERR	INIT-014	Bank Operations	BEN-1014	Sunset Cafe	2023-01-28	2023-01-30	false	false	REF-20230129-14	blank	Incorrect payment date selected by customer.	Customer error confirmed, reversal completed.
RVSL-0015	COMPLETED	98	false	EUR	PAY-10014	2023-02-28T23:58:00Z	DISPUTE	INIT-015	Customer Service	BEN-1015	Euro Books	2023-02-27	2023-03-01	false	true	REF-20230228-15	blank	Customer did not recognize transaction.	Transaction reviewed, reversal approved.
RVSL-0016	PENDING	6300	false	AUD	PAY-10015	2023-03-17T15:40:00Z	FRAUD	INIT-016	Fraud Analysis Team	BEN-1016	Sydney Traders Pty	2023-03-16	blank	true	false	REF-20230317-16	EXTINV-0004	Merchant account compromised, unauthorized withdrawal.	Merchant account flagged, further review underway.
RVSL-0017	PENDING	2500	false	CHF	PAY-10016	2023-04-03T07:05:00Z	OTHER	INIT-017	Legal Department	BEN-1017	Swiss Legal Advisors	2023-04-02	blank	false	false	REF-20230403-17	EXTINV-0005	Legal hold placed on funds after payment.	Funds blocked, awaiting court directive.
RVSL-0018	COMPLETED	325	true	USD	PAY-10017	2023-05-12T13:50:00Z	ERR	INIT-018	QA Team	BEN-1018	Bright Solutions	2023-05-11	2023-05-13	false	false	REF-20230512-18	blank	Payment processed twice due to API misfire.	API bug confirmed, reversal processed.
RVSL-0019	REJECTED	45	false	USD	PAY-10018	2023-06-28T17:55:00Z	DISPUTE	INIT-019	Customer Service	BEN-1019	Streaming Media Hub	2023-06-27	blank	false	true	REF-20230628-19	blank	Customer disputed charge for canceled subscription.	Merchant provided evidence of service, dispute closed.
RVSL-0020	COMPLETED	7999.99	false	INR	PAY-10019	2023-07-14T09:15:00Z	FRAUD	INIT-020	Security Division	BEN-1020	Mumbai Imports Pvt Ltd	2023-07-13	2023-07-16	true	false	REF-20230714-20	EXTINV-0006	Transaction linked to phishing incident.	Fraudulent account confirmed, reversal successful.

What the 200 rows show

from the 200-row sample

COMPLETED (investigation status) stands out: 57 of its 139 rows have error_indicator = true, against 0 of 61 for the rest.

28%error_indicator = true
350.0median reversal_amount
4reversal reason codes
42initiator party names

Error indicator rate by investigation_statuserror_indicator = true

reversal_amount200 rows, in bands of 10k

Median 350.0, from 0.01 to 100,000.

currency200 rows · 8 values

USD122
EUR26
CHF14
CAD11
GBP11
AUD7
INR5
JPY4

20 columns by typefrom the column list below

string 13
float 1
date 2
datetime 1
boolean 3

Columns

20 columns in four groups

blueprint · 20 columns
column	type	description	example
Text 13 columns
`reversal_id`	string	Unique identifier for the payment reversal requestunique	RVSL-0001
`original_payment_id`	string	Identifier of the original settled payment being reversed	PAY-10001
`reversal_reason_code`	string	Standardized code indicating the reason for reversal (e.g., ERR, FRAUD, DISPUTE)ERR · FRAUD · DISPUTE · OTHER	ERR
`reversal_reason_description`	string	Detailed description of the reason for payment reversaloptional	Payment submitted twice.
`currency`	string	ISO currency code of the reversal amount (e.g., USD, EUR)8 currencies	USD
`initiator_party_id`	string	Identifier for the party initiating the reversal request	INIT-001
`initiator_party_name`	string	Name of the party initiating the reversaloptional	Bank Operations
`beneficiary_party_id`	string	Identifier for the original beneficiary of the payment	BEN-1001
`beneficiary_party_name`	string	Name of the original beneficiaryoptional	Jackson Plumbing LLC
`investigation_status`	string	Current status of the investigation (e.g., PENDING, COMPLETED, REJECTED)PENDING · COMPLETED · REJECTED	COMPLETED
`investigation_details`	string	Additional details or notes about the investigation processoptional	Fraud review ongoing.
`reference_number`	string	Reference number for tracking the reversal requestoptional	REF-20230102-01
`external_investigation_id`	string	Identifier for any external investigation related to the reversaloptional	EXTINV-0001
Numbers 1 column
`reversal_amount`	float	Amount being reversed0.01 or more	210.44
Dates and times 3 columns
`reversal_request_date`	datetime	Date and time when the reversal request was initiated	2023-01-02T08:15:00Z
`settlement_date`	date	Date when the original payment was settled	2022-12-30
`reversal_settlement_date`	date	Date when the reversal was settled (if applicable)optional	2023-01-03
True or false 3 columns
`fraud_indicator`	boolean	Indicates if the reversal is due to suspected or confirmed fraudoptional	false
`customer_dispute_indicator`	boolean	Indicates if the reversal is due to a customer disputeoptional	false
`error_indicator`	boolean	Indicates if the reversal is due to an error in the original paymentoptional	true

Use it for

A finance dashboard
The error_indicator rate, reversal_amount by investigation_status and a breakdown of currency. Excel, Power BI or Tableau.
Why do 57 of 200 rows have error_indicator = true?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Reversals200
RVSL-0001210.44COMPLETED
RVSL-00025200PENDING
RVSL-000450COMPLETED
A software demo
Believable reversals with original_payment_id, reversal_request_date and reversal_reason_code to fill a screen in front of a buyer.

This dataset200 rows20 columns

Yours1,000 rows20 columns

blueprint · iso20022-payment-reversal-pacs007

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 20 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 payment identification required
Reversal reason: fraud, error, dispute
Reversal amount not exceeding original
Time limit for reversal per scheme rules
Supporting documentation reference
Beneficiary notification required
Compensation amount if applicable

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-payment-reversal-pacs007

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A finance dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Finance

What should your data show?