Negative stock values

tetrault's Avatar

tetrault

19 Apr, 2021 10:00 PM

Moneydance suddenly showed an $800,000 drop in my net worth. Investigation shows that old stock sales now have negative shares such as -1000 shares that sold at $50 a share for a cash value of the sale of -50,000. That reduces the value of the account by $100,000. This happened to several shares on the same launch. Naturally, Moneydance will not let me change the share numbers to positive. Putting in a duplicate entry and deleting the original one does not fix the problem. I had to create a duplicate entry of the sale using an earlier date.

How can this be prevented? Is there an easier fix than manually correcting each incorrect share number?

  1. 1 Posted by Stuart Beesley ... on 20 Apr, 2021 07:04 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    What version of MD?
    What os / version?

    It’s not entirely clear from your message what exactly is wrong. Perhaps you could lay out what the txn was originally and what it is now? Eg
    Original Sale qty 100 ($3000)
    Is now Sale qty ? ($6000)

    Perhaps a screenshot of the problem

    Or is the txn unchanged and the error is elsewhere?

    Did you change anything? Did you upgrade recently? Do you download these txns from bank?

    (Not support, just a fellow user)

  2. 2 Posted by Stuart Beesley ... on 20 Apr, 2021 07:47 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    I just checked mine and a Sell should show a positive qty and a positive cash result. Another useful input would be to right click the txn and show record / txn details and post that here too (along with the screen shot).

    (Not support, just a fellow user)

  3. 3 Posted by tetrault on 20 Apr, 2021 08:55 AM

    tetrault's Avatar

    Moneydance 2020.2 has changed the sign of shares bought or sold or the price of a share. Example: sell 100 shares at $20 per share. Moneydance can change this to -100 shares and enter -$2,000 instead of $2,000. Or it can change the transaction to 100 shares at -$20 per share and enter -2,000. My most recent bad entry resulted in the “loss” of more than $700,000 dollars.

    None of these changes can be fixed directly. The transaction can’t be corrected. Deleting the transaction and entering a new one doesn’t work. I entered a new transaction with an earlier date and deleted the bad transaction. That corrected the register balance, but the portfolio view retains the incorrect data. That is reflected in the net worth.

    I switched to a backup record account set, but somehow the bad data problem got passed to it even though the backup was older than the screwed-up transactions. Moneydance is being stubbornly wrong.

    Last year a Moneydance error added a million dollars to my net worth via a similar but not identical error. I fixed that problem but don’t remember how. Moneydance has made serious errors that are very hard to fix—not a good feature for a finance manager.

    I hoped that creating a new account set would allow me to fix the errors after importing the current account set. I exported my current account set (with 9 negative value stock transactions), created a blank account set, and imported the QIF file. The resulting new account set is screwed up beyond belief. The QIF was just as screwed up when I imported it into a demo version of iFinance 4. Moneydance is terrible at exporting. That’s nothing new.

    Greg Tetrault

  4. 4 Posted by Stuart Beesley ... on 20 Apr, 2021 08:59 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    Gosh. I’ve spent quite a bit of time looking under the covers of MD..

    Can you send a SS of a bad txn and also do the right click show record details and send that too so we can see?

    (Not support, just a fellow user)

  5. 5 Posted by tetrault on 24 Apr, 2021 06:17 PM

    tetrault's Avatar

    I described the transaction thoroughly. A sale of stock shows the share price as a negative of the actual price. (Ex: -450 instead of 450). The sale has a negative total. The errors are random. I can't fix them. What else is there to say.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac