Preparing Statement in TALLY or EXCEL

Save Share

This query is : Resolved

Vijay Kr. Mishra (Querist)

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

chetan soni

chetan soni (Expert)

03 June 2009 see the reply to duplicate post.

CA. Dashrath Maheshwari

CA. Dashrath Maheshwari (Expert)

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

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now