Tracking cost basis's Avatar

05 Mar, 2021 06:18 PM

I have donated shares of a mutual fund the charity. The shares were acquired at different times over the years. I need to track which shares have been donated to know my current cost basis for future transactions. On the Securities Detail page there is a clear history of my purchases and sales or transfers. I would like to export that information to a spreadsheet where I can track which shares I have donated and which i retain, but I can't find a way to do that. Right next to that listing is a greyed out button marked "Download" but it doesn't work.

Any suggestions? Thanks

  1. 1 Posted by dwg on 05 Mar, 2021 08:18 PM

    dwg's Avatar

    I'm a fellow user.

    The cost basis report should show each individual purchase transaction and can be exported.

    If you need to identify specific shares that are sold it sounds like you may need to use Lot Matching in Moneydance to determine costs.

  2. 2 Posted by rcoffman@sprint... on 06 Mar, 2021 02:01 PM's Avatar

    Thanks DWG, I had overlooked the Cost basis report by goiing directly to investments. I was able to solve the immediate problem that i posted.

    You mention Lot matching in Moneydance. I expected that I would have to do that manually. I am unable to find any mention of lot matching in my version of Moneydance 2021.1 Apparently, the Cost Basis report uses average price to calculate cost basis for individual transfers of shares.

    Is lot matching a function I should be able to find within Moneydance?

    Thanks again for your fast and helpful answer to my original question.


  3. 3 Posted by Stuart Beesley ... on 06 Mar, 2021 02:10 PM

    Stuart Beesley (Mr Toolbox)'s Avatar

    Within the investment account. Top right. Securities. Select your security. Edit. Select lot matching (or whatever it’s called). You will then need to match your buyssells in the pop up window.

    (Not support, just a fellow user)

  4. 4 Posted by rcoffman@sprint... on 06 Mar, 2021 03:39 PM's Avatar

    Thanks for your quick answer. I have created a spread sheet to understand the complexities of splitting lots an will have to study to see which way is the easiest. Itis always nice to learn that the product you have been using has more capability than you previously knew.


  5. System closed this discussion on 05 Jun, 2021 03:40 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