printing chart of Accounts

[Peter Kiessling]

----------------------------------------------------------------------

Message: 1
Date: Wed, 9 Oct 2013 13:09:52 +0000
From: "Dominic Grosleau " <farbauti_19 at hotmail.com>
To: "gnucash-user at gnucash.org " <gnucash-user at gnucash.org>
Subject: Printing Chart of Accounts
Message-ID: <BLU176-DS203725075ACF53454F7549861D0 at phx.gbl>
Content-Type: text/plain; charset="iso-8859-15"

In gnucash 2.4.11 for linuxmint, how do I print the chart of account to printer??

The print option is graayed out, and when trying to export in the only format available (xml) it comes out in a .gnucash file that libre office Calc cannot open properly.

Please help as I am sittting down with accountant this afternoon and I need to bring him my draft CoA 
Sent by my Blackberry, I-Pod Touch, Computer, PSP, DS, PDA, Tablet, smoke signal, ESP, Cell Phone, Other device nobody but the manufacturer cares about....




------------------------------

Message: 2
Date: Wed, 09 Oct 2013 15:28:03 +0200
From: Mike Simms <mesimms at gmail.com>
To: gnucash-user at gnucash.org
Subject: Re: Printing Chart of Accounts
Message-ID: <525559E3.9020803 at gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

I think you can only print a report, rather than a the accounts tab (the 
one that's always open). Do any of the reports suit your purposes, maybe 
a Trial Balance? that at least list the accounts, if that's what is 
meant by chart of accounts. HTH.

On 09/10/13 15:09, Dominic Grosleau wrote:
> In gnucash 2.4.11 for linuxmint, how do I print the chart of account to printer??
> 
> The print option is graayed out, and when trying to export in the only format available (xml) it comes out in a .gnucash file that libre office Calc cannot open properly.
> 
> Please help as I am sittting down with accountant this afternoon and I need to bring him my draft CoA
> Sent by my Blackberry, I-Pod Touch, Computer, PSP, DS, PDA, Tablet, smoke signal, ESP, Cell Phone, Other device nobody but the manufacturer cares about....
> 
> 
> _______________________________________________
> 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.
> 

-- 
Mike Simms  +34 648749426


------------------------------

Message: 3
Date: Wed, 9 Oct 2013 14:35:18 +0100
From: Michael Hendry <hendry.michael at gmail.com>
To: Dominic Grosleau <farbauti_19 at hotmail.com>
Cc: "gnucash-user at gnucash.org " <gnucash-user at gnucash.org>
Subject: Re: Printing Chart of Accounts
Message-ID: <50D8B0C0-D72C-4E54-B49C-46010C6CA955 at gmail.com>
Content-Type: text/plain; charset=us-ascii

On 9 Oct 2013, at 14:09, Dominic Grosleau <farbauti_19 at hotmail.com> wrote:

> In gnucash 2.4.11 for linuxmint, how do I print the chart of account to printer??
> 
> The print option is graayed out, and when trying to export in the only format available (xml) it comes out in a .gnucash file that libre office Calc cannot open properly.
> 
> Please help as I am sittting down with accountant this afternoon and I need to bring him my draft CoA 

Fast-and-dirty method - almost certainly could be improved!!


Reports->Account Summary

Then adjust the Options so that the date of the summary is before the first entry in your accounts (e.g. 01/01/1970), so every account will have a zero balance. 

Tidy it up a bit by ticking the box marked "Omit zero balance figures" (in the Display tab of Options).

You might need to adjust other options to get the information you need.

Michael




For my money the best bet is the report "Account Summary"
Adjust options as detailed by Michael. You can adjust the subaccount level shown up to 6.
Save report to Desktop.
Open report in HTML (YOur browser) 
At this point you can print it or if you wish to massage it further, as I sometimes do,  import it into excel
Excel Import: Select all of report and "copy"
open Excel and go to "paste special." I like "Unicode text" which preserves the gridlines  Paste report.
>From there you can add or delete at will. This does preserve the parent/child relationship by using indentations but does not separate them into individual columns.  Then print with or without gridlines.
This will probably work with other spreadsheet programs with a few mods of the paste command.

Now I haven't figured out how to take such a report of just the account tree (no numbers) from excel or a CSV save back into a new copy Gnucash.  Anybody?