Question on query output on per transaction basis.

[mpl...@gmail.com]

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 ?

[Red S]

 Did you try: `journal` ?

[mpl...@gmail.com]

yes, it outputs postings, not transactions.

[Red S]

Right, but it groups postings together by transaction, which is exactly what transactions are: groups of postings.

If this is not what you want, what exactly do you want? Send us a sample format.

[Martin Blais]

Use bean-bake, or if you cannot, write a script that will upload journals to a spreadsheet.

On Thu, Apr 30, 2020 at 9:12 PM Red S <redst...@gmail.com> wrote:

Right, but it groups postings together by transaction, which is exactly what transactions are: groups of postings.

If this is not what you want, what exactly do you want? Send us a sample format.

--
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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/c38d3f41-2204-4396-a817-f95e73da41d6%40googlegroups.com.

[mpl...@gmail.com]

i tried to use bean-bake, but stumbled upon couple issues / questions. could you please look at them https://groups.google.com/forum/#!topic/beancount/6P5fVmoDm9Q ? Of course if you will have a spare minute, i know you are in the process of migrating to new version control system.

On Thursday, April 30, 2020 at 9:52:37 PM UTC-4, Martin Blais wrote:

Use bean-bake, or if you cannot, write a script that will upload journals to a spreadsheet.

On Thu, Apr 30, 2020 at 9:12 PM Red S <redst...@gmail.com> wrote:

Right, but it groups postings together by transaction, which is exactly what transactions are: groups of postings.

If this is not what you want, what exactly do you want? Send us a sample format.

--
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 bean...@googlegroups.com.

[Martin Blais]

done, in other thread

To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/fc0474f2-fd56-4536-a0ec-128bec5e0a64%40googlegroups.com.