banner_ad

Purchase and sales of Shares entry in Tally

A/c entries 3580 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
22 May 2026
U.S. Financial Reporting & Consolidation Manager

Karia Overseas

Ahmedabad

CA

View Details
Company
22 May 2026
Sr. Financial Analyst - Consolidation

Search Synergy

Mumbai

CA

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
11 May 2026
Post office

Post office

Anakapalle

Others

View Details
Company
29 May 2026
Accounts assistant

Shubh Consultancy

Mumbai

Graduate (Any)

View Details
Company
08 May 2026
CHARTERED ACCOUNTANT

SHAH LADHA AND ASSOCIATE

Ahmedabad

CA

View Details
Company
29 May 2026
Company Secretary - Part time

Shaswat initial support private limited

Ahmedabad

CS

View Details