querying (Fava-style) budget with beanquery

17 views
Skip to first unread message

Stefano Zacchiroli

unread,
Oct 8, 2025, 4:06:12 PM (2 days ago) Oct 8
to bean...@googlegroups.com
Hello beancounters,

I've started using Fava-style budgeting [1] and I'm quite happy thus
far. What I'm missing is a end-of-year (or point-in-time, it doesn't
really matter) breakdown of how recorded finances did w.r.t. the budget
for the matching year.

[1]: https://fava.pythonanywhere.com/example-beancount-file/help/budgets

As far as I can tell this is not shown in any Fava view. The only budget
views you have out of the box are the comparison of periodic income and
expenses with the aggregate budget (all accounts together) for that
period.

What I'd like to have instead is a breakdown *per account*, for each
account that have an associated budget entry, showing how the account
total did w.r.t. its budget.

I see how to do this in Python, but less so with beanquery. Is it even
possible, considering it requires querying into custom directives and
propagating the period specification (daily, weekly, etc.) out?

As anyone done anything like this, no matter how? It feels like a
common need, so I suspect I might be missing something.

Thanks in advance,
Cheers
--
Stefano Zacchiroli - https://upsilon.cc/zack
Full professor of Computer Science, Polytechnic Institute of Paris
Co-founder & CSO Software Heritage
Reply all
Reply to author
Forward
0 new messages