home / skills / openclaw / skills / personal-finance

personal-finance skill

safe

This skill helps you manage personal finances by logging expenses, tracking budgets, and reminding you of EMIs and annual spends using a SQLite backend.

npx playbooks add skill openclaw/skills --skill personal-finance

Review the files below or copy the command above to add this skill to your agents.

Files (4)

SKILL.md

1.2 KB

---
name: personal-finance
description: Manage personal finances, track spending by category, set budgets, and receive reminders for EMIs and one-time annual expenses. Use for logging expenses, checking budget status, or setting up financial reminders.
---

# 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).
2. 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.

Overview

This skill helps you manage personal finances by tracking spending by category, setting budgets, and scheduling reminders for EMIs and one-time annual expenses. It stores data locally in an SQLite database so your records remain private and portable. The tool includes preset categories and lets you add custom categories or budgets as needed.

How this skill works

You log expenses as transactions with an amount, category, and optional note; entries are saved to an SQLite database named finance.db. The skill summarizes spending (weekly digest) and checks scheduled items to trigger EMI or annual expense reminders. You can create or update categories and budgets, and the system will report budget status by category.

When to use it

Recording a purchase or expense quickly into a specific category.
Checking how much you’ve spent against a category budget this month.
Setting recurring EMI reminders so you never miss payments.
Scheduling one-time annual payments like insurance or subscriptions.
Reviewing a weekly summary of transactions to spot trends or overspend.

Best practices

Log expenses immediately with a clear category and short note to keep records accurate.
Set realistic monthly budgets per category and review them monthly after the weekly digest.
Add custom categories only when needed to avoid fragmentation of tracking.
Run the database initialization script once and keep regular backups of finance.db.
Use scheduled reminders for fixed obligations (EMIs, insurance) to reduce manual tracking.

Example use cases

Quickly log: "Spent 500 on Food for lunch" to record a meal expense in Food.
Create a Rent budget and check mid-month spending to ensure you’re on track.
Add an EMI schedule to receive reminders before each payment due date.
Schedule an annual insurance payment so the system reminds you a month before.
Run the weekly digest to see top spending categories and adjust budgets accordingly.

FAQ

Where is my data stored?

All data is stored locally in an SQLite database file named finance.db.

Can I add new expense categories?

Yes. You can add custom categories on the fly and then assign transactions to them.

How do reminders work?

The skill checks a schedules table for EMIs and one-time items and issues reminders according to the saved schedule.