Re: [GNC] Unable to Export General Ledger (was: Potential regression: PDFs generated using "Make PDF" have a superfluous blank page)

[Adrien Monteleone]

That’s probably a different issue entirely.

I just ran the General Ledger Report, and used both ‘Export' (which is HTML) 
and ‘Make PDF’ both of which worked fine without extra blank pages. (I’m now on 
3.906 on MacOS 10.15.5) I haven’t yet jumped to 4.x but will tonight. I’ll see 
if I can test with 3.7, but I can report that at least as of 3.906 it works 
properly.

If you want to export to a spreadsheet you have a few options for ‘General 
Ledger’

1. Run the report then export to html, then open the html file in your 
spreadsheet app of choice.
2. Run the report, copy/paste the contents from the GnuCash window to your 
spreadsheet app.

Or, when viewing the General Journal (a register form of the ledger report):

3. File > Export > Active Account Register to CSV
4. Reports > Account Report > (and then proceed with either of steps 1 or 2 
above)

Any of those methods will get you ALL transactions into a spreadsheet.

You can also use File > Export > Export Transactions to CSV.

The advantage with the General Journal register or General Ledger report is 
that you can do some filtering first if you like.

You can do the same #1 & #2 above for any report or #3 & #4 for any open 
register, including a search results register.

--

What steps (exactly) did you take to do your export? (there is no xlsx format 
supported that I am aware of) You can’t export and just choose a different file 
name to get a different format.

Regards,
Adrien


> On Jun 29, 2020 w27d181, at 6:35 PM, Adrian Yong 
>  wrote:
> 
> Hi Adrien,
> 
> After speaking to you the last time, I tried exporting documents (ie. General 
> Ledger) to pdf and xlsx formats and I got gibberish...
> 
> I am using version 3.7...
> 
> Regards,
> Adrian

___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see 
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: export general ledger

[Geert Janssens]

Op dinsdag 19 december 2017 15:58:38 CET schreef Adrien Monteleone:
> Thanks Geert,
> 
> Good to know if I ever need this, export is not the way to go.
> 
> Out of curiosity, could you shed light on why the limitation to export only
> one account type at a time?
> 
> Regards,
> Adrien

I believe this stems from the state of import/export at the time this feature 
was added. Csv import was primarily intended to import bank statements and 
with that limited scope had limited functionality. The csv export was written 
as an inverse operation for this csv import, and in that mindset it was never 
considered to export the GL as the csv import wouldn't be able to import it 
anyway (support for roundtrip export-import was taken in consideration but not 
properly implemented).

In 2.7 the csv importer has been made much more flexible and I believe it 
would even be able to import GL like transaction data now.

The csv exporter has not (yet) gotten the same attention in 2.7 so GL export 
is still not available. It would make more sense now though to line it up with 
the improved csv importer.

Is there an enhancement request for this ? If not, feel free to file one.

Regards,

Geert
___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Adrien Monteleone]

Thanks Geert,

Good to know if I ever need this, export is not the way to go.

Out of curiosity, could you shed light on why the limitation to export only one 
account type at a time?

Regards,
Adrien

> On Dec 19, 2017, at 2:16 AM, Geert Janssens  
> wrote:
> 
> Op dinsdag 19 december 2017 02:55:14 CET schreef Adrien Monteleone:
>> Sorry if my understanding of the GC General Ledger was off.
>> 
>> By combining the files, I meant the exported csv files. So a simple: “cat *
>>> gnucash.csv” after those 4 exports would do the trick.
>> 
> You'd probably end up with lots of duplicate transactions rather than a 
> properly exported general ledger...
> 
> Geert

___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Geert Janssens]

Op dinsdag 19 december 2017 02:55:14 CET schreef Adrien Monteleone:
> Sorry if my understanding of the GC General Ledger was off.
> 
> By combining the files, I meant the exported csv files. So a simple: “cat *
> > gnucash.csv” after those 4 exports would do the trick.
> 
You'd probably end up with lots of duplicate transactions rather than a 
properly exported general ledger...

