Re: Filtered account report

[Mike or Penny Novack]

On 1/16/2018 6:07 PM, AC wrote:


Yes except that's not how things started or ended up.  Many of the
transactions are from before GnuCash so they are historical records that
imported that way.  Second, I really wasn't paying attention to the
interest in any way other than to record it for record keeping as part
of a transaction mainly because I was more interested in the portion of
the payment that went to the principal and tracking the remaining amount
of payoff.

There were already over 500 transactions at the time I imported into
GnuCash for the first time.  So it's a bit off base to suggest I should
have "paid attention" when setting up the CoA when I didn't have a CoA
due to the original software.  I was lucky enough to get it to import
with few errors as is.
I thought I was clear enough that this situation is something that we 
ALL had to keep alert for to prevent it from happening. To PREVENT this. 
Obviously not going to help in retrospect for any particular person. For 
example, I now tell people "keep your backups in a separate location" 
--- that did not help me with backups I made before our 2006 house fire. 
I was not being critical that you had not done the separation for 
whatever reason. Sometimes these things are completely beyond our 
control to have foreseen << like a change in tax codes >>


However, you raised another issue, when should we import data from 
another package and when maybe not (create a new set of books under 
gnucash going forward). Factors I would take into account:
1) Is the old package still available on my machine to (re)produce 
historical reports and for viewing historical data? If not, obviously 
you want to import. But if so, you have a choice, and decide based on 
how hard to use the old system for that purpose vs how hard to clean up 
after import.

2) How changed would be your CoA now from your CoA then.
3) Do you have the necessary skills to write a program to modify the 
file being imported.


FIXING the sort of problem you had really a matter for a pro. For 
example, you describe being able to parse externally. Getting the 
computer to do that, parse*, create a batch of correction transactions 
(writing  a special ad hoc program to do that) and bringing in that 
batch is precisely the sort of thing I used to get paid to do. Except it 
would have not been 500 but 5000 or even 50,000 so would have taken a 
whole army of folks sitting at their terminals to do the corrections by 
hand. IF faced with your (initial) problem and realizing that the data I 
was about to import had these transactions all going to one interest 
account but I wanted them separated, I would have written something to 
alter the .cvs or whatever before the import. But not expecting you to 
<< you didn't do this sort of thing for your living; I did >>


I should perhaps add that USUALLY even I cannot see in advance that I 
should split an account. When the first "not quite fitting" transaction 
appears, it might seem an oddball case, so you ignore. It is when 
several others appear you realize not so oddball after all. So even I 
have to correct a few transactions. For example, one of the 
organizations existed more than a decade before the first fixed asset, 
and then several more years before there was a second << and so the need 
to split >>


Michael D Novack


* If you can look at them and tell which, then presumably a program 
could be written to do the same thing.

___
gnucash-user mailing list
gnucash-user@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.

Re: Filtered account report

[AC]

No, it's a roughly even distribution across the loans but, as mentioned
in my other email, transactions look different at different dates in
history because the majority were imported from other software before
switching to GnuCash.

