Manager - Finance and Accounts
58971 Points
Joined June 2010
Below is the correct and simplest method to record purchase and sale of shares with Qty & Rate in Tally ERP 9 / Tally Prime.
This works whether you are accounting as an investor (capital gains) or as a trader (stock-in-trade).
I will give both methods so you can choose what applies to you.
✅ FIRST: Decide whether shares are “Inventory” or “Investment”
Tally allows quantity tracking for both, but accounting groups differ:
| Situation |
Treatment |
Group |
| Investor (Long-term, capital gains) |
Shares are Investments, not stock |
Investments → Current Assets |
| Trader (Buying/Selling as business) |
Shares are Inventory (Stock-in-trade) |
Stock-in-hand → Inventory |
Most users who buy shares for investment should follow the Investment method.
I’ll explain both with steps.
-----------------------------------------
🅐 METHOD 1 — FOR INVESTORS (Most common)
-----------------------------------------
1️⃣ Enable Settings
-
Gateway of Tally → F11 (Features)
-
Enable “Maintain Accounts with Inventory”
-
Enable “More than ONE Godown” (optional)
-
Enable “Tracking of Inventory for Investments” (in some versions called Cost Tracking/Cost Category)
2️⃣ Create Ledger for INVESTMENT
Name: Investment in Shares
Group: Investments → Current Assets
Enable inventory values affected? ✔ Yes
(This allows you to enter Qty, Rate.)
3️⃣ Create Stock Item for Each Scrip
Gateway → Inventory Info → Stock Item → Create
4️⃣ Create Broker Ledger
Gateway → Accounts Info → Ledgers → Create
✔ Do NOT put broker under expenses.
✔ It is a party from whom you buy shares → hence grouped as creditor.
5️⃣ Purchase Entry with Qty & Rate
Voucher → F9 – Purchase
-
Party: Broker
-
Stock Item: XYZ Ltd.
-
Qty: 100
-
Rate: 75
-
Amount: 7,500
Add charges if any:
Total amount = Investment value.
6️⃣ Sale Entry
Voucher → F8 – Sales
Profit/Loss does not appear in sales ledger; Tally computes gain/loss based on FIFO automatically if tracking is enabled.
-----------------------------------------
🅑 METHOD 2 — FOR TRADERS (STOCK-IN-TRADE)
-----------------------------------------
Use this only if you are doing share trading as business.
1️⃣ Create Stock Group
2️⃣ Create Stock Item
3️⃣ Create Ledger
-
Share Trading Purchase → Group: Purchase → Yes, inventory affected
-
Share Trading Sales → Group: Sales → Yes, inventory affected
-
Broker Account → Sundry Creditors
4️⃣ Pass Purchase Entry (F9)
5️⃣ Pass Sale Entry (F8)
📌 Where does the BROKER account go?
✔ Sundry Creditors (if you settle later)
✔ Bank (if amount debited instantly)
Brokers are not expenses; they are your counter-party for the contract note.
🎯 Summary (Quick Guide)
| What to Do |
Where to Create |
| Share Scrip (XYZ) |
Inventory → Stock Item |
| Investment Ledger |
Investments (Current Assets) |
| Broker Ledger |
Sundry Creditors |
| Purchase Entry |
F9 – Purchase (Qty & Rate entered) |
| Sale Entry |
F8 – Sales (Qty & Rate entered) |