Creating details in TALLY or EXCEL
This query is : Resolved
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….
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….
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.
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.
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.
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 )
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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Reopen of assessment proceeding
- TDS on Consultancy- Non DTAA
- Depreciation of fixed assets- coop housing society in mumbai
- COMMERCIAL INVOICE FOR MATERIAL AND FREIGHT
- Gift Received from nonblood relative
- Management System (IMS)
- Foreign lottery ticket bought online from India: legality, tax and consequences
- Reprocessing of rectification order AY 2025-26
- FTS Taxable under 115A
- Tax Audit u/s 44AB for Transport Business A proprietorship is engaged in transportation business and
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- STATUTORY AUDIT OF A SMALL PRIVATE COMPANY INCORPORATED ON 28.03.2025
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
- How to pay remaining amount of TDS after due date?
- Resigning a auditor from the company for misconduct
- RCM @ 5% on Hamali charges, Transport Charges, Unloading charges we take ITC or not
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
