csv4.2 KB
Bank Transactions (CSV, 60 rows)
A bank-transaction statement — 60 debits and credits across three accounts (masked numbers) with running balances, categories, and merchants. Synthetic data for testing statement parsers, categorisation, and reconciliation.
Preview — first 50 linescsv
txn_id,date,account,description,category,amount,currency,balance
T00051,2025-11-01,****1043,Salary deposit,income,1926.98,USD,10851.98
T00057,2025-11-01,****1043,Book Nook,retail,-39.24,USD,10647.94
T00024,2025-11-02,****1043,Bright Pharmacy,health,-12.81,USD,7920.74
T00056,2025-11-03,****4021,City Transit,transport,-153.79,USD,7661.32
T00041,2025-11-04,****4021,Fuel Stop 24,fuel,-153.54,USD,5940.88
T00007,2025-11-05,****4021,Stream Plus,subscription,-53.6,USD,4738.54
T00037,2025-11-05,****4021,Salary deposit,income,1044.87,USD,6111.73
T00015,2025-11-06,****7788,Salary deposit,income,2392.28,USD,8276.22
T00048,2025-11-07,****7788,Stream Plus,subscription,-93.9,USD,9959.79
T00032,2025-11-08,****7788,Salary deposit,income,550.13,USD,10507.16
T00026,2025-11-10,****1043,Bright Pharmacy,health,-62.55,USD,7858.19
T00023,2025-11-11,****7788,Salary deposit,income,1914.0,USD,10190.22
T00020,2025-11-15,****4021,Corner Grocery,groceries,-122.22,USD,4046.37
T00039,2025-11-18,****4021,Corner Grocery,groceries,-17.31,USD,6094.42
T00053,2025-11-18,****4021,Stream Plus,subscription,-141.09,USD,7815.11
T00055,2025-11-18,****1043,Hardware Depot,home,-164.8,USD,10687.18
T00013,2025-11-19,****4021,Gym Access,fitness,-137.91,USD,4394.03
T00005,2025-11-20,****1043,Corner Grocery,groceries,-111.85,USD,6226.86
T00036,2025-11-20,****1043,Book Nook,retail,-149.97,USD,7560.58
T00017,2025-11-22,****4021,Fuel Stop 24,fuel,-172.82,USD,4221.21
T00003,2025-11-23,****1043,Salary deposit,income,1506.08,USD,6350.75
T00030,2025-11-24,****7788,Cloud Hosting Ltd,software,-139.42,USD,9957.03
T00008,2025-11-26,****4021,Cloud Hosting Ltd,software,-188.46,USD,4550.08
T00019,2025-11-27,****1043,Corner Grocery,groceries,-142.84,USD,5762.93
T00046,2025-11-27,****1043,Bright Pharmacy,health,-125.03,USD,7042.34
T00049,2025-11-27,****1043,Salary deposit,income,1882.66,USD,8925.0
T00059,2025-11-27,****1043,Salary deposit,income,909.55,USD,11497.85
T00035,2025-11-28,****7788,Stream Plus,subscription,-41.25,USD,10301.73
T00050,2025-11-28,****4021,Salary deposit,income,2382.53,USD,8174.55
T00002,2025-11-29,****1043,Hardware Depot,home,-155.33,USD,4844.67
T00012,2025-12-04,****7788,Stream Plus,subscription,-109.7,USD,5883.94
T00009,2025-12-06,****1043,City Transit,transport,-172.76,USD,6054.1
T00021,2025-12-09,****1043,Hardware Depot,home,-99.0,USD,5663.93
T00040,2025-12-09,****7788,Corner Grocery,groceries,-55.85,USD,10245.88
T00004,2025-12-10,****1043,Cloud Hosting Ltd,software,-12.04,USD,6338.71
T00010,2025-12-13,****4021,Bright Pharmacy,health,-18.14,USD,4531.94
T00014,2025-12-14,****1043,Bright Pharmacy,health,-16.01,USD,6038.09
T00038,2025-12-14,****1043,Fuel Stop 24,fuel,-188.58,USD,7372.0
T00018,2025-12-15,****4021,Bright Pharmacy,health,-52.62,USD,4168.59
T00029,2025-12-19,****7788,Stream Plus,subscription,-93.77,USD,10096.45
T00034,2025-12-19,****7788,Bright Pharmacy,health,-164.18,USD,10342.98
T00045,2025-12-19,****7788,Cloud Hosting Ltd,software,-30.71,USD,10215.17
T00044,2025-12-20,****1043,Book Nook,retail,-89.39,USD,7167.37
T00052,2025-12-20,****4021,Cafe Aroma,dining,-218.35,USD,7956.2
T00028,2025-12-22,****1043,Corner Grocery,groceries,-64.05,USD,7794.14
T00031,2025-12-22,****1043,Cafe Aroma,dining,-83.59,USD,7710.55
T00047,2025-12-22,****7788,City Transit,transport,-161.48,USD,10053.69
T00060,2025-12-22,****4021,Fuel Stop 24,fuel,-156.07,USD,7505.25
T00027,2025-12-23,****4021,Salary deposit,income,1307.48,USD,5186.81… 62 lines total — download for the full file.
Specifications
- Rows
- 60
- Schema
- txn_id, date, account, description, category, amount, currency, balance
- Domain
- banking
- Note
- synthetic; account numbers masked
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
Code examples
import pandas as pd
df = pd.read_csv("transactions.csv")
print(df.head())
print(df.dtypes)Related files
- xmlISO 20022 Credit Transfer — pain.001 (XML)A sample ISO 20022 customer credit-transfer initiation (pain.001.001.09) — a single payment with debtor/creditor parties, IBANs, BICs, amount, and remittance info. IBANs are published documentation examples; a fixture for testing payment-message parsers and bank integrations.
- csvE-commerce Customers (CSV, 500 rows)A realistic e-commerce customer directory (500 rows) — part of a relational dataset (products, customers, orders) with CSV, JSON, SQL, and Parquet twins for testing joins, imports, and conversion.
- jsonE-commerce Customers (JSON, 500 records)The e-commerce customers table as a JSON array — the format twin of the CSV, for import and conversion testing.
- sqlE-commerce Database Schema (SQL)A relational SQL schema (products, customers, orders with primary and foreign keys) plus sample INSERTs — the DDL twin of the e-commerce dataset, for testing schema import and migrations.
- csvE-commerce Orders (CSV, 2000 rows)A realistic e-commerce order lines (customer_id → customers, product_id → products) (2000 rows) — part of a relational dataset (products, customers, orders) with CSV, JSON, SQL, and Parquet twins for testing joins, imports, and conversion.
- jsonE-commerce Orders (JSON, 2000 records)The e-commerce orders table as a JSON array — the format twin of the CSV, for import and conversion testing.
Generated by generation/data_domains.py. Free for any use, no attribution required — license.