nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Mike16

Quicken Premier 2018 - Stock sale that closed on 1/3/18 - Not Showing on Cap Gains Report - How can I make it appear? I have checked and uncheck stock but without a change in the result. Any other ideas? Thanks!

Find more posts tagged with

Comments

UKR

Usually there is a delay of 3 - 5 business days before a stock transaction closes and the funds are deposited.
When exactly did the actual Sell transaction take place? That could have been 12/28/17 or 12/29/17, which means it applies to last year.

Mike16

Here is the additional information:
Quicken reports transaction date as: 1/3/2018
Charles Schwab has the stock settlement/close date was: 1/3/2018
Schwab is telling me this is income for 2018 - and - their Capital Gains information supports this.
Quicken did not capture this as income for 2017.

Any other ideas - please?

mshiggins

What is the date range of the report? Is the account where the stock sale occurred included in the report?

Mike16

The date range of the report is: 1/1/2018 through 8/11/2018. So, should have included this 1/3/2018 trade.

q_lurker

Is there a placeholder associated with the security?

If you edit the transaction, and choose to specify lots, what do you see?

Does the report customization include the relevant account? (As previously asked.)

Is the security included in the report customization settings? Especially be wary of similarly named securities.

Jim_Harman

Check that this security and account are included in the report.

Check that this is not a tax deferred account.

Mike16

Yes - this account is included in the report - just not the sale of this one security.

A sale in April 2017 of this same security from this same account did appear in the 2017 Quicken Capital Gains report.

Mike16

Thank you -
No - no placeholder.
No ability to specify lots - sale came from one purchase.
No issues with customized settings or security naming.
DARN!!

Mike16

Thank you for your suggestions!

Mike16

Thank you for your ideas.

Mike16

Thanks for your feedback!

Jim_Harman

Does the sale appear in the very similar Sched D report?

In case there was something squirrely about the transaction, you might try deleting and re-entering it. Do a backup first and make sure you copy down all the info about the original transaction - tax lots, etc.

UKR

Mike,
you edited your original post from

I'm not sure about tax implications of a Sale pending settlement across tax years.
AFAIK, if the sale actually took place on 12/27/2017 (I assume "2012" to
be a typo), then this sale should be reported as Gain/Loss for 2017. A Cap Gains report for Tax Year 2017 should have shown this transaction for as long as it was recorded with a Transaction Date of 12/27/17
If
you originally recorded this transaction in Quicken with a 12/27/17
date and later changed it to 1/3/18, there may be a Tax Year notation
under the covers in Quicken which says 2017 ... I'm just guessing here ...
So, assuming that Schwab is correct saying that this represents Gain/Loss for 2018 then you should delete and reenter this Sale transaction with a 1/3/18 date.

Does anybody know what the rules are for Sales straddling tax years?

Jim_Harman

Apparently it is usually the sale date, not the settlement date that determines the tax year.

https://www.bogleheads.org/forum/viewtopic.php?t=204058

Jim_Harman

also does this sale show up if you set the year to 2017, or is it completely missing?

q_lurker

Yes, normally the trade date is used for the cap gains determination (purchase and sale). As such, I always have the trade date recorded in Quicken as the transaction date.

Quicken does not have any provision (as far as I know) for having a tax year association different from the transaction date. If you change the transaction date from 2017 to 2018 or the other way, the cap gains reports (and Schedule D reports) should also adjust accordingly.

mshiggins

I usually go with however the 1099-B captures it.

Mike16

It does not appear on the Schedule D report.

Later tonight I will try to delete and add in manually.

Mike16

Thank you for your attention.

I edited my original data because I had made a mistake. The stock was purchased on 12/12/12. That was not the sale date. When I discovered my error, I corrected the information I included in my posted question. Transaction date was 1/3/18.

Mike16

Transaction date was 1/3/18. I edited my original data because I had made a mistake. The stock was purchased on 12/12/12. That was not the sale date. When I discovered my error, I corrected the information I included in my posted question. Transaction date was 1/3/18. This transaction does not appear on Quicken Schedule D, 1099-B or Capital Gains report. Quicken does show the sale under transactions.

Jim_Harman

Did you try deleting and re-entering the transaction?

Mike16

I will try that later tonight and let you know what happens. Thanks for your idea!

mshiggins

If that doesn't work, I think it's time to post some screen captures showing the sell transaction and the report customizations.

Mike16

I deleted the 1/3/18 sale transaction. When I tried to enter, I got a message saying that I didn't own enough of that stock to support the sale of 10 shares. In looking at the Holding Report it shows I own none of the stock while, case in fact, I do. (Just confirmed that by looking at a report from my Brokerage company - Charles Schwab.
On Quicken I am now running their file repair tool.

Fingers crossed!

Thanks again for EVERYONE's ideas and help!

Mike16

Update - NOPE didn't work. Quicken still does not show the correct number of shares I own for this stock - and - until it does, I cannot re-enter the Jan 2018 transaction. In looking at the transaction history for this stock in this account, there is not a logical reason and nothing showing that the shares left the account. The mystery gets deeper!

q_lurker

You indicated earlier you did not have any placeholders. Placeholders can be hidden. Make sure under your Edit / Preferences for Investment transactions, you have the selection checked to Show Hidden Transactions.

NotACPA

Also, when was the last time that you reconciled your investment account?

That is, compared, position by position, what your brokerage statement shows and what Q shows?

Bob_L

When you ran the validate routine, did you include the option to recalculate investment lots? If not try that.

Mike16

I have no Placeholder transactions - and - under your Edit / Preferences for Investment transactions, I have the selection checked to Show Hidden Transactions.

While Quicken shows I own none of this stock - dividends continue to be paid and credited based on the number of shares I do own - while not reflected in Quicken.

Thanks AGAIN for your thoughts, ideas and insights!!

Mike16

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