Re: Aggregate accounts on income statement

Yes, combination of beanquery with jupyter-notebook, pandas and matplotlib seems to be very powerful indeed. Add to this the fact, that VS ode has a native support for jupyter-notebook as well as an extension for beancount On Sunday, March 12,

Re: Aggregate accounts on income statement

Char, That is a great resource! Thanks for sharing. I will look into that for more customized reports than what I can get with Fava. Dan, Thanks! That works perfectly for me, given how I have my Expense accounts structured On Sunday, March 12, 2023 at 7:23:23 AM UTC-7 dan...@grinta.net wrote:

Re: Aggregate accounts on income statement

On 11/03/23 20:27, Daniel González wrote: Hi, I'm generating an income statement (with only my expenses) like this: SELECT account, sum(position) FROM OPEN ON 2023-03-01 CLOSE ON 2023-03-30 WHERE account ~ "Expenses" GROUP BY 1 ORDER BY 1 But I have some subdivisions of my accounts that I wou

Re: Aggregate accounts on income statement

Not sure it can be done in beanquery, but here is example how it can easily be done in pandas https://www.isabekov.pro/multiperiod-hledger-style-reports-in-beancount-pivoting-a-table/ In general it seems like using beanquery together with pandas in jupyter notebook is the best way forward for

Aggregate accounts on income statement

Hi, I'm generating an income statement (with only my expenses) like this: SELECT account, sum(position) FROM OPEN ON 2023-03-01 CLOSE ON 2023-03-30 WHERE account ~ "Expenses" GROUP BY 1 ORDER BY 1 But I have some subdivisions of my accounts that I would like to report one level up. For example