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 <stepbystepfarm at dialup4less.com> 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 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.