export general ledger

[Sébastien de Menten]

To export a gnucash book to a ledger-cli output, you may be interested by
the piecash python module and the related script
https://github.com/sdementen/piecash/blob/master/scripts/piecash_ledger.py


On Mon, Dec 18, 2017 at 11:32 AM, Jeff Abrahamson <jeff at p27.eu> wrote:

> On 18/12/17 03:26, Wm via gnucash-user wrote:
> > On 17/12/2017 19:31, Jeff Abrahamson wrote:
> >> I'd like to export the general ledger to a csv file.  When I use File ->
> >> Export, however, I'm offered a choice of exporting income, expenses,
> >> assets, or liabilities.  But I'd like to have all transactions in the
> >> csv file.
> >>
> >> I think I see how to do this using python (the example script
> >> account_analysis.py in the examples is instructive).  But this seems so
> >> basic I suspect I'm missing something.
> >>
> >> Many thanks for any pointers.
> > May be easier to do a transaction report or similar and copy and paste
> > that into a spreadsheet.
> >
> > Alternatively there are a number of scripts that can take gnc files of
> > some flavour and produce ledger-cli / beancount compatible files which
> > are generally mores useful than csv files for accounting data anyway.
>
> Ah, ledger-cli and beancount are neat, thanks for the pointer.
>
> This sort of export is something I want to be able to do frequently.
> I'll have a look around for scripts to automate it.
>
> --
>
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
>
> http://p27.eu/jeff/
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>