← All projects
WIP November 2026

HomeBalanceMonitor

A family web application to keep income and expenses of bank accounts and credit cards in one place, read-only. The foundations and the manual register with file import are built.

PythonFastAPIPostgreSQLDockerOpen BankingSelf-hosted

The idea

I’d like one place where the family can see what comes in and what goes out, instead of looking at each bank separately. HomeBalanceMonitor is meant to be that place: a multi-user web application, used only inside the home network, where movements arrive in three ways: read-only synchronisation through an Open Banking service, import from the banks’ CSV/Excel files and manual entry. It never makes payments: it only uses read access.

The design comes first

So far there is no application code, only a requirements document and a test script. I wanted the constraints on paper before writing anything, because several of them change the shape of the project:

On the technical side: Python with FastAPI and PostgreSQL, server-side pages with HTMX instead of a single-page app, Docker, HTTPS, restricted access, amounts as exact decimals and never floating point, logs that never contain financial data, secrets kept out of the repository, and encrypted backups with a documented restore test.

What’s built so far

Two phases are done and installed. The first laid the foundations: login, per-user and per-account permissions, an administration page, HTTPS, encrypted backups and an update script. The second is the register: movements, import from files, categories, balances and search.

The one non-obvious choice is the import. Instead of a fixed format for each bank, I show a preview, I choose which column is the date, the amount and the description, and the choice is saved on the account for the next time. My first guess at the header was wrong on the first real file, because the bank had put a few lines of notes above it; now the header is recognised even with notes on top. I also check my own data on the Mac by printing only structure and counts, with the figures masked.

Status

Work in progress. Requirements and architecture are written, the foundations and the register are in use, and a first test against a bank worked. Not tried yet: real email delivery, a restart after the weekly reboot, and the internal pages on a real phone. Next comes the automatic sync (only when I decide to start it), then matching and reconciliation, and last a security review and a guide for the family.

Stack

Python · FastAPI · PostgreSQL · SQLAlchemy · HTMX · Docker