personal-finance

The Personal Finance skill provides a robust, privacy-focused solution for individual expense management by leveraging a local SQLite database backend. Designed for users who prioritize data sovereignty, this skill allows you to track spending in real-time, enforce budget constraints, and maintain oversight of financial commitments such as Equated Monthly Installments (EMIs) and non-recurring annual expenses. By recording transactions directly into a structured database, the skill facilitates consistent financial logging and enables periodic reviews, ensuring you stay within your predefined financial targets.

• Categorized Tracking: Log daily expenses into default categories like Food, Rent, Utilities, or Travel, with full support for creating and managing custom categories dynamically.

• Budget Management: Define and monitor budget limits for each category to ensure spending remains aligned with your financial goals.

• Automated Reminders: Maintain a schedules table for EMIs and one-time annual payments, allowing the agent to proactively notify you of upcoming financial obligations.

• Data Persistence: Utilizes a local finance.db file, ensuring that your sensitive financial information remains on your machine without requiring external cloud storage.

• Weekly Summaries: Generate automated digests summarizing your expenditure trends and budget utilization from the transactions table.

• Installation and Setup: Requires the execution of the provided initialization script to prepare the database schema; users are prompted to configure custom categories during initial setup.

• Input Handling: Accepts natural language commands for logging transactions, such as "Spent 500 on Food for lunch," which the agent parses into specific table entries.

• Constraints: The skill operates on a local file system; ensure sufficient write permissions for the agent in the directory containing finance.db.

• Practical Tip: Regularly trigger the weekly digest to gain insights into your spending habits and identify areas for potential savings. The SQLite backend allows for direct SQL querying if you require advanced custom reports or data visualization.