Capital Gains Tracking in India: Lots, Cost Basis, and Clean Records
Tax outcomes depend on facts: purchase dates, costs, and which lots you sell. Here is an educational framework for tracking capital gains inputs in India — not tax advice.
Why capital gains tracking is a data problem first
In India, capital gains on equity and mutual funds generally depend on how long you held a position and what you paid for the units you sold. Before any discussion of rates or exemptions, you need reliable facts: buy dates, quantities, acquisition cost, sale proceeds, and which lot was closed.
Capital gains tracking is the discipline of preserving those facts across brokers, folios, and corporate actions. Spreadsheets that only store “average price today” often fail when you sell part of a holding bought over many SIPs.
This article is educational only. Tax law changes, exceptions, and your facts matter. Treat every example as a concept — verify filing positions with a Chartered Accountant or qualified tax professional. Capitallytics does not provide tax advice or file returns for you.
LTCG and STCG at a high level (concepts, not advice)
Investors commonly hear two labels: short-term capital gains (STCG) and long-term capital gains (LTCG). In broad educational terms, the holding period threshold and the applicable rules can differ by asset type (for example listed equity versus many mutual fund categories) and by the law in force for the relevant financial year.
Do not memorize a rate from a blog post and apply it blindly. Rates, exemptions, grandfathers, and special cases have changed over time. Use official sources and your CA for the year you are filing.
Your tracking system’s job is narrower: show acquisition date, cost, and sale details clearly enough that someone competent can classify the gain correctly under current rules.
| Data to preserve | Why it matters | Typical source |
|---|---|---|
| Trade / allotment date | Holding period starts here | Contract note, fund statement, CAS |
| Quantity | Partial sales need lot math | Broker / RTA records |
| Acquisition cost (incl. charges if you track them) | Gain = sale − cost (conceptually) | Contract notes, SIP confirmations |
| Sale date & proceeds | Closes the lot; sets the gain period end | Sell contract note / redemption |
| Corporate actions | Splits/bonuses change quantity & cost per unit | Exchange / fund notices |
| Folio / demat identity | Prevents mixing unrelated lots | CAS, broker holdings |
Why lot history beats a single average price
SIPs create many small lots. Selling “100 units” is not the same economic or tax event as selling the oldest 100 units versus the newest 100 units — depending on how lots are identified for that product and what method your records support.
A single blended average cost helps performance intuition but can obscure which purchases are long-held versus recent. When statements and broker exports disagree, lot-level reconciliation is how you find the gap.
After bonuses, splits, or mergers, per-unit cost changes even if your total invested capital did not. Update lots when the corporate action lands; waiting until March invites filing season chaos.
Equity, mutual funds, and multi-broker reality
Listed shares in demat and mutual fund units in folios may appear in different apps. Capital gains tracking still needs one coherent ledger of purchases and sales. Export contract notes and CAS/account statements; do not rely on memory of “I bought around 180.”
Switching brokers or platforms does not erase history. Transfer and rematerialization events should preserve acquisition cost and date where applicable — confirm with statements rather than assuming the new app’s average is complete.
Overseas holdings add FX and foreign-tax complexity. Keep separate, detailed records and involve a professional; do not assume domestic equity shortcuts apply.
Performance returns are not the same as taxable gains
XIRR and CAGR answer “how did my money work?” Taxable capital gains answer “what happened on closed lots under tax rules?” You can have strong XIRR while realizing short-term gains, or harvest gains in a year that interacts poorly with your income slab.
Use return guides for investing process — how to calculate portfolio returns with XIRR, and calculating mutual fund XIRR — and keep tax lot records as a separate discipline. Mixing the two produces false comfort.
The income tax calculator on Capitallytics can help you explore slab arithmetic at a high level; it is not a capital-gains engine and not advice for your return.
A practical record-keeping workflow
Monthly: import or download trades and SIP allotments; confirm quantities match holdings. Flag missing costs immediately.
After every sale or redemption: store the contract note or statement PDF; note which lots you believe were closed. Do not wait until you forget the rationale.
Before filing season: export a clean transactions history for your CA, including corporate actions. Ask them how they want lots presented — then match that format.
What Capitallytics is — and is not — for tax season
Capitallytics helps you track portfolio holdings and performance context. It is not a tax-filing product, not a substitute for AIS/TIS reconciliation, and not personalized tax advice.
If a screen shows gain-like figures, treat them as estimates that depend on your imports being complete. Your CA and official broker/fund tax reports remain authoritative for filing.
Educational reminder: laws and forms change. Verify everything material with a Chartered Accountant before you act on numbers from any app or article — including this one.
Start Free Tracking
Unified multi-asset portfolio analytics, live NSE/BSE prices, and AI investment intelligence — free to start.
Read-Only Access
Strict read-only layer endpoints. Your capital cannot be touched or transferred.
Bank-Grade Encryption
AES-256 bit end-to-end encryption protecting your asset data.
Data Privacy Secured
Zero data selling. No ad-networks. Fully isolated rows.
Secure Auth
Industry-standard secure authentication protocols.