ISO20022 Bank to Customer Statement (camt.053)
This dataset provides detailed, end-of-day and periodic bank statements in compliance with ISO20022 camt.053 standards, including complete transaction histories, charges, interest calculations, and final balances for each account. It is ideal for accounting, reconciliation, financial analysis, and regulatory reporting, offering granular insights into account activity and transaction-level details.
Sample rows
preview · 8 of 500 rows · all 25 columns| statement_idstring | interest_typestring | opening_balancefloat | charge_typestring | account_idstring | account_ibanstring | account_currencystring | statement_datedate | period_start_datedate | period_end_datedate | closing_balancefloat | total_debitsfloat | total_creditsfloat | transaction_idstring | transaction_datedatetime | transaction_amountfloat | transaction_typestring | transaction_descriptionstring | counterparty_namestring | counterparty_accountstring | counterparty_bankstring | charge_amountfloat | interest_amountfloat | transaction_referencestring | transaction_statusstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| STMT0001 | blank | 2500 | blank | ACCT1001 | DE89370400440532013000 | EUR | 2024-04-30 | 2024-04-01 | 2024-04-30 | 3180.2 | 520.8 | 1201 | TXN10001 | 2024-04-05T09:14:00 | 1200 | credit | Salary April | Acme Corp | DE89370400440532013001 | DEUTDEFF | blank | blank | SAL20240405 | booked |
| STMT0001 | blank | 2500 | blank | ACCT1001 | DE89370400440532013000 | EUR | 2024-04-30 | 2024-04-01 | 2024-04-30 | 3180.2 | 520.8 | 1201 | TXN10002 | 2024-04-07T15:40:12 | -120.5 | debit | Groceries SuperMart | SuperMart | DE29370400123456789012 | COBADEFF | blank | blank | PUR20240407 | booked |
| STMT0001 | blank | 2500 | blank | ACCT1001 | DE89370400440532013000 | EUR | 2024-04-30 | 2024-04-01 | 2024-04-30 | 3180.2 | 520.8 | 1201 | TXN10003 | 2024-04-18T10:08:22 | -75.3 | debit | Electricity Bill April | BerlinElectric | DE77370400440123456789 | BEBEDEFF | blank | blank | UTIL20240418 | booked |
| STMT0001 | blank | 2500 | service_fee | ACCT1001 | DE89370400440532013000 | EUR | 2024-04-30 | 2024-04-01 | 2024-04-30 | 3180.2 | 520.8 | 1201 | TXN10004 | 2024-04-25T17:48:00 | -15 | fee | Monthly account service fee | blank | blank | blank | 15 | blank | FEE20240425 | booked |
| STMT0001 | credit_interest | 2500 | blank | ACCT1001 | DE89370400440532013000 | EUR | 2024-04-30 | 2024-04-01 | 2024-04-30 | 3180.2 | 520.8 | 1201 | TXN10005 | 2024-04-29T20:05:44 | 1.2 | interest | Interest credited April | blank | blank | blank | blank | 1.2 | INT20240429 | booked |
| STMT0002 | blank | 1100.5 | blank | ACCT1002 | FR7630006000011234567890189 | EUR | 2024-03-31 | 2024-03-01 | 2024-03-31 | 1215.8 | 385.2 | 500.5 | TXN10006 | 2024-03-03T11:23:52 | 500 | credit | Refund from TravelCo | TravelCo | FR7630006000011234567890190 | AGRIFRPP | blank | blank | REF20240303 | booked |
| STMT0002 | blank | 1100.5 | blank | ACCT1002 | FR7630006000011234567890189 | EUR | 2024-03-31 | 2024-03-01 | 2024-03-31 | 1215.8 | 385.2 | 500.5 | TXN10007 | 2024-03-09T08:11:44 | -85.2 | debit | Online purchase BookStore | BookStore | FR7630006000011234567890191 | BNPAFRPP | blank | blank | PUR20240309 | booked |
| STMT0002 | blank | 1100.5 | blank | ACCT1002 | FR7630006000011234567890189 | EUR | 2024-03-31 | 2024-03-01 | 2024-03-31 | 1215.8 | 385.2 | 500.5 | TXN10008 | 2024-03-19T13:52:17 | -120 | debit | Restaurant bill | Chez Pierre | FR7630006000011234567890192 | SGRFFRPP | blank | blank | DIN20240319 | booked |
| STMT0002 | blank | 1100.5 | service_fee | ACCT1002 | FR7630006000011234567890189 | EUR | 2024-03-31 | 2024-03-01 | 2024-03-31 | 1215.8 | 385.2 | 500.5 | TXN10009 | 2024-03-30T18:22:10 | -30 | fee | Card renewal fee | blank | blank | blank | 30 | blank | FEE20240330 | booked |
| STMT0002 | credit_interest | 1100.5 | blank | ACCT1002 | FR7630006000011234567890189 | EUR | 2024-03-31 | 2024-03-01 | 2024-03-31 | 1215.8 | 385.2 | 500.5 | TXN10010 | 2024-03-31T23:55:01 | 0.5 | interest | Interest credited March | blank | blank | blank | blank | 0.5 | INT20240331 | booked |
| STMT0003 | blank | 6500000 | blank | ACCT1003 | US12345678901234567890 | USD | 2024-05-31 | 2024-05-01 | 2024-05-31 | 6589900 | 1100 | 10000 | TXN10011 | 2024-05-30T16:45:10 | 10000 | credit | Stock trading gain | NYSE | US98765432109876543210 | CITIUS33 | blank | blank | STK20240530 | booked |
| STMT0003 | blank | 6500000 | transfer_fee | ACCT1003 | US12345678901234567890 | USD | 2024-05-31 | 2024-05-01 | 2024-05-31 | 6589900 | 1100 | 10000 | TXN10012 | 2024-05-31T22:10:00 | -900 | fee | Transfer fee | blank | blank | blank | 900 | blank | FEE20240531 | booked |
| STMT0003 | blank | 6500000 | blank | ACCT1003 | US12345678901234567890 | USD | 2024-05-31 | 2024-05-01 | 2024-05-31 | 6589900 | 1100 | 10000 | TXN10013 | 2024-05-31T23:59:00 | -200 | debit | Wire transfer | Bank of America | US11223344556677889900 | BOFAUS3N | blank | blank | WIR20240531 | booked |
| STMT0004 | blank | 3500 | blank | ACCT1004 | PL61109010140000071219812874 | PLN | 2024-06-30 | 2024-06-01 | 2024-06-30 | 0 | 3500 | 0 | TXN10014 | 2024-06-30T14:30:00 | -3500 | debit | Account closure transfer | New Bank | PL61109010140000071219812875 | BPKOPLPW | blank | blank | CLS20240630 | booked |
| STMT0005 | blank | 120 | blank | ACCT1005 | CH9300762011623852957 | CHF | 2024-04-30 | 2024-04-01 | 2024-04-30 | 65 | 65 | 10 | TXN10015 | 2024-04-04T12:00:00 | -50 | debit | Online purchase E-Shop | E-Shop | CH9300762011623852958 | UBSWCHZH | blank | blank | PUR20240404 | booked |
| STMT0005 | blank | 120 | overdraft | ACCT1005 | CH9300762011623852957 | CHF | 2024-04-30 | 2024-04-01 | 2024-04-30 | 65 | 65 | 10 | TXN10016 | 2024-04-28T17:20:00 | -15 | charge | Overdraft charge | blank | blank | blank | 15 | blank | CHG20240428 | booked |
| STMT0005 | blank | 120 | blank | ACCT1005 | CH9300762011623852957 | CHF | 2024-04-30 | 2024-04-01 | 2024-04-30 | 65 | 65 | 10 | TXN10017 | 2024-04-30T23:59:20 | 10 | credit | Refund Notary | Notary Bern | CH9300762011623852959 | ZKBKCHZZ | blank | blank | REF20240430 | booked |
| STMT0006 | blank | 600 | blank | ACCT1006 | RU02044510448400012345 | RUB | 2024-05-31 | 2024-05-01 | 2024-05-31 | 610.4 | 50 | 60.4 | TXN10018 | 2024-05-05T11:05:02 | 40 | credit | Gift from Anna | Anna Petrov | RU02044510448400012346 | SBERRU22 | blank | blank | GFT20240505 | booked |
| STMT0006 | credit_interest | 600 | blank | ACCT1006 | RU02044510448400012345 | RUB | 2024-05-31 | 2024-05-01 | 2024-05-31 | 610.4 | 50 | 60.4 | TXN10019 | 2024-05-30T20:25:00 | 10.4 | interest | Interest credited May | blank | blank | blank | blank | 10.4 | INT20240530 | booked |
| STMT0006 | blank | 600 | blank | ACCT1006 | RU02044510448400012345 | RUB | 2024-05-31 | 2024-05-01 | 2024-05-31 | 610.4 | 50 | 60.4 | TXN10020 | 2024-05-16T14:18:00 | -50 | debit | Purchase MiniMarket | MiniMarket | RU02044510448400012347 | VTBMRUMM | blank | blank | PUR20240516 | booked |
What the 500 rows show
from the 500-row sample- 1,876median opening_
balance - 6transaction types
- 9account currencies
- 1,530median closing_
balance - 142.5median total_
debits - 50.4median total_
credits
Median 1,876, from -230.0 to 27,500,000.
- string 14
- float 7
- date 3
- datetime 1
Columns
25 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
statement_id | string | Unique identifier for the bank statement.unique | STMT0001 |
account_id | string | Unique identifier for the bank account associated with the statement. | ACCT1001 |
account_iban | string | International Bank Account Number (IBAN) for the account. | DE89370400440532013000 |
account_currency | string | Currency code (ISO 4217) for the account.9 currencies | EUR |
transaction_id | string | Unique identifier for the transaction within the statement.unique | TXN10001 |
transaction_type | string | Type of transaction (e.g., credit, debit, interest, charge, fee).6 values | credit |
transaction_description | string | Description or reference for the transaction.optional | Salary April |
counterparty_name | string | Name of the counterparty involved in the transaction.optional | Acme Corp |
counterparty_account | string | Account number or IBAN of the counterparty.optional | DE89370400440532013001 |
counterparty_bank | string | Bank name or BIC of the counterparty.optional | DEUTDEFF |
charge_type | string | Type of charge applied (e.g., service fee, overdraft, transfer fee).service_fee · overdraft · transfer_fee · other · optional | service_fee |
interest_type | string | Type of interest (e.g., credit_interest, debit_interest).credit_interest · debit_interest · other · optional | credit_interest |
transaction_reference | string | Reference number or code for the transaction.optional | SAL20240405 |
transaction_status | string | Status of the transaction (e.g., booked, pending, rejected).booked · pending · rejected · optional | booked |
| Numbers 7 columns | |||
opening_balance | float | Opening balance at the start of the statement period. | 2500 |
closing_balance | float | Closing balance at the end of the statement period. | 3180.2 |
total_debits | float | Total debit amount for the statement period.optional | 520.8 |
total_credits | float | Total credit amount for the statement period.optional | 1201 |
transaction_amount | float | Amount of the transaction. | 1200 |
charge_amount | float | Amount charged for transaction fees, if applicable.optional | 15 |
interest_amount | float | Interest amount credited or debited in the transaction.optional | 1.2 |
| Dates and times 4 columns | |||
statement_date | date | Date the statement was issued. | 2024-04-30 |
period_start_date | date | Start date of the statement period. | 2024-04-01 |
period_end_date | date | End date of the statement period. | 2024-04-30 |
transaction_date | datetime | Date and time the transaction occurred. | 2024-04-05T09:14:00 |
Use it for
A finance dashboard
Opening_
balance by interest_ type and a breakdown of charge_ type. Excel, Power BI or Tableau. What pattern can you find in 500 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 500 rows.
- Statements500STMT00012500—STMT00012500—STMT00012500—
A software demo
Believable statements with account_
id, account_ iban and account_ currency to fill a screen in front of a buyer.
This dataset500 rows25 columns
Yours1,000 rows25 columns
blueprint · iso20022-bank-to-customer-statement-camt053
Behind this dataset
Same schema. As many rows as you need.
These 500 rows came out of a blueprint — 25 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
- Statement period from-to dates
- Legal sequence number maintained
- Opening balance from previous statement
- Closing balance calculated
- All transactions within statement period
- Interest and charges itemized
- Currency statement if multi-currency
- Page number if multi-page
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-bank-to-customer-statement-camt053