ISO20022 Request for Account Management Status (pacs.009)

This dataset provides detailed records of ISO20022 pacs.009 account management status inquiries exchanged between banks, including comprehensive tracking of account opening, modification, and closure instructions. It enables financial institutions to monitor workflow progress, compliance, and customer account lifecycle events, supporting operational transparency and regulatory reporting.

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

Monitoring and auditing account management workflows between banks

Sample rows

preview · 8 of 200 rows · all 19 columns
request_idstringinstruction_typestringstatus_reason_codestringinstruction_idstringbank_sender_idstringbank_receiver_idstringaccount_idstringaccount_typestringstatusstringrequest_datetimedatetimeresponse_datetimedatetimecustomer_namestringcustomer_idstringcustomer_typestringaccount_currencystringaccount_open_datedatelast_modified_datedateclosure_datedatestatus_reason_descriptionstring
REQ-00001openingblankINST-10001BANKUSNYXXXBANKDEFFXXXACC-10101010101checkingpending2024-05-10T09:15:23ZblankJohn A. SmithUS123456789individualUSDblankblankblankblank
REQ-00002openingblankINST-10002BANKDEFFXXXBANKUSNYXXXACC-20202020202savingscompleted2024-05-13T14:42:54Z2024-05-13T15:01:12ZJürgen KrügerDE2020202020individualEUR2024-05-13blankblankblank
REQ-00003openingblankINST-10003BANKJPJTXXXBANKSGSGXXXACC-30303030303corporatepending2024-05-14T10:30:00ZblankNihon Auto Corp.JP8765432101corporateJPYblankblankblankblank
REQ-00004modificationblankINST-10004BANKAU2SXXXBANKGB2LXXXACC-40404040404savingsin-progress2024-05-15T13:18:47ZblankClara EvansGB998877665individualGBP2019-06-222024-05-15blankblank
REQ-00005modificationblankINST-10005BANKINBBXXXBANKCABCXXXACC-50505050505corporatecompleted2024-05-16T08:21:34Z2024-05-16T09:03:10ZXinghua Logistics LLCCN300100200corporateCNY2020-02-102024-05-16blankblank
REQ-00006openingblankINST-10006BANKSGSGXXXBANKINBBXXXACC-60606060606othercompleted2024-05-17T11:45:28Z2024-05-17T12:07:09ZGovTech SingaporeSG000000001governmentSGD2024-05-17blankblankblank
REQ-00007modificationNONCOMPINST-10007BANKCABCXXXBANKJPJTXXXACC-70707070707corporaterejected2024-05-18T07:55:10Z2024-05-18T08:00:00ZShenzhen Tech HoldingsCN400200300corporateCNY2018-09-302024-05-18blankNon-compliance with regulatory standards
REQ-00008modificationblankINST-10008BANKDEFFXXXBANKAU2SXXXACC-80808080808checkingcompleted2024-05-19T16:13:23Z2024-05-19T16:19:45ZMichael BrownAU1029384756individualAUD2017-03-192024-05-19blankblank

What the 200 rows show

from the 200-row sample
  • 3customer types
  • 4account types
  • 5statuses
  • 9account currencies
  • 10bank senders
  • 10bank receivers
instruction_type200 rows by value
0459079opening40%82modification41%39closure20%
status_reason_code28 rows with a value · 172 left blank
  1. REGULATORY9
  2. DOCMISSING6
  3. NONCOMP5
  4. LIMITEXC4
  5. CLIENTREQ4
19 columns by typefrom the column list below
  • string 14
  • date 3
  • datetime 2

Columns

19 columns in two groups
blueprint · 19 columns
columntypedescriptionexample
Text 14 columns
request_idstringUnique identifier for each account management status request messageuniqueREQ-00001
instruction_idstringUnique identifier for the original account management instruction being queriedINST-10001
bank_sender_idstringIdentifier (e.g., BIC) of the bank sending the status inquiry10 sendersBANKUSNYXXX
bank_receiver_idstringIdentifier (e.g., BIC) of the bank receiving the status inquiry10 receiversBANKDEFFXXX
account_idstringUnique identifier of the account involved in the management instructionACC-10101010101
account_typestringType of account (e.g., checking, savings, corporate)checking · savings · corporate · other · optionalchecking
instruction_typestringType of account management instruction (opening, modification, closure)opening · modification · closureopening
statusstringCurrent status of the account management instruction (e.g., pending, completed, rejected, in-progress)pending · completed · rejected · in-progress · cancelledpending
status_reason_codestringCode indicating the reason for the current status (e.g., insufficient documentation, compliance check)5 codes · optionalNONCOMP
status_reason_descriptionstringHuman-readable description of the reason for the current statusoptionalNon-compliance with regul…
customer_namestringName of the customer associated with the accountoptionalJohn A. Smith
customer_idstringUnique identifier for the customer (e.g., national ID, internal bank ID)optionalUS123456789
customer_typestringType of customer (individual, corporate, government, other)individual · corporate · government · other · optionalindividual
account_currencystringCurrency code of the account (e.g., USD, EUR)9 currencies · optionalUSD
Dates and times 5 columns
request_datetimedatetimeTimestamp when the status inquiry was sent2024-05-10T09:15:23Z
response_datetimedatetimeTimestamp when the status response was receivedoptional2024-05-13T15:01:12Z
account_open_datedateDate the account was originally openedoptional2024-05-13
last_modified_datedateDate of last modification to the accountoptional2024-05-15
closure_datedateDate the account was closed, if applicableoptional2024-05-20

Use it for

  • rows20019 columnsrows by instruction t…79opening82modifi…39closure

    A finance dashboard

    A breakdown of status_reason_code. 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 requests with instruction_id, bank_sender_id and bank_receiver_id 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-request-for-account-management-status-pacs009

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
  • Account identification required
  • Original request reference
  • Status: pending, completed, rejected
  • Processing date and time
  • Reason code if rejected
  • Instructed agent confirmation
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-request-for-account-management-status-pacs009

More in Finance

Browse all
Also in FinanceSWIFT MT910 Credit ConfirmationLoan Default Prediction DatasetBank Customer Segmentation DatasetAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.