[GNC] Posting Sell Of Stock Automatically Calculating Wrong Number
Dr. Timothy B. Jones
tbj at timothybjones.net
Fri Sep 10 20:10:22 EDT 2021
John
Thanks for the response. The 1887.50 is the actual cost basis as reflected in the buy transaction. It is the amount that needs to be offset.
I didn’t realize those trading entries could be eliminated. Anytime my trial balance is off….they are usually my reason, so I watch these stock trades like a Hawk.
Interestingly, after getting your email, I logged back in and this time, GNUCASH took my entry without anything changing. In other words, it accepted it the way I manually entered it. And….trial balance is balanced.
Thanks!
tbj
Sent from my iPhone
> On Sep 10, 2021, at 6:46 PM, John Ralls <jralls at ceridwen.us> wrote:
>
> To make sure I understand what you entered I'll rewrite it as it might look in split view:
>
> 09/10/2021 Sell EVC 100
> SEP Brokerage Cash 1874.99
> Realized Capital Gain 12.51
> Fidelity:Pension:EVC -100 188.75 1887.50
> Fidelity:Pension:EVC 12.51
> Trading:NYSE:EVC 100 188.75 1887.50
> Trading:CURRENCY:USD 1887.50
>
> When I commit that transaction GnuCash changes it to
>
> 09/10/2021 Sell EVC 100
> SEP Brokerage Cash 1874.99
> Realized Capital Gain 12.51
> Fidelity:Pension:EVC -100 188.75 1887.50
> Fidelity:Pension:EVC 12.51
> Trading:NYSE:EVC 100 188.75 1900.01
> Trading:CURRENCY:USD 1900.01
> Imbalance-USD 12.51
>
> instead of reducing the stock value.
> The reason for the imbalance and the increased trading entries is the extra capital gain split in Fidelity:Pension:EVC. If you use the basis as the sale value then you don't need the split: With it you're counting the money twice.
>
> Regards,
> John Ralls
>
>> On Sep 10, 2021, at 3:39 PM, Dr. Timothy B. Jones <tbj at timothybjones.net> wrote:
>>
>> Hello
>>
>> I wasn't yelling...just trying to keyword to help.
>>
>> Yes, my last upgrade was from 4.5 to 4.6 (the latest version, I believe).
>>
>> Here is an example of a trade entered today:
>>
>> I enter a stock sale with a loss:
>>
>> SEP Brokerage Cash $1874.99 (DB)
>> Trading:NYSE:EVC $1887.50 (DB) This amount also represents the cost of the
>> security in the buy transaction. (GNUCASH calculated share price)
>> Realized Capital Gain $12.51 (DB)
>>
>> Fidelity:Pension: EVC $1874.99 (CR) (GNUCASH calculates share price, I
>> enter shares and amount)
>> Trading:Currency:USD $1887.50 (CR)
>> Fidelity:Pension:EVC $12.51 (CR)
>>
>> In this transaction, when I enter it (exactly as above) and save, the
>> software changes both $1887.50 amounts to also reflect $1874.99. In other
>> words, the transaction has that amount 4 times. I have entered it allowing
>> the software to create the accounts and I have entered it from scratch, but
>> both times it changes the $1887.50 amounts to also reflect $1874.99. The
>> auto calculations of share price seems fine and correct. I am not asking
>> about that....rather, something (I called it an automatic calculation but
>> perhaps not) is replacing the manually entered $1887.50 with $1874.99 and
>> thus my journal entry is not correct.
>>
>> I have literally hundreds of stock transactions over the 7 years I have used
>> GNUCASH. I cannot figure out why this one will not post as usual.
>>
>> To also clarify, I am not positive that this started with the upgrade. But,
>> it was my first stock loss entered since upgrading last weekend.
>>
>> Thank you in advance for any help. I am sorry you thought I was yelling.
>>
>> tbj
>>
>> Timothy B. Jones, Ed.D.
>> Author, International Speaker & Principal Consultant
>>
>> -----Original Message-----
>> From: John Ralls <jralls at ceridwen.us>
>> Sent: Friday, September 10, 2021 4:53 PM
>> To: Dr. Timothy B. Jones <tbj at timothybjones.net>
>> Cc: gnucash-user at gnucash.org
>> Subject: Re: [GNC] Posting Sell Of Stock Automatically Calculating Wrong
>> Number
>>
>> Please stop yelling.
>>
>> You don't say what you upgraded from and to; was it GnuCash 4.5 to 4.6?
>>
>> There has never been a setting to disable balancing unbalanced transactions
>> or ensuring that shares * price = buy/sell amount though in the latter case
>> GnuCash should pop a dialog asking which one you want changed. Trading
>> account entries are always calculated by the balancing code and as of 4.6
>> any existing trading account splits are deleted at the beginning of
>> balancing because trying to adjust them proved too hard.
>>
>> Can you provide an example (change the symbol of the security if you like
>> but please leave the numbers unchanged) showing the before-and-after
>> balancing entries, including number of shares/units, price, and value. It
>> would also be helpful to know the smallest fraction on the security account;
>> you'll find that in the account's edit dialog.
>>
>> Regards,
>> John Ralls
>>
>>> On Sep 10, 2021, at 11:34 AM, Dr. Timothy B. Jones <tbj at timothybjones.net>
>> wrote:
>>>
>>> Greetings:
>>>
>>>
>>>
>>> When I enter a stock SELL, the split is AUTOMATICALLY changing my
>>> entry for the TRADING account (by adding $1.00) and also the CURRENCY
>>> account (also by adding $1.00). Since the TRADING account entry
>>> represents the cost basis of the stock, adding a dollar not only does not
>> agree with the BUY entry, but
>>> it throws off my trial balance by the same dollar. No matter how many
>>> times I enter it (even from scratch) something is automatically changing
>> the
>>> value.
>>>
>>>
>>>
>>> I seem to remember there is a setting to prevent the software from
>>> AUTO calculating anything in the stock sale.but I CANNOT find it.
>>> Also..it was fine before I updated my version so I am guessing I have
>>> unset or changed a setting as part of the update process. However..I NEED
>> it to not
>>> auto-calculate. CAN ANYONE HELP?
>>>
>>>
>>>
>>> Thank you!!!
>>>
>>>
>>>
>>> Timothy B. Jones, Ed.D.
>>>
>>> Author, International Speaker & Principal Consultant
>>>
>>> 5172 Artemesia Lane
>>>
>>> Dallas, Texas 75209
>>>
>>> (214)252-0489
>>>
>>>
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at 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.
>>
>>
>
More information about the gnucash-user
mailing list