Month end balance in python

[David Coleman]

Just getting started with Beancount, so sorry for the basic question.
How can you get the month end balances of balance sheet accounts from python with v3?

[Chary Chary]

Hi,

You need to use beanquery

This is what I use:

 SELECT account, convert(SUM(position),'{currency}',{date_iso}) as amount

    where date <= {date_iso} AND account ~ 'Assets|Liabilities'

   

On Wed, Jul 23, 2025, 09:23 David Coleman <dav...@gmail.com> wrote:

Just getting started with Beancount, so sorry for the basic question.
How can you get the month end balances of balance sheet accounts from python with v3?

--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/beancount/04af43f5-2330-4bc5-9142-79fd911cbd2bn%40googlegroups.com.