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
- Post Office RD Interest
- Reporting Income under Section 44ADA
- Itr 1 processing
- Building and other construction workers welfare cess act 1996
- ITR validation error - Balance sheet is not filled
- ITR 1: Details for showing Exempt Income
- Bank Accounts in Balance Sheet for ITR 3
- Annual return of gst limit
- TDS ON CASH WITHDRAWALS...
- Article ship defecit
- Eway bill for machinery reparing
- ITR 3 FILING OF AN INDIVIDUAL (PARTNER IN A PARTNERSHIP fIRM)
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- Difference in tax comparison report
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
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
