[GNC] Transferring portion of mutual fund account to another fund account

[Harry Foerster]

Hi. I've haven't finalized my method to accomplish the fund transfer at
cost, but it does involve selling the specified number of fund units, using
the lots utility and scrubbing. This will generate an orphan capital gain
which can then be used to calculate the cost basis for the specified units.
The entries from the scrubbing are then deleted from the account and the
sell transaction is modified with the value of the calculated cost basis.
The lot and scrubbing utility are again used and should produce a total
orphan capital gain of 0 and the proper entries and transfer to the other
account. This procedure will also create incorrect entries into the price
database for the respective mutual fund units, which should be deleted.

 I'm not quite finished looking into this but it seems to be the way to go
since scrubbing maintains the allotment of the units on a FIFO basis and
future transfers can be done on the remaining lots.

-----Original Message-----
From: gnucash-user <gnucash-user-bounces+hfoerster=shaw.ca at gnucash.org> On
Behalf Of D via gnucash-user
Sent: February 6, 2019 7:38 AM
To: alen siljak at gmx. com <alen.siljak at gmx.com>; Gnucash Users
<gnucash-user at gnucash.org>
Subject: Re: [GNC] Transferring portion of mutual fund account to another
fund account



On February 6, 2019, at 2:10 PM, cicko <alen.siljak at gmx.com> wrote:

>Hi, Harry,
>What I do is simply create a transaction which subtracts shares from 
>one accounts and puts them into the other.
>This, of course, does not track the original prices. For that you'd 
>need to do something similar to what scrubbing does. Note that I don't 
>use scrubbing as I found it makes things worse for me rather than 
>better. To my understanding, scrubbing will work at all only if you 
>sell. It will then match the sold split(s) to the purchased split(s). 
>However, if you buy 10 units twice (10 + 10) at different prices, and 
>then sell (or move) 15 at once, I don't GnuCash will help you much in 
>keeping track of original purchase prices for the lot.

Cicko, you're wrong on this point. Gnucash does keep track of each of these
lots, and will calculate gains on the separate lots when you scrub lots. The
scrub function in this case will actually take your original sell
transaction and create lot-based sell splits, and then separate gains
transactions for each lot. I have found these transactions to be accurate
for mutual funds, where commissions and fees are not specified. With stock
sales, I get tripped up by the fees and commissions, which I manually adjust
after the fact. Some have noted that a user could record their stock
purchases in the same way (i.e., roll the fees into the purchase price) but
that rubs my sensibilities (such as they are) the wrong way.I

David


>In that regard, I'm also interested in what others are doing. For those 
>rare cases when I do sell, I created a Python script that performs
"scrubbing"
>in-memory and calculates the original prices for the lots but does not 
>write anything to the book. Then I can create transactions manually to 
>reflect the real life. I actually use it mostly for the accurate 
>calculation of the average purchase price as it takes into account only 
>the prices for the shares I actually own, assuming FIFO, of course.
>--
>Sent from: 
>https://nam03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgnucas
>h.1415818.n4.nabble.com%2FGnuCash-User-f1415819.html&data=02%7C01%7
>C%7C7a4b1647d8fb49ad0fa308d68c388322%7C84df9e7fe9f640afb435aaaaaaaaaaaa
>%7C1%7C0%7C636850571671394911&sdata=d4MJb%2FQ%2FRqsaKh69kz7G2HxFy2O
>7wZ4PYjsztwMykTM%3D&reserved=0
>_______________________________________________
>gnucash-user mailing list
>gnucash-user at gnucash.org
>To update your subscription preferences or to unsubscribe:
>https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists
>.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=02%7C01%7C%7C
>7a4b1647d8fb49ad0fa308d68c388322%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1
>%7C0%7C636850571671404917&sdata=%2FnWyjr5No27KGsXf2Q2Pe81KG8EzwZyQc
>QlpL%2Bcz4YA%3D&reserved=0 If you are using Nabble or Gmane, please 
>see
https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnuca
sh.org%2Fwiki%2FMailing_Lists&data=02%7C01%7C%7C7a4b1647d8fb49ad0fa308d6
8c388322%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636850571671404917&amp
;sdata=U%2BQTH1ogqmxcApdhboDu3x5AVNv0I051Uuc%2FxEE9Zmo%3D&reserved=0 for
more information.
>-----
>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 at gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnuc
ash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=02%7C01%7C%7C7a4b1647d8
fb49ad0fa308d68c388322%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C63685057
1671404917&sdata=%2FnWyjr5No27KGsXf2Q2Pe81KG8EzwZyQcQlpL%2Bcz4YA%3D&
reserved=0
If you are using Nabble or Gmane, please see
https://nam03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnuca
sh.org%2Fwiki%2FMailing_Lists&data=02%7C01%7C%7C7a4b1647d8fb49ad0fa308d6
8c388322%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C636850571671404917&amp
;sdata=U%2BQTH1ogqmxcApdhboDu3x5AVNv0I051Uuc%2FxEE9Zmo%3D&reserved=0 for
more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.