Skip to main content
Trevor Grafton

PROJECT / Full stack

Personal Finance Tracker

A small command-line app to log expenses and chart spending by category.

Built
  • Python
  • SQLite
  • pandas
  • matplotlib
Type
Full stack
Source
Public on GitHub
Role
Solo project.
Built with
Python, SQLite, pandas

01 / Overview

Overview

  1. Add, view and delete expenses

    A menu loop over a SQLite table.

  2. Validate input

    Amounts must be non-negative numbers; categories and descriptions are checked.

  3. Summarize and chart

    pandas groups spending by category and matplotlib draws a bar chart.

02 / Context and problem

Context and problem

A simple way to record expenses and see where money goes, without a spreadsheet.

03 / My role

My role

Solo project.

04 / How it works

How it works

  • SQLite storage, pandas summary, matplotlib chart.

05 / Results and numbers

Results and numbers

A finished console app with input validation and a bar chart of spending by category.

  • Input validation on every field.

06 / Limitations

Limitations

  • No date column yet, so the summary covers every entry; no editing; command line only; no tests.

07 / Next project

Next project

Alex, AI Voice Agent for the IT Service Desk →