Presently, I do accounting on Tally ERP9 for stock exchange transactions i.e buying and selling of shares.In normal tally version their is not proper system for recording short term/long term gain/loss.Tally is not taking date-wise calculation for bifurcation of shot term/long term.My question is how to make entry of short term/long term gain/loss of shares in Tally ERP9.
Another one,I want to record opening stock of shares with quantity and date in Tally ERP9 .Let say,I wants to record Reliance 1000 Qty (200 on 15-2-2008, 300 on 16-8-2009 and 500 on 30-9-2010) in opening stock of 01-04-2011.My question is how to record opening stock with different dates in Tally ERP9.
20 July 2025
Great question! Managing share transactions and tracking short-term vs long-term gains/losses in Tally ERP9 can be tricky since it's primarily designed for accounting, not investment portfolio management. Here's how you can approach it:
1. Recording Shares as Stock in Tally ERP9 Create a Stock Item for each share (e.g., Reliance Shares). To record opening stock with different purchase dates and quantities: Unfortunately, Tally doesn't track batch-wise or date-wise stock by default for shares. You can create different batches (with purchase dates as batch names) to distinguish share lots. In Inventory Info > Stock Item > Alter > Batches, create batches like "Reliance_15Feb2008", "Reliance_16Aug2009", etc. Enter opening stock quantity for each batch separately on 01-04-2011. This helps maintain quantities by purchase dates but Tally won't automatically calculate gains/losses date-wise. 2. Recording Buy/Sell Transactions For buying shares: Use Purchase Voucher (or Journal Voucher) and select the appropriate batch to increase stock quantity. For selling shares: Use Sales Voucher (or Journal Voucher) and select batch to reduce stock. Make sure you always select the correct batch to maintain FIFO or specific identification. 3. Tracking Short Term / Long Term Gains and Losses Tally ERP9 does not have built-in capital gain computation. You have to calculate capital gains outside Tally (e.g., Excel or specialized software) using purchase date, sale date, and cost price. Once you calculate short-term or long-term gain/loss manually, pass adjustment entries in Tally: Create ledger accounts like "Short Term Capital Gain" and "Long Term Capital Gain". At the end of the period, enter journal vouchers to record the gain or loss under these ledgers. Summary: Task How to do in Tally Opening stock with dates Create batches with purchase dates as batch names and enter stock quantities batch-wise Buy/Sell shares Use Purchase/Sales voucher selecting appropriate batch Calculate Gains/Losses Calculate outside Tally, then pass adjustment journal entries Record Gains/Losses Use separate ledger accounts for short-term and long-term gains/losses Suggestion: For complex capital gains accounting, consider using specialized portfolio management software or Excel sheets alongside Tally for accounting.
CAclubindia
