CGTax calculation spred sheet

#1
I have been trading through idirect for for last two yrs. The CGT is deducted at source for NRIs, while the losses are ignored and hence I must file returns to claim the same.

I would like help of someone who has been doing trading through idirect on how to use their trade book data for calculating the tax using spread sheet. The problem are more since the idirect changes the brokerage based on transaction and deduct / refunds some ammount after on month.

I have total 4000 trasactions to be accounted and hence it would be very difficult to do it manually.

I tried my calculation for few trades but the tax caculations do not match with the TDs certificate provided by idirect.

Any help on this would appreciated.
:confused:
 

Similar threads