Home

Investment Account Lot Discrepancy

Unknown Member
edited May 2018 in
Hi,  This might be a bit complicated to explain, but here it goes....  In one of my investment accounts, I have a security.  Under the lot detail for the security I have the following six lots:  Lot Date       Shares  8/15/2002      11  2/15/2003      29  8/15/2003      24  5/15/2007       11  4/15/2008       8  5/15/2008       11  This totals  94 shares.  However the total (next to the security name) shows 110 shares (a difference of 16 shares).  The 110 is the correct number of shares (per my brokerage statement).  The problem is when I go to sell 27 shares (all with a purchase date of 8/15/2002) and specify lots, Quicken only shows 11 shares available.  The question is where are the other 16 shares?  How can I record the sale against the correct lot of 27 shares?  Thanks, Odyinpdx

Comments

  • Unknown Member
    edited February 2017
    You didn't complete your profile so I don't know what Quicken version you are using.Try looking at the security's Transaction History in the Security Detail View to see if you can determine the disposition of the 16 shares.i Select the account in the Account Bar, select the Summary/Overview tab and Click on the security.
  • Unknown Member
    edited July 2016
    Denis,    Thanks for the response.  I am running Quicken Deluxe 2007.    I was not able to locate the missing shares in the tranaction history .    What I did do is simulate various sales dates for the 27 shares I am now selling.  If I sell them as of 12/4/07, the 8/15/02 lot shows 27 shares available.  However, if I sell them as of 12/5/07, the 8/15/02 lot shows only 11 shares.    There are no other transactions on either 12/4/07 or 12/5/07.  Any ideas as to what might be happening?    Thanks,   Brian
  • Unknown Member
    edited February 2017
    >i I was not able to locate the missing shares in the tranaction history .Are you saying you do NOT see a Buy OR a Sell transaction in the transactions history for the 27 shares?>>Try Showing Hidden transactions to see if it helps.i Edit > Preferences > Quicken Programi click on Investment Transactions and check "Show hidden transactions"
  • Unknown Member
    edited July 2016
    Denis,    I do see the buy transaction for the 27 shares (on 8/15/02).    What I don't see is a sell transaction (or other share reduction) for the 16 shares that disappear between 12/4/07 and 12/5/07.     As I mentioned, if I go to sell the 27 shares with a transaction date of(or before) 12/4/07 I see 27 shares available from the 8/15/02 lot.    If I go to sell the 27 shares with a transaction date of(or after) 12/5/07 I only see 11 shares available from the 8/15/02 lot.    That said, I will look for hidden transactions and report back later tonight.    Thanks again for your help.   Brian
  • q_lurkerq_lurker SuperUser ✭✭✭✭✭
    edited May 2018
    Most likely, your file has been corrupted._ Validate the file though_File  File Operations  Validate.Less likely IMO:_ Recalculate the register._ Open the Investment account, Ctrl-Shift-Z.
  • Unknown Member
    edited July 2016
    Bingo.The validation process didn't help, but recalculating the register did the trick.Thanks a bunch.Brian
  • q_lurkerq_lurker SuperUser ✭✭✭✭✭
    edited May 2018
    Well that speaks volumes about my ability to predict what is more or less likely to work!_ <IMG src="/Images/e/smile.gif">Now with regard to your OP, what changed after the recalc?_ You listed out several lots that totalled to 94 shares instead of 110 shares._ Did one oe several of them gain the missing shares?_ I am presuming a new transaction did not show up, or did one?_ Can you tell how_the recalc changed your data presentation?_ Just curious.
  • Unknown Member
    edited July 2016
    On the account summary screen, the 8/15/02 lot gained the 16 missing shares (now says 27).  So now the sum of shares in each of the lots adds up to 110 (the number of shares on the summary line).    Also, when I go to sell the 27 shares on 8/8/08 (actual sale date), the 27 shares are available under the Lot detail.    I did not see a new tranaction.   Thanks again,   Brian
Sign In or Register to comment.