Personal Finance
Track spending, manage budgets, and stay on top of recurring payments (EMIs) and one-time annual expenses using a local SQLite backend.
Preset Categories
The skill starts with:
Food,
Rent,
Utilities,
Travel,
Entertainment,
Shopping,
Health,
Misc.
Core Features
- - Categorized Tracking: Log expenses into preset or custom categories.
- Dynamic Categories: Add new categories on the fly.
- SQLite Backend: All data is stored in
finance.db.
Setup
- 1. Run
scripts/init_db.py to initialize the database (already done). - Ask the user if they want to add custom categories or set budgets for the presets.
Logging Expenses
Record spends into
finance.db.
Example: "Spent 500 on Food for lunch" -> Insert into transactions table.
Scheduled Tasks
- - Weekly Digest: Summarize SQLite
transactions table. - Reminders: Check
schedules table for EMIs and One-time spends.
个人理财
使用本地SQLite后端追踪支出、管理预算,并掌握定期付款(EMI)和一次性年度开支。
预设类别
该技能初始包含:餐饮、房租、水电、出行、娱乐、购物、医疗、其他。
核心功能
- - 分类追踪:将支出记录到预设或自定义类别中。
- 动态类别:随时添加新类别。
- SQLite后端:所有数据存储在finance.db中。
设置
- 1. 运行scripts/init_db.py初始化数据库(已完成)。
- 询问用户是否要添加自定义类别或为预设类别设置预算。
记录支出
将消费记录存入finance.db。
示例:午餐花费500元在餐饮上 -> 插入到交易记录表中。
定时任务
- - 每周摘要:汇总SQLitetransactions交易记录表。
- 提醒:检查schedules计划表中的EMI和一次性支出。