How to Track Investments in India: Stocks, Mutual Funds, Gold & Real Estate

Most Indian investors have their portfolio spread across 5–7 different platforms: a demat account for stocks, an AMC or MF portal for mutual funds, a bank locker for gold, a property document folder for real estate, a passbook for PPF and FD. Tracking total net worth across all of these requires manual effort that most people simply do not do. The result: poor visibility into allocation, missed SIP dates, and no clear picture of overall financial health.

Tracking stocks and equity: For listed Indian stocks (NSE/BSE), you need to track the quantity, average buy price, current market price, and profit/loss. The key metric beyond P&L is allocation — what percentage of your portfolio is in equities? Most financial planners recommend 60–70% for investors under 40, declining as you approach retirement. Log each stock holding with the date of purchase, number of shares, and buy price. Review monthly — Indian markets are volatile enough that quarterly reviews can miss important rebalancing signals.

Mutual funds and SIP tracking: Systematic Investment Plans are the backbone of retail investment in India. Track each SIP with: fund name, AMFI code, SIP amount, SIP date, start date, and the XIRR (extended internal rate of return) which accounts for irregular cash flows. Many investors do not track whether their SIP actually executed on the correct date — bank failures or insufficient balance can cause a month to be skipped without notification. Set a reminder for 2 days after each SIP date to confirm execution.

Gold tracking — physical and digital: Physical gold (jewelry, coins, bars) should be valued at current market price (MCX gold rate) minus making charges. Sovereign Gold Bonds (SGBs) are issued by RBI and trade on NSE — track them by series, face value, and current NAV. Digital gold through apps should be tracked by units held and current value. Gold typically represents 5–15% of a balanced Indian portfolio.

Real estate: Track each property with purchase price, current estimated value (use recent comparable sales in your area as a proxy), outstanding loan balance, monthly EMI, and rental income if applicable. Calculate net equity (current value minus outstanding loan) rather than gross value — this is your actual net worth contribution from the property. Include stamp duty and registration costs in your cost basis for accurate P&L calculation.

PPF, EPF, FD, and debt instruments: Public Provident Fund grows at the current declared rate (check RBI quarterly). Employee Provident Fund balance is accessible via the EPFO portal — log the balance annually. Fixed Deposits should be tracked by bank, principal, interest rate, tenure, and maturity date. Set reminders 30 days before each FD matures so you have time to decide on renewal versus deployment.

Allocation review and rebalancing: Once all holdings are logged, calculate your allocation across asset classes: equity (stocks + equity MF), debt (FD + debt MF + PPF + EPF), gold, real estate, and cash. Compare to your target allocation. If equity has grown to 80% from a 65% target due to a strong market, rebalance by redirecting new investments to underweight categories — not by selling (which triggers capital gains tax). Review allocation quarterly and rebalance annually. TrackWise-AI tracks all of this in one dashboard with multi-currency support, SIP reminders, and allocation breakdowns across 30+ asset types.