Filtered account report

[David T.]

Sure. I understand. My experience with my own accounts was different (even with multiple loans over multiple years). Personally, I find the burden of changing transactions--evens hundreds of them--to be minor.  And the results have been consistent and reliable ever since. But you do what you have to do. 
David

 
 
  On Tue, Jan 16, 2018 at 13:05, AC<gnucash at acarver.net> wrote:   
Thanks but not exactly simple in my case as there are over 1000
transactions to the loan interest expense account.  The report was
mainly for my own curiosity which is why I'd rather use an algorithmic
method to generate the report.  With the distinct lack of global search
and replace, it would take way too long to do it so it's not worth the
time to refactor that many accounts for a off-the-cuff experiment.

On 2018-01-15 23:37, David T. wrote:
> AC,
> I went a different way.  I created Subaccounts for each grouping I wanted to track. So, if I want to track interest on a particular loan (for example, if I expected a 1099 for it), I created a subaccount under Expenses:Interest. That made it simple to track individual loans. I also can assign the account to a tax line, and have it turn up in the TXF report.
> It only takes a few minutes really, to restructure like this. 
> David
> 
>  
>  
>  On Tue, Jan 16, 2018 at 10:21, AC<gnucash at acarver.net> wrote:  The description for each split does have the specific loan to which it
> applies.  I used the search to filter on all of those but the
> transaction report still pulls everything in.
> 
> On 2018-01-15 21:14, Adrien Monteleone wrote:
>> Have you tagged each interest payment split with the loan name? You could use that as the filter, though I would think the memo field would suffice.
>>
>> Regards,
>> Adrien
>>
>>> On Jan 15, 2018, at 10:29 PM, AC <gnucash at acarver.net> wrote:
>>>
>>> No, that didn't work.  It still pulls the interest payments from
>>> multiple loans and won't let me filter out the specific interest
>>> payments for one of the loans.
>>>
>>> On 2018-01-15 20:13, Christopher Lam wrote:
>>>> Try the Transaction Report which has an Account Filter in the first tab.
>>>>
>>>> On 16 Jan 2018 11:54 AM, "AC" <gnucash at acarver.net> wrote:
>>>>
>>>>> I was looking at some of my loans and wanted to get an idea of how much
>>>>> I paid in interest to each loan over their life.  I've got one account
>>>>> that collects the amount of loan interest every time I pay (as part of a
>>>>> split transaction) while the principal portion of the payment goes to
>>>>> the specific loan account.
>>>>>
>>>>> There's a mix of different loans in the one interest paid account (Loan
>>>>> A, Loan B, Loan C, etc.) and I wanted to see, for example, only the
>>>>> interest paid on Loan B.
>>>>>
>>>>> I thought I could run an account report on a search window but that
>>>>> doesn't work because it also finds the principal payments and tabulates
>>>>> them as well in the final total.
>>>>>
>>>>> What report and/or filtering mechanism could/should I use to show this