Skip to content
TakoAPI
Back to skills

financial-reconciler

by gowtham1984

Search & Research
747Downloads reported by clawskills.sh
0Views
0 likesSign in to like this skill
—Not yet rated
Your rating

Brief

Privacy-first personal finance tracker with local SQLite storage.

Description

What This Skill Does

Imports bank statement files in CSV or OFX/QFX format, auto-categorizes transactions by merchant, and tracks budgets against monthly or yearly limits. Answers natural language spending queries using a local script. All data stays in a local SQLite database, nothing is sent externally.

Unlike cloud-based finance tools, all transaction data stays on your machine and is never transmitted to external servers.

When to Use It

  • Importing a Chase CSV export to see last month's category breakdown
  • Asking how much was spent on groceries over the past 30 days
  • Setting a monthly dining budget and checking if it has been exceeded
  • Adding a custom rule to categorize a recurring merchant correctly
  • Generating an HTML monthly report to open and review in a browser

Example Workflow

INPUT

User asks: "Import my statement and show what I spent last month"

AGENT
  1. 1

    Checks file extension to select import_csv.py or import_ofx.py

  2. 2

    Runs the import script and parses the JSON output for transaction count and date range

  3. 3

    Automatically runs categorize.py on uncategorized transactions without waiting for user input

  4. 4

    Runs query.py with a last-month time filter to total spending by category

  5. 5

    Presents a conversational summary of imported transactions and category totals

OUTPUT

Imported 54 transactions from Feb 1–28. Groceries $412, Dining $218, Subscriptions $47, Transport $89, Other $203. Skipped 3 duplicate transactions.

Installation

clawhub install gowtham1984/financial-reconciler

Run the CLI command, or paste the prompt into Claude Code, Cursor, Codex or whichever coding agent you use.

Links