My brokerage house provides me one such report. But it is mainly a LIFO kind of a report where the selling price of last bought shares of a particular scrip are taken into account for calculation.
For Eg: Scrip A - Bought 100 shares in 2010 for Rs10
Scrip A - bought 200 shares in July 2013 Rs20
Scrip A - sold 100 shares in Aug 2013 Rs23
so, in the report the p/l is calculated as (100 * 23) - (100 * 20)
whereas it should have been (100 * 23) - (100 * 10)
I have ended up in manually calculating the whole P/L. Though the ledger shows the expected P/L. I have contacted my brokerage house but I was told that in the reports it would always be LIFO but the actual calculation would be FIFO.
Is it the same case with your brokerage houses too? If that is the case, it is such a tedious job to do the whole calculation. I spent ~1 hour for that whole calculation. What is your say about this?
For Eg: Scrip A - Bought 100 shares in 2010 for Rs10
Scrip A - bought 200 shares in July 2013 Rs20
Scrip A - sold 100 shares in Aug 2013 Rs23
so, in the report the p/l is calculated as (100 * 23) - (100 * 20)
whereas it should have been (100 * 23) - (100 * 10)
I have ended up in manually calculating the whole P/L. Though the ledger shows the expected P/L. I have contacted my brokerage house but I was told that in the reports it would always be LIFO but the actual calculation would be FIFO.
Is it the same case with your brokerage houses too? If that is the case, it is such a tedious job to do the whole calculation. I spent ~1 hour for that whole calculation. What is your say about this?