The NRI Portfolio Challenge
For Non-Resident Indians (NRIs) working in the US, building wealth naturally happens in two distinct financial ecosystems. You contribute to a 401(k) and buy US stocks or ETFs through brokerages like Fidelity or Charles Schwab. At the same time, you likely maintain investments back in India—SIPs in mutual funds, fixed deposits, or direct equities managed through a local demat account.
The challenge isn't investing in both countries; it is trying to view them as a single portfolio. US brokerages don't support Indian mutual funds, and Indian tracking platforms rarely handle US equity properly. This forces most NRIs into a frustrating monthly ritual of logging into multiple portals, downloading statements, and battling spreadsheets.
If you are wondering how to track NRI mutual funds and US stocks together without spending hours on manual data entry, you need a systematic approach.
Step 1: Exporting Your Indian Asset Data (NSDL CAS)
The first step to consolidation is getting your Indian data out of the silos. Rather than logging into every single mutual fund AMC or bank portal, you should utilize the Consolidated Account Statement (CAS).
The NSDL CAS provides a single, comprehensive view of your Indian securities market investments. It includes your mutual funds, direct equities, and even government securities held in demat form. By generating and downloading this single PDF statement, you capture the vast majority of your Indian portfolio in one file.
However, a raw PDF doesn't help you run portfolio analytics. To integrate this with your US assets, the data must be parsed into a readable format, either by manually copying the units and NAVs into a spreadsheet or using a tool designed to securely upload your NSDL CAS PDF and read it automatically.
Step 2: Grabbing Your US Brokerage Data
Your US assets are generally easier to export. Most major US brokerages offer a straightforward "Export to CSV" function. This will give you a clean list of your ticker symbols, the number of shares held, and your cost basis.
If you are using a spreadsheet, your next task is to paste this CSV data onto a new tab.
The Spreadsheet Method vs. Automation
If you rely on spreadsheets, consolidating these two data sources requires setting up live price feeds. You can use `=GOOGLEFINANCE("TICKER")` for your US stocks. For Indian mutual funds, things get trickier, as standard finance formulas often fail to pull reliable, updated NAVs for Indian funds.
Even if you get the prices working, you still face the currency hurdle. You must apply a live USD/INR exchange rate to your Indian assets so you can view your total portfolio value in a single base currency.
This process works, but it is fragile. Every time you invest your monthly SIP or buy a new US stock, you have to repeat the export, import, and alignment process.
Consolidating Your Cross-Border Portfolio
Instead of spending your weekend reconciling spreadsheets, you can use software built for this exact use case. MapMyWealth allows you to seamlessly track NRI mutual funds and US stocks together. You can securely upload your NSDL CAS PDF to automatically parse your Indian holdings, and import your US brokerage CSVs in seconds. The platform automatically applies real-time USD/INR exchange rates, giving you an instantly accurate, unified view of your entire cross-border portfolio.
Start tracking your global portfolio with MapMyWealth for free