On 2018-01-16 09:44, Adrien Monteleone wrote:
> On that note, if only one loan has 1000 interests splits but the other loans 
> are more manageable, then Michael just provided a workable solution.
> 
> Rename the current ‘loan interest’ account to match the name of the loan with 
> the most interest splits. (yes, everything will still be in it)
> 
> Then create the new parent and the other child loan interest accounts as he 
> indicated.
> 
> Run a Find on the newly renamed ‘loan interest 1’ account and filter for 
> memos/descriptions for one of the other loans. Now, you’re looking at a 
> subset of that account register for just one particular loan. Edit those 
> interest splits to their respective new child interest account.
> 
> Rinse, repeat for additional loans.
> 
> This will provide what you want, with the least amount of work and set you up 
> for more granular reporting in the future.
> 
> I did something similar on several occasions when I wanted to re-assign a 
> large block of expenses to child accounts as I was refining my CoA.
> 
> 
> Regards,
> Adrien
> 
>> On Jan 16, 2018, at 7:48 AM, Mike or Penny Novack 
>>  wrote:
>>
>> On 1/16/2018 3:04 AM, AC 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.
>> This is an important point (what David just said)
>>
>> With any of these accounting packages you have to plan the CoA so that the 
>> information you need will be available. Essentially what you are saying is:
>>
>> "I did not design the CoA in such a way (a parent "loan interest" under 
>> which children "loan 1 interest", "loan 2 interest", ..) that I could 
>> see the interest for each loan separately. How can I NOW obtain that 
>> information?"
>>
>> The simple answer is, you can't. But that leads to a discussion about being 
>> alert to changes needed in our books. Such changes might be easy at the time 
>> but very difficult later. Using this situation as an example, you might have 
>> started out with just one loan, so natural to have just "loan interest". It 
>> is when first entering transactions related to a second loan that we need to 
>> notice "oops, won't be able to track the interest of the two loans 
>> separately" and so you:
>> 1) rename "loan interest" to "loan 1 interest"
>> 2) create parent account (placeholder) "loan interest"
>> 3) make "loan 1 interest" a child of this account.
>> 4) create "loan 2 interest" a child of this account.
>> If you realized this fairly speedily after loan 2 came into existence, not a 
>> lot of work re-entering transactions. But if you wait till there are 
>> hundreds or thousands that would need to be fixed .
>>
>> Michael D Novack
>>
>>
>> ___
>> gnucash-user mailing list
>> gnucash-user@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@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@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.

Re: Filtered account report

[AC]

On 2018-01-16 05:48, Mike or Penny Novack wrote:
> On 1/16/2018 3:04 AM, AC 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.
> This is an important point (what David just said)
> 
> With any of these accounting packages you have to plan the CoA so that
> the information you need will be available. Essentially what you are
> saying is:
> 
> "I did not design the CoA in such a way (a parent "loan interest" under
> which children "loan 1 interest", "loan 2 interest", ..) that I
> could see the interest for each loan separately. How can I NOW obtain
> that information?"
> 
> The simple answer is, you can't. But that leads to a discussion about
> being alert to changes needed in our books. Such changes might be easy
> at the time but very difficult later. Using this situation as an
> example, you might have started out with just one loan, so natural to
> have just "loan interest". It is when first entering transactions
> related to a second loan that we need to notice "oops, won't be able to
> track the interest of the two loans separately" and so you:
> 1) rename "loan interest" to "loan 1 interest"
> 2) create parent account (placeholder) "loan interest"
> 3) make "loan 1 interest" a child of this account.
> 4) create "loan 2 interest" a child of this account.
> If you realized this fairly speedily after loan 2 came into existence,
> not a lot of work re-entering transactions. But if you wait till there
> are hundreds or thousands that would need to be fixed .
>

Yes except that's not how things started or ended up.  Many of the
transactions are from before GnuCash so they are historical records that
imported that way.  Second, I really wasn't paying attention to the
interest in any way other than to record it for record keeping as part
of a transaction mainly because I was more interested in the portion of
the payment that went to the principal and tracking the remaining amount
of payoff.

There were already over 500 transactions at the time I imported into
GnuCash for the first time.  So it's a bit off base to suggest I should
have "paid attention" when setting up the CoA when I didn't have a CoA
due to the original software.  I was lucky enough to get it to import
with few errors as is.

However, I was able to do it anyway without modifying the account
structure.  I just dumped the table and parsed it externally.
___
gnucash-user mailing list
gnucash-user@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.

Re: Filtered account report

[Adrien Monteleone]

On that note, if only one loan has 1000 interests splits but the other loans 
are more manageable, then Michael just provided a workable solution.

Rename the current ‘loan interest’ account to match the name of the loan with 
the most interest splits. (yes, everything will still be in it)

Then create the new parent and the other child loan interest accounts as he 
indicated.

Run a Find on the newly renamed ‘loan interest 1’ account and filter for 
memos/descriptions for one of the other loans. Now, you’re looking at a subset 
of that account register for just one particular loan. Edit those interest 
splits to their respective new child interest account.

Rinse, repeat for additional loans.

This will provide what you want, with the least amount of work and set you up 
for more granular reporting in the future.

I did something similar on several occasions when I wanted to re-assign a large 
block of expenses to child accounts as I was refining my CoA.


Regards,
Adrien