Geert
___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Adrien Monteleone]

Jeff,

If you have piles of invoices, and you like data entry spreadsheet/text style, 
you can set up an import csv for them instead and bring them in all at once.

There’s a few threads here about the format not too long ago. (within the year)

Regards,
Adrien

> On Dec 18, 2017, at 1:06 PM, Jeff Abrahamson  wrote:
> 
> Thanks, Adrien.  In the end, as long as I can automate this, I'll be
> happy.  (I haven't fully followed on on the python solution, but it sure
> looks like it will work fine, so I've chalked it up as future work for
> me rather than potential workflow blocking today.  Always good to have a
> project over Christmas.)
> 
> Ultimately, it's a user experience issue, and I don't have any vision at
> all of what gnucash users expect.  The accounting software I've used
> previously was geared towards professional accountants, and some of the
> features (like journal entry rather than account entry) I found really
> convenient once I got used to them.  Faced with a pile of bills, for
> example, it was great to be able to enter them all from their respective
> a/p to their respective expense accounts without a single mouse click,
> just a steady stream of typing bill numbers, descriptions, amounts, and
> debit and credit account numbers.
> 
> Again, my perspective is keeping the books for a rowing club.  I'm sure
> that matters in terms of what I find convenient or not.
> 
> Jeff
> 
> 
> On 18/12/17 19:13, Adrien Monteleone wrote:
>> Jeff,
>> 
>> If I recall correctly from other discussion, the General Ledger is not it’s 
>> own entity. It’s a ‘view’ of the separate account ledgers all rolled into 
>> one. This is probably why there is no export option for it.
>> 
>> GnuCash takes the opposite approach from paper books.
>> 
>> With paper, you enter everything in a General Journal and then later post 
>> the proper amounts to T-accounts.
>> 
>> With GnuCash, you skip the Journal and enter directly to the accounts.
>> 
>> The General Ledger was provided for the benefit of those who were used to 
>> the paper method and wanted the option to see all transactions in 
>> chronological order regardless of accounts used.
>> 
>> But I don’t see why you can’t combine the files after the fact. That’s an 
>> easy concatenation command.
>> 
>> It is curious that you can’t export ‘all’ transactions and have to choose 
>> only one hierarchy at a time.
>> 
>> Regards,
>> Adrien
>> 
>>> On Dec 17, 2017, at 1:31 PM, 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.
>>> 
>>> -- 
>>> 
>>> Jeff Abrahamson
>>> +33 6 24 40 01 57
>>> +44 7920 594 255
>>> 
>>> http://p27.eu/jeff/
>>> 
>>> 
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@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.
>> ___
>> gnucash-user mailing list
>> gnucash-user@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.
> 
> -- 
> 
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
> 
> http://p27.eu/jeff/
> 
> 

___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Adrien Monteleone]

Sorry if my understanding of the GC General Ledger was off.

By combining the files, I meant the exported csv files. So a simple: “cat * > 
gnucash.csv” after those 4 exports would do the trick.

Regards,
Adrien

