LIVE GST Certification Course by CA Arun Chhajer begins 27th April. Register Now!!

Creating Details in TALLY or EXCEL

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

Reply
Follow
Share

3 Replies

CA. Dashrath Maheshwari (TaXpert) (15090 Points)
Replied 05 June 2009

Dear Mr. Mishra,

This query was answered earlier, I'm replicating it here again:

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

1 Like