Stock Market Entries in TallyPrime as (Investment): 3 Easy Steps

Jan 16, 2024

—

by

Rishit Shah

in Difficult

To record stock market entries in TallyPrime as investments, you can follow these steps:

Table of Contents

1. Create Investment Ledgers:

Go to Gateway of Tally > Masters > Create > Ledger.
Create ledgers for each type of investment (e.g., Stocks, Mutual Funds, Bonds).
Set the Group to “Investments” or a sub-group within Investments if you have specific categories.
Optional: Set the Maintain Quantities option to “Yes” if you want to track individual shares and quantities.

2. Record Purchase Entries:

Go to Accounting Vouchers > Journal.
Select “Investment Purchase” as the voucher type.
In the “Party/Account” field, select the Investment ledger you created for the specific asset.
In the “Debit” field, enter the total amount invested.
In the “Credit” field, select the bank or demat account from which you made the purchase.
Enter the date and any relevant narration (e.g., Script name, Quantity purchased, Average price).
Save the voucher.

3. Record Sale Entries:

Go to Accounting Vouchers > Journal.
Select “Investment Sale” as the voucher type.
In the “Party/Account” field, select the Investment ledger for the asset being sold.
In the “Credit” field, enter the total amount received from the sale.
In the “Debit” field, select the bank or demat account where the proceeds were deposited.
Enter the date and any relevant narration (e.g., Script name, Quantity sold, Sale price).
Save the voucher.

If you encounter any specific challenges or have questions about your particular situation, you can contact me or comment below and I will help you.

Comments

2 responses to “Stock Market Entries in TallyPrime as (Investment): 3 Easy Steps”

Navin Patel

April 17, 2024

If I purchase Tatasteel 100 Qty at rate 100 and some charges like Rs. 500.Means Total Amount to be pais to angel is Rs. 10500 with all expense.

Then after week I sold it at Rs. 120 _ 100 Qty = 12000 and charges are like 400 Means I got Net 11600.
Means I make 1100 Short Term Profit.

How to make entry in Tally.

Reply
1. Rishit Shah
  
  April 18, 2024
  
  Tally Prime can’t directly track short-term capital gains, but you can record the purchase and sale transactions to see your profit. Here’s how:
  
  Purchase:
  
  1. Account: Shares
  2. Particulars: Tatasteel (or Investment account name)
  3. Qty: 100
  4. Rate: 100
  5. Charges: 500 (Debit this amount to an expense account)
  
  Sale:
  
  1. Account: Shares
  2. Particulars: Tatasteel (or Investment account name)
  3. Qty: -100 (Use negative quantity for sale)
  4. Rate: 120
  5. Charges: -400 (Credit this amount to an income account)
  
  Profit Calculation:
  
  Tally Prime will automatically track the movement in your investment account. You can calculate the short-term capital gain by subtracting the purchase cost (including charges) from the sale proceeds (including charges).
  
  In your case, Profit = (120 * 100 – 400) – (100 * 100 + 500) = Rs. 1100
  
  Note:
  
  Remember to choose appropriate expense and income accounts for recording charges.
  Tally Prime offers capital gains reports, but they might be designed for long-term investments. You can still use the purchase and sale records to assess your short-term gains.
  
  Reply