> On Dec 18, 2017, at 1:17 PM, Wm via gnucash-user  
> wrote:
> 
> On 18/12/2017 18:13, Adrien Monteleone wrote:
>> Jeff,
>> If I recall correctly from other discussion, the General Ledger is not it’s 
>> own entity. It’s a ‘view’ of the separate account ledgers all rolled into 
>> one. This is probably why there is no export option for it.
> 
> You recall incorrectly.  The general ledger is (as the name suggests) 
> actually about as pure a view as the UI gives of the entirety of a gnc set of 
> accounts as is available.
> 
> gnc does not actually have separate account ledgers at all, it belongs to the 
> stream of transactions accounting family.
> 
>> GnuCash takes the opposite approach from paper books.
> 
> that may be correct or incorrect, depending on where you learned accounting.
> 
>> With paper, you enter everything in a General Journal and then later post 
>> the proper amounts to T-accounts.
> 
> Not in UK accounting you don't.  In UK accounting you do it the other way :)
> 
>> With GnuCash, you skip the Journal and enter directly to the accounts.
>> The General Ledger was provided for the benefit of those who were used to 
>> the paper method and wanted the option to see all transactions in 
>> chronological order regardless of accounts used.
> 
> 
> Bollocks.
> 
>> But I don’t see why you can’t combine the files after the fact. That’s an 
>> easy concatenation command.
> 
> Oh, for fuck's sake.  There are no separate files, it is a stream of 
> transactions.
> 
>> It is curious that you can’t export ‘all’ transactions and have to choose 
>> only one hierarchy at a time.
> 
> Yes, that is a bit weird, but it is probably like that because someone had 
> the same misunderstanding as you about separate account ledgers 15 or more 
> years ago.
> 
> -- 
> Wm
> 
> ___
> gnucash-user mailing list
> gnucash-user@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.

___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Wm via gnucash-user]

On 18/12/2017 18:13, Adrien Monteleone wrote:

Jeff,

If I recall correctly from other discussion, the General Ledger is not it’s own 
entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This 
is probably why there is no export option for it.



You recall incorrectly.  The general ledger is (as the name suggests) 
actually about as pure a view as the UI gives of the entirety of a gnc 
set of accounts as is available.


gnc does not actually have separate account ledgers at all, it belongs 
to the stream of transactions accounting family.



GnuCash takes the opposite approach from paper books.


that may be correct or incorrect, depending on where you learned accounting.


With paper, you enter everything in a General Journal and then later post the 
proper amounts to T-accounts.


Not in UK accounting you don't.  In UK accounting you do it the other way :)


With GnuCash, you skip the Journal and enter directly to the accounts.

The General Ledger was provided for the benefit of those who were used to the 
paper method and wanted the option to see all transactions in chronological 
order regardless of accounts used.



Bollocks.


But I don’t see why you can’t combine the files after the fact. That’s an easy 
concatenation command.


Oh, for fuck's sake.  There are no separate files, it is a stream of 
transactions.



It is curious that you can’t export ‘all’ transactions and have to choose only 
one hierarchy at a time.


Yes, that is a bit weird, but it is probably like that because someone 
had the same misunderstanding as you about separate account ledgers 15 
or more years ago.


--
Wm

___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Wm via gnucash-user]

On 18/12/2017 13:16, Sébastien de Menten wrote:

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


I already said that, you just have to wait longer for my messages while 
someone checks if I have said something that one person in a faraway 
land of innocence might consider rude :)


--
Wm

___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Wm via gnucash-user]

On 18/12/2017 10:32, Jeff Abrahamson 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.


The database formats of both gnc and the text accounting tools are 
pretty stable so once you get an export that works you won't have to 
fiddle with it much.  Only major decision is that you might have to 
switch to an sqlite backend if you are using xml at the moment (but the 
long term plan is for sqlite to be the default store anyway).


I've probably used most of the conversion scripts over time, let me know 
the gist of what you're trying to achieve and I'll dig through the ones 
I've used.


If you can read python it'll be plain sailing and the best place to 
start is probably Sebastien's work

https://piecash.readthedocs.io/en/latest/
he has a ledger-cli conversion and ledger-cli to csv (or gnc to csv if 
that is what you really want) is simple.


The point about using text accounting as an intermediary is that damn 
near everyone has had a kick at it so there is little you can't make it 
do or get out of (or into) it.


As an e.g. of frequent use (but probably in the opposite direction) I 
used ledger-cli to black box per month everything that happens for one 
of my p2p accounts that produces hundreds of transactions of less than a 
few pennies and with more than 2 decimal significance and just isn't 
worth replicating in gnc; ledger-cli produces a summary journal per 
month and I put *that* into gnc


--
Wm

