ISO20022 Bank to Customer Account Report (camt.052)

This dataset provides comprehensive intraday and interim bank account statements, detailing account balances, transaction activity, and reconciliation data for financial institutions and corporate treasuries. It enables granular tracking of cash positions, transaction flows, and counterparty details, supporting real-time cash management and financial auditing.

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

Automated bank account reconciliation for corporate finance teams

Sample rows

preview · 8 of 500 rows · all 24 columns
report_idstringtransaction_typestringtransaction_amountfloattransaction_currencystringreport_datedatereport_timedatetimeaccount_idstringaccount_ibanstringaccount_currencystringaccount_holder_namestringopening_balancefloatclosing_balancefloatbalance_typestringtransaction_idstringtransaction_datedatetransaction_timedatetimetransaction_descriptionstringcounterparty_namestringcounterparty_accountstringcounterparty_bank_namestringcounterparty_bank_bicstringreference_numberstringstatusstringadditional_informationstring
RPT000000001credit250.5EUR2024-04-012024-04-01T09:15:32ZACC000000001DE89370400440532013000EURAnna Schmidt15000.2315250.73closingTXN0000012024-04-012024-04-01T10:00:12ZSalary AprilTech Solutions GmbHDE72500105170612345678CommerzbankCOBADEFFXXXREF20240401A1bookedMonthly salary payment
RPT000000002debit-44.75EUR2024-04-022024-04-02T15:44:12ZACC000000002FR7630006000011234567890189EURJean Dupont87508705.25closingTXN0000022024-04-022024-04-02T13:28:23ZGrocery Store ParisCarrefourFR7630006000019876543210987BNP ParibasBNPAFRPPXXXREF20240402B2bookedWeekly grocery shopping
RPT000000003credit25GBP2024-03-302024-03-30T08:00:00ZACC000000003GB29NWBK60161331926819GBPSarah Johnson2100.772125.77closingTXN0000032024-03-302024-03-30T11:10:45ZRefund AmazonAmazon UKGB29NWBK60161398765432NatWestNWBKGB2LREF20240330C3bookedProduct return refund
RPT000000004debit-25EUR2024-03-282024-03-28T16:05:03ZACC000000004IT60X0542811101000000123456EURGiovanni Rossi499.9474.9closingTXN0000042024-03-282024-03-28T14:20:01ZATM WithdrawalIntesa Sanpaolo ATMIT60X0542811101234567890123Intesa SanpaoloBCITITMMREF20240328D4bookedCash withdrawal
RPT000000005debit-40EUR2024-04-032024-04-03T10:25:18ZACC000000005ES9121000418450200051332EURMaria Garcia1425014210closingTXN0000052024-04-032024-04-03T09:45:00ZRestaurant paymentRestaurante MadridES9121000418450200051333Banco SantanderBSCHESMMREF20240403E5bookedDinner with friends
RPT000000006credit50EUR2024-04-042024-04-04T11:12:09ZACC000000006NL91ABNA0417164300EURPeter de Vries3090.53140.5closingTXN0000062024-04-042024-04-04T10:59:47ZTransfer from savingsPeter de VriesNL91ABNA0417164301ABN AMROABNANL2AREF20240404F6bookedInternal transfer
RPT000000007debit-25EUR2024-04-052024-04-05T14:41:00ZACC000000007BE68539007547034EURLuc Vermeulen780.1755.1interimTXN0000072024-04-052024-04-05T13:02:19ZTrain ticketSNCBBE68539007547035KBC BankKREDBEBBREF20240405G7bookedTravel expense
RPT000000008credit25CHF2024-04-062024-04-06T17:18:33ZACC000000008CH9300762011623852957CHFSimon Keller65206545closingTXN0000082024-04-062024-04-06T16:25:00ZGift from familyNicole KellerCH9300762011623852958UBSUBSWCHZH80AREF20240406H8bookedBirthday gift

