Finance
28 columns
200 rows
8 formats

ISO20022 Mandate Cancellation Request (pain.011)

This dataset contains comprehensive records of ISO20022 direct debit mandate cancellation requests, detailing debtor and creditor information, cancellation reasons, effective dates, and contact details. It is ideal for financial institutions seeking to track, audit, and analyze mandate cancellations for compliance, operational efficiency, and customer service improvements.

last updated 29 Oct 2025
by GoMask

The brief that made it

Automated processing and audit of mandate cancellations in banking systems

Sample rows

preview · 8 of 200 rows · all 28 columns

mandate_cancellation_request_idstring	request_initiator_typestring	is_final_cancellationboolean	debtor_address_countrystring	mandate_idstring	debtor_namestring	debtor_account_numberstring	debtor_bank_idstring	creditor_namestring	creditor_account_numberstring	creditor_bank_idstring	cancellation_reason_codestring	effective_cancellation_datedate	request_initiator_contact_namestring	request_initiator_contact_emailstring	request_submission_datetimedatetime	mandate_referencestring	debtor_address_streetstring	debtor_address_citystring	debtor_address_statestring	debtor_address_postal_codestring	creditor_address_streetstring	creditor_address_citystring	creditor_address_statestring	creditor_address_postal_codestring	creditor_address_countrystring	cancellation_reason_descriptionstring	additional_informationstring
CAN-000001A	DEBTOR	false	US	MAND-870A2B01	Caroline Welch	US14WELLSF00000122345678901234	WELLSF01	StreamOne Media Services	US19STREAM00001123456789098765	STREAMB1	DEBTOR_REQUEST	2023-06-12	Caroline Welch	caroline.welch@email.com	2023-06-09T14:33:04	StreamOne-Subscription-Jun2023	47 Mission Blvd	San Francisco	CA	94103	900 Market St	San Francisco	CA	94103	US	blank	blank
CAN-000002B	CREDITOR	true	JP	MAND-0022AB29	Yoshiko Tanaka	JP27SUMITOMO000001112345678901	SUMITOMO1	Tokyo Water Utilities	JP08TOKYOWA000012345678901234	TOKYOWU1	MANDATE_EXPIRED	2024-03-31	Kenji Sato	kenji.sato@tokyowater.jp	2024-03-28T09:00:00	Mandate Expiry - Tokyo Water March 2024	2-1-3 Shibuya	Tokyo	Tokyo	150-0002	1-2-4 Shinjuku	Tokyo	Tokyo	160-0022	JP	blank	Mandate expired automatically at period end.
CAN-000003C	CREDITOR	true	ES	MAND-74DE9021	Miguel Alvarez	ES32BBVA00000012345678904567	BBVAES01	Madrid Waste Management	ES47MADWASTE00009876543210987	MADWASTE1	CREDITOR_REQUEST	2022-12-30	Lucia Fernandez	lucia.fernandez@madwaste.es	2022-12-27T11:22:15	Waste Collection - Madrid End 2022	Calle Gran Via 51	Madrid	Madrid	28013	Avenida de la Paz 13	Madrid	Madrid	28042	ES	blank	Mandate cancelled by creditor request due to policy update.
CAN-000004D	DEBTOR	false	IT	MAND-1298AFB2	Laura Rossi	IT60INTESA000000123456789045	INTESA01	Milan Telecom Services	IT34MILTEL000000987654321012	MILTEL01	DEBTOR_REQUEST	2024-09-02	Laura Rossi	laura.rossi@rossimail.it	2024-08-29T17:45:50	Milan Telecom - September 2024	Via Roma 22	Milan	MI	20121	Via Torino 11	Milan	MI	20123	IT	blank	blank
CAN-000005E	DEBTOR	true	SE	MAND-2139BDF1	Sven Johansson	SE54HANDBANK0000012345678901	HANDBANK	Stockholm Energy Grid	SE85STOCKENGR000987654321098	STOCKENG	ACCOUNT_CLOSED	2023-04-07	Sven Johansson	sven.johansson@swemail.se	2023-04-04T10:15:20	Stockholm Energy - April 2023	Vasagatan 14	Stockholm	Stockholm	11120	Kungsgatan 31	Stockholm	Stockholm	11221	SE	blank	Account closed at debtor's request.
CAN-000006F	DEBTOR	false	US	MAND-9982FBC4	James Lee	US56CHASEBANK000012345678901234	CHASEB01	National Broadband LLC	US89NATBROAD000098765432109876	NATBROAD1	DEBTOR_REQUEST	2023-10-31	James Lee	james.lee@nbroadband.com	2023-10-29T16:01:45	National Broadband - October 2023	153 Main St	New York	NY	10001	500 Fifth Ave	New York	NY	10018	US	blank	blank
CAN-000007G	DEBTOR	false	BR	MAND-4882CDA5	Maria Lopez	BR18BANCOBRAS000000123456789012	BANCOBR01	Rio Utilities	BR23RIOUTIL000009876543210987	RIOUTIL01	DEBTOR_REQUEST	2023-08-03	Maria Lopez	maria.lopez@rioutilities.br	2023-07-31T08:42:14	Rio Utilities - August 2023	Rua das Flores 45	Rio de Janeiro	RJ	20010-060	Av. Atlantica 99	Rio de Janeiro	RJ	22010-010	BR	blank	blank
CAN-000008H	DEBTOR	false	DE	MAND-7891BCF2	Heidi Schmidt	DE17COMMERZB000001234567890123	COMMERZB	Berlin Cable Services	DE22BERLCABL000009876543210987	BERLCABL1	DEBTOR_REQUEST	2024-02-01	Heidi Schmidt	heidi.schmidt@berlincable.de	2024-01-29T11:54:00	Berlin Cable - February 2024	Friedrichstrasse 88	Berlin	Berlin	10117	Unter den Linden 5	Berlin	Berlin	10117	DE	blank	blank
CAN-000009J	CREDITOR	true	IT	MAND-1348AFD7	Tommaso Greco	IT40POSTE00000012345678901234	POSTEITA	Milan Insurance Group	IT55MILINSUR00000987654321098	MILINSUR1	CREDITOR_REQUEST	2023-01-15	Giulia Bianchi	giulia.bianchi@milinsurance.it	2023-01-12T08:22:10	Insurance Policy - Milan Jan2023	Via Dante 14	Milan	MI	20123	Corso Buenos Aires 19	Milan	MI	20124	IT	blank	Mandate cancelled at creditor's request.
CAN-000010K	DEBTOR	false	GB	MAND-8102BCF9	Sarah Johnson	GB44HSBC0000001234567890123456	HSBCUK01	London Streaming Ltd	GB54LONSTREAM0000987654321098	LONSTREAM	DEBTOR_REQUEST	2024-05-05	Sarah Johnson	sjohnson@londonstream.co.uk	2024-05-03T13:45:00	London Streaming - May2024	12 Oxford St	London	London	W1D1BS	55 Regent St	London	London	W1B2AE	GB	blank	blank
CAN-000011L	DEBTOR	true	CN	MAND-9321AFC2	Chen Wei	CN62ICBC0000001234567890123456	ICBCCN01	Beijing Utilities	CN47BJUTIL000098765432109876	BJUTIL01	ACCOUNT_CLOSED	2024-11-16	Chen Wei	chen.wei@bjutilities.cn	2024-11-13T09:22:00	Beijing Utilities Nov2024	Tiananmen Ave 77	Beijing	Beijing	100006	Dongcheng St 12	Beijing	Beijing	100010	CN	blank	Debtor account closed.
CAN-000012M	DEBTOR	false	AE	MAND-2489BCE5	Ahmed Hassan	AE54EMIRSTB000001234567890123	EMIRSTB1	Dubai Telecom	AE99DUBTEL000009876543210987	DUBTEL01	DEBTOR_REQUEST	2023-03-04	Ahmed Hassan	ahassan@dubaitel.ae	2023-03-02T15:20:00	Dubai Telecom Mar2023	Sheikh Zayed Rd 100	Dubai	Dubai	00000	Burj Khalifa Blvd 21	Dubai	Dubai	00001	AE	blank	blank
CAN-000013N	CREDITOR	true	SE	MAND-0033AAA4	Anna Svensson	SE33SWEDBANK000012345678901	SWEDBANK1	Stockholm Broadband	SE88STOCKBRD000098765432109	STOCKBRD1	MANDATE_EXPIRED	2022-12-31	Gunnar Dahl	gunnar.dahl@stockbrd.se	2022-12-28T13:50:00	Broadband Mandate Expiry Dec2022	Storgatan 12	Stockholm	Stockholm	11321	Kungsgatan 15	Stockholm	Stockholm	11421	SE	blank	Mandate expired end of year.
CAN-000014P	DEBTOR	false	GB	MAND-7771DCD3	Julia White	GB19NATWEST000012345678901234	NATWEST01	London Insurance PLC	GB99LONINSUR000098765432109	LONINSUR1	DEBTOR_REQUEST	2024-04-09	Julia White	jwhite@londoninsurance.co.uk	2024-04-07T15:50:00	Insurance Mandate April2024	23 Regent St	London	London	W1B3HR	45 Oxford St	London	London	W1D2JA	GB	blank	blank
CAN-000015Q	DEBTOR	false	IT	MAND-8234BCE2	Emilia Ferrari	IT71UNICRED000001234567890123	UNICRED01	Milan Waste Services	IT29MILWASTE0000098765432109	MILWASTE1	DEBTOR_REQUEST	2023-11-12	Emilia Ferrari	emilia.ferrari@milwaste.it	2023-11-10T09:25:00	Milan Waste Nov2023	Via Milano 80	Milan	MI	20131	Viale Monza 22	Milan	MI	20127	IT	blank	blank
CAN-000016R	DEBTOR	false	NG	MAND-0192DDC4	Mohammed Bello	NG23ZENITHBK0000123456789012	ZENITHBK1	Lagos Telecom Services	NG53LAGTEL00000987654321098	LAGTEL01	DEBTOR_REQUEST	2023-07-18	Mohammed Bello	m.bello@lagostelecom.ng	2023-07-15T11:30:00	Lagos Telecom July2023	10 Ikoyi Rd	Lagos	Lagos	101233	33 Victoria Island	Lagos	Lagos	100271	NG	blank	blank
CAN-000017S	DEBTOR	true	KR	MAND-6132AAC0	Emily Kim	KR82KBK0000001234567890123456	KBKBANK01	Seoul Electric	KR99SEOULELC0000987654321098	SEOULELC1	ACCOUNT_CLOSED	2024-02-19	Emily Kim	emily.kim@seoulel.kr	2024-02-17T08:00:00	Seoul Electric Feb2024	Jongno 120	Seoul	Seoul	03000	Gangnam-daero 55	Seoul	Seoul	06100	KR	blank	Account closed by debtor.
CAN-000018T	DEBTOR	false	US	MAND-4392AAE5	John Doe	US39CITIBANK000012345678901234	CITIBANK1	NY Water Utilities	US55NYWATER000098765432109876	NYWATER01	DEBTOR_REQUEST	2023-02-28	John Doe	john.doe@nywater.com	2023-02-26T09:10:00	NY Water Feb2023	23 Broadway	New York	NY	10004	14 Wall St	New York	NY	10005	US	blank	blank
CAN-000019U	CREDITOR	true	FR	MAND-2022AAB1	Pierre Dubois	FR76BNP0000001234567890123456	BNPFR001	Paris Waste Services	FR99PARWASTE00009876543210987	PARWASTE1	CREDITOR_REQUEST	2023-09-25	Isabelle Martin	imartin@parwaste.fr	2023-09-22T14:10:00	Paris Waste Sept2023	Rue de Rivoli 10	Paris	Paris	75001	Avenue Montaigne 30	Paris	Paris	75008	FR	blank	Service discontinued by creditor.
CAN-000020V	DEBTOR	true	EG	MAND-5034AAE2	Fatima El-Sayed	EG55NBEG0000001234567890123456	NBEG0011	Cairo Water Utility	EG99CAIWATER00009876543210987	CAIWATER1	OTHER	2024-02-29	Fatima El-Sayed	fatima.elsayed@cairowater.eg	2024-02-29T10:00:00	Cairo Water LeapYear	El Tahrir St 22	Cairo	blank	11511	Corniche El Nil 8	Cairo	blank	11221	EG	Mandate cancelled due to regulatory compliance change for international transfers.	Edge case: Leap year, regulatory change.

