banner_ad

Purchase and sales of Shares entry in Tally

A/c entries 2043 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)


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details