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...@gnucash.org> On Behalf Of D via gnucash-user Sent: February 6, 2019 7:38 AM To: alen siljak@gmx. com <alen.sil...@gmx.com>; Gnucash Users <gnucash-user@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.sil...@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@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& ;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@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& ;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@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists 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.