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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/2b64137f-d0c5-2615-9988-0fb33743d5e9%40grinta.net.
