I made an offline spending tracker for the OFFLFIRSOCH 2026, to replace my bank's online expenses tracking thingie.
Solderpunk's announcement of OFFLFIRSOCH 2026
My initial plan
The repository of spend
Naturally I did not have time to do everything I wanted to, but I was able to use the program to input my spendings of March.
I don't expect anyone else but me to actually use this - or more precisely to be able to use it. I didn't have time to package it any way, so the program is just launched by cloning the repo and saying python main.py. And it really requires understanding of my mental model of it, and understanding my mental state is often a challenge for myself, not to mention others.
The main things missing are readline tab-completion for subcommands and database items, and creating new stores, producers and products while inputting data. The idea was to be able to quickly tab through existing things through readline tab completion, and for the program to courteously add missing relations instead of complaining about them missing. It will take a couple of evenings to do those, but for the challenge, I will settle for yesterday's version that's still missing them.
After a few SQL queries I found out that in March I spent surprisingly big chunk of my money (that was not related to compulsory housing expenses) in eating or drinking out. March was a socially busy month and I'm not unhappy that I had lunches with workmates or a couple of dinner/pub evenings with friends. That's money well spent in my opinion when one can afford it. The groceries analysis needs a bit more data tweaking to be useful, but now I'm better equipped to know what I want to know.
--
pv@smolpub.mail.kapsi.fi