[GNC] Are there any add-on modules for Gnucash
I'm currently running Gnucash 3.3 under Windows 10. Currently I would need to do a large amount of manual entering/editing to record some investment transactions I require. Are there any add-on modules available that manipulate transactions and/or what programming language would be required for my setup? ___ 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.
Re: [GNC] Pension Fund
I also have asset accounts that tracked both personal and company pension plans. These I have keep and am withdrawing from them and depositing those as income into bank accounts. My personal pension plan is invested in mutual funds and as such have dividends, etc. required to be tracked to keep them current. The company pension plans is also being withdrawn and reducing to zero at which time the income will be designated as coming from an outside source other than the gnucash company pension plan account. -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+hfoerster=shaw...@gnucash.org] On Behalf Of rsbrux via gnucash-user Sent: Thursday, February 14, 2019 9:16 AM To: rsbrux via gnucash-user Subject: [GNC] Pension Fund I had created a couple of accounts to track the capital of (and contributions to) pension funds for myself and my wife. Now we are drawing pensions from those funds, but cannot calculate our benefits as a simple draw-down of the capital. I don't want or need the capital to appear in our accounting any longer. The only information I could find in the GC documentation about pensions pertains to U.S. tax reporting, but this is not relevant for me. What is the correct way to handle (i.e. zero out) these accounts? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7Cde7f76c1b98b421af17408d6928f84b1%7C84df9e7fe9f640afb435%7C1%7C0%7C636857542431902570sdata=CBGgKJoqXyyEmJMDsulyYPBkZN%2Fj%2Br8OlxHmmArPV%2B0%3Dreserved=0 If you are using Nabble or Gmane, please see https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7Cde7f76c1b98b421af17408d6928f84b1%7C84df9e7fe9f640afb435%7C1%7C0%7C636857542431902570sdata=31U%2Fbu43fSGN%2BHODhuv8k48FDuJA2mOitQVDB7P4Bb8%3Dreserved=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.
Re: [GNC] Transferring portion of mutual fund account to another fund account
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 On Behalf Of D via gnucash-user Sent: February 6, 2019 7:38 AM To: alen siljak@gmx. com ; Gnucash Users Subject: Re: [GNC] Transferring portion of mutual fund account to another fund account On February 6, 2019, at 2:10 PM, cicko 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.htmldata=02%7C01%7 >C%7C7a4b1647d8fb49ad0fa308d68c388322%7C84df9e7fe9f640afb435 >%7C1%7C0%7C636850571671394911sdata=d4MJb%2FQ%2FRqsaKh69kz7G2HxFy2O >7wZ4PYjsztwMykTM%3Dreserved=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-userdata=02%7C01%7C%7C >7a4b1647d8fb49ad0fa308d68c388322%7C84df9e7fe9f640afb435%7C1 >%7C0%7C636850571671404917sdata=%2FnWyjr5No27KGsXf2Q2Pe81KG8EzwZyQc >QlpL%2Bcz4YA%3Dreserved=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_Listsdata=02%7C01%7C%7C7a4b1647d8fb49ad0fa308d6 8c388322%7C84df9e7fe9f640afb435%7C1%7C0%7C636850571671404917 ;sdata=U%2BQTH1ogqmxcApdhboDu3x5AVNv0I051Uuc%2FxEE9Zmo%3Dreserved=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-userdata=02%7C01%7C%7C7a4b1647d8 fb49ad0fa308d68c388322%7C84df9e7fe9f640afb435%7C1%7C0%7C63685057 1671404917sdata=%2FnWyjr5No27KGsXf2Q2Pe81KG8EzwZyQcQlpL%2Bcz4YA%3D reserved=0 If you are using Nabble or Gmane, please see
Re: [GNC] Transferring portion of mutual fund account to another fund account
It seems this email request has gone sideways a bit. The actual transactions are being handled by the financial institutions accordingly and reported to me in statements. I fully believe their accountants are following the proper Canadian financial security laws. The crust of my request for assistance was how I could personally record these transaction into Gnucash; what steps or procedures does Gnucash have to allow the transfer, on the cost basis, of units between accounts in Gnucash. Any suggestions or hints on a path to follow is appreciated. -Original Message- From: gnucash-user On Behalf Of Michael or Penny Novack Sent: February 5, 2019 8:58 AM To: gnucash-user@gnucash.org Subject: Re: [GNC] Transferring portion of mutual fund account to another fund account On 2/4/2019 8:09 PM, David Carlson wrote: > If you are in the US and both funds are within the same custodial > account the answer is trivial, just sell one and buy the other. It > only matters when you withdraw cash. > > If you are somehow moving shares from one custodian to another, that > is more complicated. > > If they are non-custodial accounts ask your accountant. > > David Carlson > This (correct) answer points out that this was NOT a gnucash question but rather a question about how to account for a transaction of this sort no matter what was being used for the bookkeeping (even old fashioned pen and ink on paper). The problem with questions of this sort is that while many of us here do know the answer (and "allowed" to use that knowledge for our own books, few if any of us hold the "credentials" allowing us to advise others. That's why we have to say "ask your accountant". Michael D Novack ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnuc ash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7Ce56a3fc006 da4d11c64608d68b7a7976%7C84df9e7fe9f640afb435%7C1%7C0%7C63684975 5465077636sdata=xhU08OV4oFifkESEK51d%2FOY%2BB1wmHHdKXDib4Vxx%2B74%3D p;reserved=0 If you are using Nabble or Gmane, please see https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnuca sh.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7Ce56a3fc006da4d11c64608d6 8b7a7976%7C84df9e7fe9f640afb435%7C1%7C0%7C636849755465077636 ;sdata=0pPAgKPt%2B2xVBID7YueviGHqp8CUJW216kL3eQDr4nE%3Dreserved=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.
[GNC] Transferring portion of mutual fund account to another fund account
Hello I'm a recent user of Gnucash coming over from the Quicken world. I would like to get some guidance on how to properly transfer a portion of a mutual fund total units in account X into another mutual fund account Y. The transferred units from account X are taken out on a FIFO basis and into account Y maintaining the cost basis. This transfer is not a sale and purchase and as such does not involve capital gains or losses. I've looked at the concept of lots and scrubbing but I'm uncertain on how the transfer gets into the other account. Thanks ___ 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.