Good that you've resolved the problem. Trading accounts are enabled and disabled on the first tab of File>Properties. You should make sure that it's disabled so that GnuCash doesn't create more trading accounts for you going forward.
Regards, John Ralls > On Aug 23, 2022, at 2:37 AM, aeg <aeg21212-fo...@yahoo.com> wrote: > > PROBLEM RESOLVED (I think) > > ----- Forwarded message ----- > From: aeg <aeg21212-fo...@yahoo.com> > To: john <jra...@ceridwen.us> > Cc: gnucash-user@gnucash.org <gnucash-user@gnucash.org> > Sent: Tuesday, 23 August 2022 at 08:45:51 BST > Subject: Re: [GNC] Recording stock holdings > > >> On Aug 21, 2022, at 11:30 PM, aeg via gnucash-user >> <gnucash-user@gnucash.org> wrote: >> >> I have been using GnuCash for about 6 years, starting with version 2.6 and >> now use 3.5 on a Windows 10 laptop. I like it very much, but have a >> persistent problem with entering stock investments. >> The day-to day financial transactions cause me no problems at all, but I've >> never been able to fully understand how stocks and shares are recorded and >> managed, and I'm frustrated that, despite following the tutorials very >> carefully, it never works for me as it does in the tutorial, so I hope >> someone can explain what's going on. >> I have a relatively small portfolio of shares that I've tried to enter, and >> the following example should illustrate the problems I've faced: >> >> Having set up the various accounts according to sections 9.4.1 and 9.4.2 of >> the tutorial, I then followed the instructions in section 9.5.1 to record 33 >> National Grid shares (NG.L) that were valued at 7.833030 GBP on 5/4/2019 as >> follows (note that I have used || to separate the columns): >> Transaction date: 5/4/2019Split 1: Brokerage Account:Stock:NG.L || 33.00 >> || 7.833030 || 258.49 ||Split 2: Equity:Opening Balances || || >> || || 258.49 >> However, when I press Enter, GnuCash seeks to make corrections and adds >> three more splits, leaving me with: >> Split 1: Brokerage Account:Stock:NG.L || 33.00 || 0.903030303 || 258.49 >> || Split 2: Trading:CURRENCY:GBP || || || >> 258.49 ||Split 3: Imbalance - GBP || || || >> 15,588,385,182,335.90 ||Split 4: Equity:Opening Balances || || >> || || 258.49Split 5: Trading:LSE:NG.L || >> || || || 15,588,385,182,594.39 >> Subtracting the large number in column 5 of split 5 from the large number in >> column 4 of split 3 equals 258.49, so why is it making any of these changes? >> > > On Monday, 22 August 2022 at 16:52:08 BST, john <jra...@ceridwen.us> wrote: > > It's creating the splits because you have trading accounts enabled on the > book, see https://wiki.gnucash.org/wiki/Trading_Accounts. I'd need to see the > rest of your book to figure out why the value of that split is so large. The > price change is strange too. > > Does it do that if you set up a new book and create just that transaction? > > What about upgrading to GnuCash 4.11? > > Regards, > John Ralls > > > > Thanks John. > > As far as I'm aware, all of my transactions are in GBP and I've never set up > any trading accounts manually, but they first appeared automatically when I > recorded my holding of Santander shares and added DRIP dividends. Although > that is a Spanish company, the shares and dividends are recorded in my book > in GBP. > > I set up a new book as you suggested, and was able to enter the transaction > without any problems, so when I returned to my current book, I decided to > delete the troublesome account and start again. This time, when I pressed > Enter, GnuCash inserted the trading account splits, but with a different set > of trading account numbers: 67,487,302.84 and 67,487,044.35. (Note that the > difference between those numbers is still 258.49) > > (Note also that I previously recorded other stocks in my original book > without problems. and without trading account splits) > > Regarding your suggested upgrade to GnuCash 4.11, I would normally have done > that by now but my last upgrade (to 3.5) resulted in the need for a > substantial amount of format tweaking to create the screen layout that works > for me, so I'm reluctant to rock the boat again unless I have to; (If it > ain't broke, etc...) > > Regards, > Alan G > > > > Dear John, > > After sending my previous message, I decided to delete the stock account for > the troublesome holding, as well as its associated trading account, then to > create a fresh stock account and re-enter transactions. That, I am pleased > (and relieved) to say, seems to have solved the problem and everything now > appears to be working correctly! > > It would be nice to know why the problem occurred in the first place, but at > least my chart of accounts now appears to reflect reality. > > Thank you again for your input. > > Regards, > Alan G > > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
