Generating a Transaction or General Ledger Report

John R. Sowden jsowden at americansentry.net
Wed Jun 5 20:38:52 EDT 2013


On 06/05/2013 04:38 PM, David J. Bakeman wrote:
> On 06/05/2013 04:07 PM, Theresa wrote:
>> Yes, I did "Select All" and then "Select Children" - the entire list was
>> highlighted in a darker shade.  Still nothing.  Perhaps there is another
>> setting I've missed when I set up my GnuCash file?  For instance, I find it
>> odd that I no longer have any totals in my summary bar???  Hopefully it's a
>> quick fix.  Thanks for trying to help me out anyway Michael.  At least now I
>> know to "Select Children" when I do finally get things figured out.
> I use transaction reports all the time but I guess I've always manually
> selected all of the accounts.
>
> What I found is select children only selects the children of the last
> account you clicked on.  So when I started a new report select
> all/select children just selected the top level account.  If I then
> click on assets then select all/select children it selects all of the
> top level accounts and the it expands Assets and selects the children.
> Then I can scroll down and select Expenses and select all/select
> children and it selects all top/the displayed children of assets and it
> expands Expenses and selects the children.
>
> This along with selected an appropriate date range should get you something.
>
> P.S. I using gnucash 2.4.13 on linux fedora 18.
>> T
>>
>> -----Original Message-----
>> From: Michael Hendry [mailto:hendry.michael at gmail.com]
>> Sent: Wednesday, June 05, 2013 6:03 PM
>> To: Theresa
>> Cc: gnucash-user at gnucash.org
>> Subject: Re: Generating a Transaction or General Ledger Report
>>
>>
>>
>> On 5 Jun 2013, at 23:39, Theresa <TRost at ontera.net> wrote:
>>
>>> I just tried "Select Children" as suggested - the report appears with two
>>> lines only and both have 0.00 for totals.
>> Damn!
>>
>> Works for me!
>>
>> Did you highlight a "parent" that is known to have transactions dated within
>> the period you've selected in General Tab? Or press Select All and then
>> Select Children?
>>
>> M
>>
>>
>>> Theresa
>>> -----Original Message-----
>>> From: Michael Hendry [mailto:hendry.michael at gmail.com]
>>> Sent: Wednesday, June 05, 2013 3:45 PM
>>> To: Theresa
>>> Cc: gnucash-user at gnucash.org
>>> Subject: Re: Generating a Transaction or General Ledger Report
>>>
>>>
>>>
>>> On 5 Jun 2013, at 21:17, Theresa <TRost at ontera.net> wrote:
>>>
>>>> I've tried and tried to generate a Transaction Report and a General
>> Ledger
>>>> Report to no avail - usually just a report with 0.00 as the total.
>>> Perhaps
>>>> someone can spot what I'm doing wrong.  Here's one scenario I've tried
>> for
>>>> the Transaction Report:
>>>>
>>>> I make sure I'm using the correct GnuCash file then I click on Report and
>>>> select Transaction Report. From there, I click the Options button and, in
>>>> each of the following tabs select the following:
>>>>
>>>> 1.  Accounts tab - Accounts - Select All; Show Hidden Accounts (no
>> check);
>>>> Filter By - Clear All; Show Hidden Accounts (no check); Filter type -
>>> None;
>>>> Void Transactions: Both.
>>> I think you need to "Select Children" for all the accounts you're
>> interested
>>> in ("Select All" selects the parents).
>>>
>>> Michael
>>>
>>>> 2.  Display tab - checked the following:  Date, Num, Description, Memo,
>>> Use
>>>> Full Account Name, Totals;  Amt: Single; Sign Reverses: Credit Accounts.
>>>>
>>>> 3.  General tab - Style Sheet: Easy; Start Date: May 1, 2012; End Date:
>>>> April 30, 2013; Style: Single; Common Currency: CAD; Table for Exporting
>>> (no
>>>> Check).
>>>>
>>>> 4.  Sorting tab - Primary key: Account Name; Primary subtotal (checked);
>>>> Primary sort order: Ascending; Secondary key: Register Order; Secondary
>>>> subtotal for date key: Monthly; Secondary sort order: Ascending.
>>>>
>>>> Thanks in advance for all your help.
>>>> T
>>>>
>>>> -----Original Message-----
>>>> From: Derek Atkins [mailto:warlord at MIT.EDU]
>>>> Sent: Wednesday, June 05, 2013 10:54 AM
>>>> To: Theresa
>>>> Cc: gnucash-user at gnucash.org
>>>> Subject: Re: General Ledger Listing
>>>>
>>>>
>>>> "Theresa" <TRost at ontera.net> writes:
>>>>
>>>>> What do accountants mean by General Ledger Listing?  Do my accountants
>>>> want
>>>>> a report of some sort?
>>>> Probably either a full Transaction Report or a GL Report.
>>>>
>>>>> Theresa R
>>>>> 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, SB '93 MIT EE, SM '95 MIT Media Laboratory
>>>>       Member, MIT Student Information Processing Board  (SIPB)
>>>>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>>>>       warlord at MIT.EDU                        PGP key available
>>>>
>>>> _______________________________________________
>>>> 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.
>>
> _______________________________________________
> 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.
>
>
That is quite a process to go through to see "all transactions", 
including Asses Liabilities, Equity, Income and Expenses.  You should 
look into one of those "computer programs" to automatically select them 
all for you.  :))

John



More information about the gnucash-user mailing list