> On Jan 16, 2018, at 7:48 AM, Mike or Penny Novack 
>  wrote:
> 
> On 1/16/2018 3:04 AM, AC 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.
> This is an important point (what David just said)
> 
> With any of these accounting packages you have to plan the CoA so that the 
> information you need will be available. Essentially what you are saying is:
> 
> "I did not design the CoA in such a way (a parent "loan interest" under which 
> children "loan 1 interest", "loan 2 interest", ..) that I could see the 
> interest for each loan separately. How can I NOW obtain that information?"
> 
> The simple answer is, you can't. But that leads to a discussion about being 
> alert to changes needed in our books. Such changes might be easy at the time 
> but very difficult later. Using this situation as an example, you might have 
> started out with just one loan, so natural to have just "loan interest". It 
> is when first entering transactions related to a second loan that we need to 
> notice "oops, won't be able to track the interest of the two loans 
> separately" and so you:
> 1) rename "loan interest" to "loan 1 interest"
> 2) create parent account (placeholder) "loan interest"
> 3) make "loan 1 interest" a child of this account.
> 4) create "loan 2 interest" a child of this account.
> If you realized this fairly speedily after loan 2 came into existence, not a 
> lot of work re-entering transactions. But if you wait till there are hundreds 
> or thousands that would need to be fixed .
> 
> Michael D Novack
> 
> 
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Re: Filtered account report

[Mike or Penny Novack]

On 1/16/2018 3:04 AM, AC 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.

This is an important point (what David just said)

With any of these accounting packages you have to plan the CoA so that 
the information you need will be available. Essentially what you are 
saying is:


"I did not design the CoA in such a way (a parent "loan interest" under 
which children "loan 1 interest", "loan 2 interest", ..) that I 
could see the interest for each loan separately. How can I NOW obtain 
that information?"


The simple answer is, you can't. But that leads to a discussion about 
being alert to changes needed in our books. Such changes might be easy 
at the time but very difficult later. Using this situation as an 
example, you might have started out with just one loan, so natural to 
have just "loan interest". It is when first entering transactions 
related to a second loan that we need to notice "oops, won't be able to 
track the interest of the two loans separately" and so you:

1) rename "loan interest" to "loan 1 interest"
2) create parent account (placeholder) "loan interest"
3) make "loan 1 interest" a child of this account.
4) create "loan 2 interest" a child of this account.
If you realized this fairly speedily after loan 2 came into existence, 
not a lot of work re-entering transactions. But if you wait till there 
are hundreds or thousands that would need to be fixed .


Michael D Novack


___
gnucash-user mailing list
gnucash-user@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.

Re: Filtered account report

[David T. via gnucash-user]

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 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 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  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"  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
  
___
gnucash-user mailing list
gnucash-user@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.

Re: Filtered account report

[AC]

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 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  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"  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
___
gnucash-user mailing list
gnucash-user@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.

Re: Filtered account report

[Adrien Monteleone]

Or just add the new transaction report to GnuCash. It’s an attachment here on 
the list from a few months ago. Sorry I don’t have the link to the thread 
directly. But I’m sure a Google search will turn it up.

Regards,
Adrien

> On Jan 15, 2018, at 11:57 PM, Christopher Lam  
> wrote:
> 
> Ah the transaction report as it stands currently cannot do description text
> filtering. The next release will be. For now the easiest workaround is to
> export to spreadsheet and filter from there.
> 
> On 16 Jan 2018 13:33, "AC"  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  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"  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
> information?
> ___
> gnucash-user mailing list
> gnucash-user@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@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@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@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@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.



Regards,
Adrien

___
gnucash-user mailing list
gnucash-user@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.

Re: Filtered account report

[AC]

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  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"  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
 information?
 ___
 gnucash-user mailing list
 gnucash-user@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@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@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@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.

Re: Filtered account report

[Adrien Monteleone]

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  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"  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
>>> information?
>>> ___
>>> gnucash-user mailing list
>>> gnucash-user@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@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@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.

Re: Filtered account report

[Christopher Lam]

Try the Transaction Report which has an Account Filter in the first tab.

On 16 Jan 2018 11:54 AM, "AC"  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
> information?
> ___
> gnucash-user mailing list
> gnucash-user@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@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.

Filtered account report

[AC]

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
information?
___
gnucash-user mailing list
gnucash-user@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.