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.