Creating details in TALLY or EXCEL

This query is : Resolved

Vijay Kr. Mishra (Querist)
Follow

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)
Follow

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)
Follow

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)
Follow

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

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

Manjunath J

Rahul Kulkarni

Badhri Narayanan

RAVINDRA KUMAR

kesav

Subscribe Now

Creating details in TALLY or EXCEL

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA