I suggest creating one or a series of queries to get what you need - then probably some spreadsheeting if you need to do anything advanced.
I like keeping a summary table of monthly income and expenses, but which also includes my mortgage payments, and for that I use this query (saved in fava): SELECT year, month, root(account, 2) as Account, sum(number) as Total, currency WHERE account ~ 'Expenses' OR account ~ 'Liabilities:Mortgage' OR account ~ 'Income' GROUP BY year, month, Account, currency ORDER BY year, month, currency, Account FLATTEN The root(account, 2) keeps it at a high level, like Expenses:Car. You can simplify it further with just root 1 and no month. Then you get your year's summary. I just press the download as, and then paste it into my spreadsheet. As I'm writing this, I realise that my query is old (from when I first started playing with it) and you could simplify it with: account ~ 'Expenses|Liabilities:Mortgage|Income' So, just add or subtract AND NOT account ~ 'Assets:Not:This:One' to your report and get the data that way. -- 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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/687039ac-2451-490f-ab1d-25223ef04f8c%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
