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 <dave...@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+unsubscr...@googlegroups.com. > To view this discussion visit > https://groups.google.com/d/msgid/beancount/04af43f5-2330-4bc5-9142-79fd911cbd2bn%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/04af43f5-2330-4bc5-9142-79fd911cbd2bn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/beancount/CAAP-nVvSZcG1BAjvNXskKSHfMBE%3DHEyZYDa2MjBwPVEp%3DkUZgg%40mail.gmail.com.