Bank Account Details
This dataset provides comprehensive bank account details for testing and validating banking systems, including account types, balances, transaction limits, and detailed account holder information. It is ideal for simulating real-world banking scenarios, performing system integration tests, and validating compliance requirements in financial applications.
Sample rows
preview · 8 of 201 rows · all 20 columns| account_idstring | account_typestring | balancefloat | is_activeboolean | holder_countrystring | account_numberstring | currencystring | daily_transaction_limitfloat | monthly_transaction_limitfloat | opened_datedate | account_holder_idstring | holder_first_namestring | holder_last_namestring | holder_date_of_birthdate | holder_emailstring | holder_phonestring | holder_street_addressstring | holder_citystring | holder_statestring | holder_postal_codestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A1B2C3D4E5F6G7H8 | checking | 8123.45 | true | USA | 10001234567891 | USD | 5000 | 25000 | 2022-03-18 | HLD1001 | Michael | Smith | 1992-07-09 | michael.smith01@ | +16125551234 | 201 Main St | New York | NY | 10011 |
| J3K4L5M6N7O8P9Q0 | savings | 56543.12 | true | USA | 10008765432109 | USD | 10000 | 50000 | 2011-07-24 | HLD1002 | Linda | Johnson | 1974-03-21 | linda.johnson74@ | +19175554321 | 12 Elm Avenue | Buffalo | NY | 14222 |
| Q1W2E3R4T5Y6U7I8 | business | 2234567.89 | true | India | 20004561238974 | INR | 500000 | 2000000 | 2018-02-13 | HLD1003 | Rajesh | Kumar | 1982-11-05 | rajesh.kumar@ | +919876543210 | 44 MG Road | Mumbai | MH | 400001 |
| Z9X8C7V6B5N4M3A2 | student | 45.67 | true | USA | 30002345678912 | USD | 250 | 1000 | 2023-09-12 | HLD1004 | Emily | Williams | 2004-02-17 | emily.williams@ | blank | 89 College Rd | Boston | MA | 02115 |
| F1G2H3J4K5L6M7N8 | joint | 350000 | false | UK | 40005678912340 | GBP | 20000 | 100000 | 2008-11-03 | HLD1005 | Peter | Brown | 1955-01-09 | peter.brown55@ | +447911123456 | 54 Queen St | Liverpool | Merseyside | L18 1BX |
| S2D3F4G5H6J7K8L9 | checking | 15500 | true | France | 50007890123456 | EUR | 6000 | 30000 | 2021-05-06 | HLD1006 | Sophie | Martin | 1995-05-12 | sophie.martin95@ | +33123456789 | 120 Rue Lafayette | Paris | Ile-de-France | 75010 |
| M1N2B3V4C5X6Z7A8 | business | 12500000 | false | USA | 60002345678913 | USD | 1000000 | 5000000 | 2010-06-18 | HLD1007 | David | Miller | 1972-09-30 | david.miller@ | +17184447777 | 88 Wall St | New York | NY | 10005 |
| U3I4O5P6A7S8D9F0 | student | 0 | false | Australia | 70005678912341 | AUD | 0 | 0 | 2023-02-01 | HLD1008 | Olivia | Taylor | 2005-10-24 | olivia.taylor05@ | blank | 23 Campus Lane | Melbourne | VIC | 3000 |
| P0O9I8U7Y6T5R4E3 | joint | 480000 | true | Switzerland | 80002345678914 | CHF | 35000 | 200000 | 2009-07-25 | HLD1009 | Helena | Schmidt | 1962-12-19 | helena.schmidt@ | +41791234567 | 35 Bahnhofstrasse | Zurich | ZH | 8001 |
| L8K7J6H5G4F3D2S1 | savings | 78000 | true | Canada | 90007654321089 | CAD | 12000 | 60000 | 2013-04-15 | HLD1010 | Daniel | Clark | 1980-08-21 | daniel.clark80@ | +15145550011 | 101 King St W | Toronto | ON | M5H 1J9 |
| C3V4B5N6M7L8K9J0 | checking | 9720.5 | true | USA | 10102345678915 | USD | 3500 | 18000 | 2020-08-30 | HLD1001 | Michael | Smith | 1992-07-09 | michael.smith02@ | +16125551234 | 201 Main St | New York | NY | 10011 |
| V7B8N9M0L1K2J3H4 | savings | 99000.75 | true | Italy | 10208765432110 | EUR | 13000 | 70000 | 2016-09-17 | HLD1011 | Ana | Rossi | 1978-06-18 | ana.rossi@ | +390612345678 | 22 Via Roma | Rome | Lazio | 00184 |
| A2S3D4F5G6H7J8K9 | business | 8945000 | true | France | 10304561238975 | EUR | 350000 | 1500000 | 2019-12-02 | HLD1012 | Claire | Durand | 1989-11-30 | claire.durand@ | +33198765432 | 76 Avenue de France | Paris | Ile-de-France | 75013 |
| S9D8F7G6H5J4K3L2 | student | 99.99 | true | UK | 10407890123457 | GBP | 500 | 2500 | 2024-01-14 | HLD1013 | Amelia | Evans | 2003-08-12 | amelia.evans@ | +447911222333 | 10 University Rd | Manchester | Greater Manchester | M13 9PL |
| F2G3H4J5K6L7M8N9 | joint | 820000 | false | Australia | 10505678912342 | AUD | 40000 | 240000 | 2006-05-22 | HLD1014 | Greg | Harris | 1958-04-16 | greg.harris@ | +61412345678 | 7 Beach Rd | Gold Coast | QLD | 4217 |
| M2N3B4V5C6X7Z8A9 | business | 38450000 | true | Switzerland | 10602345678916 | CHF | 800000 | 3200000 | 2015-03-09 | HLD1015 | Lukas | Meier | 1975-09-02 | lukas.meier@ | +41791234988 | 101 Seefeldstrasse | Zurich | ZH | 8008 |
| U4I5O6P7A8S9D0F1 | student | 13.5 | false | Japan | 10705678912343 | JPY | 100 | 500 | 2022-11-11 | HLD1016 | Yuki | Sato | 2006-05-21 | yuki.sato@ | blank | 2-12 Sakura St | Osaka | Osaka | 530-0002 |
| P1O2I3U4Y5T6R7E8 | joint | 420000 | true | Canada | 10802345678917 | CAD | 18000 | 90000 | 2012-02-20 | HLD1017 | Janet | Turner | 1966-02-11 | janet.turner@ | +16045551234 | 33 River St | Montreal | QC | H2X 1Y9 |
| L9K8J7H6G5F4D3S2 | savings | 66000 | true | Japan | 10907654321090 | JPY | 15000 | 75000 | 2014-10-19 | HLD1018 | Takashi | Nakamura | 1979-04-27 | takashi.nakamura@ | +819012345678 | 8-15 Ginza | Tokyo | Tokyo | 104-0061 |
| C4V5B6N7M8L9K0J1 | checking | 11850.9 | true | Australia | 11002345678918 | AUD | 3800 | 16000 | 2021-01-03 | HLD1019 | Lucas | Baker | 1997-03-22 | lucas.baker@ | +61412345999 | 14 St Kilda Rd | Melbourne | VIC | 3004 |
What the 201 rows show
from the 201-row sampleBusiness (account type) stands out: mean balance is 121,517,275, against 205,756 for the rest.
- 76%is_
active = true - 85,000median balance
- 8currencies
- 54holder cities
- 54holder states
- 9,500median daily_
transaction_ limit
Median 85,000, from 0.0 to 900,000,000.
- string 14
- float 3
- date 2
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
account_id | string | Unique identifier for the bank accountunique | A1B2C3D4E5F6G7H8 |
account_number | string | Official bank account numberunique | 10001234567891 |
account_type | string | Type of bank account (e.g., checking, savings, business)checking · savings · business · joint · student | checking |
currency | string | Currency code for the account balance (ISO 4217)8 values | USD |
account_holder_id | string | Unique identifier for the account holder | HLD1001 |
holder_first_name | string | First name of the account holder | Michael |
holder_last_name | string | Last name of the account holder | Smith |
holder_email | string | Email address of the account holder | rajesh.kumar@ |
holder_phone | string | Phone number of the account holderoptional | +16125551234 |
holder_street_address | string | Street address of the account holder | 201 Main St |
holder_city | string | City of the account holder | New York |
holder_state | string | State or province of the account holderoptional | NY |
holder_postal_code | string | Postal code of the account holder | 10011 |
holder_country | string | Country of the account holder10 countries | USA |
| Numbers 3 columns | |||
balance | float | Current balance of the account0 or more | 8123.45 |
daily_transaction_limit | float | Maximum allowed transaction amount per day0 or more | 5000 |
monthly_transaction_limit | float | Maximum allowed transaction amount per month0 or more | 25000 |
| Dates and times 2 columns | |||
opened_date | date | Date when the account was opened | 2022-03-18 |
holder_date_of_birth | date | Date of birth of the account holder | 1992-07-09 |
| True or false 1 column | |||
is_active | boolean | Indicates if the account is currently active | true |
Use it for
A finance dashboard
The is_
active rate, balance by account_ type and a breakdown of holder_ country. Excel, Power BI or Tableau. Why do the 43 business rows have a mean balance of 121,517,275?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Accounts201A1B2C3D4E5F6G7H88123.45checkingJ3K4L5M6N7O8P9Q056543.12savingsF1G2H3J4K5L6M7N8350000joint
A software demo
Believable accounts with account_
number, account_ type and balance to fill a screen in front of a buyer.
blueprint · bank-account-details
Behind this dataset
Same schema. As many rows as you need.
These 201 rows came out of a blueprint — 20 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.
- Account number follows banking format
- Account type: checking, savings, money market
- Balance is non-negative for most accounts
- Daily transaction limit by account type
- Account status: active, frozen, closed
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
- bank-account-details