Personal Expense Logger with SQLite

Project roadmap

1. 01

   Design the database schema

   ~1h

   Create a SQLite database with a transactions table storing date, amount, category, and description.

2. 02

   Implement add and list commands

   ~2h

   Write CLI subcommands to insert new expenses and list all recorded transactions in a readable table.

3. 03

   Add category summaries

   ~1.5h

   Write a query and report that groups transactions by category and month, showing totals.

4. 04

   Add edit and delete commands

   ~1.5h

   Allow users to update or remove a transaction by its ID, handling missing IDs gracefully.

5. 05

   Export summaries to CSV

   ~1h

   Add a command to export a monthly summary report to a CSV file for use in spreadsheets.

Resources

• DocsPython Documentation