89.58 million unique individual demat holders were recorded in India by March 2024, yet only 59.4% of individual-held demat accounts represented unique accounts. To track a stock portfolio properly, consolidate every broker, demat account, mutual fund, ETF, and relevant family holding into one dashboard before measuring returns.
That distinction changes how you should think about portfolio management. An investor who checks three broker apps may believe they own a diversified collection of businesses, while holding the same sector, theme, promoter group, or economic risk through several accounts. A rising portfolio value can also hide fresh deposits, duplicated accounts, dividends, corporate actions, or an oversized position.
The right system has two layers. First, build a clean record of every transaction. Then use it to measure performance, concentration, risk, and thesis quality. The point isn't to watch prices all day. It's to create a reliable control system for long-term investing and multibagger strategies.
Table of Contents
- Why Consolidated Tracking Comes First
- Building Your Transaction Ledger
- Spreadsheets Versus Dedicated Tracking Tools
- Calculating Real Returns and Setting Benchmarks
- Setting Alerts and Rebalancing Rules
- Exposing Hidden Concentration Risk
- Your Ongoing Portfolio Maintenance Routine
Why Consolidated Tracking Comes First
India's retail investment market has expanded sharply. SEBI's data records growth in unique individual demat holders from 282.2 lakh in March 2019 to 895.8 lakh in March 2024, equal to 89.58 million holders, more than three times the earlier level. But account counts can mislead because one investor can operate multiple demat accounts. SEBI reported that only 59.4% of individual-held demat accounts represented unique accounts in March 2024. SEBI's bulletin on demat-account data makes the practical issue clear: counting accounts isn't the same as counting investors.
Build one source of truth
Before calculating profit or loss, create one consolidated view. Import or enter holdings from every broker, demat account, mutual-fund folio, and ETF account. If family accounts form part of the capital you manage, record them separately but include them in a household exposure view.
Your dashboard should identify each position using its ISIN or stock symbol, not only a company nickname. Then capture quantity, average cost, purchase date, current market value, realised and unrealised profit or loss, dividends, and portfolio weight. This structure prevents a holding in one broker from appearing unrelated to the same holding in another.
The SEBI Consolidated Account Statement guidance makes CAS a useful starting point because it combines mutual-fund transactions with securities held across demat accounts. Keep your PAN updated with each depository participant or stockbroker so the statement can consolidate the relevant records.
Practical rule: Don't measure returns until every position appears once, with the correct quantity and cost basis.
A single dashboard also exposes duplicate exposure. Five separate entries may become one large position after consolidation. Mutual funds can add another layer of overlap, especially when their holdings resemble your direct stock picks. Consolidation isn't an administrative upgrade. It's the condition that makes every later metric credible.
Building Your Transaction Ledger
A portfolio tracker fails at the ledger stage, not the chart stage. If you do not record each cash movement and position change properly, your return figure is decoration. It will miss fresh capital, misread dividends as price gains, and obscure the actual size of a family's exposure to the same stock across brokers, demat accounts, and mutual funds.
Build the ledger at the transaction level. Use one row for each buy, sell, dividend receipt, SIP allotment, transfer, split, bonus issue, or rights-related adjustment. Record the security's ISIN, exchange, transaction date, transaction type, quantity, and execution price. Add brokerage, STT, GST, and stamp duty on the same row. If you skip charges, your cost basis is wrong. If you club transactions together, your XIRR and realised gains will drift away from reality.
Core fields that protect your calculations
| Field | Purpose | Source |
|---|---|---|
| ISIN or stock symbol | Identifies the security consistently across accounts | Broker contract note or CAS |
| Exchange | Distinguishes the trading venue and instrument record | Contract note |
| Transaction date | Supports return calculations and audit trails | Contract note or broker ledger |
| Quantity | Shows current and historical ownership | Broker or demat statement |
| Buy or sale price | Establishes the transaction cost and proceeds | Contract note |
| Brokerage, STT, GST, stamp duty | Captures cost drag and taxable transaction detail | Contract note |
| Dividend | Separates income from price appreciation | Broker statement or bank record |
| Split or bonus adjustment | Corrects quantity and cost basis after corporate actions | NSE corporate-action records |
| Sale proceeds | Records realised capital and exit value | Contract note |
| Account reference | Helps reconcile the same security across accounts | Broker or depository statement |
Keep original entries intact after a corporate action. Do not overwrite an old buy just because the share count changed later. NSE's records distinguish events such as dividends and bonus allotments, and they show the dates that matter for reconciliation. Store those dates in your ledger so a revised quantity does not appear as a mysterious profit jump.
Account reference matters more than investors think. If you manage your own capital and track family accounts, tag every transaction by owner, broker, and demat or folio reference. Then map identical securities to one master line for exposure analysis. That is how you catch the hidden problem. One stock bought in two demat accounts and held indirectly through a mutual fund is still one economic bet.
Reconcile before errors multiply
Use CAS and broker statements as control documents. Do not let them become your only record. SEBI's investor charter states that CAS is issued within 10 days after month-end when there were transactions in the previous month, and half-yearly when there were none. That schedule is good enough for periodic checking, but your own ledger should be updated as trades happen.
The CAS dispatch schedule, covered in the maintenance routine below, is your monthly reconciliation checkpoint.
Match quantities, transaction dates, dividends, charges, and corporate actions every month. Reconcile cash flows too. A sale credited late, a dividend posted to the wrong bank account, or a transfer between family accounts can distort returns if you leave it unresolved.
Use time-weighted return to judge the quality of your investing decisions because it strips out the effect of deposits and withdrawals. Use money-weighted return, or XIRR, to measure what your actual capital earned. Serious investors track both. Multibagger hunting without a clean ledger usually turns into story-telling, because the wins stay visible while the position sizing mistakes, duplicate exposure, and cash drag disappear from view.
Spreadsheets Versus Dedicated Tracking Tools
A spreadsheet is sufficient for a small, stable portfolio. It gives you complete control over fields, formulas, account labels, thesis notes, and review dates. It also exposes every calculation, which is valuable when you're learning how portfolio returns work.
The weakness is maintenance. Manual entry creates opportunities for missed dividends, incorrect quantities, stale prices, and broken formulas. A spreadsheet can be flexible and still become unreliable when you stop updating it.
A dedicated tracker reverses that trade-off. It can reduce repetitive data entry, aggregate accounts, calculate XIRR, maintain transaction history, and present concentration or tax views. The risk is opacity. If you can't explain how the tool treats deposits, withdrawals, dividends, splits, and fees, you shouldn't trust its headline return.
Choose based on portfolio complexity
| Criteria | Spreadsheet | Dedicated Tracker |
|---|---|---|
| Setup | Manual structure and formulas | Guided setup or imported data |
| Customisation | Very high | Depends on the platform |
| Data entry | Manual unless connected to feeds | Often reduced through sync or import |
| Return calculations | You build and audit formulas | Usually includes XIRR and performance views |
| Concentration analysis | Requires custom design | Often available in dashboard form |
| Error visibility | Formula and input errors need checking | Data mapping still needs validation |
| Best fit | Few holdings and one account | Multiple accounts, funds, ETFs, and family exposure |
For a handful of stocks held through one broker, use a spreadsheet if you enjoy maintaining it. Keep a transaction tab, a current holdings tab, a benchmark tab, and a review-notes tab. Don't build a decorative dashboard before the ledger works.
If you hold direct equities, mutual funds, ETFs, and several demat accounts, automation has more value. A platform such as Futurecaps' portfolio tracking software can sit alongside your own records, but validate its imported quantities and cost basis against CAS and broker statements.
Futurecaps Stocks also offers a portfolio tracker and screener among its tools. Treat any platform as an assistant, not an authority. The correct question isn't whether the interface looks polished. Ask whether you can export your data, inspect transaction-level calculations, reconcile CAS, and see exposure across the entire household.
Calculating Real Returns and Setting Benchmarks
Portfolio value is not performance. If you add capital during a market rise, the account can grow even when your investment decisions add little value. If you withdraw money after a strong period, the current balance can fall while your actual return remains healthy.
Separate cash flows from investment results. Record contributions, withdrawals, purchases, sales, dividends, and price changes as different events. Then use XIRR to measure the return on your actual cash-flow pattern. This is the most relevant figure for an investor who adds money irregularly.
Use time-weighted return for a different question: how did the selected investments perform independent of the timing and size of your personal cash flows? That distinction matters when you evaluate a multibagger strategy, compare a portfolio manager, or decide whether stock selection is working.
Benchmark the portfolio honestly
For an Indian equity portfolio, use the Nifty 500 TRI or a relevant NSE sector TRI. A total-return index includes dividends, while a price index excludes them. Comparing a dividend-producing portfolio with a price-only benchmark gives you an incomplete comparison. Record both absolute return and excess return over the chosen benchmark.
Your dashboard should also show:
- Maximum drawdown, the deepest fall from a portfolio peak to a later trough.
- Volatility, which indicates how widely returns fluctuate.
- Turnover, which reveals how often you replace holdings.
- Concentration, measured by stock, sector, market capitalisation, and account.
- Tax and cost drag, including transaction charges and other portfolio costs.
Don't change a long-term thesis because of one weak week. SEBI's 2025 Investor Survey reported that 36.67% of investors monitored mutual-fund performance weekly and 20% did so daily, as cited in the Indian portfolio-tracking methodology paper. That behaviour may increase recency bias and unnecessary turnover, but it doesn't prove that frequent checking improves outcomes.
Review valuation monthly, examine businesses after quarterly results, and respond immediately to material corporate announcements. Use rolling three-year and five-year comparisons when judging a strategy, rather than allowing a single price move to dictate your decision.
For passive allocation decisions, an index fund returns calculator can help you frame the opportunity cost of a portfolio that consistently lags its benchmark. The calculator doesn't replace a thesis review, but it can expose the cost of ignoring benchmark performance.
Setting Alerts and Rebalancing Rules
A tracker becomes useful when it tells you what deserves attention. Price alerts alone aren't enough. A falling price may create an opportunity, while a rising price may signal that valuation has moved beyond your thesis. Alerts should connect market events to decisions you've already defined.
Configure alerts around the thesis
Set a price alert against your estimated intrinsic value, not an arbitrary round number. A discount can justify further research or accumulation when the business remains intact. A premium can justify trimming when expected returns have compressed. Neither alert should trigger an automatic trade without a thesis check.
Add event alerts for earnings announcements, investor presentations, material corporate announcements, dividend declarations, record dates, and ex-dates. Corporate actions can alter both quantity and income, so the tracker needs to notify you before it updates the portfolio's apparent performance.
Use portfolio-level triggers
Define a maximum weight for each holding before you buy it. The exact limit depends on your conviction, liquidity, valuation, and ability to withstand a drawdown. The important point is to decide the rule before a rising stock dominates the portfolio.
Use a simple action matrix:
- Thesis intact and valuation attractive: Consider adding only within your pre-defined position limit.
- Thesis intact and valuation stretched: Review whether to trim or stop adding.
- Thesis weakened by earnings, debt, or governance: Put the position on a sell-review list.
- Allocation has drifted: Rebalance according to your written rules, not market excitement.
- Price falls but business evidence is unchanged: Re-read the thesis before acting.
Deliver alerts through email, with optional WhatsApp updates if that fits your working routine. Notifications should reduce screen-watching, not create another stream of noise. Schedule a review window and act only when the alert points to a defined decision.
A price alert is not a decision. It is a request to inspect the thesis.
Value investors should accumulate on drawdowns only when the business case remains valid. They should trim when market price materially exceeds intrinsic value and exit when the original thesis breaks. Panic selling during broad volatility is not risk management. It is an unplanned change of strategy.
Exposing Hidden Concentration Risk
A portfolio can look diversified and still be dangerously concentrated. The problem usually sits above the individual stock level. You may own one theme across direct equities, mutual funds, ETFs, and family accounts, then miss it because each account looks acceptable on its own.
That risk is easy to underestimate in India. SEBI's Investor Survey 2025 reported that 5.3% of Indian households directly hold equities and 6.7% hold mutual funds or ETFs. Those exposures can overlap inside the same household. The same survey also reported that 38% of demat accounts were dormant, so account counts do not show whether anyone is actively reviewing total exposure.
Map exposure beyond the ticker
Build one exposure sheet for the entire household. Pull in direct stocks, mutual funds, ETFs, and family accounts. Then classify each position by sector, market capitalisation, business cycle, commodity sensitivity, customer concentration, lender dependence, geography, and policy dependence. This is what reveals the hidden concentration that broker dashboards usually miss.
Ask hard questions:
- Do several holdings depend on the same government spending cycle?
- Do your mutual funds and ETFs already own the same companies you hold directly?
- Are multiple businesses tied to the same commodity price?
- Do several companies rely on one lender, customer group, or geography?
- Are your small-cap bets clustered in one market theme?
- Could one policy change hit several positions together?
- Are family accounts increasing the same exposure outside your main dashboard?
Five genuinely different businesses can give you better protection than ten names linked to the same economic driver. Diversification comes from independence of outcomes, not from a longer holdings list.
Review concentration by stock, sector, theme, market-cap bucket, and issuer group. Use limits that trigger analysis, not blind selling. If you choose to run a concentrated portfolio because conviction is high, write down the reason. Then define what business evidence, valuation stretch, or change in industry structure would prove you wrong.
For investors who want structured research to feed into that process, the Multicap Plan provides monthly multibagger reports with buy range, valuation, thesis, and risk factors, plus 2–6 past reports on onboarding. Use that research as one input. Your real defence against concentration is still a consolidated household view that shows where the same bet keeps repeating.
Your Ongoing Portfolio Maintenance Routine
Portfolio tracking breaks when you treat it as a setup task instead of an operating habit. Run a routine that is boring, repeatable, and strict enough to catch drift across demat accounts, mutual funds, and family portfolios before one idea quietly becomes your biggest risk.
Monthly control check
At month-end, pull the latest CAS where applicable and match it against your ledger. Reconcile quantities, average cost, dividends, sales, fees, splits, bonuses, and cash movements. Then refresh XIRR, current allocation, benchmark comparison, and exposure by stock, sector, fund, theme, and family account.
Use the CAS dispatch schedule from the transaction-ledger section as your calendar. Electronic statements arrive by the 12th day after month-end and physical statements by the 15th. Keep your PAN, nominee, and account details updated with each depository participant and fund house, or your consolidated view will break the moment you switch brokers, add a folio, or start investing through a family member's account.
One missed mapping can hide a repeated bet.
Quarterly investment review
Review holdings after results, not after price swings. Compare each position with the original thesis and check earnings quality, debt, cash conversion, competitive position, capital allocation, promoter conduct, and valuation. If the business changed, record what changed and whether expected return still justifies the weight you carry.
Use a written decision log:
- What did I believe when I bought?
- What evidence supports that view now?
- What evidence contradicts it?
- Has intrinsic value changed?
- Has the position exceeded its allocation limit?
- What event would make me sell?
SEBI's investor research shows a large share of investors stay inactive for long stretches, and many households prioritise capital preservation over return chasing. The survey report reinforces a simple point. A quiet account is not the same thing as a healthy portfolio. If you are not reviewing overlap across direct equities, funds, and linked family holdings, inactivity can mask concentration rather than discipline.
Annual allocation reset
Once a year, compare actual weights against your written limits. Rebalance when exposure drifted too far, the thesis weakened, or the position no longer offers enough margin of safety. Record the reason, along with tax impact and trading costs, so your future decisions are based on evidence instead of memory.
A serious standard for portfolio management in India is straightforward. Keep consolidated records, calculate returns correctly, compare against a relevant benchmark, and document every allocation decision. If your tracker cannot show total household exposure to the same stock, sector, or theme, it is not helping you manage risk.
Start now. Download the latest CAS, list every account and folio, update the ledger, and review exposure before you make another purchase.
Futurecaps Stocks offers Indian equity research focused on multibagger opportunities, along with portfolio tracking and screening tools that can support a disciplined review process. Visit Futurecaps Stocks to explore the available research, tools, and investor education resources, then connect every idea you consider to your consolidated portfolio dashboard.
