How to Conduct a Quarterly Portfolio Review: A Practical Checklist for Indian Investors
A quarterly portfolio review is a structured evidence update—not a quarterly trading ritual. Its purpose is to check whether financial goals, asset allocation, individual stock theses, concentration, liquidity and personal risk capacity still support the current portfolio.
The review should end with one of six actions for every holding: hold, add, trim, exit, investigate or monitor. “Do nothing” is a valid result when the evidence and portfolio structure remain sound.
Why Review Quarterly?
A quarter is long enough for companies to report operating and financial evidence, but short enough to identify deterioration before it becomes a multi-year habit. The review interval also creates discipline without encouraging daily reaction to price movements.
SEBI investor guidance recommends monitoring investments regularly, rebalancing when the mix no longer aligns with objectives and reviewing the portfolio when important life circumstances change.
A Review Is Not a Trade Signal
A well-constructed review may produce no transactions. Trading merely because three months passed increases turnover without improving the portfolio.
Review on schedule; trade only when evidence or policy requires it.
Bull Run's Six-Layer Quarterly Review
Investor Position
Goals, cash needs, income stability and time horizon.
Portfolio Structure
Asset allocation, market caps, sectors, factors and overlap.
Investment Evidence
Business performance, cash flow, debt, valuation and governance.
Performance Quality
Benchmark-relative, risk-adjusted and contribution analysis.
Implementation
Liquidity, turnover, cost, tax and records.
Action Plan
Prioritised decisions and evidence deadlines.
Step 1: Review Personal Circumstances
Before reviewing stocks, review the investor. Record changes in:
- income and job stability;
- family responsibilities;
- emergency reserves;
- insurance coverage;
- loan obligations;
- house, education or retirement goals;
- expected withdrawals;
- ability to tolerate drawdown;
- tax residency or reporting needs.
A portfolio can remain attractive while becoming unsuitable because the investor's liquidity needs changed.
Personal Liquidity Check
Liquidity runway = Liquid reserves ÷ Essential monthly expensesDo not include volatile equity positions in emergency reserves unless the plan explicitly accepts forced selling during a drawdown.
Step 2: Reconcile Every Account
Combine:
- demat and broker accounts;
- mutual-fund folios;
- ETFs;
- employer shares and ESOPs;
- spouse or household portfolios where goals are shared;
- cash awaiting investment;
- dividends and corporate-action proceeds.
Use current market values, not invested cost, for portfolio weights.
Portfolio Reconciliation Formula
Opening value + contributions − withdrawals + investment return = Closing valueDifferences indicate missing trades, dividends, fees, corporate actions or data errors.
Step 3: Measure Performance Correctly
Review:
- rupee profit;
- XIRR for investor experience;
- time-weighted return where available;
- return versus the policy benchmark;
- active return;
- maximum drawdown;
- rolling performance;
- stock-level contribution;
- fees, costs and tax drag.
Active return = Portfolio return − Suitable benchmark returnUse a total return index or policy blend matching asset allocation and market-cap exposure.
Performance Questions That Matter
| Question | Useful Metric | Bad Interpretation |
|---|---|---|
| Did the portfolio beat a reasonable alternative? | Active return | Comparing every portfolio with the Nifty 50 |
| What created the return? | Holding and sector contribution | Looking only at total percentage return |
| How much risk was taken? | Drawdown, volatility and stress loss | Assuming higher return means better process |
| Was active risk rewarded? | Information Ratio | Ignoring benchmark mismatch |
| Did costs matter? | Net return after friction | Using only gross results |
Step 4: Review Asset Allocation
Allocation drift = Current weight − Policy targetReview equity, debt, cash, gold, international and other strategic assets. Then review the equity sleeve by large, mid and small caps.
| Asset | Target | Current | Drift | Status |
|---|---|---|---|---|
| Indian equity | 60% | 66% | +6% | Review upper band |
| Debt | 25% | 21% | −4% | Use contributions |
| International equity | 10% | 8% | −2% | Within band |
| Cash | 5% | 5% | 0% | On target |
Step 5: Review Concentration
Calculate:
- largest stock weight;
- top-three, top-five and top-ten weights;
- sector and sub-sector exposure;
- economic risk clusters;
- effective holdings;
- single-stock and cluster portfolio-at-risk;
- stress exit days.
Single-stock stress loss = Portfolio weight × Severe stock downsideA strong company can still become a portfolio problem when its weight exceeds the risk budget.
Step 6: Review Portfolio Overlap
Total company exposure = Direct holding + Σ(Fund allocation × Company weight inside fund)Check exact stock, sector, market-cap, factor and economic-cluster duplication. Different fund names do not guarantee different exposures.
Step 7: Re-Underwrite Every Stock
For each direct holding, update:
- revenue and volume growth;
- gross and operating margins;
- operating cash flow;
- receivables and inventory;
- debt and interest coverage;
- return on capital;
- customer and market-share evidence;
- management guidance and capital allocation;
- auditor, promoter and related-party disclosures;
- downside, base and upside valuation.
The Thesis Variance Table
| Original Assumption | Current Evidence | Status | Value Effect | Action |
|---|---|---|---|---|
| Revenue growth remains above 15% | Growth slows for one quarter because of delayed shipment | Potentially temporary | Mainly timing | Monitor evidence |
| Stable margin | Competitor resets industry pricing | Structurally weaker | Large reduction | Revalue and reduce |
| Net-cash balance sheet | Debt-funded acquisition announced | New thesis required | Higher equity risk | Re-underwrite |
| Clean governance | Auditor qualification appears | Thesis suspended | Evidence unreliable | Prioritise capital protection |
Governance Review Has Priority Over Valuation
Auditor resignation, qualified accounts, delayed results, unexplained related-party transactions, promoter pledging and regulatory concerns can invalidate the numbers used for valuation.
A low price is not a margin of safety when the evidence cannot be trusted.
Step 8: Classify Thesis Status
Position size should reflect thesis status. A weakened thesis may justify a smaller weight even before a full exit is required.
Step 9: Review Valuation
Use current evidence rather than the old purchase target. Build:
- downside case;
- base case;
- upside case;
- severe-loss estimate;
- expected return range;
- implied expectations in the current price.
Expected annualised return = (Estimated future value ÷ Current price)^(1 ÷ Years) − 1Step 10: Review Mutual Funds and ETFs
Check:
- scheme mandate and benchmark;
- portfolio holdings and overlap;
- expense ratio;
- tracking difference and tracking error for passive funds;
- fund manager and process changes;
- portfolio turnover;
- market-cap and sector drift;
- exit load and tax implications before switching.
Do not switch funds only because of one quarter or one year of relative underperformance.
Step 11: Review Turnover and Costs
One-way turnover = Lower of purchases or sales ÷ Average portfolio valueGross trading intensity = (Purchases + sales) ÷ Average portfolio valueClassify trades by reason: thesis, rebalance, opportunity, corporate action, tax, liquidity or behavioural churn.
Step 12: Review Liquidity
Stress exit days = Position value ÷ Acceptable share of stressed daily traded valueUse median traded value, lower-circuit history, free float and stressed volume rather than normal average volume alone.
Step 13: Run Stress Tests
At minimum, test:
- broad equity decline;
- small-cap liquidity freeze;
- credit and property stress;
- government-capex slowdown;
- commodity or currency shock;
- earnings decline and valuation compression;
- loss of personal income during a market drawdown.
Portfolio stress loss = Σ(Holding weight × Scenario loss)Step 14: Review Tax and Records
Maintain:
- contract notes and broker statements;
- capital-gain and loss records;
- purchase dates and tax lots;
- dividend statements;
- mutual-fund capital-gain statements;
- corporate-action records;
- nominee and contact details;
- bank and demat information;
- will and succession documentation where appropriate.
Tax rules and filing requirements can change. Verify current treatment through official sources or a qualified professional.
Step 15: Create the Action Hierarchy
Use this order:
- Resolve fraud, governance and account-reliability risks.
- Resolve company or investor liquidity risks.
- Reduce hard concentration breaches.
- Exit broken theses.
- Rebalance asset allocation using cash flows first.
- Trim extreme valuation or overlap.
- Add to intact underweight positions.
- Research new opportunities only after current risks are controlled.
This prevents investors from spending time on exciting new ideas while ignoring the largest existing risks.
The Hold, Add, Trim, Exit Matrix
| Thesis | Valuation | Weight | Likely Action |
|---|---|---|---|
| Intact | Attractive | Below target | Consider adding |
| Intact | Fair | Within band | Hold |
| Intact | Expensive | Oversized | Trim |
| Weakened | Attractive | Small | Monitor with evidence deadline |
| Weakened | Fair or expensive | Large | Reduce |
| Suspended | Apparently cheap | Any | Do not rely on valuation until evidence is reliable |
| Broken | Any | Any | Exit or reduce according to liquidity |
Worked Example 1: No-Trade Quarter
The investor's goals, allocation and cash needs are unchanged. Every thesis remains intact, positions remain inside bands and the stress loss is acceptable.
The correct action is no trade. Monitoring dates are updated and the review is complete.
Worked Example 2: Winner Becomes Oversized
A 5% position grows to 12%. The thesis remains strong, but a 50% severe decline would reduce the portfolio by 6%.
The investor trims to the documented maximum without making a negative forecast about the company.
Worked Example 3: One Bad Quarter
Revenue misses because a shipment moves across the reporting date. The customer remains, cash arrives later and debt is stable.
The thesis remains intact. The investor monitors the next evidence milestone rather than selling on the headline.
Worked Example 4: Cash Flow Breaks Before Profit
Reported profit grows while receivables and debt rise for several quarters. Operating cash flow remains negative.
The thesis is downgraded and position size reduced until collections verify earnings quality.
Worked Example 5: Fund Overlap
Two funds and one direct holding create 13% look-through exposure to the same company.
The investor trims the direct position because the core funds already provide substantial exposure.
Worked Example 6: Asset Allocation Drift
Equity rises above the policy band after a strong market. New contributions are redirected to debt and cash before selling appreciated holdings.
Worked Example 7: Goal Horizon Shortens
A house purchase is now two years away. The portfolio remains attractive, but required goal money is moved out of volatile equity.
Worked Example 8: Small-Cap Liquidity Risk
Several positions require more than twenty stressed exit days. The investor reduces the least liquid holdings before any company-specific crisis.
Worked Example 9: Broken Governance Thesis
An auditor resigns and management provides an incomplete explanation. The apparently cheap valuation is ignored because evidence reliability is impaired.
Worked Example 10: Better Opportunity Does Not Clear Costs
A replacement stock has a slightly higher estimated return, but switching creates tax, spread and uncertainty costs. The existing holding is retained.
The 90-Minute Review Agenda
| Time | Task | Output |
|---|---|---|
| 0–10 minutes | Personal goals and cash needs | Suitability changes |
| 10–25 minutes | Accounts, weights and performance | Reconciled dashboard |
| 25–45 minutes | Concentration, overlap and allocation | Risk breaches |
| 45–70 minutes | Stock and fund evidence | Updated thesis status |
| 70–80 minutes | Liquidity and stress tests | Survival assessment |
| 80–90 minutes | Action ranking | Next-quarter plan |
Quarterly Portfolio Review Worksheet
| Field | Required Output |
|---|---|
| Goal and time horizon | Unchanged or revised |
| Liquidity runway | Months of essential spending |
| Portfolio XIRR and TWRR | Investor and strategy return |
| Policy benchmark return | Matched total return comparison |
| Asset allocation drift | Target, current and band status |
| Largest stock and top-five weight | Concentration status |
| Economic-cluster exposure | Common failure drivers |
| Look-through fund overlap | Total company and sector exposure |
| Thesis status | Intact, weakened, suspended or broken |
| Updated valuation | Downside, base and upside cases |
| Stress portfolio loss | Total and contributor loss |
| Stress exit days | Liquidity status |
| Turnover and friction | Activity and cost |
| Tax and records | Missing documents or actions |
| Decision | Hold, add, trim, exit, investigate or monitor |
Common Quarterly Review Mistakes
1. Starting with price performance
Begin with goals, structure and evidence.
2. Trading because a quarter ended
Review frequency is not trade frequency.
3. Comparing with the wrong benchmark
Market-cap and asset-allocation mismatch distorts conclusions.
4. Reviewing stocks but not funds
Fund overlap and mandate drift can dominate exposure.
5. Ignoring cash flow
Profit growth can hide weak earnings quality.
6. Ignoring governance
Valuation is unreliable when accounts are unreliable.
7. Looking only at account-level weights
Household and fund look-through exposure may be larger.
8. Rebalancing to exact percentages
Use policy bands and cash flows to reduce unnecessary turnover.
9. Creating too many actions
Rank the few decisions with the largest portfolio impact.
10. Failing to set evidence deadlines
Temporary problems need measurable recovery milestones.
How Bull Run Features Fit the Review
Use the Bull Run watchlist to separate research candidates from current holdings and record evidence milestones.
Use Bull Run Compare to review growth, margins, debt, cash flow, return ratios and valuation against peers.
The Stock Battle tool helps when two holdings compete for one portfolio role. Smart Screeners can identify alternatives without turning every review into immediate trading.
Primary Official Sources
Disclaimer
This article is for educational and informational purposes only. It is not personalised investment, tax or legal advice, a model portfolio or a recommendation to buy, hold, trim or sell any security. Review frequency and appropriate actions depend on goals, time horizon, income stability, liquidity needs, other assets, tax circumstances and research ability. Bull Run is not a SEBI-registered Research Analyst or Investment Adviser.
The Practical Conclusion
A quarterly review should make the portfolio easier to understand, not busier to trade. Reconcile every account, compare performance with the right benchmark, re-underwrite each thesis, measure concentration and overlap, stress liquidity and personal cash flow, then rank the few actions that materially improve survival or expected return. When nothing important changed, the correct action is to hold and continue monitoring.