Stock sale that closed on 1/3/18 - Not Showing on Cap Gains Report

q_lurker

Mike said:

Thank you - but - there was only one purchase of this stock - so - no multiple lots to select between.

Not sure who you are responding to with that comment.


If it was my earlier comment to edit the sale transaction, and specify lots, you are missing the point. By going to the specify lots page, you might see something about the lot that is or is not available. You might also see that the page properly computes the gain on the lot being sold.


If you are commenting about the rebuild investment lots during validation, you are again missing the point. Something is amiss and rebuilding all lots even if it is only one, might fix the one. What is the harm in following suggestions?

Mike16

Bob_L

Try stepping through the past by changing the date on the holdings view to see what it shows in terms of shares held. Also try selecting “all shares” instead of entering a number of shares on that second transaction that isn’t working.

q_lurker

Mike16

Mike16

Bob_L

Bob L said:

Try stepping through the past by changing the date on the holdings view to see what it shows in terms of shares held. Also try selecting “all shares” instead of entering a number of shares on that second transaction that isn’t working.

Schwab would not be adding a January transaction now. Did you instead get an indication that the shares in quicken did not match those held by

Schwab?

q_lurker

Bob L said:

Try stepping through the past by changing the date on the holdings view to see what it shows in terms of shares held. Also try selecting “all shares” instead of entering a number of shares on that second transaction that isn’t working.

May I please ask you to walk me through this?  

The Portfolio views (Ctrl-U) and holdings views (from the account transaction list) provide a selection box for the "As of" date.  Most views include the number of shares.  So by changing the As of date back through time, you can see how many shares Quicken thinks you have on any date. 

So by varying the date, you can see when the count of the shares goes haywire.  Th, what transactions took place on that date?  Ostensibly the date of the furst purchase should show the correct share quantity.  On the date of the split, the share quantity should adjust accordingly.

I will also add that an all-to-common source of the "not enough shares" message is the user choosing to sell the wrong security.  That could be due to having two very similarly named securities in Quicken, either correctly or in error.  The security list (Ctrl-Y) may help in that determination.   

Bob_L

Bob L said:

Try stepping through the past by changing the date on the holdings view to see what it shows in terms of shares held. Also try selecting “all shares” instead of entering a number of shares on that second transaction that isn’t working.

Maybe he did a 1 for 2 instead of a 2 for 1 split?

Mike16

Bob L said:

Try stepping through the past by changing the date on the holdings view to see what it shows in terms of shares held. Also try selecting “all shares” instead of entering a number of shares on that second transaction that isn’t working.

Bob - No indication now that Quicken and Scwab are not in balance - because they are in balance - now.  Quicken magic - nothing I did. However, the issue that the 1/3/18 sale still does not appear on 2018 Captial Gains, 1099-B, remains.

Quicken did capture the 7 for 1 stock split correctly.

Mike16

Bob L said:

Try stepping through the past by changing the date on the holdings view to see what it shows in terms of shares held. Also try selecting “all shares” instead of entering a number of shares on that second transaction that isn’t working.

q.lurker - Thank you for these directions.
As of last night - by some Quicken magic - Quicken and Schwab are in balance. 

I used the exercise you suggested and Quicken follows right along with what the total number of shares should be each step of the way - now.

Dare I try to delete the 1/3/18 sale transaction and try to manually enter it again?

What do you and Bob think?

Thank you both - so, so much!

Mike

q_lurker

Bob L said:

Try stepping through the past by changing the date on the holdings view to see what it shows in terms of shares held. Also try selecting “all shares” instead of entering a number of shares on that second transaction that isn’t working.

Dare I try to delete the 1/3/18 sale transaction and try to manually enter it again?

I think I would first

• make a backup,
• edit the existing sale transaction,
• choose the option to specify lots,
• click the FIFO option (or any other option actually), and
• see what that screen shows for Cap Gains.  

If everything looks correct (right CG value), save the edited transaction and check your report.

If there is a problem (wrong CG value or still bad CG report), I would:
Enter the same sale transaction the day before (1/2/18) and see if that takes correctly.  If so, then delete the 1/3/18 sale and redate the newly created 1/2/18 sale to the correct date.  (Effectively this is deleting and re-entering the 1/3/18 sale but you are sort of stepping through the process.)  

If still a problem, is there any prior date you can enter the sale (immediately after the split, or immediately after the original purchase)?  Obviously, you'll need to adjust dates on the CG report if you move the sale back to prior years.

Mike16

Bob_L

Please confirm that you ran the file validation and repair routine, choosing the option to rebuild investing lots (File, File operations, validate and repair, rebuild investment lots).

Mike16

Jim_Harman

Now that you have fixed the lots, you might try deleting and re-entering the sale agian

Mike16

Mike16

q_lurker

Mike16

Mike16

Jim_Harman

Are you *sure* there are no Placeholders for this security in this account?



Go to Edit > Preferences > Investment transactions and make sure Show hidden transactions is checked, then look for transactions with a gray background and an Action of Entry.

Mike16

Jim Harman said:

Are you *sure* there are no Placeholders for this security in this account?



Go to Edit > Preferences > Investment transactions and make sure Show hidden transactions is checked, then look for transactions with a gray background and an Action of Entry.

Jim - Thank you!

Yes - I just checked again (thanks for the step by step directions) - Show Hidden Transactions Box IS Checked.

Also - on the page where the final line is - Downloaded Transactions, Bill and Income Reminders and Placeholder Entries - all show (0).

q_lurker

Mike16