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
- REGARDING GST ON COMMERICIAL PROPERTY
- Is this income indian or foreign income?
- 15ca /15cb whose income tax login? remitter or nri seller's login?
- GST on export of services and Input Credit
- Regarding Documentation & Compliances for Opening of Unit of Pvt Ltd.
- TDS U/S. 194NF
- ITC temporary reversal and reclaim
- RCM applicability on Rent Paid by Registered Person to Unregistered Landlord for Residental Building
- Applicable TDS rate for sale of property in Nov 2024
- Donation Receipt u/s 80G
- MIS MATCH OF INVOICE NUMBER
- VERIFICATION OF REFUND RELATED
- GST Regis.
- ITC c/f from FY2022-23 to FY2023-24 entered the same in table 8C of GSTR9 of FY 2022-23, in FY23-24
- Late filling fees Demand by gst office
- IGST Credit-Show cause notice issued-confusion
- Short and Excess provision of expenses
- Issue of gst e invoice
- Interchangeable words in accounts
- Adjusted profit/Loss in the case of LLP and Pvt. Ltd.company
Trending Online Classes
CAclubindia
