Lot-Matching Window only displays 5 available tax lots
Running Moneydance 2011r2 (803)
iMac with Mac OS X 10.7.4, 2.8 GHZ Intel Core i7, 8 GB 1067 MHz
DDR3
Problem description: The Lot-Matching window only displays the
first five (5) available tax lots. In my situation there are ten
(10) such tax lots as the Security Detail and Register windows
correctly display. So I always receive the "You have allocated an
incorrect number of shares." pop-up when I try to allocate the
shares. I have tried to enlarge the window in order to display more
transactions, but this has no effect.
Comments are currently closed for this discussion. You can start a new one.
2 Posted by -Kevin N. on 07 Jul, 2012 06:07 PM
Hi ursine1,
Can you provide a screenshot of the Lot Matching window?
-Kevin N.
3 Posted by ursine1 on 08 Jul, 2012 04:31 AM
Screen shot of Lot-Matching window. I enlarged the window, but only the first five (5) lots are displayed. My guess is that there is a bug that computes the number of lines to display based on the original display area (which is shorter.) Changing the window dimensions does cause the information to be re-displayed, but probably the calculation for the number of items is not correctly updated. Also, normally when there are more items to be displayed that will not fit, scroll bars would normally appear. (I used to be a programmer and back-line support at Sun Microsystems.)
Securities Detail correctly displaying all transactions:
4 Posted by -Kevin N. on 08 Jul, 2012 10:57 AM
Hi ursine1,
Your screenshot did not post.
I can not reproduce the issue that you are describing.
I've attached a screenshot of a Lot Matching Window with multiple lots showing that a scroll bar does indeed display to allow the user to view them all.
Keep in mind that only Sell txns are listed on the left side of the Lot Matching Window and the user must click on them individually so as to match them with the desired Buy txns on the right.
HTH -Kevin N.
5 Posted by ursine1 on 08 Jul, 2012 03:04 PM
I will attach screen shots rather than add them in line. Well, I guess the e-mail client still inserts rather than append.
I added a bunch of spurious "sell" transactions. Note that there are ten (10) available lots to match.
The default-size Lot-Matching window does indeed display scroll bars for both the sell transactions and the available lots.
If I scroll the available lots, only 5 are displayed even though there are actually ten (10). You can get an idea of how many transactions there are by the length of the darker area in the scroll-bar. The "shares sold" scrolls correctly to display all of the transactions.
When I enlarge the window to accommodate additional transactions, here is the result:
All of the sell transactions are displayed, but only the first five (5) of the available lots are displayed. In case this shot does not appear in the e-mail, here is another of the same thing:
I have a suspicion that the maximum number of available lots display will not exceed five (5). The "Total" and "Shares Remaining" parts of the window allocate space on the window.
To reproduce the problem, add or duplicate a number of available lots ("buys") so that there are more than five (5). Try re-sizing the Lot-Matching Window and watch how the window is re-drawn, including the scroll bars.
6 Posted by -Kevin N. on 08 Jul, 2012 03:31 PM
Hi ursine1,
Consider the Sell txn of 7678 shares on 26.05.2011. There are only 5 lots displayed because there are only 5 Buy txns that occurred prior to 26.05.2011 to match it to.
If you were to click on the last Sell txn listed in the left column, you should then be offered all of the available unassigned lots prior to 08.07.2012.
HTH -Kevin N.
7 Posted by ursine1 on 08 Jul, 2012 04:51 PM
Hi Kevin,
I agree that if I select (click) on the last "sell" txn listed in the left column of the Lot-Matching Window, then all of the available unassigned lots prior to 08.07.2012 SHOULD be offered. The following screen shot indicates that is not the case. Note that I have enlarged the default window in order to display all of the transactions without the need for scroll bars.
There is no way to have more than five (5) available lots to be offered. As I previously wrote, to reproduce the problem, add or duplicate a number of available lots ("buys") so that there are more than five (5). Try re-sizing the Lot-Matching Window and watch how the window is re-drawn, including the scroll bars.
Chuck
8 Posted by -Kevin N. on 08 Jul, 2012 05:16 PM
Hi Chuck,
I can't say for certain but this behavior may be due to creating the unrealistic situation of owning negative shares.
Those last 8 spurious Sell txns do just that.
What lots are displayed when you click on the 8,519.032 Sell txn for 27.01.2012?
-Kevin N.
9 Posted by ursine1 on 10 Jul, 2012 09:15 PM
Hi Kevin,
I did a lot of research and found that when I set up a separate test account and entered all of the transactions and everything was OK. So I went back to my real account and deleted the two "Sell" transactions. I then re-entered the first sale and allocated the shares successfully. I then re-entered the second sale and this time all of the "buy" (actually dividend reinvestment) transactions were displayed in the Lot-Matching Window. I was then able to successfully enter the all of the amounts and the window "cleared" correctly.
So I think the root problem was that all of the transactions up to July of last year were actually imported from a Quicken file. That included a number of "buys" before and after a single "sell". Normally when a "Sell" transaction is entered, the Lot-Matching Window appears. Of course in this case that was "old" imported data so no window appeared. Entering the second "Sell" transaction this year is when the problem occurred.
If this problem re-occurs, I know what to do: delete all the "Sell" transactions and then re-enter them in chronological order. Each time the transaction is re-entered, properly allocate the shares. I think other people who import old Quicken files which have a mix of buy/sell transactions, but still have some shares remaining might run into the same problem that I did when at a later date they sell more shares.
So you can go ahead and close this bug report.
Chuck
10 Posted by -Kevin N. on 11 Jul, 2012 02:06 AM
Hi Chuck,
You had piqued my interest with this issue. I too created a test data file with your exact entries and like yourself, was able to successfully lot match the Sells to all the Buys.
I think that we can chalk this up to the nefarious .QIF file format. From what I've read on these forums, the .QIF file format was never intended for data transfer. It was a troubleshooting tool for Intuit techs. There are variable standards for creating them which exacerbates the problem.
With so many different .QIF variations to contend with, I doubt that this is a solvable dilemma. It's something that will have to be logged and looked out for.
Thanks for posting back with your findings.
As the OP, you can close the thread by clicking the 'Close this Discussion' link in the upper right-hand corner of this thread.
-Kevin N.
ursine1 closed this discussion on 11 Jul, 2012 05:28 AM.
ursine1 re-opened this discussion on 11 Jul, 2012 05:38 AM
11 Posted by ursine1 on 11 Jul, 2012 05:38 AM
Hi once again,
I think that you should put in the knowledge base for those who import Quicken (.QIF) files to manually check for buy/sell share transactions. The US no longer allows the "averaging" method for computing income taxes, only the lot-matching method. People may have old data that needs examining. (Like I did.)
It is easy to look at the "security detail" to view all of the transactions for a particular security. With a screen snapshot of the details, Delete the "sell" transactions and re-enter them one-by-one, each time going through the Lot-Matching Window. Trust me, when you have 20 such transactions it seems like a daunting task. But in reality it is easy to rectify.
Chuck
12 Posted by -Kevin N. on 11 Jul, 2012 11:47 AM
HI Chuck,
I agree wholeheartedly that there should be a knowledge base article that points out the quirks, problems, errors, etc that having different variants of .QIF file format can cause.
The extent of this problem runs deep in that different versions of Quicken create different versions of .QIF files. Someone like yourself who may have imported from Quicken 2008 may experience the problem that you encountered whereas someone who imported from Quicken 2005 or 2010 may not. It's a bit of a crap shoot when it comes to .QIF files.
Full disclosure: I have no affiliation to Moneydance, Moneydance Support or help.infinitekind.com. These forums although actively monitored by the MD Support Staff are also home to a knowledgeable user base. I humbly include myself in the latter. :)
If I may make a suggestion, you should post to the 'Suggestions' forum and link to this thread to point out that there is yet another issue created by .QIF and that there should be a huge mention of the problems related to .QIF files in the knowledge base.
-Kevin N.
Ethan Tupelo closed this discussion on 16 Aug, 2012 08:09 PM.