___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Aaron Laws]

>
> 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.


It looks like ledger-cli dropped gnucash import support in 2009?

https://github.com/ledger/ledger/commit/71642d98

Also

https://github.com/ledger/ledger/commit/aece6339, and
https://github.com/ledger/ledger/commit/d56f9c4032
___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Jeff Abrahamson]

Thanks, Adrien.  In the end, as long as I can automate this, I'll be
happy.  (I haven't fully followed on on the python solution, but it sure
looks like it will work fine, so I've chalked it up as future work for
me rather than potential workflow blocking today.  Always good to have a
project over Christmas.)

Ultimately, it's a user experience issue, and I don't have any vision at
all of what gnucash users expect.  The accounting software I've used
previously was geared towards professional accountants, and some of the
features (like journal entry rather than account entry) I found really
convenient once I got used to them.  Faced with a pile of bills, for
example, it was great to be able to enter them all from their respective
a/p to their respective expense accounts without a single mouse click,
just a steady stream of typing bill numbers, descriptions, amounts, and
debit and credit account numbers.

Again, my perspective is keeping the books for a rowing club.  I'm sure
that matters in terms of what I find convenient or not.

Jeff


On 18/12/17 19:13, Adrien Monteleone wrote:
> Jeff,
>
> If I recall correctly from other discussion, the General Ledger is not it’s 
> own entity. It’s a ‘view’ of the separate account ledgers all rolled into 
> one. This is probably why there is no export option for it.
>
> GnuCash takes the opposite approach from paper books.
>
> With paper, you enter everything in a General Journal and then later post the 
> proper amounts to T-accounts.
>
> With GnuCash, you skip the Journal and enter directly to the accounts.
>
> The General Ledger was provided for the benefit of those who were used to the 
> paper method and wanted the option to see all transactions in chronological 
> order regardless of accounts used.
>
> But I don’t see why you can’t combine the files after the fact. That’s an 
> easy concatenation command.
>
> It is curious that you can’t export ‘all’ transactions and have to choose 
> only one hierarchy at a time.
>
> Regards,
> Adrien
>
>> On Dec 17, 2017, at 1:31 PM, 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.
>>
>> -- 
>>
>> Jeff Abrahamson
>> +33 6 24 40 01 57
>> +44 7920 594 255
>>
>> http://p27.eu/jeff/
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@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.
> ___
> gnucash-user mailing list
> gnucash-user@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.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/


___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Adrien Monteleone]

Jeff,

If I recall correctly from other discussion, the General Ledger is not it’s own 
entity. It’s a ‘view’ of the separate account ledgers all rolled into one. This 
is probably why there is no export option for it.

GnuCash takes the opposite approach from paper books.

With paper, you enter everything in a General Journal and then later post the 
proper amounts to T-accounts.

With GnuCash, you skip the Journal and enter directly to the accounts.

The General Ledger was provided for the benefit of those who were used to the 
paper method and wanted the option to see all transactions in chronological 
order regardless of accounts used.

But I don’t see why you can’t combine the files after the fact. That’s an easy 
concatenation command.

It is curious that you can’t export ‘all’ transactions and have to choose only 
one hierarchy at a time.

Regards,
Adrien

> On Dec 17, 2017, at 1:31 PM, 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.
> 
> -- 
> 
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
> 
> http://p27.eu/jeff/
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@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.

___
gnucash-user mailing list
gnucash-user@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.

Re: 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  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@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.
>
___
gnucash-user mailing list
gnucash-user@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.

Re: export general ledger

[Jeff Abrahamson]

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@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.

Re: export general ledger

[Wm via gnucash-user]

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.


--
Wm


___
gnucash-user mailing list
gnucash-user@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.

export general ledger

[Jeff Abrahamson]

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.

-- 

Jeff Abrahamson
+33 6 24 40 01 57
+44 7920 594 255

http://p27.eu/jeff/


___
gnucash-user mailing list
gnucash-user@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.