A local-first SQLite bookkeeping skill that transforms natural language prompts into structured financial records and analytical reports.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install money-tracker
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install money-tracker using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Money Tracker?
The Money Tracker skill is a powerful financial management tool designed for users who prioritize privacy and local data ownership. Built to work seamlessly with Openclaw Skills, it utilizes a lightweight SQLite database to store transactions, manage multiple currency wallets, and track recurring expenses. It excels at interpreting natural language—particularly Chinese prompts—allowing users to record spending or query balances as if they were chatting with a personal accountant.
By leveraging a robust Python backend, this skill ensures that your financial data remains on your local machine. It provides a comprehensive framework for category management, account reconciliation, and period-based reporting without the need for external cloud dependencies. Whether you are tracking daily coffee runs or managing complex multi-currency bank accounts, this addition to your Openclaw Skills library offers professional-grade bookkeeping with minimal friction.
Money Tracker Use Cases
- Logging daily expenses and income using simple natural language commands.
- Managing multiple digital wallets and bank accounts across different currencies like CNY, USD, and EUR.
- Automating the tracking of recurring monthly subscriptions, rent, and utility bills.
- Generating instant reports to analyze spending habits by category over weeks, months, or years.
- Querying historical transaction data or checking real-time balances for specific wallets.
How Money Tracker Works
- The AI agent receives a natural language prompt and identifies the user's intent (e.g., recording a transaction or querying a balance).
- Key data points such as amount, date, category, and wallet account are extracted from the text.
- The skill interacts with a bundled Python script to communicate with a local SQLite database stored in the user's home directory.
- Transaction records are validated against predefined categories and active accounts to maintain data integrity.
- The system generates a structured response, confirming the action taken or displaying the requested financial data.
Money Tracker Setup
To get started with this skill in your Openclaw Skills environment, ensure you have Python 3.9+ installed and follow these steps:
# Initialize the SQLite database
python "{baseDir}/scripts/bookkeeping.py" init-db
# Configure your initial spending categories
python "{baseDir}/scripts/bookkeeping.py" set-categories --replace "Daily" "Education" "Electronics"
# Set up your primary wallet accounts with currencies
python "{baseDir}/scripts/bookkeeping.py" set-accounts --replace "Alipay:CNY" "BankCard:USD" "Cash:EUR"
Money Tracker Data Schema & Taxonomy
The skill organizes financial data within a local SQLite database (~/.money_tracker/bookkeeping.db) using the following structure:
| Component | Description |
|---|---|
| Transactions | Stores amount, type (income/expense), date, category, and account mapping. |
| Accounts | Manages wallet names linked to specific ISO currency codes. |
| Categories | User-defined labels for semantic classification of entries. |
| Recurring | Templates for scheduled transactions with frequency and interval settings. |
| Metadata | Tracks the original natural language source text for every entry. |
Money Tracker Advanced Features
- Multi-currency support allowing independent balance tracking for various international wallets.
- Automated recurring transaction management with support for weekly, monthly, and yearly intervals.
- Advanced period reporting using ISO week, month, or year formats for precise financial analysis.
- Strict validation modes to prevent data fragmentation by enforcing predefined category and account lists.
- Flexible environment configuration allowing for custom database locations and legacy migrations.
SKILL.md
Loading
Related Openclaw Skills
Home Fix-It
Home Fix-It is an AI-powered home maintenance assistant designed to help users safely diagnose, estimate, and repair household issues.
InvoiceGen
A professional AI invoicing assistant that manages client directories, calculates complex totals, and generates polished PDF invoices through natural language.
Project Aura: The Emo-Agent-Toolkit
A lightweight emotional presentation layer for AI companions using RLHF and dynamic weighted algorithms.
9kvr-panorama
A comprehensive VR panorama management skill for handling everything from asset uploads and hotspot configuration to audio integration and project scoring.
Bilibili Real-Time Search & Analysis
A specialized plugin for AI agents to retrieve, analyze, and summarize real-time trending video data from Bilibili.
Novel to Storyboard Generator
A cinematic tool for Openclaw Skills that transforms literary prose into production-ready film storyboard scripts and shot lists.
Featured*
