Book Cost for funds with occasional sells

someone

The funds in my S&S ISA have been transferred multiple times over the years (Fidelity > Charles Stanley Direct > Vanguard Investor > Lloyds) but held the same underlying funds. I have records for all the transactions and wanted to calculate the book cost. The idea been I can provide my current platform (Lloyds) the amount for each fund and I can finally have an accurate Profit/Loss calculation.

Simple if every transaction was a BUY but I have an occasional SELL, mostly for collecting platform fees. How do I correctly calculate the book cost for my current holdings?

kuratowski

Obviously this is just for your own satisfaction not to satisfy HMRC, but why not use the s104 pool method, which is what you would need to do in order to establish cost for CGT purposes if the funds were held outside a tax wrapper.

There is a tool here you can use.  Just pretend you are going to sell everything today and just look at the average price workings - obviously you can ignore the tax.

http://cgtcalculator.com/

ColdIron

You need to establish the weighted average cost per share/unit. Add up the total costs of all purchases (including stamp duty and transaction costs where they apply) and divide by the number of shares bought. Sales do not affect the cost of acquisition. Your current book cost is the weighted average cost per share multiplied by the current number of shares

eskbanker

someone said:

How do I correctly calculate the book cost for my current holdings?

There isn't a correct method as such, so you can choose!  The above pooling one is used by HMRC, as stated, but your own preferred policy could be FIFO, for example....