Banking Transaction Sequence Patterns
This dataset provides detailed, synthetic banking transaction records across customer accounts, including transaction types, amounts, channels, geolocation, and fraud indicators. Designed for advanced sequence modeling, fraud detection, and behavioral segmentation, it enables deep analysis of financial activity patterns and risk assessment. The rich set of attributes supports both supervised and unsupervised machine learning applications in financial analytics.
Sample rows
preview · 8 of 200 rows · all 17 columns| transaction_idstring | channelstring | transaction_amountfloat | is_fraudulentboolean | merchant_categorystring | customer_idstring | account_idstring | transaction_datetimedatetime | transaction_typestring | currencystring | merchant_idstring | transaction_descriptionstring | balance_after_transactionfloat | device_idstring | transaction_location_latitudefloat | transaction_location_longitudefloat | related_transaction_idstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TXN100001 | online | 2450 | false | blank | CUS1001 | ACC20001 | 2024-05-01T09:15:23Z | deposit | USD | blank | Salary deposit for May | 12450 | DEV1001 | 40.7128 | -74.006 | blank |
| TXN100002 | mobile | -120.75 | false | groceries | CUS1002 | ACC20002 | 2024-05-01T10:05:12Z | payment | USD | MER9001 | Payment at FreshMart | 3879.25 | DEV1002 | 34.0522 | -118.2437 | blank |
| TXN100003 | branch | -12 | false | bank_fees | CUS1001 | ACC20001 | 2024-05-01T11:17:41Z | fee | USD | MER9002 | Monthly maintenance fee | 12438 | blank | 40.713 | -74.0059 | blank |
| TXN100004 | branch | 1500 | false | blank | CUS1003 | ACC20003 | 2024-05-01T12:00:00Z | deposit | EUR | blank | Monthly pension deposit | 3500 | blank | 48.8566 | 2.3522 | blank |
| TXN100005 | atm | -300 | false | blank | CUS1004 | ACC20004 | 2024-05-01T13:21:44Z | withdrawal | USD | blank | ATM cash withdrawal | 2200 | DEV1004 | 41.8781 | -87.6298 | blank |
| TXN100006 | mobile | 1800 | false | blank | CUS1002 | ACC20002 | 2024-05-01T14:05:30Z | deposit | USD | blank | Paycheck deposit | 5679.25 | DEV1002 | 34.0524 | -118.244 | blank |
| TXN100007 | online | -60 | false | utilities | CUS1003 | ACC20003 | 2024-05-01T15:30:00Z | payment | EUR | MER9003 | Electricity bill payment | 3440 | DEV1003 | 48.857 | 2.353 | blank |
| TXN100008 | mobile | 350 | false | blank | CUS1005 | ACC20005 | 2024-05-02T08:00:00Z | deposit | USD | blank | Allowance deposit | 850 | DEV1005 | 40.7306 | -73.9352 | blank |
| TXN100009 | online | -500 | false | blank | CUS1006 | ACC20006 | 2024-05-02T09:18:07Z | transfer | USD | blank | Transfer to savings account | 2500 | DEV1006 | 37.7749 | -122.4194 | TXN100010 |
| TXN100010 | online | 500 | false | blank | CUS1006 | ACC20007 | 2024-05-02T09:18:07Z | transfer | USD | blank | Received from checking account | 1500 | DEV1006 | 37.7749 | -122.4195 | TXN100009 |
| TXN100011 | mobile | -40 | false | entertainment | CUS1007 | ACC20008 | 2024-05-02T10:40:22Z | payment | GBP | MER9004 | Concert ticket purchase | 1960 | DEV1007 | 51.5074 | -0.1278 | blank |
| TXN100012 | online | 1200 | false | blank | CUS1008 | ACC20009 | 2024-05-02T11:25:11Z | deposit | EUR | blank | Scholarship deposit | 2200 | DEV1008 | 52.52 | 13.405 | blank |
| TXN100013 | mobile | -12.5 | false | food | CUS1005 | ACC20005 | 2024-05-02T12:10:31Z | payment | USD | MER9005 | Cafeteria lunch | 837.5 | DEV1005 | 40.7307 | -73.9351 | blank |
| TXN100014 | branch | -5 | false | bank_fees | CUS1007 | ACC20008 | 2024-05-02T13:00:00Z | fee | GBP | MER9002 | Account service fee | 1955 | blank | 51.5075 | -0.128 | blank |
| TXN100015 | online | 425 | false | blank | CUS1009 | ACC20010 | 2024-05-02T13:42:19Z | deposit | CAD | blank | Freelance project payment | 825 | DEV1009 | 45.4215 | -75.6998 | blank |
| TXN100016 | atm | -100 | false | blank | CUS1010 | ACC20011 | 2024-05-02T14:15:29Z | withdrawal | CAD | blank | ATM withdrawal | 400 | DEV1010 | 43.6532 | -79.3832 | blank |
| TXN100017 | mobile | 900 | false | blank | CUS1011 | ACC20012 | 2024-05-03T08:00:00Z | deposit | EUR | blank | Job income | 1200 | DEV1011 | 41.9028 | 12.4964 | blank |
| TXN100018 | online | -75 | false | travel | CUS1012 | ACC20013 | 2024-05-03T09:45:23Z | payment | EUR | MER9006 | Train ticket payment | 675 | DEV1012 | 48.1351 | 11.582 | blank |
| TXN100019 | online | 75 | false | travel | CUS1012 | ACC20013 | 2024-05-03T10:00:01Z | refund | EUR | MER9006 | Refund for train ticket | 750 | DEV1012 | 48.1352 | 11.5822 | TXN100018 |
| TXN100020 | branch | -7.5 | false | bank_fees | CUS1013 | ACC20014 | 2024-05-03T11:34:12Z | fee | EUR | MER9002 | Monthly account fee | 392.5 | blank | 46.6034 | 1.8883 | blank |
What the 200 rows show
from the 200-row sample- 7%is_
fraudulent = true - -7.8median transaction_
amount - 6currencies
- 7transaction types
- 1,600median balance_
after_ transaction
Median -7.8, from -1,000,000,000 to 1,000,000,000.
- string 11
- float 4
- datetime 1
- boolean 1
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
transaction_id | string | Unique identifier for each transaction.unique | TXN100001 |
customer_id | string | Unique identifier for the customer account associated with the transaction. | CUS1001 |
account_id | string | Unique identifier for the specific bank account involved in the transaction. | ACC20001 |
transaction_type | string | Type of transaction, such as deposit, withdrawal, transfer, payment, etc.7 values | deposit |
currency | string | ISO 4217 currency code for the transaction (e.g., USD, EUR).6 currencies | USD |
merchant_id | string | Unique identifier for the merchant or counterparty involved in the transaction, if applicable.optional | MER9001 |
merchant_category | string | Category of the merchant or transaction (e.g., groceries, utilities, entertainment).optional | groceries |
transaction_description | string | Free-text description or memo associated with the transaction.optional | Salary deposit for May |
device_id | string | Identifier for the device used to initiate the transaction, if available.optional | DEV1001 |
channel | string | Channel through which the transaction was made (e.g., online, ATM, branch, mobile).6 values · optional | online |
related_transaction_id | string | Identifier of a related transaction (e.g., for transfers or reversals), if applicable.optional | TXN100010 |
| Numbers 4 columns | |||
transaction_amount | float | Monetary amount of the transaction. Positive for credits, negative for debits. | 2450 |
balance_after_transaction | float | Account balance immediately after the transaction is processed.optional | 12450 |
transaction_location_latitude | float | Latitude of the location where the transaction was initiated, if available.-90 to 90 · optional | 40.7128 |
transaction_location_longitude | float | Longitude of the location where the transaction was initiated, if available.-180 to 180 · optional | -74.006 |
| Dates and times 1 column | |||
transaction_datetime | datetime | Date and time when the transaction occurred. | 2024-05-01T09:15:23Z |
| True or false 1 column | |||
is_fraudulent | boolean | Flag indicating if the transaction is known or suspected to be fraudulent.optional | false |
Use it for
A finance dashboard
The is_
fraudulent rate, transaction_ amount by channel and a breakdown of merchant_ category. Excel, Power BI or Tableau. Why do 13 of 200 rows have is_
fraudulent = true? A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Transactions200TXN1000012450onlineTXN100031999999999.99onlineTXN100032-999999999.99online
A software demo
Believable transactions with customer_
id, account_ id and transaction_ datetime to fill a screen in front of a buyer.
blueprint · banking-transaction-sequence-patterns
Behind this dataset
Same schema. As many rows as you need.
These 200 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.
- Each account assigned a unique ID
- Transactions ordered by time
- Include deposits, withdrawals, payments
- Flag possible suspicious patterns
- Account demographics anonymized
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
- banking-transaction-sequence-patterns