What the 200 rows show

from the 200-row sample

CREDITOR (request initiator type) stands out: 46 of its 46 rows have is_final_cancellation = true, against 27 of 154 for the rest.

37%is_final_cancellation = true
5cancellation reason codes
17creditor address countries
53debtor address states
54creditor address states
57debtor address cities

Is final cancellation rate by request_initiator_typeis_final_cancellation = true

debtor_address_country200 rows · top 10 of 17 values

US23
IT20
DE19
SE18
ES16
GB15
BR14
JP13
CN12
AE10

28 columns by typefrom the column list below

string 25
date 1
datetime 1
boolean 1

Columns

28 columns in three groups

blueprint · 28 columns
column	type	description	example
Text 25 columns
`mandate_cancellation_request_id`	string	Unique identifier for the mandate cancellation requestunique	CAN-000001A
`mandate_id`	string	Unique identifier of the direct debit mandate being cancelled	MAND-870A2B01
`debtor_name`	string	Full name of the debtor requesting cancellationup to 140	Caroline Welch
`debtor_account_number`	string	Account number of the debtorup to 34	DE89370400440532013000
`debtor_bank_id`	string	Bank identifier code (e.g., BIC or routing number) for the debtor's bankup to 11	WELLSF01
`creditor_name`	string	Full name of the creditor associated with the mandateup to 140	StreamOne Media Services
`creditor_account_number`	string	Account number of the creditorup to 34	ES11MADTV000098765432109
`creditor_bank_id`	string	Bank identifier code (e.g., BIC or routing number) for the creditor's bankup to 11	STREAMB1
`cancellation_reason_code`	string	Standardized code indicating the reason for cancellation5 values	DEBTOR_REQUEST
`cancellation_reason_description`	string	Detailed description of the cancellation reason, if 'OTHER' is selectedup to 500 · optional	Mandate cancelled due to …
`request_initiator_type`	string	Indicates whether the request was initiated by the debtor or creditorDEBTOR · CREDITOR	DEBTOR
`request_initiator_contact_name`	string	Name of the contact person who initiated the cancellation requestup to 140 · optional	Caroline Welch
`request_initiator_contact_email`	string	Email address of the contact person who initiated the requestoptional	caroline.welch@email.com
`mandate_reference`	string	Reference or description for the mandate, as provided by the creditorup to 70 · optional	Dubai Telecom Mar2023
`debtor_address_street`	string	Street address of the debtorup to 70 · optional	47 Mission Blvd
`debtor_address_city`	string	City of the debtor's addressup to 35 · optional	San Francisco
`debtor_address_state`	string	State or province of the debtor's addressup to 35 · optional	CA
`debtor_address_postal_code`	string	Postal code of the debtor's addressup to 16 · optional	94103
`debtor_address_country`	string	Country code (ISO 3166-1 alpha-2) of the debtor's addressoptional	US
`creditor_address_street`	string	Street address of the creditorup to 70 · optional	900 Market St
`creditor_address_city`	string	City of the creditor's addressup to 35 · optional	San Francisco
`creditor_address_state`	string	State or province of the creditor's addressup to 35 · optional	CA
`creditor_address_postal_code`	string	Postal code of the creditor's addressup to 16 · optional	94103
`creditor_address_country`	string	Country code (ISO 3166-1 alpha-2) of the creditor's addressoptional	US
`additional_information`	string	Any additional information or comments related to the cancellation requestup to 500 · optional	Debtor account closed.
Dates and times 2 columns
`effective_cancellation_date`	date	Date when the mandate cancellation becomes effective	2023-06-12
`request_submission_datetime`	datetime	Timestamp when the cancellation request was submitted	2023-06-09T14:33:04
True or false 1 column
`is_final_cancellation`	boolean	Indicates whether this cancellation is final and irrevocableoptional	false

Use it for

A finance dashboard
The is_final_cancellation rate, is_final_cancellation by request_initiator_type and a breakdown of debtor_address_country. Excel, Power BI or Tableau.
Why do 73 of 200 rows have is_final_cancellation = true?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Mandate cancellation requests200
CAN-000001ADEBTOR
CAN-000002BCREDITOR
CAN-000003CCREDITOR
A software demo
Believable mandate cancellation requests with mandate_id, debtor_name and debtor_account_number to fill a screen in front of a buyer.

This dataset200 rows28 columns

Yours1,000 rows28 columnsdebtor_address_street: UK only

blueprint · iso20022-mandate-cancellation-request-pain011

Behind this dataset

Same schema. As many rows as you need.

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

Mandate reference to be cancelled
Cancellation effective date specified
Reason code for cancellation
Initiating party: debtor or creditor
Outstanding collections status check
Final collection processing rules

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-mandate-cancellation-request-pain011

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?