Creating details in TALLY or EXCEL

Save Share

This query is : Resolved

Vijay Kr. Mishra (Querist)

03 June 2009 Dear Members,
I am Investing in Share Market and wants to make a Records in “TALLY” or “Excel” of my Trading / Transactions during the year to find out my Stock Position (Closing), Long Term Capital Gains / Loss, Short Term Capital Gains / Loss, Expenses Incurred, etc….

chetan soni

chetan soni (Expert)

03 June 2009 It is better if you prepare this in excel. With this we can have all the times flexibility to change the formats.

In tally you can not maintained few details like, no of shares in hand, profit of loss per transactions, long term or short term gains etc.

saurabh

saurabh (Expert)

03 June 2009 u can record in tally the records of ur investment in share market and for viewing the details in columnar form as well, but it will be a time consuming excercise to record it in tally.

Vijay Kr. Mishra

Vijay Kr. Mishra (Querist)

05 June 2009 Dear Sir,
Please draw a performa in excel to calculate Short Term Capital Gain / Loss on given Example :-

Purchase details : On 15 June 2008, X Purchases 100 Shares of TISCO For Rs. 12,000.00 ; at the time of purchase X pays : Brokerage Rs. 6.15; Transaction Charges Rs. 2.50; Stamp Duty Rs. 3.25; Service Tax Rs. 9.50; STT Rs. 18.00.
( Total Amount X pays for 100 Shares 12,000.00 + 6.15 + 2.50 + 3.25 + 9.50 + 18.00 = 12,039.40 )

Sales details : On 20 March 2009, X Sells 75 Shares TISCO For Rs. 10,875.00; at the time of Sales X pays : Brokerage Rs.5.25; Transaction Charges Rs.1.85; Stamp Duty Rs. 2.25; Service Tax Rs.7.50; STT Rs. 16.00.
( Amount Realised after paying Charges & Taxes: 10,875.00 - 5.25 – 1.85 – 2.25 – 7.50 – 16.00 = 10,842.15 )

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now