Creating Details in TALLY or EXCEL

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

NICE