Bank Statement (Credit/Debit)
A personal bank statement with separate credit and debit columns, running balances, and categories.
41 rows 6 columns
Schema
| Column | Type | Description |
|---|---|---|
| date | date | Transaction date in YYYY-MM-DD format |
| description | string | Merchant or transaction description |
| credit | number | Credit amount (deposits, income, refunds) |
| debit | number | Debit amount (withdrawals, purchases, payments) |
| balance | number | Running account balance after the transaction |
| category | string | Spending category (Income, Groceries, Housing, Utilities, etc.) |
Data
41 rows × 6 columns
| 1 | date | description | credit | debit | balance | category |
| 2 | 2025-01-01 | Opening Balance | 4250.00 | Opening Balance | ||
| 3 | 2025-01-02 | Direct Deposit - Payroll | 3850.00 | 8100.00 | Income | |
| 4 | 2025-01-03 | Whole Foods Market | 87.32 | 8012.68 | Groceries | |
| 5 | 2025-01-04 | Shell Gas Station | 52.18 | 7960.50 | Transportation | |
| 6 | 2025-01-05 | Netflix Subscription | 15.99 | 7944.51 | Entertainment | |
| 7 | 2025-01-06 | Transfer to Savings | 500.00 | 7444.51 | Savings | |
| 8 | 2025-01-07 | Starbucks | 6.45 | 7438.06 | Dining | |
| 9 | 2025-01-08 | Electric Company | 128.50 | 7309.56 | Utilities | |
| 10 | 2025-01-09 | Rent Payment | 1750.00 | 5559.56 | Housing | |
| 11 | 2025-01-10 | Amazon.com | 43.97 | 5515.59 | Shopping | |
| 12 | 2025-01-11 | Trader Joe's | 62.84 | 5452.75 | Groceries | |
| 13 | 2025-01-12 | Uber Ride | 18.50 | 5434.25 | Transportation | |
| 14 | 2025-01-13 | AT&T Wireless | 85.00 | 5349.25 | Utilities | |
| 15 | 2025-01-14 | Chipotle | 12.95 | 5336.30 | Dining | |
| 16 | 2025-01-15 | Freelance Payment | 750.00 | 6086.30 | Income | |
| 17 | 2025-01-16 | Direct Deposit - Payroll | 3850.00 | 9936.30 | Income | |
| 18 | 2025-01-17 | Whole Foods Market | 94.17 | 9842.13 | Groceries | |
| 19 | 2025-01-18 | Planet Fitness | 29.99 | 9812.14 | Health | |
| 20 | 2025-01-19 | Home Depot | 156.33 | 9655.81 | Home | |
| 21 | 2025-01-20 | Insurance Premium | 220.00 | 9435.81 | Insurance | |
| 22 | 2025-01-21 | Water Bill | 45.00 | 9390.81 | Utilities | |
| 23 | 2025-01-22 | Target | 67.42 | 9323.39 | Shopping | |
| 24 | 2025-01-23 | Spotify Subscription | 10.99 | 9312.40 | Entertainment | |
| 25 | 2025-01-24 | Costco | 145.88 | 9166.52 | Groceries | |
| 26 | 2025-01-25 | Restaurant - Olive Garden | 58.30 | 9108.22 | Dining | |
| 27 | 2025-01-26 | Parking Meter | 8.00 | 9100.22 | Transportation | |
| 28 | 2025-01-27 | Doctor Visit Copay | 40.00 | 9060.22 | Health | |
| 29 | 2025-01-28 | Internet - Comcast | 79.99 | 8980.23 | Utilities | |
| 30 | 2025-01-29 | Transfer to Savings | 500.00 | 8480.23 | Savings | |
| 31 | 2025-01-30 | Venmo - Refund from Friend | 35.00 | 8515.23 | Refund | |
| 32 | 2025-01-31 | Trader Joe's | 71.56 | 8443.67 | Groceries | |
| 33 | 2025-02-01 | Direct Deposit - Payroll | 3850.00 | 12293.67 | Income | |
| 34 | 2025-02-02 | Rent Payment | 1750.00 | 10543.67 | Housing | |
| 35 | 2025-02-03 | Whole Foods Market | 82.19 | 10461.48 | Groceries | |
| 36 | 2025-02-04 | Shell Gas Station | 48.75 | 10412.73 | Transportation | |
| 37 | 2025-02-05 | Electric Company | 135.20 | 10277.53 | Utilities | |
| 38 | 2025-02-06 | Amazon.com | 29.99 | 10247.54 | Shopping | |
| 39 | 2025-02-07 | Starbucks | 5.80 | 10241.74 | Dining | |
| 40 | 2025-02-08 | Car Wash | 24.99 | 10216.75 | Transportation | |
| 41 | 2025-02-09 | Amazon Refund | 43.97 | 10260.72 | Refund | |
| 42 | 2025-02-10 | Transfer to Savings | 500.00 | 9760.72 | Savings |