Capitallytics official logo — blue and purple 3D translucent crystal AI CFO iconCapitallytics
Guides12 Aug 202613 min readBy Capitallytics · Capitallytics Editorial

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.

Educational checklist of data fields — not a tax classification guide
Data to preserveWhy it mattersTypical source
Trade / allotment dateHolding period starts hereContract note, fund statement, CAS
QuantityPartial sales need lot mathBroker / RTA records
Acquisition cost (incl. charges if you track them)Gain = sale − cost (conceptually)Contract notes, SIP confirmations
Sale date & proceedsCloses the lot; sets the gain period endSell contract note / redemption
Corporate actionsSplits/bonuses change quantity & cost per unitExchange / fund notices
Folio / demat identityPrevents mixing unrelated lotsCAS, broker holdings
Educational checklist of data fields — not a tax classification guide

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.

Article FAQ

Is this article tax advice for my capital gains in India?
No. It is general education about record-keeping and concepts. Your facts, product types, and the law for the relevant year determine tax treatment — confirm with a CA.
Why does cost basis matter for capital gains tracking?
Gain estimates need what you paid for the units you sold, not only today’s market price. Incomplete cost basis makes holding-period classification and gain math unreliable.
Can I rely on one broker’s tax P&L for my whole portfolio?
Only if that broker holds every relevant lot — which is uncommon if you use multiple platforms or mutual fund folios. Consolidate records across sources before filing discussions with your CA.
Does Capitallytics file my taxes or compute final LTCG/STCG?
No. Use it for portfolio tracking and awareness. Final computation and filing should follow official statements and professional guidance.

Capitallytics provides financial data tracking analytics tools for informational purposes only. This does not constitute personalized financial advice.

Read-only import

Analysis-only pipelines. Capitallytics cannot transfer your capital.

Encrypted connections

HTTPS on every session. Credentials stay with auth providers.

Your data stays yours

We do not sell personal information to third parties.

Secure authentication

Industry-standard sign-in. No OTPs or passwords over email.

Read next in this series

“AI CFO” sounds like autopilot for money. In practice, useful tools summarize and question your data — they do not replace your judgement, your CA, or your broker.

11 min read

You do not need a 20-person finance org to know if the company is healthy. You need a short scoreboard, clean books, and a ritual you will not skip.

12 min read

One card, one account, one blurry 'profit' number — until payroll and rent collide. Here is why separation is an operating system, not a formality.

11 min read

FP&A is not enterprise bureaucracy. For startups it is the habit of connecting hiring, revenue, and cash before surprises hit the bank account.

13 min read

Profit on paper does not pay salaries. Founders need a cash flow system — forecast, categories, and weekly habits — before the bank balance becomes the only metric.

12 min read

Runway is not a vibe — it is cash divided by burn, with ugly edge cases. Here is a clear founder-facing definition and a tracking habit that survives messy months.

12 min read

You may also like

Your bank balance, your portfolio value, and your salary are all partial pictures. A net worth tracker is the one number that tells you whether you are actually getting wealthier.

22 min read

Most budgets die in week three. This is the full system — how to set one up, run it weekly, and fix it when real life doesn't match the plan.

20 min read

A FIRE calculator turns 'retire early' from a slogan into a number. Here is the complete math — FI number, savings rate, withdrawal rate, and every major FIRE variant.

19 min read
    Capital Gains Tracking in India: Lots, Cost Basis, and Clean Records | Capitallytics