bapi VS beancount

I'm obviously biased, but I think fava + beancount is worth the investment. Been using it for over six years now and have never run across anything I couldn't do with it. I even recently wrote a REST API for it and have been using it to make custom dashboards.

Since you've already written a web app, your other alternative would be creating a separate web app that wraps the ledger binary. I did something similar to this with bapi using the beancount binary.

bapi builds off bdantic by creating an HTTP API for interacting with Beancount data. It runs in a container and can pull ledger data locally, from AWS S3, or even from Redis.

Have you had a look into plain text accounting like e.g. https://beancount.github.io/ ?

Also written in Python, loads of tooling around it. Might be even good to “just” as the database.

[1] https://plaintextaccounting.org [2] https://ledger-cli.org [3] https://beancount.github.io

I used Beancount + Fava for a web UI for years. It stores everything in plaintext files, but the downside is you either have to manually enter everything or probably write a script to import csv/qfx from your bank(s).

beancount -> https://beancount.github.io/

The beancount documentation has some good background material, and the concepts apply to ledger as well.

I track my personal finances using beancount. I have a plugin that I wrote for myself, which in beancount is a python module that is installed in the same python environment as beancount is.