home-finance
v0.1.0 personal automation onStatus
# Project Status — Home Finance
**Last updated:** 2026-04-13
**Updated by:** Dominic / Claude Code
**Project phase:** Active — v0.1.0 data integration complete
**Project type:** personal
**Version:** 0.1.0
---
## What This Project Does
Personal financial management — budget tracking, spend analysis, debt payoff planning,
and account monitoring. Integrates 18 months of historical transaction data (Nov 2024 –
Apr 2026) from BoA Checking and Citi Double Cash. Dashboard displays real data across
Statements, Goals, Spend Review, and Accounts tabs.
---
## Current Status
Migration data from Cowork financial model session fully integrated. Dashboard /finance
page shows real transaction data, real account balances, and goal tracking with live
progress from SQLite queries. All 4 tabs functional with 1,594 historical transactions.
Key findings from financial model:
- Monthly salary ($8,675 net) does not cover monthly expenses (~$15,213)
- Annual bonus (~$50K net) required to bridge the gap
- 401(k) loan payoff in July 2026 frees $2,382/mo starting August
- Shopping ($1,706/mo) and Travel ($1,349/mo) are largest discretionary levers
---
## Ideas Tracker IDs
- (none yet)
---
## Key Files
| File | Location | Purpose |
|------|----------|---------|
| VERSION | projects/home-finance/VERSION | Current semantic version |
| CHANGELOG.md | projects/home-finance/CHANGELOG.md | Versioned change history |
| historical_transactions.csv | projects/home-finance/references/ | 1,594 classified transactions — source of record |
| finance.db | projects/home-finance/references/ | SQLite database — indexed for dashboard queries |
| accounts.yaml | projects/home-finance/references/ | Editable account config — 8 debt + 4 asset accounts |
| goals.yaml | projects/home-finance/references/ | Debt milestones + spending limit targets |
| FinancialModel_DominicMancini.xlsx | projects/home-finance/outputs/ | 7-tab financial model (647 formulas) |
| finance_data.py | scripts/dashboard/ | Data la
Activity
Loading activity...
Ideas & Tasks
Loading ideas...
Budget
13,311,517 / 500,000
$11.62 / $10.00
Change Log
v0.1.0
2026-04-13
minor
Migration Data Integration
Added
- Integrated 1,594 historical transactions (Nov 2024 – Apr 2026) from Cowork financial model migration
- `references/historical_transactions.csv` — source of record for all transaction data
- `references/finance.db` — SQLite database with indexed transactions for fast dashboard queries
- `references/accounts.yaml` — editable account config (8 debt + 4 asset accounts with balances, rates, monthly payments)
- `references/goals.yaml` — debt payoff milestones and spending limit targets from financial model
- `outputs/FinancialModel_DominicMancini.xlsx` — 7-tab financial model (647 formulas)
- `scripts/dashboard/finance_data.py` — data layer module for dashboard finance routes
Changed
- Dashboard /finance page now displays real data instead of mock data across all 4 tabs
- Statements tab shows BoA Checking (459 txns) and Citi Double Cash (1,135 txns) with actual date ranges
- Spend Review tab has 18 selectable months with real category breakdowns and month-over-month trends
- Goals tab shows 4 debt payoff milestones + 5 spending limits with live progress from transaction data
- Accounts tab shows 12 real accounts with rates and monthly payments for debt accounts
- Recurring expenses sourced from financial model Budget Review tab
Recent Commits
9963d40Worker: process submission 20260413-023431-2c20ecbed7125Add Cashflow tab to Finance dashboard — Checking account projectionb7fe5c5Worker: process submission 20260413-023431-2c20ecac1c257Worker: process submission 20260413-023431-2c20eccdbd5a1Worker: process submission 20260413-023431-2c20ec8396ebbWorker: process submission 20260413-023431-2c20ecf2cc264Worker: process submission 20260413-023431-2c20ec56cec74Worker: process submission 20260413-020459-6dfb99977722aAdd home asset (8915 SW 156th St) and link Cenlar Mortgage to property1d85001Worker: process submission 20260413-020459-6dfb99