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.

Reply via email to