docgarner
New Member

Investors & landlords

Create an excel spreadsheet like this

 

Columns:

(1)Asset

(2)Acquisition Date

(3)Cost/share at Acq

(4)GPIE Date

(5)GPIE Amount

(6)Price on GPIE Date

(7)Shares Sold

(8)GPIE Cost Basis

 

1: The stock symbol

2: The date you acquired some of that stock (must be sufficient to cover the GPIE sale, or else use next date forward); specific date is the first date if using first-in, first-out accounting, change as needed

3: The price/share (cost basis) that corresponds to the date in #2

4 and 5: Date and amount of GPIE sale from your 1099B form

6: Enter this formula: =STOCKHISTORY(A2,D2,D2,0,0,1)

A2 and D2 should refer to the stock symbol and GPIE date for that row and match the column orders I put here

7: Enter this formula: =E2/F2

(GPIE amount / Price on that day)

8: Enter this formula: =G2*C2

(Effective shares sold * Cost basis for all shares in the lot used to sell them)

 

Fill that spreadsheet with all the GPIE sales from your 1099B; don't worry about the Cost Basis Factor if you use this method; that's only needed if you can't figure this method out.

 

Take the values from columns 2 and 8 for each GPIE sale, using them to manually edit the "needs review" entries in TurboTax; helps to click "status" twice in the TurboTax table to sort all "needs review" to top.

 

Voila!  Cost basis complete.

 

Screen Shot 2022-04-10 at 3.34.16 PM.png