finance-reconciler

What This Skill Does

The Finance Reconciler is a powerful, privacy-focused tool designed to help you maintain control over your personal finances without sacrificing data security. By utilizing a local SQLite database, the skill ensures that your sensitive transaction history, spending habits, and budget data never leave your computer. It allows you to import bank statements directly from major institutions, automatically categorizes your transactions, tracks your monthly budgets, and provides insightful analysis into your spending patterns through simple, natural language queries.

Installation

To get started, first install the skill via the OpenClaw platform using the command: clawhub install openclaw/skills/skills/gowtham1984/financial-reconciler. Once installed, you must perform a one-time setup on your local machine. Ensure you have the necessary dependencies by running: pip3 install pandas ofxparse tabulate python-dateutil. Finally, initialize your database with the command: python3 scripts/db.py. If these steps encounter any errors, please check your local environment permissions before proceeding.

Use Cases

This skill is perfect for individuals looking to gain better visibility into their financial health. Use it to consolidate multiple bank accounts, keep a pulse on discretionary spending, or adhere to strict monthly budgeting goals. Whether you are prepping for tax season or simply trying to understand where your paycheck goes, the Finance Reconciler provides a clear, categorized view of your financial life.

Example Prompts

1. "I just downloaded my latest statement. Can you help me import it? Here is the file path: ~/Downloads/bank_statement.csv"
2. "How much money did I spend on groceries during the month of October?"
3. "Set a new monthly budget of $500 for entertainment expenses."

Tips & Limitations

For the best results, ensure your bank statements are in a supported format like CSV, OFX, or QFX. While the skill features robust auto-detection for Chase, Bank of America, and Wells Fargo, you may occasionally need to provide manual column mapping for generic bank exports. Remember that because all data is stored locally, you are responsible for maintaining your own backups of the generated SQLite database file.