Another Lot matching problem
G'day,
Seems like it is my week for problems sigh - the good news I think this is the last one (fingers crossed)
I have a security I need to use lot matching on. I've enabled lot match and have deleted all more recent sales, capital returns etc. Basically latter transactions are just dividend payment. I really don't want to have to delete all latter transactions, the transaction in question is from 2003!
All seems ok in the lot matching window I can enter the shares allocated and all looks well, click ok and window shuts but every time i go into this register the lot match window reappears. I read in one other post you have to pres enter after each share allocated amount is entered, so I try that. Alas exactly the same result.
This windows is getting to be extremely annoying, I do not really want to have to use average cost and fudge up a capital return to get the right number. that should not be necessary.
Des
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 dwg on 13 Dec, 2012 10:31 AM
Well I've worked out part of the problem I think. I take it back to the bare basics and it works as advertised. Then I enter a 0 value sell of a very small number of shares (0.0002) as shares have to be in whole numbers. This doesn't concern me I expect
rounding errors. I then have some capital return on the same account If i enter a sell of 0 shares with a $ value of the return then the lot-matching gets pretty unhappy and the window comes up every time.
I do not believe a sell/buy transaction is viable - you do not incur a capital gain at this stage and that is how this would appear. this just reduces your cost base for future transaction, nor is it correct to go back and change the original transactions, this would mess up other transfers.
What is the solution here?
Thanks
Des
2 Posted by dwg on 13 Dec, 2012 08:32 PM
I've reread john Prewitt's method of account for capital return and while it will work for a lot of situations - although let me say you do not use Financial mangement software to then have to do this much work in a spreadsheet - as i have mulltiple stock splits in the same security that does not turn out even and thus really requires a rounding entry to get back to a whole number of shares, this continues to throw out lot matching. Thus there would seme to be two issues here.
There needs to be a method in MD to allow for return of capital, in my part of the world this is not an unusual transaction. As well as companies using it for unneeded capital, they have also used it in situations like demergers and company spin offs (do it as a capital return and this is used to "purchase" shares in the spin off)
There needs to be a way in MD to allow entries for rounding adjustments to number of shares (all of the stock splits I have had have required an adjustment). FWIW Quicken allows for this with "Add" & "Remove" transactions types, pretty simple but effective - they are not considered as sales or purchases.
Both of these look to me to be pretty fundamental requirements for software handling investment transactions.
Des
3 Posted by dwg on 17 Dec, 2012 01:20 AM
G'day,
While this has not been posted for long I'm getting the impression, that these capabilities are not there. If this is the case for Add and Remove transaction I'm more than happy to write it up as a suggestion, with justification and why and how it would be used.
I've noted as indicated there have been discussions on Capital Returns, what is the best way to add another voice to this and also perhaps provide some additional justification?
Moneydance is a good product, i would not have spent as much time as I have on it if I did not think so, I just see some basic omissions for want of a better term.
Thanks
Des
4 Posted by Jon Hoover on 17 Dec, 2012 06:09 PM
Hi Des,
Sorry we did not get back to you sooner, there is an existing ticket requesting better functionality around return on capital. I've attached the ticket to this post, by attaching it to another post it increases its ranking in our bug/feature tracking system.
Thanks for the thoughtful feedback on this manner.
Sincerely,
Jon Hoover, Moneydance Support
5 Posted by dwg on 18 Dec, 2012 12:14 AM
Hi Jon,
Thanks.
I do not know how your ranking system works but from my perspective there is nothing more important than being able to record and classify transactions accurately and correctly, and not have them impact other transactions.
Well it looks like then I should at least do a suggestion on the Add/Remove share tranasction type. This transaction type would fix up a nasty problem that I'm seeing in some securities I own - the fixes I've had to do are fundamentally wrong but currently necessary to reflect the correct cost. Plus I see see another use for these.
I'll write it up in the next day or so and add it to suggestions.
Thanks
Des
6 Posted by Jon Hoover on 18 Dec, 2012 02:03 AM
Hi Des,
I agree that "there is nothing more important than being able to record and classify transactions accurately and correctly, and not have them impact other transactions."
The only thing is the application of that. There are various things that go on in the world of finance, banking, etc that Moneydance could record more accurately than it currently does. The trick is prioritizing what there is the greatest demand for and addressing those things first. This particular feature ticke has about a medium level ranking, so it does have a shot and it might not be right away that it happens.
Please do write up any suggestions you have and don't forget to post them on a new public thread. Giving people an opportunity to support their support for a feature helps us assess the demand for it.
Sincerely,
Jon Hoover, Moneydance Support
7 Posted by dwg on 18 Dec, 2012 02:36 AM
Hi Jon,
I certainly agree with doing those that impact the most first. I was thinking more in terms of doing the basics about transactions vs say nice things in reporting etc, so I was thinking in a pretty broad context.
For my other issue I've been looking at the transaction "Actions" and am up to looking at the last two Cover & Short.
Neither of these appear to have any impact like a Buy or Sell transactions does so they do not impact Lot matching. they raise an entry in the register you are in whch is what I'm looking for, but are they reflected anywhere else? So far I have not been able to find anything.
If they are not, they may present me with a solution. I'm not so much worried about transaction names, I'm more interest in the way they work.
Thanks for the patience.
Des
System closed this discussion on 31 Mar, 2015 03:57 PM.