Investors & landlords

I am correlating your $100 with the Sales Proceeds on the Sales Worksheet column 3, as well as the 1099-B column 1d.  I'm correlating your $80 with the Sales Worksheet column 4 and 1099-B Cost or other basis column 1e.  In my case, that leaves a $3684.74 Realized loss.

 

Side note: There are 2 sales so I'm splitting everything for all calculations between them from the Sales Worksheet that only has the total values.  There HAS to be a better way.