Reconciling investments issues

Christopher Rath's Avatar

Christopher Rath

17 Apr, 2017 12:29 AM

I'm just switching from Quicken to Moneydance and this is the first month that I'm reconciling my investment accounts in Moneydance. The issue is that the Reconcile dialog box only provides information on 5 fields from each record: Date, Check#/Transaction Type, Description, C, and Amount (see attached screen shot). This doesn't allow me to use the Reconcile panel for non-cash transactions (e.g., ReinvDiv transactions) because I can't see the number of shares and the share price (or share total).

How can I add the missing columns to the Reconcile panel?

  1. 1 Posted by Tom Freeman on 17 Apr, 2017 02:09 PM

    Tom Freeman's Avatar

    I believe the intention of the reconciliation window in the investment account is to reconcile the checking associated with some investment accounts.

    A reconciliation function for investment activity could be useful and I will pass this on to the developers.

    Tom Freeman
    Infinite Kind Support

  2. 2 Posted by Christopher Rat... on 17 Apr, 2017 10:56 PM

    Christopher Rath's Avatar

    Hi Tom,

     

    Thanks for the reply. I don’t recommend the team do too much work on an investment reconciliation function. All I need is to be able to see the investment transaction details; that is, I don’t need Moneydance to try and mathematically reconcile the trades and dividends, etc. – although that would be nice it’s not essential.

     

    Regards,

    Christopher Rath

     

    Email: <mailto:[email blocked]> [email blocked]

    Post: 1371 Major Rd., Ottawa, ON, Canada K1E 1H3

    Canada Mobile: +1 (281) 638-1847

    Singapore Mobile: +65 8648 6035

    Web: <http://rath.ca/> http://rath.ca/

    Skype: christopher.rath.ca

  3. 3 Posted by Tom Freeman on 19 Apr, 2017 07:46 PM

    Tom Freeman's Avatar

    Have you tried running an investment transaction report.

    You can edit it to set the date range and which investment accounts to reconcile.

    Then you can check the transactions listed against the ones on your statement. If you need to edit the transaction in MD, just double click on the transaction in the report. This will take you to the transaction in the investment register.

    Tom Freeman
    Infinite Kind Support

  4. 4 Posted by Christopher Rat... on 19 Apr, 2017 11:56 PM

    Christopher Rath's Avatar

    Hi Tom,

     

    Yes, I’ve looked at that report, but it doesn’t offer me anything that I don’t already see in the register. In order to perform my reconciliation against the statement from my investment account, as I find and validate each entry I need to change its status to “reconciling” so that I can then close it out in the register. Doing that through the report just adds a level of indirection.

     

    Part of the value of using the reconcile dialog is that the toggle to reconciling is a single click or enter keypress; whereas doing this from the register requires a right mouse click and then navigating with the mouse to the “Mark as reconciling” option and another mouse click (much too wasteful of my time).

     

    Cheers,

    Christopher Rath

     

    Email: <mailto:[email blocked]> [email blocked]

    Post: 1371 Major Rd., Ottawa, ON, Canada K1E 1H3

    Canada Mobile: +1 (281) 638-1847

    Singapore Mobile: +65 8648 6035

    Web: <http://rath.ca/> http://rath.ca/

    Skype: christopher.rath.ca

  5. System closed this discussion on 20 Jul, 2017 12:00 AM.

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

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

Recent Discussions

29 May, 2024 07:01 AM
29 May, 2024 06:26 AM
29 May, 2024 02:38 AM
29 May, 2024 12:43 AM
28 May, 2024 11:59 PM