ISO20022 Mandate Initiation Request (pain.009)

This dataset contains comprehensive records of direct debit mandate initiation requests as per ISO20022 standards, including creditor and debtor details, mandate terms, authorization status, and electronic signature information. It enables robust tracking, compliance auditing, and automation of mandate management for financial institutions and payment processors.

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

Automated mandate management and compliance auditing for banks and payment processors

Sample rows

preview · 8 of 200 rows · all 28 columns
mandate_idstringfrequencystringmaximum_amountfloatdebtor_address_countrystringcreditor_namestringcreditor_identifierstringcreditor_account_ibanstringcreditor_bicstringdebtor_namestringdebtor_identifierstringdebtor_account_ibanstringdebtor_bicstringdebtor_address_streetstringdebtor_address_citystringdebtor_address_statestringdebtor_address_postal_codestringmandate_typestringmandate_signature_datedatemandate_start_datedatemandate_end_datedatecurrencystringpurposestringelectronic_signature_typestringelectronic_signature_valuestringauthorization_methodstringauthorization_statusstringcreated_atdatetimeupdated_atdatetime
A9ZFY2QJ-14N8-4B7C-8C8B-B2G009DAmonthly78.45DEBerlin WaterworksDE-CRED-0012345678DE89370400440532013000DEUTDEBBXXXKatrin SchneiderCUST-DE-83912DE02500105170137075030COBADEFFXXXFriedrichstr. 101BerlinBerlin10117recurring2024-03-102024-03-152025-03-15EURWater supply billeIDASsigval_DE_8931online_portalauthorized2024-03-09T08:22:482024-03-12T10:09:16
NL-GYM-2024-4B5F3562monthly49.99NLAmsterdam City GymNL-CRED-3388123NL91ABNA0417164300ABNANL2AEva van DijkUSER-NL-09437NL27RABO0123456789RABONL2UPrinsengracht 435Amsterdamblank1016HMrecurring2024-04-022024-04-052025-04-05EURGym membership feeOTPotp-48395723mobile_appauthorized2024-04-01T11:01:132024-04-06T09:55:37
GB-UTIL-2024-07DB1A8Cmonthly120GBLondon Energy Co.GB-CRED-EN-778899GB29NWBK60161331926819NWBKGB2LGeorge HarrisonCUST-GB-01594GB04BARC20201530093459BARCGB22221B Baker StLondonGreater LondonNW16XErecurring2024-02-052024-02-102025-02-10GBPElectricity billOTPotp-GB-5531mobile_appauthorized2024-02-04T16:32:142024-02-10T08:45:29
FI-23-MEDIA-7F6D1D2Emonthly21.9FIHelsinki Media GroupFI-CRED-100243189FI2112345600000785NDEAFIHHJari KorhonenCUST-FI-42218FI3950000120035678HELSFIHHMannerheimintie 24Helsinkiblank00100recurring2024-05-112024-05-15blankEURStreaming subscriptionbiometricbio_9321_FIonline_portalauthorized2024-05-10T09:38:55blank
US-ONOFF-2024-9A1EFD24blank2499.99USNY Hardware Inc.US-CRED-998812US123456789012345678901234blankRachel AdamsUSER-US-44822US098765432109876543210987blank155 Park AveNew YorkNY10022one-off2024-06-162024-06-17blankUSDHardware purchaseOTPotp-US-2391online_portalauthorized2024-06-16T13:09:42blank
DE-LOAN-2024-FFB3-8D12annually9000DEDeutsche KreditbankDE-CRED-LO-8821934DE12500105170648489890DKBODEBBXXXMatthias BauerCUST-DE-67211DE07500105170137075031COBADEFFXXXKarl-Liebknecht-Str. 12LeipzigSachsen04107recurring2024-01-042024-01-102025-01-10EURLoan repaymenteIDASsigval_DE_9000paperauthorized2024-01-03T15:22:402024-01-11T11:14:18
CH-TRANSPORT-2024-5E4D2B1Amonthly110CHSwiss RailwaysCH-CRED-RAIL-11982374CH9300762011623852957UBSWCHZH80ALukas SteinerUSER-CH-77121CH5600700115212543245ZKBKCHZZ80ABahnhofstrasse 7ZurichZH8001recurring2024-02-202024-03-012025-03-01CHFTransport passOTPotp-CH-110mobile_appauthorized2024-02-19T09:04:332024-03-03T12:55:21
ES-UTIL-2024-661A-5C2Bmonthly76.8ESBarcelona ElectricidadES-CRED-EL-889274ES9121000418450200051332CAIXESBBXXXPablo GarciaCUST-ES-22019ES7921000418450200051333BBVAESMMXXXCarrer de Sants 42BarcelonaCatalunya08014recurring2024-04-222024-05-01blankEURElectricity billbiometricbio_ES_7680online_portalauthorized2024-04-20T10:45:37blank

What the 200 rows show

from the 200-row sample

