investment account suggestions

jer's Avatar


18 Jan, 2019 10:31 PM

Would like to offer product improvement suggestions for Moneydance particularly as related to investment accounts.
1) Reconcile of an investment account to its cash balance is not very useful as often cash is swept to a fund leaving reconcile to zero cash which becomes meaningless. Would like to be able to "reconcile" share quantity against statements.. This could be an indication of total share quantity for the security highlighted on the register (at the date highlighted, not last date); or could be a display of share quantities of each security held at the end of a reconcile period.
2) When acquiring data using OFX protocol it would be desirable for Moneydance to enter category information for long term and short term capital gains, not just call everything dividends.
3) An ability to adjust share quantity (and/or share price and cash balance) by a small amount would help. Sometimes an error is so small that its not worth struggling with reconcile, but because share quantity is nonzero the security is displayed as owned when it is no longer so.
4) Last is a bit OCD and may not be controllable by Moneydance, but on OFX update when there is a dividend followed by purchase of additional shares it would be nice if the dividend came first and the purchase second in the register.

Thank you

  1. 1 Posted by dwg on 18 Jan, 2019 11:08 PM

    dwg's Avatar

    I'm a fellow user.

    The OFX specification has no provision for Category information, so there is nothing in the downloaded date to give an indication.

    You can Create categories for Short Term Capital Gains and Long term capital gains and assign as appropriate.

    Within Moneydance you should not consider an Action type of "Div" as just meaning dividends it really should be taken to mean any regular investment return received and the category you assign determines what it is.

  2. 2 Posted by John Roling on 19 Jan, 2019 01:49 PM

    John Roling's Avatar

    Quicken does this.jer

    Sent from Yahoo Mail for iPad

    On Friday, January 18, 2019, 5:08 PM, dwg <[email blocked]> wrote:

     #yiv4374116440 pre {width:92%;margin:10px 2%;padding:5px 2%;background:#efefef;border:1px solid #d6d6d6;}#yiv4374116440 blockquote {margin-left:0;padding-left:1em;border-left:5px solid #ccc;}

  3. 3 Posted by John Roling on 19 Jan, 2019 02:03 PM

    John Roling's Avatar

    I think I have confused “actions” with categories. My intent was to add actions beyond “div” and “divreinvest”. Similar for suggestion about being able to adjust holdings - create new action.  Sorry.

    Sent from Yahoo Mail for iPad

    On Friday, January 18, 2019, 5:08 PM, dwg <[email blocked]> wrote:

     #yiv4374116440 pre {width:92%;margin:10px 2%;padding:5px 2%;background:#efefef;border:1px solid #d6d6d6;}#yiv4374116440 blockquote {margin-left:0;padding-left:1em;border-left:5px solid #ccc;}

  4. 4 Posted by dwg on 19 Jan, 2019 08:25 PM

    dwg's Avatar

    Some of the extra actions that Quicken has forces what category to be used.

    I'm not sure this is necessarily a good thing to do because in different countries there are different requirements. For example where I am Capital gains have 4 different categories.

  5. 5 Posted by avp2 on 23 Jan, 2019 06:06 PM

    avp2's Avatar

    An action I would like to see is "transfer shares" between accounts without a sell, and corresponding buy.

    A share count reconcile function that works within a single page (either register or security detail) would be welcome though.

  6. 6 Posted by avp2 on 18 Feb, 2019 08:52 PM

    avp2's Avatar

    A little more register ordering accuracy for transactions done on the same date would also be nice. Maybe using the transaction time stamp or a move up/down user function that would stick between any register re-ordering date sort.

  7. 7 Posted by Robert Miller on 14 Mar, 2019 05:58 PM

    Robert Miller's Avatar

    I’m really loving Moneydance on Mac, iPad and iPhones. One needed addition is to have investment accounts show on the mobile versions. Unless I’m mistaken, I don’t think that’s happening in the current versions. Am I right or just not aware of a way to do that, or maybe it’s already in the works?

  8. 8 Posted by dwg on 14 Mar, 2019 08:45 PM

    dwg's Avatar

    I'm a fellow user.

    You are not mistaken, the current version of the mobile app does not support investment accounts.

    The history of the mobile app, explains why. The app was originally devised in times of earlier smartphones, smaller less functional, limited screen space. The intention of the app was limited to providing a way of simply entering transaction data on the go hence the inclusion of only Credit Card and Bank accounts.

    There has been talk about a full version of Moneydance for tablets, I doubt if that is trivial as I do not think there is complete Java support for the OS that many of these devices use.

  9. 9 Posted by Robert Miller on 15 Mar, 2019 05:25 AM

    Robert Miller's Avatar

    Thank you dwg! I thought that was the case but wanted to make sure I wasn’t missing anything. I can certainly see the challenge of porting over everything MD does to fit into IOS devices. Great tool regardless. Thanks again.

  10. 10 Posted by richard.mourino on 20 Mar, 2019 04:34 PM

    richard.mourino's Avatar

    My Investment vendor allow OFX downloads and within the ofx file are Price for the day. You system does not seem to use that information to update prices only the transactions. It would be great if the file is an OFX grab the information and update the investment prices. I invest in Bonds only so I wrote a python script that extracts in a qif format price updates that I apply to my investment accounts and it works very well as long as the ticker symbol is the bond cusip number which mine are. If I had a stock unit I could see what is there in the ofx file but as I said i only invest in bonds. The stock extension does not support bonds so I wrote my own. But you should add this feature into your system. I have attached my python script for those who may need it and for your developers to review and see if you can add this feature in to your next release. If the data is there in the OFX file use it if you can.

  11. System closed this discussion on 19 Jun, 2019 04: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

Recent Discussions

14 Jul, 2024 11:01 PM
14 Jul, 2024 10:58 PM
14 Jul, 2024 10:32 PM
14 Jul, 2024 10:28 PM
14 Jul, 2024 09:49 PM