How to Update historical stock price for specific "Lots" ?

r-e-l
r-e-l Member ✭✭✭
edited November 2018 in Investing (Windows)
I have many transactions where my employer, part of benefits deposited stocks to my broker account. (every six month for many years - added a few).

What I didn't realize/paid attention at the time is that when the stocks were added, there wasn't a stock price. I assume because it was not traded however, for Tax reasons, I will need to report the value of the stock grant no matter how small it is.
For that, I guess I can use the close day value of the stock on the day of the grant.

So now the question is:
Can I go an edit (in an easy way as we are talking about ~ 100 lots) the price of the stock on the day it was given?

essentially for any "add" transaction that is missing a stock price, edit the per price value by the value of the close on that day.

thanks

Comments

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018
    QWin Premier subscription
  • r-e-l
    r-e-l Member ✭✭✭
    edited November 2018
  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018
    QWin Premier subscription
  • splasher
    splasher Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018

    -splasher using Q continuously since 1996
    - Subscription Quicken - Win11 and QW2013 - Win11
    -Questions? Check out the Quicken Windows FAQ list

  • Tom Young
    Tom Young Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018
  • r-e-l
    r-e-l Member ✭✭✭
    edited November 2018
  • r-e-l
    r-e-l Member ✭✭✭
    edited November 2018
  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    edited November 2018
    I agree with splasher, the total cost of the lot along with number of shares is what gets reported to the IRS for covered securities.



    Fidelity should have trade confirmations that provide the total cost for the lot.

    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the Quicken Windows FAQ list

  • r-e-l
    r-e-l Member ✭✭✭
    edited November 2018
  • Tom Young
    Tom Young Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018
    mshiggins said:

    I agree with splasher, the total cost of the lot along with number of shares is what gets reported to the IRS for covered securities.



    Fidelity should have trade confirmations that provide the total cost for the lot.

    The most accurate per share information is the per share "fair market value" used by the employer to determine the compensation income to include on your W-2:

    (# of shares received) x per share fair market value on date of issuance = Cost of the lot.

    I'd think you'd have been receiving statements with each delivery, from your employer, explaining all this.  But if you don't have anything in hand then the only way to get those lots' basis "close enough" is to look up the closing stock price, or maybe the average of the high and low for that day, or something else that you feel you could defend to the IRS.  (There's no "cookbook" formula that the IRS publishes for this.)

    You can always ask Fidelity if they have the information, and I'd think they would, at least for years before 2004(?)  (After 2004(?) the IRS is only required to report your "out of pocket" cost which for you is $0.)
  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    edited November 2018
    mshiggins said:

    I agree with splasher, the total cost of the lot along with number of shares is what gets reported to the IRS for covered securities.



    Fidelity should have trade confirmations that provide the total cost for the lot.

    Did you look at the trade confirmations?

    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the Quicken Windows FAQ list

  • Beijing Mac
    Beijing Mac Quicken Windows Subscription Member ✭✭✭✭
    edited November 2018
    just bite the bullet and start adding the share price, you've spent so much time looking for other solutions you could be done by now.  you are talking about a transaction 2 times a year.
  • r-e-l
    r-e-l Member ✭✭✭
    edited November 2018
  • q_lurker
    q_lurker Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited November 2018
  • mshiggins
    mshiggins Quicken Windows 2017 SuperUser ✭✭✭✭✭
    edited November 2018

    Quicken user since Q1999. Currently using QW2017.
    Questions? Check out the Quicken Windows FAQ list

  • r-e-l
    r-e-l Member ✭✭✭
    edited November 2018
This discussion has been closed.