ISO20022 Payment Status Report (pain.002)

This dataset provides detailed ISO20022 payment status reports (pain.002), including transaction identifiers, status updates, reason codes for failed or pending payments, and party/account information. It enables comprehensive tracking, reconciliation, and analysis of payment instructions across financial institutions, supporting regulatory compliance and operational efficiency.

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

Automated reconciliation of payment instructions and status updates

Sample rows

preview · 8 of 300 rows · all 17 columns
report_idstringpayment_statusstringamountfloatstatus_reason_codestringreport_datetimedatetimeoriginal_instruction_idstringtransaction_idstringstatus_reason_descriptionstringcurrencystringdebtor_namestringdebtor_accountstringcreditor_namestringcreditor_accountstringsettlement_datedateinstructed_datedateprocessing_bankstringadditional_informationstring
RPT-USA001accepted582.41blank2024-02-12T11:12:29INST-000154ATXN-10012blankUSDMary Ellen ShawUS98BOFA1234567890123456Riverside Grocery LLCUS13CHASE78912345601234562024-02-132024-02-12Bank of AmericaPayment for weekly supplies
RPT-GBR002completed125000blank2024-03-21T09:30:45INST-000214BTXN-10013blankGBPLondon Tech GroupGB29BARC20412398765432Alpha Electronics PLCGB37HSBC409865432112342024-03-222024-03-21BarclaysLarge corporate transfer
RPT-DEU003rejected432.15INSF2024-01-15T14:12:37INST-000314CTXN-10014Insufficient funds in debtor accountEURKlara HoffmannDE89370400440532013000Buchhandlung KleeDE09500105179732176455blank2024-01-15Deutsche BankPlease review account balance and retry
RPT-USA004accepted89.99blank2024-04-08T16:27:15INST-000154ATXN-10015blankUSDMary Ellen ShawUS98BOFA1234567890123456Riverside Grocery LLCUS13CHASE78912345601234562024-04-092024-04-08Bank of AmericaPayment for weekly supplies
RPT-FRA005pending1500blank2024-05-10T10:22:18INST-000415DTXN-10016blankEURLaurent MoreauFR7630006000011234567890189Le Marché ParisienFR1420041010050500013M02606blank2024-05-10BNP ParibasAwaiting confirmation from debtor bank
RPT-ITA006partially accepted750PARTPAY2024-06-02T13:08:09INST-000614ETXN-10017Partial payment due to limitEURGiovanni RomanoIT60X0542811101000000123456Studio Legale RossiIT34C02008050200004006912342024-06-032024-06-02Intesa SanpaoloBalance due next period
RPT-USA007cancelled3250CUSTREQ2024-07-19T12:17:36INST-000715FTXN-10018Cancelled at customer requestUSDJeffrey PattersonUS23WELLS9876543210987654Pacific Movers IncUS45CITI6543210987654321blank2024-07-19Wells FargoContact support for further assistance
RPT-ESP008accepted65.75blank2024-05-12T09:45:21INST-000815GTXN-10019blankEURMaria SanchezES9121000418450200051332Café de la PlazaES76207700240031025757662024-05-132024-05-12Banco SantanderMonthly membership fee

What the 300 rows show

from the 300-row sample

Completed (payment status) stands out: mean amount is 781,267, against 1,226 for the rest.

  • 882.5median amount
  • 20currencies
  • 68processing banks
Mean amount by payment_status300 rows
0400k800k1,581accep…118 ro…934.9rejec…45 rows362.5pendi…40 rows1,282parti…33 rows781.3kcompl…42 rows1,407cance…22 rows
amount300 rows, in bands of 200k
013527026495335513201M2Mamount →

Median 882.5, from 0.01 to 2,000,000.

status_reason_code100 rows with a value · 200 left blank
  1. PARTPAY21
  2. INSF19
  3. CUSTREQ19
  4. LIMITEXCEED16
  5. ACCTCLOSED14
  6. INVALIDACCT3
  7. LIMITEXC2
  8. INVNUM2
  9. USERCANCEL2
  10. SUSPACT1
17 columns by typefrom the column list below
  • string 13
  • float 1
  • date 2
  • datetime 1

Columns

17 columns in three groups
blueprint · 17 columns
columntypedescriptionexample
Text 13 columns
report_idstringUnique identifier for the payment status report messageuniqueRPT-USA001
original_instruction_idstringUnique identifier for the original payment instruction being referencedINST-000154A
transaction_idstringUnique identifier for the payment transaction within the instructionTXN-10012
payment_statusstringStatus of the payment instruction (e.g., accepted, rejected, pending, partially accepted)6 valuesaccepted
status_reason_codestringStandardized code indicating the reason for the current payment status11 codes · optionalINSF
status_reason_descriptionstringHuman-readable description of the reason for the payment statusoptionalCreditor account closed
currencystringISO 4217 currency code for the payment amountUSD
debtor_namestringName of the party sending the paymentoptionalMary Ellen Shaw
debtor_accountstringAccount identifier (e.g., IBAN) of the debtoroptionalUS98BOFA1234567890123456
creditor_namestringName of the party receiving the paymentoptionalRiverside Grocery LLC
creditor_accountstringAccount identifier (e.g., IBAN) of the creditoroptionalGB37HSBC40986543211234
processing_bankstringIdentifier or name of the bank processing the payment status reportoptionalBank of America
additional_informationstringAny supplementary information or comments related to the payment statusoptionalLarge corporate transfer
Numbers 1 column
amountfloatMonetary amount of the payment transaction0 or more582.41
Dates and times 3 columns
report_datetimedatetimeTimestamp when the payment status report was generated2024-02-12T11:12:29
settlement_datedateDate when the payment is settled or expected to settleoptional2024-02-13
instructed_datedateDate when the payment instruction was originally sentoptional2024-02-12

Use it for

  • median amount882.5300 rowsmean amount by paymen…1.6kacce…934.9reje…362.5pend…1.3kpart…

    A finance dashboard

    Amount by payment_status and a breakdown of status_reason_code. Excel, Power BI or Tableau.

  • Why do the 42 completed rows have a mean amount of 781,267?

    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 reports with report_datetime, original_instruction_id and transaction_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 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 dataset300 rows17 columns
Yours1,000 rows17 columns

blueprint · iso20022-payment-status-report-pain002

Behind this dataset

Same schema. As many rows as you need.

These 300 rows came out of a blueprint — 17 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 message ID reference required
  • Status codes: accepted, rejected, pending, partially accepted
  • Reason codes for rejection per ISO20022 standard
  • Status timestamp after original message timestamp
  • Transaction count matches original instruction
  • Accepted amount sum validates
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-status-report-pain002

More in Finance

Browse all
Also in FinanceISO20022 Financial Institution to Financial Institution Payment Status (pacs.002)Finance Expense Categorization DatasetBank Customer Segmentation DatasetAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.