Build a local transaction reporting tool with Claude
At a glance
A developer uses Claude to build a local command-line tool for categorizing and reviewing personal spending. This workflow is listed under Personal Finance, CLI, Coding.
SourceBuilding a tool for these workflows? See weekly rates.
What they did
1) Download bank and credit card transactions and use Claude to build a local command-line tool in Go with Cobra, Charm libraries and SQLite. Have it load the transactions into a local database and implement the needed categorization, grouping and exclusions as subcommands or flags. 2) Work in small features: let Claude iteratively run commands and database queries to check its work, ask it to document each feature's usage in the README, and commit the changes. Use that README to orient a new conversation. 3) Run the tool to get an ordered monthly expense report as plain text; the author also queried the database with Claude Code and copied output into a text document with comments. Import updated transactions for a later month's report.
How it went
The author said the tool worked reasonably well after a few hours of focused work spread across about a day, with basic prior experience helping them steer it.
Worth knowing
The author described the code as so-so and identified repeat-safe imports and transaction transformation design as areas for more work.