What the 500 rows show

from the 500-row sample

Credit (transaction type) stands out: mean transaction_amount is 76.3, against -53.1 for the rest.

  • -8.0median transaction_amount
  • 3balance types
  • 3statuses
  • 34account currencies
  • 7,000median opening_balance
  • 7,045median closing_balance
transaction_amount408 rows, in bands of 100
01002001014196142371413-400100500transaction_amount →

Median -8.0, from -353.4 to 500.0.

transaction_currency408 rows with a value · 92 left blank
  1. EUR239
  2. USD28
  3. CHF24
  4. GBP21
  5. DKK12
  6. SEK12
  7. PLN11
  8. NOK9
  9. RON7
  10. CZK6
24 columns by typefrom the column list below
  • string 17
  • float 3
  • date 2
  • datetime 2

Columns

24 columns in three groups
blueprint · 24 columns
columntypedescriptionexample
Text 17 columns
report_idstringUnique identifier for the account report documentuniqueRPT000000001
account_idstringUnique identifier for the bank accountACC000000001
account_ibanstringInternational Bank Account Number (IBAN) for the accountoptionalDE89370400440532013000
account_currencystringISO currency code for the account (e.g., EUR, USD)EUR
account_holder_namestringName of the account holderoptionalAnna Schmidt
balance_typestringType of balance (e.g., interim, closing, opening)opening · interim · closingclosing
transaction_idstringUnique identifier for the transactionoptionalTXN000001
transaction_currencystringCurrency of the transaction (ISO code)optionalEUR
transaction_typestringType of transaction (e.g., credit, debit)credit · debit · optionalcredit
transaction_descriptionstringNarrative or description of the transactionoptionalSalary April
counterparty_namestringName of the transaction counterpartyoptionalTech Solutions GmbH
counterparty_accountstringAccount number or IBAN of the counterpartyoptionalDE72500105170612345678
counterparty_bank_namestringName of the counterparty's bankoptionalCommerzbank
counterparty_bank_bicstringBank Identifier Code (BIC) of the counterparty's bankoptionalCOBADEFFXXX
reference_numberstringReference number for reconciliation purposesoptionalREF20240401A1
statusstringStatus of the transaction (e.g., booked, pending)booked · pending · reversed · optionalbooked
additional_informationstringAny additional information or notes related to the report or transactionoptionalMonthly salary payment
Numbers 3 columns
opening_balancefloatOpening balance of the account for the report period15000.23
closing_balancefloatClosing balance of the account for the report period15250.73
transaction_amountfloatAmount of the transactionoptional250.5
Dates and times 4 columns
report_datedateDate the account report was generated2024-04-01
report_timedatetimeTimestamp when the report was createdoptional2024-04-01T09:15:32Z
transaction_datedateDate the transaction occurredoptional2024-04-01
transaction_timedatetimeTimestamp of the transactionoptional2024-04-01T10:00:12Z

Use it for

  • median transac…-8.0408 rows

    A finance dashboard

    Transaction_amount by transaction_type and a breakdown of transaction_currency. Excel, Power BI or Tableau.

  • Why do the 197 credit rows have a mean transaction_amount of 76.3?

    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_date, report_time and account_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 24 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 dataset500 rows24 columns
Yours1,000 rows24 columns

blueprint · iso20022-bank-to-customer-account-report-camt052

Behind this dataset

Same schema. As many rows as you need.

These 500 rows came out of a blueprint — 24 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 IBAN format
  • Statement sequence number incremental
  • Opening balance matches previous closing
  • Transaction entries with value dates
  • Booking date and value date specified
  • Entry reference unique per transaction
  • Debit/credit indicators correct
  • Running balance calculated correctly
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-bank-to-customer-account-report-camt052

More in Finance

Browse all
Also in FinanceSWIFT MT950 Account Balance StatementBank Customer Segmentation DatasetDigital Wallet Transaction DatasetAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.