ISO20022 Direct Debit Mandate Notification (pacs.010)

This dataset provides comprehensive records of ISO20022 direct debit mandate notifications exchanged between banks, detailing mandate status changes, activations, amendments, and cancellations. It includes identifiers for mandates and banks, account information for both debtor and creditor, and reasons for changes, making it ideal for audit trails, compliance monitoring, and operational reconciliation in financial institutions.

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

Automated reconciliation of direct debit mandates between banks

Sample rows

preview · 8 of 200 rows · all 19 columns
notification_idstringnotification_typestringmandate_statusstringmessage_datedatetimemandate_idstringstatus_effective_datedateinitiating_bank_idstringreceiving_bank_idstringdebtor_namestringdebtor_account_numberstringdebtor_bank_idstringcreditor_namestringcreditor_account_numberstringcreditor_bank_idstringmandate_referencestringamendment_reasonstringcancellation_reasonstringoriginal_mandate_idstringadditional_informationstring
NTF-GB-20240601-001activationactive2024-06-01T08:34:19ZMDT-GB-202406-0012024-06-01BANK-GB01BANK-GB05Oliver SmithGB29NWBK60161331926819BANK-GB01London Energy LtdGB56BARC20474422222222BANK-GB05LONEGY-2024-OSblankblankblankMandate for utility payments
NTF-DE-20240530-002activationpending2024-05-30T15:27:44ZMDT-DE-202405-0022024-06-01BANK-DE02BANK-DE11Anna MüllerDE89370400440532013000BANK-DE02München StadtwerkeDE55500105175407324931BANK-DE11STWMUC-2024-AMblankblankblankAwaiting customer signature
NTF-FR-20240601-003activationactive2024-06-01T10:16:07ZMDT-FR-202406-0032024-06-01BANK-FR21BANK-FR15Émilie LaurentFR7630006000011234567890189BANK-FR21Paris TelecomFR7630006000019876543210123BANK-FR15PARTEL-2024-ELblankblankblankMandate for telecom payments
NTF-US-20240529-004cancellationcancelled2024-05-29T20:59:22ZMDT-US-202405-0042024-05-30BANK-US33BANK-US12James WilliamsUS001234567890BANK-US33City Water ServicesUS098765432100BANK-US12CITYWS-2023-JWblankAccount closed by customerMDT-US-202404-019Closure due to relocation
NTF-CA-20240528-005activationactive2024-05-28T16:10:32ZMDT-CA-202405-0052024-05-28BANK-CA17BANK-CA22Charlotte DuboisCA5612345678901234567BANK-CA17Hydro QuébecCA0098765432101234567BANK-CA22HYDQC-2024-CDblankblankblankMandate for energy payments
NTF-IN-20240602-006activationactive2024-06-02T11:28:55ZMDT-IN-202406-0062024-06-02BANK-IN10BANK-IN88Priya SinghIN001234567890BANK-IN10Delhi Gas SupplyIN009876543210BANK-IN88DELGAS-2024-PSblankblankblankMandate for monthly gas supply
NTF-AU-20240531-007amendmentamended2024-05-31T09:03:40ZMDT-AU-202405-0072024-06-01BANK-AU07BANK-AU03Liam JohnsonAU123456789012345BANK-AU07Sydney InternetAU987654321012345BANK-AU03SYDINET-2024-LJChange of billing cycle to quarterlyblankMDT-AU-202405-007Requested via online portal
NTF-IT-20240601-008status-changeexpired2024-06-01T17:19:13ZMDT-IT-202406-0082024-06-02BANK-IT09BANK-IT02Giulia FerrariIT60X0542811101000000123456BANK-IT09Roma UtilitiesIT60X0542811101000000654321BANK-IT02ROMUTL-2023-GFblankblankblankMandate expired automatically

What the 200 rows show

from the 200-row sample
notification_type200 rows by value
055110107activati…54%30cancella…15%33amendment17%30status-c…15%
mandate_status200 rows · 5 values
  1. active82
  2. amended33
  3. cancelled30
  4. expired30
  5. pending25
19 columns by typefrom the column list below
  • string 17
  • date 1
  • datetime 1

Columns

19 columns in two groups
blueprint · 19 columns
columntypedescriptionexample
Text 17 columns
notification_idstringUnique identifier for the mandate notification messageuniqueNTF-GB-20240601-001
mandate_idstringUnique identifier for the direct debit mandateMDT-GB-202406-001
mandate_statusstringCurrent status of the mandateactive · cancelled · amended · pending · expiredactive
initiating_bank_idstringIdentifier for the bank initiating the notificationBANK-GB01
receiving_bank_idstringIdentifier for the bank receiving the notificationBANK-GB05
debtor_namestringName of the account holder authorizing the direct debitOliver Smith
debtor_account_numberstringAccount number of the debtorGB29NWBK60161331926819
debtor_bank_idstringIdentifier for the debtor's bankBANK-GB01
creditor_namestringName of the organization or individual receiving the direct debitLondon Energy Ltd
creditor_account_numberstringAccount number of the creditorGB56BARC20474422222222
creditor_bank_idstringIdentifier for the creditor's bankBANK-GB05
mandate_referencestringReference code for the mandate, as provided by the creditorLONEGY-2024-OS
amendment_reasonstringReason for amendment, if the mandate status is 'amended'optionalUpdated contact number
cancellation_reasonstringReason for cancellation, if the mandate status is 'cancelled'optionalMoved to prepaid service
original_mandate_idstringReference to the original mandate if this notification amends or cancels a previous mandateoptionalMDT-US-202404-019
notification_typestringType of notification (activation, cancellation, amendment, status-change)activation · cancellation · amendment · status-changeactivation
additional_informationstringAny supplementary information provided with the notificationoptionalMandate for water supply
Dates and times 2 columns
message_datedatetimeDate and time when the notification was sent2024-06-01T08:34:19Z
status_effective_datedateDate when the status change becomes effective2024-06-01

Use it for

  • rows20019 columnsrows by notification …107acti…30canc…33amen…30stat…

    A finance dashboard

    A breakdown of mandate_status. Excel, Power BI or Tableau.

  • What pattern can you find in 200 rows?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable notifications with message_date, mandate_id and mandate_status to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 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 dataset200 rows19 columns
Yours1,000 rows19 columns

blueprint · iso20022-direct-debit-mandate-notification-pacs010

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 19 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 unique reference
  • Notification type: activation, amendment, cancellation
  • Effective date specified
  • Creditor and debtor banks notified
  • Mandate details synchronized
  • Previous version reference for amendments
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-direct-debit-mandate-notification-pacs010

More in Finance

Browse all
Also in FinanceISO20022 Mandate Initiation Request (pain.009)Bank Customer Segmentation DatasetFinance Expense Categorization DatasetAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.