Guys hi,
I need to prepare general ledger for my cpa for specific period.
Since he does not have beancount installed I originally i planned to use
bean-bake, but now i think it will be easier to general excel files in fava.
SELECT
date, description, account, position
FROM
date > 2019-04-19 AND date < 2020-04-19
gives me close to what i need, problem is that transactions are separated
into postings:
2019-04-20 Best Hosting Company Assets:Paypal -15.99 USD
2019-04-20 Best Hosting Company Expenses:Hosting 15.99 USD
........
........
solution is to use PRINT:
PRINT FROM date > 2019-04-19 AND date < 2020-04-19
which gives format close to what i need
2019-04-20 * "Best Hosting Company"
Assets:Paypal -15.99 USD
Expenses:Hosting 15.99 USD
........
........
But problem is that i can't export it to excel in fava. As i understood
it's cause PRINT is generating beancount format output (not csv / excel).
Is there a query to generate output that displays data on per transaction
basis AND is in csv / excel format so it's exportable in fava ?
--
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/fb4270f1-4c1c-4bd2-8dae-fb640081168f%40googlegroups.com.
