Catching up on investments

Ted's Avatar


31 Aug, 2018 06:29 PM

After about 5 years of not keeping MD up-to-date, I've decided to get my act together. During those years my investments have become more complicated, and I'm wondering if the more experienced users or support staff have a suggestion on how to proceed.

When I stopped updating, my wife had a single-security IRA. Since then we've switched her to a single-security Roth and now a managed multi-security Roth. We also have a joint managed mutual fund that has dozens (if not hundreds) of yearly buys and sells inside the portfolio.

While I have every checking statement, and therefore the exact price of each deposit to the funds in question, I do not have access to the years of missing internal fund transactions (buy/sell/dividend). I'd prefer not to enter them manually anyway, since there doesn't seem to be a way to import older investment transactions.

I know the current holdings and the last 90 days or so of specific transactions. Without ruining years of reconciled checking transactions, is there a way to get my investments showing the current holdings so that I can keep them up-to-date online from now on?

  1. 1 Posted by Ted on 02 Sep, 2018 07:00 AM

    Ted's Avatar

    What I've done as a work-around to entering years of transactions is to create new accounts to match the various portfolios at our bank. I setup each one to online banking and then downloaded the most recent transactions. Then, using the current holdings and total unrealized gain/loss shown on my bank, I made a dummy purchase in the past for (current shares - Moneydance shares) for a cost of (current value - unrealized gain). For example, after downloading dividend transactions Moneydance has the security UIEMX and shows I own 4.37 shares of it. I really own 461.883 shares and have an unrealized gain of $1000 (for the sake of argument). I enter a BuyXfr transaction in the past for 457.513 shares. I see what cost Moneydance calculates at today's share price, then subtract $1000 from it.

    This leaves me with the correct current shares/value and the amount of gain/loss. It's not accurate because the cost basis isn't properly determined, but I think it will be good enough to keep these investments tracking the right direction from now on. Now I just need to enter some dummy sellxfr transactions to clear out any remaining securities I no longer own. Whew!

  2. Support Staff 2 Posted by Tom Freeman on 13 Sep, 2018 07:47 PM

    Tom Freeman's Avatar

    I apologize for the late reply.

    What you describe in your second post is a good way to get the updated holdings.

    You can almost treat it like a new set up of an investment account.

    For each security you would make an initial purchase of the total current shares held and the total of the transaction being the cost basis of the holdings. You should be able to get the cost basis from your statement.

    After all your holdings are entered there will be a negative cash balance in the account. Go to account > edit account and put in an initial balance which will adjust the cash balance in the account.

    I know this is weeks late but if this was not how you set it up you can go back and edit that original set up transaction to the cost basis

    Tom Freeman
    Infinite Kind Support

  3. 3 Posted by Ted on 15 Sep, 2018 05:03 PM

    Ted's Avatar

    Thanks for the reply. I think my investment accounts are sorted out. Now the trick is to keep them up to date so that I don't fall into this again!

  4. Ted closed this discussion on 15 Sep, 2018 05:03 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? 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