Purchase and sales of Shares entry in Tally

4735 views 1 replies

Hi Friends, I want to know how I can enter the sale and purchase of shares entry with the format of Qty. and Rate, for example. I have purchased 100 shares of XYZ. @ 75/- each, I want to show the Scrip XYZ with Qty. And for that purpose, what accounting head should I have to create under Inventory, and under which head does "Brokers Account" come? Please let me know. 

Replies (1)
Quick Summary
Explains how to record share purchase/sale in Tally with quantity and rate. Covers investor vs trader treatment, ledger creation, stock items, and broker accounting. Broker is treated as Sundry Creditor/Bank, not expense.

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

  • Name: XYZ Ltd.

  • Units: Nos

  • Group: Investments (or create a subgroup “Shares & Securities”)


4️⃣ Create Broker Ledger

Gateway → Accounts Info → Ledgers → Create

  • Name: ABC Broker / Sharekhan / Zerodha

  • Group: Sundry Creditors (if you get a contract note and pay later)
    OR Bank Accounts (if directly debited from bank)

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:

  • Brokerage

  • STT

  • Transaction charges

  • GST

  • Stamp duty
    (These can be entered as separate ledgers under Indirect Expenses – Share Trading Charges.)

Total amount = Investment value.


6️⃣ Sale Entry

Voucher → F8 – Sales

  • Party: Broker

  • Stock Item: XYZ Ltd.

  • Qty, Rate (e.g., 60 shares @ 90)

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

  • Stock-in-Trade – Shares

2️⃣ Create Stock Item

  • XYZ Ltd.

  • Units: Nos

  • Group: Stock-in-Trade – Shares


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)

  • Purchase Ledger: Share Trading Purchase

  • Stock Item: XYZ

  • Qty 100, Rate 75

  • Charges added to purchase value.


5️⃣ Pass Sale Entry (F8)

  • Ledger: Share Trading Sales

  • Qty, rate

  • Tally auto-adjusts inventory and computes trading profit.


📌 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)

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 27 June 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 28 June 2026
Article Assistant

Sharma Chetan And Company

Gurgaon

CA Inter

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details
Company
20 June 2026
Chartered Accountant

ANV & Company

New Delhi

CA

View Details
Company
ARTICLESHIP 27 June 2026
CA Articled Trainee And Paid Assistant

SKAA & Associates

New Delhi

CA Inter

View Details
Company
Featured 24 June 2026
HEAD - AUDIT AND TAXATION

A R JADHAV AND ASSOCIATES

Mumbai

CA Inter

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
22 June 2026
Finance Manager- Chartered Accountant

Triveni Turbine Limited

Bengaluru

CA

View Details