ISO20022 Account Reporting Request (camt.060)
This dataset provides a detailed record of customer-initiated account reporting requests to banks, including statement, balance, and transaction inquiries with specified date ranges and formats. It enables tracking of request status, customer and account details, and supports compliance, audit, and customer service analytics for financial institutions.
Sample rows
preview · 8 of 300 rows · all 17 columns| request_idstring | request_typestring | currencystring | customer_idstring | customer_namestring | customer_emailstring | account_idstring | bank_idstring | bank_namestring | report_formatstring | date_range_startdate | date_range_enddate | request_datetimedatetime | statusstring | response_datetimedatetime | response_referencestring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| REQ-1A2B3C4D | statement | USD | CUST-10001 | Alice Johnson | alice.johnson@ | ACC-20001 | BANK-001 | Global Trust Bank | 2023-12-01 | 2023-12-31 | 2024-01-02T09:15:32 | completed | 2024-01-02T12:34:21 | RESP-1A2B3C4D | Year-end statement requested for personal records. | |
| REQ-2E4F6G8H | balance | GBP | CUST-10002 | Michael Lee | michael.lee@ | ACC-20002 | BANK-002 | Unity Financial | CSV | 2024-01-01 | 2024-01-01 | 2024-01-01T10:05:09 | completed | 2024-01-01T11:20:10 | RESP-2E4F6G8H | Daily balance check for accounting. |
| REQ-3I5J7K9L | transaction | INR | CUST-10003 | Priya Shah | priya.shah@ | ACC-20003 | BANK-003 | Aurora Bank | XML | 2023-11-20 | 2023-12-20 | 2023-12-21T14:18:44 | pending | blank | blank | Quarterly transaction report for audit. |
| REQ-4M6N8O0P | statement | EUR | CUST-10004 | John O'Brien | john.obrien@ | ACC-20004 | BANK-004 | Summit National | 2024-01-01 | 2024-01-31 | 2024-01-31T15:25:06 | processing | blank | blank | Monthly statement for January. | |
| REQ-5Q7R9S1T | balance | CNY | CUST-10005 | Lin Wang | lin.wang@ | ACC-20005 | BANK-005 | Eastern Horizon Bank | CSV | 2024-02-01 | 2024-02-01 | 2024-02-01T08:11:47 | completed | 2024-02-01T09:40:55 | RESP-5Q7R9S1T | blank |
| REQ-6U8V0W2X | transaction | EUR | CUST-10006 | Karen Müller | karen.mueller@ | ACC-20006 | BANK-006 | Deutsche Bank | 2023-12-15 | 2024-01-15 | 2024-01-16T17:02:29 | completed | 2024-01-16T18:45:12 | RESP-6U8V0W2X | Requested in English. | |
| REQ-7Y9Z1A3B | statement | BRL | CUST-10007 | Carlos Mendes | c.mendes@ | ACC-20007 | BANK-007 | Banco do Brasil | XML | 2024-01-01 | 2024-01-31 | 2024-02-01T10:12:59 | rejected | 2024-02-01T11:00:32 | RESP-7Y9Z1A3B | Incorrect account number format. |
| REQ-8C0D2E4F | balance | AED | CUST-10008 | Fatima El-Sayed | fatima.el-sayed@ | ACC-20008 | BANK-008 | Arabia Central | 2024-02-05 | 2024-02-05 | 2024-02-05T13:14:33 | pending | blank | blank | Urgent: Payroll processing. | |
| REQ-9G1H3I5J | transaction | EUR | CUST-10009 | Sophie Dubois | sophie.dubois@ | ACC-20009 | BANK-009 | Banque Française | CSV | 2024-01-10 | 2024-01-20 | 2024-01-21T09:00:00 | completed | 2024-01-21T10:15:08 | RESP-9G1H3I5J | blank |
| REQ-0K2L4M6N | statement | USD | CUST-10010 | David Kim | d.kim@ | ACC-20010 | BANK-010 | Pacific Savings | CSV | 2023-12-01 | 2023-12-31 | 2024-01-05T08:22:41 | completed | 2024-01-05T09:00:00 | RESP-0K2L4M6N | Annual tax statement. |
| REQ-1O3P5Q7R | balance | MXN | CUST-10011 | Maria Gonzales | maria.gonzales@ | ACC-20011 | BANK-011 | Banco Nacional | 2024-02-10 | 2024-02-10 | 2024-02-10T15:10:10 | processing | blank | blank | Balance as of today. | |
| REQ-2S4T6U8V | transaction | USD | CUST-10012 | William Smith | william.smith@ | ACC-20012 | BANK-001 | Global Trust Bank | XML | 2024-01-01 | 2024-01-15 | 2024-01-16T13:47:29 | completed | 2024-01-16T14:30:00 | RESP-2S4T6U8V | blank |
| REQ-3W5X7Y9Z | balance | RUB | CUST-10013 | Elena Petrova | elena.petrova@ | ACC-20013 | BANK-012 | Siberia Bank | CSV | 2024-02-12 | 2024-02-12 | 2024-02-12T12:22:22 | completed | 2024-02-12T13:00:00 | RESP-3W5X7Y9Z | blank |
| REQ-4A6B8C0D | statement | SEK | CUST-10014 | Sara Svensson | sara.svensson@ | ACC-20014 | BANK-013 | Nordic Finance | XML | 2024-01-01 | 2024-01-31 | 2024-02-01T17:33:21 | pending | blank | blank | Requested for insurance purposes. |
| REQ-5E7F9G1H | transaction | EGP | CUST-10015 | Ahmed Hassan | ahassan@ | ACC-20015 | BANK-014 | Nile Bank | 2023-12-01 | 2023-12-31 | 2024-01-01T09:12:35 | completed | 2024-01-01T10:02:20 | RESP-5E7F9G1H | blank | |
| REQ-6I8J0K2L | balance | EUR | CUST-10016 | Anna Schmidt | anna.schmidt@ | ACC-20016 | BANK-006 | Deutsche Bank | CSV | 2024-02-15 | 2024-02-15 | 2024-02-15T11:44:18 | completed | 2024-02-15T12:00:00 | RESP-6I8J0K2L | blank |
| REQ-7M9N1O3P | statement | JPY | CUST-10017 | Yuki Tanaka | yuki.tanaka@ | ACC-20017 | BANK-015 | Tokyo Central Bank | 2024-01-01 | 2024-01-31 | 2024-02-01T13:05:44 | pending | blank | blank | blank | |
| REQ-8Q0R2S4T | transaction | USD | CUST-10018 | Helen Brown | helen.brown@ | ACC-20018 | BANK-002 | Unity Financial | CSV | 2023-11-01 | 2023-12-01 | 2023-12-02T10:10:10 | completed | 2023-12-02T11:30:00 | RESP-8Q0R2S4T | Request for business expense reconciliation. |
| REQ-9U1V3W5X | balance | EUR | CUST-10019 | Marta Rossi | marta.rossi@ | ACC-20019 | BANK-016 | Italia Credito | 2024-02-18 | 2024-02-18 | 2024-02-18T09:09:09 | processing | blank | blank | blank | |
| REQ-0Y2Z4A6B | statement | USD | CUST-10020 | Samuel Jones | samuel.jones@ | ACC-20020 | BANK-017 | Atlantic Bank | XML | 2023-12-01 | 2023-12-31 | 2023-12-31T16:40:00 | completed | 2023-12-31T17:15:20 | RESP-0Y2Z4A6B | Requested by accountant. |
What the 300 rows show
from the 300-row sample- 3report formats
- 4statuses
- string 13
- date 2
- datetime 2
Columns
17 columns in two groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
request_id | string | Unique identifier for each account reporting requestunique | REQ-1A2B3C4D |
customer_id | string | Unique identifier for the customer making the request | CUST-10001 |
customer_name | string | Full name of the customer making the request | Alice Johnson |
customer_email | string | Email address of the customeroptional | priya.shah@ |
account_id | string | Unique identifier for the bank account being reported on | ACC-20001 |
bank_id | string | Unique identifier for the bank receiving the request | BANK-001 |
bank_name | string | Name of the bank receiving the request | Global Trust Bank |
request_type | string | Type of account report requested (e.g., statement, balance, transaction)statement · balance · transaction | statement |
report_format | string | Preferred format for the report (e.g., PDF, CSV, XML)PDF · CSV · XML | |
currency | string | Currency code for the account (ISO 4217) | USD |
status | string | Current status of the request (e.g., pending, completed, rejected)pending · completed · rejected · processing | completed |
response_reference | string | Reference identifier for the bank's response (if applicable)optional | RESP-1A2B3C4D |
notes | string | Additional comments or instructions provided by the customerup to 1,024 · optional | Requested in English. |
| Dates and times 4 columns | |||
date_range_start | date | Start date for the requested reporting period | 2023-12-01 |
date_range_end | date | End date for the requested reporting period | 2023-12-31 |
request_datetime | datetime | Timestamp when the request was submitted | 2024-01-02T09:15:32 |
response_datetime | datetime | Timestamp when the bank responded to the requestoptional | 2024-01-02T12:34:21 |
Use it for
A finance dashboard
A breakdown of currency. Excel, Power BI or Tableau.
What pattern can you find in 300 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 300 rows.
- Requests300REQ-1A2B3C4DstatementREQ-2E4F6G8HbalanceREQ-3I5J7K9Ltransact…
A software demo
Believable requests with customer_
id, customer_ name and customer_ email to fill a screen in front of a buyer.
This dataset300 rows17 columns
Yours1,000 rows17 columns
blueprint · iso20022-account-reporting-request-camt060
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
- Account identification specified
- Reporting period from-to dates
- Report type: statement, balance, transactions
- Delivery method: electronic, mail
- Format preference if applicable
- Request reference unique
- Response deadline expected
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-account-reporting-request-camt060