List all accounts

41 views
Skip to first unread message

Maurice de Laat

unread,
Dec 23, 2025, 10:21:40 AM12/23/25
to Beancount
Hi list,

Using beancount 3.1.0 & fava 1.30.4, how can I get a list of all accounts?
SELECT DISTINCT ACCOUNT
Only reports accounts that have at least 1 transaction.

I would like to include accounts that have no transactions.

Thank you

Message has been deleted

Chary Ev2geny

unread,
Dec 23, 2025, 11:30:43 AM12/23/25
to Beancount
Not sure about Fava,

but this is how to do it in the latest beanquery

SELECT account
FROM #accounts

Maurice de Laat

unread,
Dec 23, 2025, 11:46:40 AM12/23/25
to Beancount
Works for me, thank you!

Op dinsdag 23 december 2025 om 17:30:43 UTC+1 schreef Chary Ev2geny:
Reply all
Reply to author
Forward
0 new messages