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….
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.