Bank Statement (Amount)
A personal bank statement with signed amounts, running balances, and spending categories.
41 rows 5 columns
Schema
| Column | Type | Description |
|---|---|---|
| date | date | Transaction date in YYYY-MM-DD format |
| description | string | Merchant or transaction description |
| amount | number | Transaction amount (positive for credits, negative for debits) |
| balance | number | Running account balance after the transaction |
| category | string | Spending category (Income, Groceries, Housing, Utilities, etc.) |
Data
41 rows × 5 columns
| 1 | date | description | amount | balance | category |
| 2 | 2025-01-01 | Opening Balance | 0 | 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 |