Well you have everything except the assets account: bean-query test.beancount 'select date, number, account where account ~ "Expenses:" '
Just write a bit of Python. On Tue, Nov 30, 2021 at 4:07 PM Daniele Nicolodi <dani...@grinta.net> wrote: > On 30/11/2021 19:41, Varac wrote: > > For tax consultency I need to export an csv file which lists my > > transactions in this format (only fields relevant to my question given): > > > > date, amount, account_from, account_to > > > > I.e. given this transaction: > > > > > > 2021-11-30 txn "Shopping" > > Assets:Beans -10 EUR > > Expenses:Unneccessary 4 EUR > > Expenses:Wtf 6 EUR > > > > > > I want a csv export like this: > > > > 2021-11-30, 4, Asset:Beans, Expenses:Unneccessary > > 2021-11-30, 6, Asset:Beans, Expenses:Wtf > > > > Is there any way getting this out of a bean-query ? > > Or what would be the best approach ? > > Looking forward to some serious beancount SQL wizardry above my horizon ! > > I don't think this is possible with the data model used in bean-query > and I don't think there is an existing tool to flatten a Beancount > ledger into the required format. Writing such a tool without introducing > some assumptions could be fairly complex. > > I would write a script that loads the ledger and iterates the > transactions and produces the desired table. > > Cheers, > Dan > > -- > 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 on the web visit > https://groups.google.com/d/msgid/beancount/2b64137f-d0c5-2615-9988-0fb33743d5e9%40grinta.net > . > -- 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 on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhP78XU9tJnZNqrgOuDa7Y5ZWw92WCBDvneFVXCH5B4OsA%40mail.gmail.com.