Cash flow in BQL

[stalbansrf...@gmail.com]

Hi all

I am near getting beancount to replace TAS for me - one last challenge.

My last hurdle is to get a cashflow statement. I want it to show all movements to accounts that I classify as 'cash' - easy. But I want to see the other side to show what that movement was for.

So, for

1/1/1970   * "Did something"

    Assets:Bank:Cash      1000 GBP

    Income:Subs                667 GBP

    Liabilities:VAT               333 GBP

It would show me the Subs and VAT entries, not the Cash entry.

I see that ledger has a --related   - is there anything similar in BQL or beancount that would do that?

I have searched this forum but couldn't find anything.

In SQL I would create a list of transactions for cash, join it to the transaction again and show the non-cash entries.

Perhaps I need to do a 'print' of the cash entries, then query on the non cash part?
Any help gratefully received!

Thanks
Paul

[p.w.ha...@gmail.com]

Having thought about it I can write a filter to add a tag when it sees a cash account, then do a bean-query select for that tag and non-cash accounts - that would probably do it.
If I can manage that I will post the filter and query.
Paul