Capital gains report gross proceeds inconsistency

[modelerMike]

I generated a capital gains report and one security sale's
amount is inconsistent with the security's sale representation
shown in the Data Register for that security's sale transaction.

The inconsistency is not with the respective sales price used, it is because
the amount of the security sold differs in the capital gains report and
in the data register sale transaction.

Any suggestions as to what I should look for to reconcile
the gross proceeds as it is shown in the data register.

[Mark]

Hi modelerMike,

Some things to check:

1) Did the one sell transaction get split up into multiple lines in the Capital Gains report? This can happen when some sold shares were short term, and some were long. Also, it will be split up when using Wash Sale Rules, and you sold lots purchased from different dates.

2) Check that the sell value isn't different just because of any commission fees paid when selling the shares.

[modelerMike]

It looks like the discrepancy reflects a number of shares sold that was higher than the accumulated shares.

It looks as if the capital gains report will not sell any more than the shares available for sale.
I know the data register sale transaction is correct so I must have failed to load some reinvested dividend transactions.

Thanks for the guidance Mark

Regards,

Mike

[Mark]

Hi Mike,

Yes, that is correct. If you record a sell for more shares than you own, it will sell all the shares you own, and then it is like you opened up a short position for the remainder. Correcting any missing purchase (or reinvestment) transactions should fix the problem.