DataBrighten

    Sample bank transaction data

    1,000 × 7rows × columns in the 1,000-row file

    Updated 3 November 2026. Fictional U.S. businesses and people, generated with a fixed seed.

    CSV XLSX JSON SQL
    textnumberdateyes/no
    Largest file10,000rows; also 100 and 1,000
    Columns7with a data dictionary below
    Dates2024-01-01 – 2025-02-20range in the file
    LicenceCC0synthetic, free for any use

    What is in it

    Each row is one posting on a single fictional checking account, starting 1 January 2024 with a $3,200.00 opening balance: salary twice a month, rent on the 1st, and everyday spending by category. The balance column always equals the opening balance plus every amount so far.

    First rows

    point at a column to light it up

    transaction_idtextdatedatedescriptiontextcategorytexttypetextamountnumberbalancenumber
    TX7000012024-01-01Salary depositIncomeCredit28406040
    TX7000022024-01-01Rent paymentHousingDebit-16504390
    TX7000032024-01-01Online retailerShoppingDebit-71.184318.82
    TX7000042024-01-02Online retailerShoppingDebit-82.754236.07
    TX7000052024-01-02Gas stationTransportDebit-62.134173.94
    TX7000062024-01-03Online retailerShoppingDebit-116.124057.82
    TX7000072024-01-03RestaurantDiningDebit-50.344007.48
    TX7000082024-01-03Online retailerShoppingDebit-126.943880.54
    TX7000092024-01-04Grocery storeGroceriesDebit-88.53792.04
    TX7000102024-01-04Coffee shopDiningDebit-4.73787.34

    Money out by category

    USD, debits, 1,000-row file

    Housing$23,100Groceries$13,818Shopping$10,087Dining$9,106Cash$5,293Transfer$4,747Bills$4,173Transport$4,072Health$1,377Entertainment$510
    Show as a table
    categoryvalue
    Housing$23,100
    Groceries$13,818
    Shopping$10,087
    Dining$9,106
    Cash$5,293
    Transfer$4,747
    Bills$4,173
    Transport$4,072
    Health$1,377
    Entertainment$510
    Source: DataBrighten synthetic data (seed 42), computed from the file you can download here.

    Data dictionary

    ColumnTypeMeaning
    transaction_idtextTransaction number
    datedatePosting date (starts 2024-01-01, about 2.4 per day)
    descriptiontextGeneric merchant type (no real merchants)
    categorytextSpending category
    typetextDebit or Credit
    amountdecimalSigned amount (USD): negative = money out
    balancedecimalRunning balance after this transaction

    Practice questions

    answers checked in SQL and in Python

    Total money out by category (debits only)?

    Housing $23,100.00; Groceries $13,817.98; Shopping $10,087.46; Dining $9,106.02; Cash $5,292.56; Transfer $4,746.65 ...

    SQL

    SELECT category, ROUND(-SUM(amount),2) AS v FROM bank_transactions WHERE type='Debit' GROUP BY category ORDER BY v DESC

    File: bank-transactions-1000

    What is the balance after the last transaction, and does it match the opening balance plus all amounts?

    $7,825.93; opening balance $3,200.00 + sum of amounts = $7,825.93

    SQL

    SELECT (SELECT balance FROM bank_transactions ORDER BY transaction_id DESC LIMIT 1), ROUND(3200 + SUM(amount),2) FROM bank_transactions

    The account opens at $3,200.00 before the first row.

    File: bank-transactions-1000