inoue2002/okane-skills
Overview
This skill analyzes okane-backup-*.json household ledger exports to forecast future balances, simulate large expenses, compress logs, and detect danger points. It produces month-by-month balance projections, evaluates whether a planned expense is feasible on a given date, and warns of upcoming balance shortfalls. Outputs include tabular summaries, PNG charts, and compressed JSON exports for long-term storage.
How this skill works
The skill reads okane-backup-*.json files containing an initialBalance and a transaction list, then reconstructs the timeline of balances. It projects forward by applying scheduled or recurring entries and aggregating monthly flows to produce N-month forecasts, highlight large inflows/outflows, and mark dates when balances fall below a threshold. Additional tools run a point-in-time expense check, compress old transactions into monthly summaries, and render a balance chart as PNG.
When to use it
- Estimate balance after N months or simulate savings trajectories
- Check if a specific large purchase is safe on a chosen date
- Alert when balance will dip below a safety threshold
- Reduce JSON size by aggregating old transactions into monthly summaries
- Generate visual balance reports for meetings or planning
Best practices
- Keep recent months uncompressed (default: retain 3 months) so detailed history is available for audits
- Set realistic thresholds for danger detection (e.g., 50k–200k depending on lifestyle)
- Label recurring incomes/expenses clearly in descriptions to improve projection accuracy
- Run forecasts with multiple scenarios (conservative/optimistic) for robust planning
- Export charts for stakeholder reviews and compressed JSON for long-term archival
Example use cases
- Forecast next 6 months of balances and list any month with >¥100,000 net movement
- Simulate spending ¥1,000,000 on 2026-03-01 and report pre/post balance and downstream scheduled payments
- Detect the first date balance falls below ¥100,000 and list contributing transactions
- Compress transactions older than 3 months into monthly income/expense aggregates to shrink file size
- Produce a PNG chart of balance trajectory with markers for large receipts and payments
FAQ
It accepts okane-backup-*.json exports matching the documented schema (initialBalance and transactions array).
How does compression handle details needed later?
Compression aggregates old transactions into monthly totals while keeping recent N months detailed; you can adjust keep-months to retain required granularity.
