Bank Transaction Categorization Sample
This dataset contains labeled bank transaction records, including detailed transaction metadata, merchant information, and manually or automatically assigned expense categories. It is ideal for developing, training, and benchmarking automated expense categorization models for personal finance, budgeting, and regulatory compliance applications.
Sample rows
preview · 8 of 200 rows · all 17 columns| transaction_idstring | currencystring | amountfloat | is_recurringboolean | merchant_category_codestring | account_idstring | transaction_datedate | posting_datedate | descriptionstring | merchant_namestring | transaction_typestring | categorystring | subcategorystring | location_citystring | location_statestring | location_countrystring | label_sourcestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TXN0000001 | USD | -95.32 | false | 5411 | ACCT001 | 2023-02-01 | 2023-02-02 | Whole Foods Market #2094 | Whole Foods Market | debit | groceries | supermarket | Austin | TX | US | automated |
| TXN0000002 | USD | 2500 | true | blank | ACCT001 | 2023-02-28 | 2023-03-01 | Salary Payment ACME Corp | ACME Corp | deposit | income | salary | Austin | TX | US | automated |
| TXN0000003 | USD | -56.8 | true | 4899 | ACCT002 | 2023-02-05 | 2023-02-07 | Netflix Subscription Feb | Netflix | debit | entertainment | streaming_service | Seattle | WA | US | automated |
| TXN0000004 | USD | -1350 | true | 6513 | ACCT003 | 2023-02-26 | 2023-02-28 | GreenLeaf Apartments Rent | GreenLeaf Apartments | payment | housing | rent | San Francisco | CA | US | manual |
| TXN0000005 | USD | -45 | false | 5814 | ACCT004 | 2023-02-11 | 2023-02-13 | Starbucks Coffee | Starbucks | debit | dining | coffee_shop | Los Angeles | CA | US | automated |
| TXN0000006 | EUR | -120.79 | false | 5942 | ACCT005 | 2023-02-03 | 2023-02-03 | Amazon DE Order #584139 | Amazon DE | debit | shopping | online_retail | Berlin | BE | DE | automated |
| TXN0000007 | GBP | -88.99 | false | 5411 | ACCT006 | 2023-02-08 | 2023-02-09 | Tesco Superstore Groceries | Tesco | debit | groceries | supermarket | London | blank | GB | automated |
| TXN0000008 | USD | -135 | true | 4814 | ACCT002 | 2023-02-19 | 2023-02-20 | Comcast Utilities Bill | Comcast | payment | utilities | internet | Seattle | WA | US | automated |
| TXN0000009 | CAD | -72.49 | false | 5651 | ACCT007 | 2023-02-17 | 2023-02-17 | Hudson's Bay Apparel | Hudson's Bay | debit | shopping | clothing | Toronto | ON | CA | automated |
| TXN0000010 | USD | -9.99 | true | 5735 | ACCT008 | 2023-02-12 | blank | Apple Music Subscription | Apple Music | debit | entertainment | music_streaming | New York | NY | US | automated |
| TXN0000011 | EUR | -435.5 | true | 6513 | ACCT009 | 2023-02-10 | 2023-02-12 | GreenLeaf Apartments Rent | GreenLeaf Apartments | payment | housing | rent | Munich | BY | DE | manual |
| TXN0000012 | USD | -13.7 | false | 4121 | ACCT010 | 2023-02-04 | 2023-02-05 | Uber Ride Downtown | Uber | debit | transportation | ride_sharing | Chicago | IL | US | automated |
| TXN0000013 | AUD | -99.99 | true | 4812 | ACCT011 | 2023-02-18 | 2023-02-20 | Optus Mobile Bill | Optus | payment | utilities | mobile | Sydney | NSW | AU | automated |
| TXN0000014 | USD | -320 | true | 6300 | ACCT012 | 2023-02-15 | 2023-02-16 | StateFarm Auto Insurance | StateFarm | payment | insurance | auto | Dallas | TX | US | automated |
| TXN0000015 | USD | -15.99 | true | 5735 | ACCT013 | 2023-02-01 | 2023-02-03 | Spotify Family Plan | Spotify | debit | entertainment | music_streaming | Boston | MA | US | automated |
| TXN0000016 | USD | -7.5 | false | blank | ACCT014 | 2023-02-09 | 2023-02-10 | PayPal Test Transaction | blank | other | uncategorized | blank | blank | blank | blank | manual |
| TXN0000017 | USD | -2.5 | false | 6011 | ACCT015 | 2023-02-20 | 2023-02-20 | Chase ATM Withdrawal Fee | Chase Bank | fee | bank_fees | atm_fee | Miami | FL | US | automated |
| TXN0000018 | USD | 44.99 | false | 5942 | ACCT001 | 2023-02-21 | 2023-02-22 | Amazon US Refund | Amazon US | refund | shopping | refund | Austin | TX | US | manual |
| TXN0000019 | INR | -0.01 | false | blank | ACCT016 | 2023-02-27 | blank | Micro UPI Debit Test | blank | transfer | transfers | upi | blank | blank | IN | manual |
| TXN0000020 | USD | -18.25 | false | 5942 | ACCT004 | 2023-02-23 | 2023-02-24 | Barnes & Noble Book | Barnes & Noble | debit | shopping | books | Los Angeles | CA | US | automated |
What the 200 rows show
from the 200-row sampleEUR currency stands out: 12 of its 17 rows have is_
- 36%is_
recurring = true - -33.5median amount
- 2label sources
- 7location countries
- 9transaction types
- 13categories
Median -33.5, from -3,500 to 1,000,000.
- string 13
- float 1
- date 2
- boolean 1
Columns
17 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
transaction_id | string | Unique identifier for each bank transaction record.unique | TXN0000001 |
account_id | string | Unique identifier for the bank account associated with the transaction. | ACCT001 |
currency | string | Three-letter ISO currency code (e.g., USD, EUR).7 currencies | USD |
description | string | Free-text description or memo provided by the bank for the transaction. | Whole Foods Market #2094 |
merchant_name | string | Name of the merchant or payee associated with the transaction, if available.optional | Whole Foods Market |
merchant_category_code | string | Industry-standard merchant category code (MCC), if available.optional | 5411 |
transaction_type | string | Type of transaction (e.g., debit, credit, transfer, fee, refund).9 values | debit |
category | string | Labeled expense category for the transaction (e.g., groceries, utilities, rent). | groceries |
subcategory | string | More granular subcategory within the main category (e.g., supermarket under groceries).optional | supermarket |
location_city | string | City where the transaction took place, if available.optional | Austin |
location_state | string | State or region where the transaction took place, if available.optional | TX |
location_country | string | Country where the transaction took place, if available.7 countries · optional | US |
label_source | string | Indicates if the category label was assigned manually or by an automated system.manual · automated · optional | automated |
| Numbers 1 column | |||
amount | float | Transaction amount. Positive for credits, negative for debits. | -95.32 |
| Dates and times 2 columns | |||
transaction_date | date | Date when the transaction occurred. | 2023-02-01 |
posting_date | date | Date when the transaction was posted to the account.optional | 2023-02-02 |
| True or false 1 column | |||
is_recurring | boolean | Indicates if the transaction is part of a recurring series (e.g., monthly subscription).optional | false |
15 SQL practice questions for the Bank Transaction Categorization Sample
Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.
Large USD transactions
Return transaction_id, account_id, transaction_date and amount for every transaction whose currency is 'USD' and whose amount is greater than 5000. Order the results by amount from highest to lowest, then by transaction_id in ascending order.
Tables: bank_transaction_categorization_sample · your result: 4 columns, 3 rowsDistinct categories
Return each distinct category found in the data as a single column named category, sorted alphabetically.
Tables: bank_transaction_categorization_sample · your result: 1 columns, 13 rowsTransactions per currency
For each currency, return currency and the number of transactions as txn_count. Order by txn_count from highest to lowest, then by currency in ascending order.
Tables: bank_transaction_categorization_sample · your result: 2 columns, 7 rows
- 04Average amount by label sourceBeginner
- 05Recurring transactions by categoryPower BI
- 06Categories with many transactionsIntermediate
- 07Amount size bucketsIntermediate
- 08Monthly transaction countsIntermediate
- 09Accounts with above-average USD spendIntermediate
- 10Missing merchant sharePower BI
- 11Rank categories by USD spendAdvanced
- 12Days since previous transactionAdvanced
- 13Running total for an accountAdvanced
- 14Category share of USD spendingAdvanced
- 15Outflows far above category averagePower BI
Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.
Get the practice kit · $3.99Use it for
A finance dashboard
The is_
recurring rate, amount by currency and a breakdown of merchant_ category_ code. Excel, Power BI or Tableau. Why do 71 of 200 rows have is_
recurring = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Transactions200TXN0000001-95.32USDTXN00000022500USDTXN0000003-56.8USD
A software demo
Believable transactions with account_
id, transaction_ date and posting_ date to fill a screen in front of a buyer.
blueprint · bank-transaction-categorization-sample
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.
- Assign category to each transaction
- Include amount, timestamp, merchant
- Simulate realistic merchant diversity
- Flag ambiguous transactions
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-transaction-categorization-sample