Open Lots Report

[brookwood]

In the Open Lots report; it doesnot appear that Returns of Capital are being figured into the Value/ $ Gain field.

Here is my example:

Purchased 100 shares of Verizon on 2/20/08 at $38.288 with a $12.95 commission. Total Cost $3841.75. Recorded a Spin off of FRP on 3/31/08 as follows. shares 1.8859, market value 17.29, oop cost value 17.29, tax cost basis 15.84, date acquired 2/20/08.

Looked in Verizon and a Return of Capital of $15.84 is recorded as of 3/31/08. But in the Open Lots Report the cost basis of the Verizon has not been reduced. Although in the Open Lots Report a cost basis of $15.84 has been assigned to the FRP.

This causes the Open Lots report total to reflect an understaement of the gain by the $15.84.

Any suggestions?

[Mark]

Hi brookwood,

This is correct, the Open Lots report does not factor distributions into any of the "Open Value", "Value", or "Value Gain" fields. You can see their definitions here:

http://www.fundmanagersoftware.com/help ... nlots.html

Distributions are factored into the "% Gain" figure in that report.

You can find this information in a Custom report instead. It is for a whole investment (not per lot), but if you add the desired "Tax Basis (ending)" and "Tax basis unrealized gain (ending)" you will get the cost basis and gain/loss that includes the effects of the return of capital distribution. In your example, the Tax Basis for Verizon would be 3825.91 and for FRP it would be the 15.84, for a total basis of the original 3841.75.

The "Open Value" field in the Open Lots report is simply the purchase amount of that lot. I can see wanting it to show the tax basis, which would be different than the purchase amount when you've had a return of capital distribution or account fee. We can consider making this a report option.

[brookwood]

Mark

thanks for your prompt reply

i think it would be a usefull future inhancement