Preparing Statement 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
see the reply to duplicate post.
05 June 2009
Dear Mr. Mishra,
First, create a company as "Accounts with Inventory" Option.
Create following ledger accounts in tally
1. Purchase of Shares A/c'
2. Sale of Shares A/c
(Open the above accounts under Purchase and Sale respy)
3. Speculation Purchase A/c
4. Speculation Sales A/c
(Open the above accounts as Direct Exps. or Income head. The head here will not make any difference as at the end of the year we will be netting off the two speculation account)
For Inventory of Shares follow following steps.
1. Open two groups:
i. Speculative Transactions Stock
ii. Delivery Based Transaction Stock
Mention each shares under two inventory groups by adding the same as stock item. CAUTION: Here make sure that you open two seperate accounts for the same stock if you are dealing in both Delivery Transactions and Speculative Transaction. E.g. Share of TISCO is defined in tally as TISCO - D and TISCO - S where D and S suggest that the entry in the inventory is for Delivery (D) and for Speculative (S) Transaction.
After above steps start entering entry BILL WISE only in JOURNAL mode.
At the end of the year close any one speculation account by transfering the balance to other speculation account. Balance either speculation profit or loss can be used for seperate reporting for Income Tax Purpose.
Hope this points will help you in accounting share transactions in Tally.
Regards,
**DM
First, create a company as "Accounts with Inventory" Option.
Create following ledger accounts in tally
1. Purchase of Shares A/c'
2. Sale of Shares A/c
(Open the above accounts under Purchase and Sale respy)
3. Speculation Purchase A/c
4. Speculation Sales A/c
(Open the above accounts as Direct Exps. or Income head. The head here will not make any difference as at the end of the year we will be netting off the two speculation account)
For Inventory of Shares follow following steps.
1. Open two groups:
i. Speculative Transactions Stock
ii. Delivery Based Transaction Stock
Mention each shares under two inventory groups by adding the same as stock item. CAUTION: Here make sure that you open two seperate accounts for the same stock if you are dealing in both Delivery Transactions and Speculative Transaction. E.g. Share of TISCO is defined in tally as TISCO - D and TISCO - S where D and S suggest that the entry in the inventory is for Delivery (D) and for Speculative (S) Transaction.
After above steps start entering entry BILL WISE only in JOURNAL mode.
At the end of the year close any one speculation account by transfering the balance to other speculation account. Balance either speculation profit or loss can be used for seperate reporting for Income Tax Purpose.
Hope this points will help you in accounting share transactions in Tally.
Regards,
**DM
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
- Itr 1 processing
- Off Market debit and credit transaction
- Showing Gift from relative in ITR for this year
- ITR returnFY25-26
- Short Term Capital gain on shares bought and sold after 2018 onwards
- INCOME TAX ON REDEVELOPEMENT OF FLAT
- Share accounting-->fifo - capital gain - period as per fifo?
- ITR 2 Short Term gain & Long term gain
- Form 10E u/s 89(1). Need clarification because experts opinions differ !!!!
- ITR selection for salaries and capital gain less than L
- ITR 1: Details for showing Exempt Income
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
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
