Short sales in imported QIF files have the wrong sign

R E's Avatar

R E

23 Jun, 2020 12:50 AM

I'm new to MD and trying it out to move away from Quicken by importing a Quicken QIF into MD 2019.3. Infinite Kind support has helped with several credit card online challenges. Now I'm looking at my investment accounts. I noticed gigantic negative balances in the Register and read that one solution is just to insert an offsetting initial balance and not worry about how the register looks prior to today. Not ideal, but I'll consider it if that's the *only* practical approach.

But I see an issue that contributes to this problem, namely that short sales in investment accounts have reversed dollar values, IOW -$xx instead of +$xx. So if I sell ABC short, the balance in MD's register decreases by $xx whereas I believe it should increase by $xx (and indeed in the original Quicken account it does increase by $xx). Is there a way to re-reverse all these signs without combing through all the transactions one-by-one?

Thanks for any pointers.

  1. 1 Posted by dantdavis on 23 Jun, 2020 01:12 AM

    dantdavis's Avatar

    just a user here - Investment accounts are problematic in that the "final values" imported usually end up being correct as to cash assets and stock positions, but that the "cash change" imported is often incorrect, for many different types of transactions. I could list several, or you could search for a thread with the word "vicissitudes" in the title. to find many examples (I don't happen to do short sales, but you've now provided another example of the cash balance issue.)

    So, I guess the hardest work was to make sure the values as of "today" are correct, but no one has worried very hard to make the past cash balance history or net worth correct.

    So, yes, putting in an adjusting balance at the beginning of time, and then totally ignoring any cash balance from then till now, is practical, and somewhat easy.

    That said, it didn't satisfy me either, as I didn't want my 35 years worth of data to have wonky balances - I probably won't even be around in 35 more years.

    So - if you are willing to expend the energy - it took me weeks to massage my data to MD liking (not full time weeks, but I'm sure you get it) and yes, you can do it by groupings, and some things are fixable beforehand - so I'll let someone else answer your particular question.

    But unless we can get MD to expand the time and energy to make a QIF import that is aware of Quicken peculiarties, it's either adjust those balances and live with it, or take a lot of time if you value past cash balance values.

    Hope that helps a bit.

  2. 2 Posted by R E on 23 Jun, 2020 06:19 AM

    R E's Avatar

    Thanks for the helpful perspective, @dantdavis.

    I'm probably not up to expending vast amounts of time to eradicate the "wonky balances." And for this short sale anomaly, the register entry loses the name of the security as well, which increases the amount of work to fully repair each transaction.

    I can live with the initial balance adjustment trick for the time being, and move on to see if I encounter other troubling "vicissitudes." The fewer the better, because I dearly want to unshackle from Quicken.

    Thanks again for your input.

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