Annually frequency stands out: mean maximum_amount is 1,134,357, against 512.9 for the rest.

  • 89.5median maximum_amount
  • 2mandate types
  • 2authorization statuses
  • 4electronic signature types
  • 4authorization methods
  • 7currencies
Mean maximum_amount by frequency143 rows
01M2M512.9monthly122 rows1.1Mannually21 rows
maximum_amount200 rows, in bands of 100M
01002001920000000080500M1Bmaximum_amount →

Median 89.5, from 0.01 to 1,000,000,000.

debtor_address_country200 rows · top 10 of 13 values
  1. DE31
  2. GB27
  3. US23
  4. FI21
  5. CH18
  6. ES15
  7. NO14
  8. NL12
  9. FR11
  10. KE11
28 columns by typefrom the column list below
  • string 22
  • float 1
  • date 3
  • datetime 2

Columns

28 columns in three groups
blueprint · 28 columns
columntypedescriptionexample
Text 22 columns
mandate_idstringUnique identifier for the direct debit mandate requestuniqueNL-GYM-2024-4B5F3562
creditor_namestringName of the organization or individual initiating the mandateBerlin Waterworks
creditor_identifierstringUnique identifier for the creditor (e.g., business registration number or SEPA Creditor ID)DE-CRED-0012345678
creditor_account_ibanstringIBAN of the creditor's account to receive direct debit paymentsDE89370400440532013000
creditor_bicstringBank Identifier Code (BIC) of the creditor's bankoptionalDEUTDEBBXXX
debtor_namestringName of the individual or organization authorizing the mandateKatrin Schneider
debtor_identifierstringUnique identifier for the debtor (e.g., customer number, national ID)optionalCUST-DE-83912
debtor_account_ibanstringIBAN of the debtor's account to be debitedDE02500105170137075030
debtor_bicstringBank Identifier Code (BIC) of the debtor's bankoptionalCOBADEFFXXX
debtor_address_streetstringStreet address of the debtoroptionalFriedrichstr. 101
debtor_address_citystringCity of the debtor's addressoptionalBerlin
debtor_address_statestringState or province of the debtor's addressoptionalBerlin
debtor_address_postal_codestringPostal code of the debtor's addressoptional10117
debtor_address_countrystringCountry of the debtor's address (ISO 3166-1 alpha-2 code)optionalDE
mandate_typestringType of mandate (e.g., one-off, recurring)one-off · recurringrecurring
currencystringCurrency code for the mandate transactions (ISO 4217)7 currenciesEUR
frequencystringFrequency of recurring debits (e.g., monthly, quarterly, annually)monthly · quarterly · annually · weekly · daily · optionalmonthly
purposestringPurpose of the direct debit mandate (e.g., utility bill, loan repayment)optionalWater supply bill
electronic_signature_typestringType of electronic signature used (e.g., eIDAS, biometric, OTP)eIDAS · biometric · OTP · none · optionaleIDAS
electronic_signature_valuestringValue or hash of the electronic signature for mandate authorizationoptionalsigval_DE_8931
authorization_methodstringMethod used for debtor authorization (e.g., online portal, paper, mobile app)online_portal · paper · mobile_app · otheronline_portal
authorization_statusstringStatus of the mandate authorization (e.g., pending, authorized, rejected)pending · authorized · rejected · cancelledauthorized
Numbers 1 column
maximum_amountfloatMaximum amount allowed per debit transaction under this mandate0 or more · optional78.45
Dates and times 5 columns
mandate_signature_datedateDate when the mandate was signed by the debtor2024-03-10
mandate_start_datedateDate when the mandate becomes effective2024-03-15
mandate_end_datedateDate when the mandate expires (if applicable)optional2025-03-15
created_atdatetimeTimestamp when the mandate request was created2024-03-09T08:22:48
updated_atdatetimeTimestamp when the mandate request was last updatedoptional2024-03-12T10:09:16

Use it for

  • median maximum…89.5200 rowsmean maximum amount b…512.9monthly1.1Mannual…

    A finance dashboard

    Maximum_amount by frequency and a breakdown of debtor_address_country. Excel, Power BI or Tableau.

  • Why do the 21 annually rows have a mean maximum_amount of 1,134,357?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable mandates with creditor_name, creditor_identifier and creditor_account_iban to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 28 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 rows28 columns
Yours1,000 rows28 columnsdebtor_address_street: UK only

blueprint · iso20022-mandate-initiation-request-pain009

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
  • Unique mandate reference per creditor
  • Debtor signature date validation
  • Mandate type: recurrent or one-off
  • Amendment indicator for mandate changes
  • Creditor scheme identification required
  • Maximum amount specified for recurrent mandates
  • Validity period start and end dates
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-initiation-request-pain009

More in Finance

Browse all
Also in FinanceISO20022 Mandate Amendment Request (pain.010)Transaction Categorization DatasetBank Transaction Category ClassificationAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.