Transaction Report - Subtotaling on Description? (Based on Previous Threads)

[Dale Alspach]

Rather than add another layer of accounts that I only need once a year, I
import the report into a spreadsheet, sort on the descriptions and dates,
and then add a subtotal cell for each group. This procedure requires care
during entry so that the descriptions will group the transactions
correctly. (I think you are already doing this.)

The import into spreadsheet step can require some manipulation so that
dates are recognized and amounts are recognized as numbers rather than text.

Dale

On Sep 4, 2017 3:18 PM, "aegross" <aegross at gmail.com> wrote:

> This post is more-or-less for the elders of the forum....those who have a
> lot
> of experience with GC and double-entry accounting....
>
> Was reporting on charitable giving for the current year, using the
> Transaction Report.  Tried to determine how to subtotal on Description;
> couldn't determine how and scanned through past threads and found these:
>
> http://gnucash.1415818.n4.nabble.com/Basic-reporting-
> Subtotal-by-Description-field-td1421478.html
>
> http://gnucash.1415818.n4.nabble.com/report-of-charitable-contributions-
> td4461126.html#a4461254
>
> http://gnucash.1415818.n4.nabble.com/Which-report-am-I-
> looking-for-td4688925.html#a4689235
>
>
> If I understand the primary points of these threads, it isn't possible to
> subtotal on Description (without changing the code) and if one really
> wanted
> to subtotal on description, they really should not have setup their account
> like Expense:Charity but rather Expense:Charity:CharityName1,
> Expense:Charity:CharityName2, etc.
>
> The previous authors and myself maybe have thinking too much as to how a
> Quicken-type program uses reports and not properly how to think this
> through
> with proper double-entry accounting.   Before reading these threads, it
> wouldn't have occurred to me to have Expense sub-accounts dedicated to a
> particular entity, esp if I may use an entity once or twice but never
> again.
>
> It's not that there is a problem with the Transaction Report or even that
> it
> "needs work" but rather, my understanding of double-entry accounting was
> insufficient.  Correct?
>
> Regards,
> Andrew Gross
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> 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.
>