[GNC] How to create a Transaction Report subtotaled by Payer?

[Tom Route36]

Hey Maf,

Big thanks.  Your suggestion to sort by "Primary Key: Other Account 
Name" works perfectly.  That's just what I needed to subtotal the report 
by each payer.  I just didn't look hard enough into the Report Options.  
Thanks again.

Tom


On 1/23/2026 10:13 PM, Maf. King wrote:
> Hi Tom,
>
> try setting
> report options -> sorting -> Primary Key:" Other Account Name"
> (and tick primary subtotal)
>
> also primary key : "description" might work, depending on how you've entered
> the txns
>
> HTH,
> Maf.
>
> On Saturday, 24 January 2026 03:57:05 GMT Tom Route36 wrote:
>> Hi all,
>>
>> I get monthly interest payments from around a dozen different payers.
>> In GnuCash each such monthly payment gets recorded against an "Interest
>> Income" account.  I want to create a report that lists all of these
>> interest payments to me transaction by transaction.  If I do a
>> Transaction Report for my "Interest Income" account I get a
>> chronological list of these interest payments (Date, Num, Description,
>> Memo/Notes, Transfer from/to, Debit, Credit).  And at the bottom of the
>> report I get the total amount of all those payments combined.  That's great.
>>
>> But what I really want is to get that same transaction-by-transaction
>> data in a report that's subtotaled by Payer.  Something like this:
>> ==========
>> Bank AA:
>>     Date, Description, Credit
>>     Date, Description, Credit
>>     Date, Description, Credit
>>        Total Bank AA:  Sub-total Credits
>>
>> Bank BB:
>>     Date, Description, Credit
>>     Date, Description, Credit
>>     Date, Description, Credit
>>        Total Bank BB:  Sub-total Credits
>>
>> Bank CC:
>>     Date, Description, Credit
>>     Date, Description, Credit
>>     Date, Description, Credit
>>        Total Bank CC:  Sub-total Credits
>>
>> Total for all payers:  Total Credits
>> ==========
>>
>> With Quicken this was straightforward.  Do a Transaction report for
>> Interest Income subtotaled by Account.  But in GnuCash I can't seem to
>> figure out how to get a similar subtotaled report.  Is there a way to do
>> this?  Any help would be appreciated.
>>
>> Tom
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> To update your subscription preferences or to unsubscribe:
>> 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.
>
>
>