Spend Log: my family's credit card spending, sorted while I do nothing 🦥

Description and use

Spend Log automatically fetches, decrypts, extracts, categorizes, and forecasts family credit‑card spending from Gmail PDFs using local Gemma and TabPFN models, presenting a unified dashboard without leaving the laptop.

Problem

Monthly password‑protected credit‑card PDFs arrive in multiple Gmail inboxes with different password rules and layouts, making it tedious to answer simple spending questions.

Outcome

Spend Log reduces manual effort from hours of password handling and spreadsheet work to a single click that aggregates, categorizes, and forecasts family card spending locally.

Workflow

• Fetch new statements from each Gmail inbox (read‑only)
• Read bank’s password hint from email and compute password using name and DOB
• Unlock PDF with pikepdf
• Extract transactions page‑by‑page with Gemma 4 E4B via Ollama
• Categorize merchants and tag by card/person
• Forecast next statement amounts with TabPFN
• Generate CSVs and display dashboard in Streamlit

Evidence

Every month, a pile of password‑protected PDFs lands across our family's Gmail inboxes: my credit card statements, my mom's and my dad's.

Source

Spend Log is a local‑first app that does all of that for you.

Source

Nothing leaves the laptop. Not the statements, not the passwords, not the transactions.

Source

Gemma 4 E4B, through Ollama, does the reading: it works out passwords from the bank's hint, pulls transactions out of any statement layout, categorizes merchants and explains the forecast.

Source