Reconciling investments issues
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?
-
Untitled.png
152 KB
Untitled.png
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
1 Posted by Tom Freeman on 17 Apr, 2017 02:09 PM
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 Posted by Christopher Rat... on 17 Apr, 2017 10:56 PM
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 Posted by Tom Freeman on 19 Apr, 2017 07:46 PM
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 Posted by Christopher Rat... on 19 Apr, 2017 11:56 PM
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
System closed this discussion on 20 Jul, 2017 12:00 AM.