Year end Trial Balance sheet

Ian Konen iankonen at gmail.com
Tue Jun 4 22:37:27 EDT 2013


Hi Theresa,

I'm a little late to this discussion, but I think there's some confusion
among relevant participants about what you meant by "the file" in your
original question, and what you got with "save as".  You were discussing a
generated *report* (trial balance IIRC), said you could print it but
couldn't figure out how to cope "the file".  I read that as you want a file
representing the *report* so that you can transmit it electronically to
your accountant, not that you want all the data from your GnuCash working
file.  If I'm wrong , and you're really trying to get your accountant to
help you in GnuCash, then you can skip the rest...

If you're trying to transmit a trial balance report to you accountant,
David's answer was probably the best approach: either export the *report*
to HTML (using File->Export->Export report) OR "print the report" to a PDF
file.  Until you do that, I don't think the report exists as a stand alone
file...it's part of your data file.  Anyway, either of those formats, HTML
or PDF, should be readable by anybody who is asking for an electronic file.
 That last step of converting the HTML report to OpenOffice Calc (and then
probably on to an excel file) will save your accountant the effort of
reading numbers with his eyes and typing them into his/her favorite
accounting software, but I suspect is overkill.

If you selected File-Save As and saved a new XML file, you're not saving a
copy of the *report*.  You've made a new copy of all of your GnuCash data
(the accounts, the transactions, the invoices, and yeah, also the reporst
in question) and you saved it in the specific data format used by GnuCash.
 Unless your accountant happens to also be a GnuCash user, he/she will not
be able to read the trail balance report or get any other useful
information about your accounts.


On Tue, Jun 4, 2013 at 8:19 PM, Theresa <TRost at ontera.net> wrote:

> Great tip Colin.  I was a bit confused for awhile because I didn't know
> GnuCash had opened with the file I had saved.  I get it now.  Thanks.
>
> T
>
> -----Original Message-----
> From: Colin Law [mailto:clanlaw at googlemail.com]
> Sent: Tuesday, June 04, 2013 4:02 PM
> To: Theresa
> Cc: Derek Atkins; gnucash-user at gnucash.org
> Subject: Re: Year end Trial Balance sheet
>
>
> On 4 June 2013 21:41, Theresa <TRost at ontera.net> wrote:
> > I couldn't figure out how to "copy" the file as you suggested Derek.
> > However, I was able to "save as" an xml file - I think that's what you
> > meant? hopefully that will do for my accountant.  On to the next item on
> my
> > accountant's list.
>
> Remember that if you do Save As and close GnuCash then the next time
> you run the program it will default to opening the new saved file not
> the original.  Assuming that this is not what you want then the best
> thing is, after Save As, to do File and select the original file from
> the recent file lists to re-open it before closing GC.  It is also a
> good idea, when doing Save As for this purpose, to give the file a
> different name so that you can distinguish between the two in the
> recent file list.
>
> Colin
>
> >
> > T
> >
> > -----Original Message-----
> > From: Derek Atkins [mailto:derek at ihtfp.com]
> > Sent: Monday, June 03, 2013 8:28 PM
> > To: Theresa
> > Cc: gnucash-user at gnucash.org
> > Subject: Re: Year end Trial Balance sheet
> >
> >
> >
> > On Mon, June 3, 2013 9:02 pm, Theresa wrote:
> >> My accountant wants a year end trial balance work sheet and a copy of
> the
> >> file on a memory stick.  I managed to print a trial balance sheet - to
> my
> >> utter amazement - but I can't seem to make a copy of the file.  Does
> >> anyone
> >> know how I can do this?
> >
> > Just copy the file, the same way you'd copy a Word Document or Excel
> > Spreadsheet.
> >
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> > -derek
> >
> > --
> >        Derek Atkins                 617-623-3745
> >        derek at ihtfp.com             www.ihtfp.com
> >        Computer and Internet Security Consultant
> >
> >
> > _______________________________________________
> > 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.
>
>
> _______________________________________________
> 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.
>



-- 
Ian Konen
iankonen at gmail.com
www.linkedin.com/in/iankonen
978-821-6498


More information about the gnucash-user mailing list