security shares running total for reconciling
Am working on reconciling an investment account. A little bit OCD trying to trace down a miniscule security share (.0005) that is resulting in Portfolio View showing I own a security that I have sold.
I have used reconcile but that only works on the cash balance and this small share total is too small to affect. Register reconciles cash even though this amount is in error.
Question then - is there a way to show running share total in the register as a security is bought or sold? In Quicken this is available if you don't click on the register transaction. (Clicking on the register transaction shows the shares/price/resulting dollars, hides the security share running total). I can find no similar capability in Moneydance but perhaps I am missing something fundamental?
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 -Kevin N. on 07 Jan, 2019 11:49 PM
Hi jer,
Try generating an Investment Transactions report to see if it reveals anything.
It appears to show share quantities out to 4 decimal places.
-Kevin N. (not a member of MD support)
2 Posted by -Kevin N. on 07 Jan, 2019 11:54 PM
Hi jer,
Forget that. Right after I clicked 'Comment' I realized that isn't going to work.
What might work though is the Transactions report.
Generate the report based on the security in question.
The report has a 'Running Balance' column for shares. I'm not sure if it goes out to 4 decimal places though.
-Kevin N. (not a member of MD support)
3 Posted by John Roling on 14 Jan, 2019 11:07 PM
Was able to accomplish goal using export of transaction report to excell and adding accumulator column. Too much hassle for monthly “reconcile”. Really would like to suggest product improvement. Is a separate product improvement message required?
I would have two potential implementations to suggest. Both applicable to investment accounts only.
1) As part of reconcile, display resulting shares for each security at reconcile end date. Could be display only or could require acceptance.2) When register transaction highlighted display accumulated shares for that security only,at that date, in some side window.
Thank you for your assistance.
jer
Sent from Yahoo Mail for iPad
On Monday, January 7, 2019, 5:55 PM, -Kevin N. <[email blocked]> wrote:
#yiv2461698507 pre {width:92%;margin:10px 2%;padding:5px 2%;background:#efefef;border:1px solid #d6d6d6;}#yiv2461698507 blockquote {margin-left:0;padding-left:1em;border-left:5px solid #ccc;}
|
System closed this discussion on 15 Apr, 2019 11:10 PM.